Skip navigation links

MySQL Forums :: Proxy :: Mysql Proxy Slave Unknown


Advanced Search

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 1487 dileep ch 02/18/2013 12:36AM
Re: Mysql Proxy Slave Unknown 599 Mike Wong 04/23/2013 02:01PM
Re: Mysql Proxy Slave Unknown 595 dileep ch 04/23/2013 08:43PM
Re: Mysql Proxy Slave Unknown 557 Mike Wong 04/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.