MySQL proxies


I’ve tested last night two proxies for MySQL : MySQL-Proxy and Dormando’s Proxy for MySQL.

Both are working, but I still don’t see really the advantage of using DPM over MySQL-Proxy, maybe I should make more tests but deploying MySQL-Proxy was easier as you define the backends as arguments in command line.

I plan to use a MySQL proxy in production as load-balancer in combination with replication and redirect all DML queries to the master.

Does one of you already use one of those two projects in production, what’s your feedback ?

You can also find more information on DLM here.

It would be maybe nice to have a kind of buffer if for any reasons the backends servers are not responding ?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

I deeply value the diversity of MySQL developers, users, community and my blog readers. I cannot agree the suffering, oppression, and systemic racism the Black community faces every day. Black lives matter.