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 ?