MySQL Forums
Forum List  »  Router & Proxy

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.

Options: ReplyQuote


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.