Talk:MySQL Proxy
The proxy should be connected to a MySQL 5.0 server. I just tried with a 4.1 server, and it hangs.
Wouldn't be better if the proxy detected the older protocol and aborted?
(Giuseppe)
[edit] mysql-proxy load balance problem
When using mysql-proxy to load balance two servers, I've setup the program to run like:
mysql-proxy --proxy-backend-addresses=10.134.121.181:3306 --proxy-backend-addresses=10.134.121.151:3306
When I connected:
mysql --port 4040
i got connected to the local version of mysql. Now, I tried shutting down the local mysql and test that i could connect to the other mysql, it didn't work and i got the usual "cannot connect" error:
ERROR 2002 (HY00): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
There isn't a lot to go off here, but if anyone else has seen this, or has a fix I'd sure be interested in it.
(dpalmer)