Bug #87234 Connector 6.9.9 error HostNotFound when 2 or more servers are specified
Submitted: 28 Jul 2017 6:57 Modified: 28 Jul 2017 7:47
Reporter: Maxim Petrov Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:6.9.9 OS:Windows (10)
Assigned to: CPU Architecture:Any
Tags: connection string, multiple hosts

[28 Jul 2017 6:57] Maxim Petrov 
Description:
Net 6.9.9 on a Net 4.5 application and connectionstring contains multiple hosts for connect, there's a run time error 'Unable to connect to any of the specified MySQL hosts.'. 
If specify any one of these hosts, then everything works

How to repeat:
Reference MySQL connector Net 6.9.9 on a Net 4.5 application. 
Set connectionstring "Server=slavedb1.compname.lan,slavedb2.compname.lan;User Id=***;password=***;Persist Security Info=True;database=***;Keep Alive=3600;Minimum Pool Size=3;Maximum Pool Size=20;Connection Lifetime=300"
[28 Jul 2017 7:12] Chiranjeevi Battula 
Hello Maxim Petrov,

Thank you for the bug report.
This is most likely duplicate of Bug #81650, please see Bug #81650.

Thanks,
Chiranjeevi.
[28 Jul 2017 7:47] Maxim Petrov 
Hi, Chiranjeevi Battula.
Thank you for your answer.
The way described in this blog, https://blogs.oracle.com/mysql/how-to%3a-using-replication-load-balancing-with-connector, really works