Skip navigation links

MySQL Forums :: Proxy :: Mysql proxy not working when slave server stops


Advanced Search

Mysql proxy not working when slave server stops
Posted by: Gautam Prashant ()
Date: February 26, 2012 09:35AM

Hi,

I have mysql proxy setup between a master-slave configuration. Whenever I stop the slave server, mysql proxy stops working. Below is my configuration:

[mysql-proxy]
daemon = true
keepalive = true
proxy-address = 10.210.6.260:8806
#admin-address=10.210.6.213:4041

# db0
proxy-backend-addresses = 10.210.6.260:9606

# db1
proxy-backend-addresses = 10.210.6.261:9606

log-file=/mysql_proxy/mysqlproxy/proxy.log
mysql-proxy.conf (END)


Mysql proxy starts using the below given script:

/mysql_proxy/mysqlproxy/libexec/mysql-proxy --defaults-file=/mysql_proxy/mysqlproxy/mysql-proxy.conf

The error when the slave server stops is:

(proxy) all backends are down


Pl. note that when master server stops, the proxy works correctly. However, its only when the slave server is down, proxy server stops working.

Let me know what exactly the issue is.

Thanks.



Edited 1 time(s). Last edit at 02/26/2012 03:27AM by Gautam Prashant.

Options: ReplyQuote


Subject Views Written By Posted
Mysql proxy not working when slave server stops 2111 Gautam Prashant 02/26/2012 09:35AM
Resolved: Mysql proxy not working when slave server stops 1091 Gautam Prashant 02/27/2012 09:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.