StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POconfiguring MySql cluster failover using the .Net connector
text
Body
copied!<p>I've got an ASP.Net website which is running on a load-balanced environment (2 Windows servers). It connects to a clustered MySql database which is running on two linux servers running Ubuntu.</p> <p>We've been running into a number of errors while trying to route the MySql data through our JetNexus load-balancer, so I'm trying to find out if there's a way of configuring the individual web-servers with some sort of automatic database server failover detection. If I were using MS-SQL, I'd configure the connection string using the "Failover partner" parameter, but MySql doesn't support that. Is there anything else like that out there, or is there an alternate solution to this issue? </p> <p>Extra info: </p> <ul> <li><p>I'm using MySql connector 6.4.3, ASP.Net 4.0, MVC 3.0, the database is running MySql cluster 7.1.15a, cluster_server 5.1</p></li> <li><p>I've tried specifying multiple MySql hosts in the connection file (using "server=192.168.0.1 & 192.168.0.2") and while this appears to work it doesn't automatically detect the failover and crashes as soon as I take out one of the databases.</p></li> <li><p>I've come across something called "MySQL Proxy" which looks like it should fit the bill, but we have a hardware load-balancer so I'm going to spend time trying to get that working properly rather than implementing an extra software proxy. </p></li> <li><p>The errors we are getting are "System.IO.EndOfStreamException: Attempted to read past the end of the stream.". This happens intermittently when we run MySql through the load-balancer. This is a separate issue and may not be related to the question but I've included it here for completeness. </p></li> </ul> <p>Thanks for reading !</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload