Resolved: Mysql proxy not working when slave server stops

[Gautam Prashant]

Hi,

This issue has been resolved. The problem was in the conf file.

**********************************************************************

# db0
proxy-backend-addresses = 10.210.6.260:9606

# db1
proxy-backend-addresses = 10.210.6.261:9606

***********************************************************************

I changed this to:

***********************************************************************

proxy-backend-addresses=10.210.6.260:9606,10.210.6.261:9606


************************************************************************

And the problem got resolved. Hence we should give the IP addresses in a single line for failover scenerio to work.