title: MySQL failover using MySQL Proxy
body: <p>I'm looking at implementing a failover mechanism for a MySQL database using MySQL Proxy (<a href="http://forge.mysql.com/wiki/MySQL_Proxy" rel="nofollow noreferrer">http://forge.mysql.com/wiki/MySQL_Proxy</a>)</p>
  
  <p>My proposed setup is as follows: One active MySQL server and one passive MySQL with two way replication enabled between the both of them. MySQL Proxy is the failover that sits in between these two servers and redirects traffic to the standby in case the active fails and vice versa.</p>
  
  <p>Just wanted to know the community's experience here about using MySQL Proxy as a failover tool for two MySQL servers. Any gotchas that I should be looking at? Any other tips/tweaks/hacks that can improvise this setup?</p>
  
  <p>And oh, I'm on Windows and hence the need for MySQL Proxy.</p>