ConnectionString and Failover

ConnectionString and Failover

Postby 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>
lkrueger
 
Posts: 6
Joined: Mon 14 Jul 2014 17:40

Re: ConnectionString and Failover

Postby 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-support-and-more-new-features-in-new-versions-of-devart-products.html
Pinturiccio
Devart Team
 
Posts: 1950
Joined: Wed 02 Nov 2011 09:44

Re: ConnectionString and Failover

Postby 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
lkrueger
 
Posts: 6
Joined: Mon 14 Jul 2014 17:40


Return to dotConnect for MySQL