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.
Subject
Views
Written By
Posted
6300
September 24, 2007 08:37PM
3756
October 03, 2007 07:41AM
Re: module 'proxy.commands' not found
6497
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.