By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,374 Members | 1,768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,374 IT Pros & Developers. It's quick & easy.

C# connector string to mySQL Cluster Database

P: 1
Hi,I'm trying mysql cluster to use in a project for our customer.

The configuration I setted up is the following:
Server1 - S.O. Windows 2008 R2 64bit
Server2 - S.O. Windows 2008 R2 64bit
Client1 - S.O. Windows 7 64bit
Client2 - S.O. Windows 7 64bit

UserClient - S.O. Windows 7 64bit

My Sql Cluster Configuration
Server1 - act as data node and mysql node (MYSQL-D1)
Server2 - act as data node and mysql node (MYSQL-D2)

Client1 - act as management node 1
Client2 - act as management node 2

Client application configuration
All Clients have a Microsoft .Net application that interact with mysql cluster database.

After a while mySQL cluster configuration appears to work correctly and the apps are able to connect to data nodes (this is possibile by changing the connection string of .NET client application and pointing to IP of MYSQL-D1 or to the IP of MYSQL-D2).

In a perfect world the client apps are automatically able to connect to the right server, pratically:
- if MYSQL-D1 is down apps connect to MYSQL-D2
- if MYSQL-D2 is down apps connect to MYSQL-D1

How .NET client application can interact with mysql cluster?

The best solutions I found for my scenario are:
1. use mysql proxy but it's in alpha stage and I can't use it in production environment
2. install mysql node on each client
3. use a connection string that support multiple servers (I don't know if it's supported by mysql .NET connector)
4. rewrite my application to interact with both MYSQL-DX node (what I want to avoid)

Is there a right solutions? Which one is the best one?

Thank you
Apr 10 '13 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.