Mysql Proxy Slave Unknown
Posted by:
dileep ch
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.
Subject
Views
Written By
Posted
Mysql Proxy Slave Unknown
5532
February 18, 2013 12:36AM
2784
April 23, 2013 02:01PM
2585
April 23, 2013 08:43PM
2569
April 24, 2013 03:43PM
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.