… the slave requests, should we use some randomize function or HA proxy? A: The Doctrine connection wrapper class randomly chooses one the… there any good experiences with MySQL Proxy (RW-splitting)? A: Most solutions with MySQL Proxy I see have stern disclaimers against using…. Even the official manual page for MySQL Proxy 0.8.2 still says: “MySQL Proxy is currently an Alpha release and should…
Comment: mysql-proxy, urgh performance and scalability ?
February 11, 2013 By 44 Comments
If Ha proxy or mysql proxy is no good for you then please look into f5 load balancers for load balancing. Read/write can be done at application level aswell. Nginx can also be used for load balancing and is quite efficient and lightweight.
Comment: mysql-proxy, urgh performance and scalability ?
February 7, 2013 By 44 Comments
… running it on live system. We moved it away to Ha-proxy, depending on your requirement you can either choose Haproxy for…. If you want to have more advance features of mysql proxy like read-write split and do not want to make…
Comment: MySQL Sizing questions
February 9, 2012 By 4 Comments
… HA proxy. PHP installed. Apache Server. 2 Database server with the same configuration, but active-pasive controlled by load balancing using HT proxy…
Comment: mysql-proxy, urgh performance and scalability ?
June 10, 2009 By 44 Comments
What about using ha-proxy? Its not an sql specific proxy but seems like it could balance the connections just as well as anything.
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… this case which allows to use simple solutions such as HA Proxy with these technologies – node is either part of the cluster… is no magic or silver bullet here of course. Making HA solution more simple clustering solutions are more complicated themselves internally… operational state. Conclusion: If you’re looking for setting up HA solution for MySQL check out synchronous replication based solutions in…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
January 31, 2013 By 63 Comments
Hi, I have implemented the HA proxy and with the XtraDB cluster. I was using your B …
Comment: Percona XtraDB Cluster reference architecture with HaProxy
July 11, 2012 By 63 Comments
Hey This might sound like a stupid question from a guy trying to read up on ha-proxy, but I can’t see what makes pxc-onenode-back and pxc-back different in how they would handle a rollback depending on if the connection goes to port 3306/3307. Anyone care to explain it to me? 
Comment: Percona XtraDB Cluster reference architecture with HaProxy
June 22, 2012 By 63 Comments
Running ha-proxy on the app server is a good one as you’re still able to use the security features for connections. And I assume it scales quite well. It also removes a possible spof. Why do you use ‘FLUSH PRIVILEGES’ after a GRANT?
Comment: mysql-proxy, urgh performance and scalability ?
June 10, 2009 By 44 Comments
Erik, I did not try ha-proxy, it seems it does not support functionality I need, I am looking to handle coming queries in one specific way.
