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 ?

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 ?

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

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.

As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

You can find articles I wrote on Oracle’s blog.

Continue