Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, you …: Hello, was there any good experiences with MySQL Proxy (RW-splitting)? A: Most solutions with MySQL Proxy I see have stern disclaimers against using it… as the page remains in the buffer pool. But the read/write split solution is intended for cases where the query load is…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… like how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to take online non…/mysql and it’s reading from /etc/my.cnf. I’ve seen a lot of cases where there’s a /var/lib/mysql… not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than…
Comment: mysql-proxy, urgh performance and scalability ?
February 7, 2013 By 44 Comments
… 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 any application changes then…
Comment: mysql-proxy, urgh performance and scalability ?
December 27, 2012 By 44 Comments
Hi, For people convenience I have posted MySQL proxy installation and configuration script. Feel free to try this out for load balancing MySQL database servers or to do read/write split. http://blog.goplar.com/#category1 —> here is the detail. Thanks. Masood
Comment: mysql-proxy, urgh performance and scalability ?
July 25, 2011 By 44 Comments
Yes, goog question… I have been adviced not to implement using two databases in my webapplication just to split between writes and reads (master / slaves). So I thought mysql-proxy could be great… If it leads to 2-3x overheads, is there another alternative to deal with that ?
