MySQL Forums
Forum List  »  Router & Proxy

proxy-backend-addresses problem
Posted by: joe joey
Date: September 24, 2010 10:38AM

Hello

i have a small problem , i have 2 backend server and mysql proxy write data only to the first of them, here is the config :
[mysql-proxy]
daemon = true
admin-lua-script=C:/mysql-proxy-0.8.1-win32-x86/share/do/mysql-proxy/rw-splitting.lua
log-file=c:/log.log
log-level = debug
admin-username = root
admin-password = 111111
proxy-backend-addresses=server1:3306,server2:3306

in this case data are inserted only to server 1 , if i change the location to
proxy-backend-addresses=server2:3306,server1:3306

then data are insert only to server 2 .
the log show

2010-09-24 19:32:19: (message) proxy listening on port :4040
2010-09-24 19:32:19: (message) added read/write backend: 127.0.0.1:3306
2010-09-24 19:32:19: (message) added read/write backend: 192.168.0.4:3306
2010-09-24 19:32:27: (debug) abs wait-for-event::done usec= 0
2010-09-24 19:32:27: (debug) abs lua-exec::done usec= 0
2010-09-24 19:32:51: (debug) abs wait-for-event::done usec= 0
2010-09-24 19:32:51: (debug) abs lua-exec::done usec= 0

Please help

Options: ReplyQuote


Subject
Views
Written By
Posted
proxy-backend-addresses problem
4593
September 24, 2010 10:38AM
1982
October 05, 2010 10:40AM


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.