Devart Forums

Posted: **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>

Posted: **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

Posted: **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

Devart Forums

ConnectionString and Failover

ConnectionString and Failover

Re: ConnectionString and Failover

Re: ConnectionString and Failover