Bug #30926 MySQL Proxy goes down if the two MySQL instances are down.

• Submitted: 10 Sep 2007 7:44
• Modified: 10 Sep 2007 8:33
• Reporter: Prashant Varshney
• Status: Can't repeat
• Category: MySQL Proxy: Core
• Severity: S1 (Critical)
• Version: 0.5.1
• OS: Linux
• CPU Architecture: Any
• Tags: MySQL Proxy with two MySQL servers.

[10 Sep 2007 7:44] Prashant Varshney

Description:
I'm running a test case where I bring down both the MySQL servers one by one. My application is connecting to MySQL server through MySQL Proxy.

I've observed that when both the instances are down, MySQL Proxy also goes down with the following lines in the log file.

[warn] epoll_create: Function not implemented
network-mysqld.c.367: connect(172.16.131.50:3306) failed: Connection refused
network-mysqld-proxy.c.2405: connecting to backend (172.16.131.50:3306) failed, marking it as down for ...
network-mysqld.c.367: connect(172.16.131.40:3306) failed: Connection refused
network-mysqld-proxy.c.2405: connecting to backend (172.16.131.40:3306) failed, marking it as down for ...
network-mysqld-proxy.c.2396: all the backends are down
network-mysqld.c.920: plugin_call(CON_STATE_CONNECT_SERVER) returned an error

How to repeat:
Define two instances of MySQL servers in MySQL proxy through '--proxy-backend-addresses' option. Bring one instance down followed by another.

[10 Sep 2007 8:33] Giuseppe Maxia

Hi,
Thanks for your report.
I can't repeat the behavior you describe using Proxy 0.6.0.

Can you try with the latest version? 
You need to compile it from SVN 
http://dev.mysql.com/doc/refman/5.0/en/mysql-proxy-install-svn.html

or wait for the new binaries (very soon)