MySQL Forums
Forum List  »  Router & Proxy

mysql-proxy rw-splitting.lua error
Posted by: jeffin mathew
Date: November 28, 2012 02:37AM

Hi,

I am using mysql-proxy for rw-splitting and load balancing. But when ever i started mysql-proxy with rw-splitting script i am not able to connect to mysql-proxy machine from slave, it gives me the following error

# mysql -uroot -pmysql -h 192.168.0.108 -P4040
ERROR 1105 (00000): #07000MySQL Proxy Lua script failed to load. Check the error log.

I am a new newbie in this please lell me what is the error,

adding my mysql-proxy configuration file below


[mysql-proxy]
daemon = true

pid-file = /usr/local/src/mysql-proxy/mysql-proxy.pid
log-file = /usr/local/src/mysql-proxy/mysql-proxy.log
log-level = message

proxy-backend-addresses = 192.168.0.108:3306

proxy-read-only-backend-addresses = 192.168.0.109:3306,192.168.0.111:3306

proxy-lua-script = /usr/local/src/mysql-proxy/active-queries.lua,/usr/local/src/mysql-proxy/rw-splitting.lua

keepalive = true

why it is not taking the rw-splitting.lua script, please help me in this.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql-proxy rw-splitting.lua error
6280
November 28, 2012 02:37AM
2901
November 29, 2012 12:09AM
2822
December 07, 2012 04:52AM


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.