MySQL Forums
Forum List  »  Router & Proxy

Re: Architecture problem, rw-splitter does not work
Posted by: Tiago Cruz
Date: May 09, 2008 03:49PM

Yeah Daniel,

Really SVN version + this workaround does this work:
http://bugs.mysql.com/bug.php?id=30304

I'm using on this way:

LUA_PATH="/usr/local/share/mysql-proxy/?.lua" mysql-proxy --plugins=admin --plugins=proxy --log-level=debug --defaults-file=/etc/mysql-proxy.conf

[mysql-proxy]
proxy-address = 10.25.0.12:4040
proxy-backend-addresses = 10.25.0.12:3306
proxy-read-only-backend-addresses = 10.25.0.11:3306
proxy-read-only-backend-addresses = 10.25.0.3:3306
proxy-lua-script=/usr/local/share/mysql-proxy/rw-splitting.tiago.lua

But I can't see yet the 10.25.0.11 on action... all queries goes to .12 and .3, never of .11...

If I use this conf file:

[mysql-proxy]
proxy-address = 10.25.0.12:4040
proxy-backend-addresses = 10.25.0.12:3306
proxy-read-only-backend-addresses = 10.25.0.3:3306
proxy-read-only-backend-addresses = 10.25.0.11:3306
proxy-lua-script=/usr/local/share/mysql-proxy/rw-splitting.tiago.lua

My queries always goes to .12 and .11, never .3... and I not understood why :-(

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Architecture problem, rw-splitter does not work
3518
May 09, 2008 03:49PM


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.