Mysql Proxy Slave Unknown
Date: February 18, 2013 12:36AM
Hi,
I'm very new to mysql proxy. I configured proxy installed in one machine and Master and slave.
Proxy conf i used
[mysql-proxy]
daemon = true
log-level = debug
admin-address=10.0.1.11:4041
admin-username=root
admin-password=purpletalk
admin-lua-script=/usr/lib/mysql-proxy/lua/admin.lua
proxy-address=10.0.1.11:4040
proxy-read-only-backend-addresses=10.0.1.119:3306
proxy-backend-addresses=10.0.1.37:3306
proxy-skip-profiling=true
proxy-lua-script=/usr/lib/mysql-proxy/lua/proxy/balance.lua
When connecting with 4041
mysql> select * from backends;
+-------------+-----------------+---------+------+------+-------------------+
| backend_ndx | address | state | type | uuid | connected_clients |
+-------------+-----------------+---------+------+------+-------------------+
| 1 | 10.0.1.37:3306 | up | rw | NULL | 0 |
| 2 | 10.0.1.119:3306 | unknown | ro | NULL | 0 |
+-------------+-----------------+---------+------+------+-------------------+
I could not understand why 10.0.1.119 is unknown.
I started proxy using command
mysql-proxy --defaults-file=/etc/mysql-proxy/proxy.conf
Please do Help ..
Thanks,
Dileep.
Sorry, only registered users may post in this forum.
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.