Clever Geek Handbook

Switching MySQL using MySQL Proxy

I am considering implementing a failover mechanism for a MySQL database using MySQL Proxy ( http://forge.mysql.com/wiki/MySQL_Proxy )

My suggested setup looks like this, one active MySQL server and one passive MySQL server with two way replication are allowed in between. MySQL Proxy is a failover that sits between the two servers and redirects traffic to standby if a failure is active and vice versa.

Just wanted to learn about the community experience here on how to use MySQL Proxy as a tool to switch between two MySQL servers. Any errors I should be looking at? Any other tips / tweaks / hacks that can improvise this setup?

And oh, I am on Windows and therefore need MySQL Proxy.

+1


source to share


2 answers


MySQL Proxy is the right solution and many people use it to build high performance systems. There are a few things to remember:



  • It's still in Alpha, so you really want to test it thoroughly before implementing it.
  • When using a proxy server, your application must have a failover method. If this is a website, perhaps a "we'll be back shortly" messsage and notification system to tell you that it is. MySQL Enterprise Manager is pretty good for this, although it costs money.
  • This will add more latency than a hardware load balancer, but it will allow you to tweak it a lot more with Lua.
+2


source


I have been using MySQL proxy for a while and found it to be very helpful. However, it looks like there are new bugs in version 0.6.1 compared to 0.6.0. Therefore, you can be careful when choosing versions. I think this is a great product for bounces and requests, but since it's in Alpha, you should expect bugs.



http://forums.mysql.com/read.php?146,202953,202953#msg-202953

0


source






More articles:


All Articles