469,927 Members | 1,763 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

C# connector string to mySQL Cluster Database

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
0 1157

Post your reply

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

Similar topics

reply views Thread by Sohail Hasan | last post: by
1 post views Thread by Eric Losier | last post: by
reply views Thread by luke crouch | last post: by
reply views Thread by davidb999 | last post: by
reply views Thread by btaranto | last post: by
reply views Thread by cmk128 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.