C# connector string to mySQL Cluster Database

[agoscamp]

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