ConnectionString and Failover

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
lkrueger
Posts: 6
Joined: Mon 14 Jul 2014 17:40

ConnectionString and Failover

Post by lkrueger » Tue 22 Jul 2014 19:45

I'm a newbie here, switching over from MySQL Connector/Net, and the documentation is pretty vague on how the Server parameter of a connection string can be set up with multiple servers. Is this supported by devart dotConnect?

For example, I would like to construct my connection string to utilize failover/load balancing of a clustered database

Code: Select all

<connectionStrings>
  <add name="MySqlServices" 
     connectionString="server=192.168.1.1,192.168.1.2,192.168.1.3; Database=pri;
     User ID=***; Password=***;" />
</connectionStrings>

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: ConnectionString and Failover

Post by Pinturiccio » Fri 25 Jul 2014 12:19

dotConnect for MySQL supports load balancing feature. This feature allows you to specify several hosts with their ports in the Host parameter of the connection string. For more information, please refer to http://blog.devart.com/oracle-12c-suppo ... ducts.html

lkrueger
Posts: 6
Joined: Mon 14 Jul 2014 17:40

Re: ConnectionString and Failover

Post by lkrueger » Fri 01 Aug 2014 18:05

For anyone else with this question, my problem was that I didn't have parenthesis around the IP addresses which is why it was giving me errors

Post Reply