MySQL proxies

on
Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

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 ?

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Leave a Reply

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

recent

Last Tweets Last Tweets

Locations of visitors to this page
categories