MySQL Forums
Forum List  »  Router & Proxy

Re: module 'proxy.commands' not found
Posted by: Safari -
Date: October 03, 2007 10:23PM

Running mysql-proxy command:
LUA_PATH="/usr/share/mysql-proxy/?.lua" /usr/sbin/mysql-proxy --proxy-backend-addresses=127.0.0.1:3306 --proxy-read-only-backend-addresses=172.19.1.151:3306 --proxy-lua-script=/usr/share/mysql-proxy/rw-splitting.lua

and then issue command: "select * from proxy_config;" from ADMIN console, I got the following information:
+----------------------------+-----------------------------------------+
| option | value |
+----------------------------+-----------------------------------------+
| admin.address | :4041 |
| proxy.address | :4040 |
| proxy.lua_script | /usr/share/mysql-proxy/rw-splitting.lua |
| proxy.backend_addresses[0] | 127.0.0.1:3306 |
| proxy.fix_bug_25371 | 0 |
| proxy.profiling | 1 |
+----------------------------+-----------------------------------------+

Why there's no "proxy-read-only-backend-addresses" in the config?


Another problem is:
+ after using mysql client to connect to the server, issue command "use test".
+ exit mysql client
+ connect again
+ issue command "show databases", I got the following error: "ERROR 1105 (07000): can't change DB to on slave 127.0.0.1:3306";

What happened with this?


Please help.
Tks.

Options: ReplyQuote


Subject
Views
Written By
Posted
5836
September 24, 2007 08:37PM
3529
October 03, 2007 07:41AM
Re: module 'proxy.commands' not found
6056
October 03, 2007 10:23PM


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.