Bug #81650 can't access to multiple hosts separated by commas
Submitted: 31 May 2016 1:01 Modified: 17 Dec 2019 16:02
Reporter: Yoshimi Takahashi Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:6.9.8, 8.0.17 OS:Any
Assigned to: CPU Architecture:Any

[31 May 2016 1:01] Yoshimi Takahashi
Description:
According to the following description of reference manual, we can specify multiple
 hosts separated by commas in a connection part.

http://dev.mysql.com/doc/connector-net/en/connector-net-connection-options.html
==========
The name or network address of the instance of MySQL to which to connect. Multiple hosts can be specified separated by commas. This can be useful where multiple MySQL servers are configured for replication and you are not concerned about the precise server you are connecting to.
==========

However, I tried it and get the connection error.
So I guess this is misdescription.

In addition, oracle blog introduced the best way for connecting to multiple servers,
you should recommend this way explicitly, I think.

https://blogs.oracle.com/MySqlOnWindows/entry/how_to_using_replication_load

How to repeat:
Prepare two MySQL server (Master and Slave):
192.168.40.10, 192.168.40.20

And execute 'test_conect_10or20_by_comma.txt' in "testcodes.zip",
you could get a error.

Of course, you could succeed in executing 'test_conect_10.txt' and 'test_conect_20.txt'

Suggested fix:

I want you to fix the manual.
[31 May 2016 1:02] Yoshimi Takahashi
testcodes for reproducing the bugs

Attachment: testcodes.zip (application/x-zip-compressed, text), 1.97 KiB.

[31 May 2016 7:28] Chiranjeevi Battula
Hello Yoshimi Takahashi,

Thank you for your report and test case.
Verified this behavior on Visual Studio 2013 (C#.Net) and Connector/NET 6.9.8.

Thanks,
Chiranjeevi.
[28 Jul 2017 7:12] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=87234 marked as duplicate of this one.
[19 Dec 2017 6:33] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=88962 marked as duplicate of this one.
[16 Aug 2019 13:24] MySQL Verification Team
Bug #96561 marked as duplicate of this one.
[17 Dec 2019 10:24] Hooman Bahreini
This project might help allow you to use a multi-host connection string using MySQL Connector .NET:

https://github.com/HoomanBahreini/MySQLConnectionManagerForNet
[17 Dec 2019 16:02] Daniel Valdez
Posted by developer:
 
Multihost feature is available now. Verified using C/NET 8.0.19