MySQL Forums
Forum List  »  Router & Proxy

mysql proxy issue: backend servers "State" is "Unknown"
Posted by: Mike Wong
Date: April 23, 2013 04:34PM

Not sure if anyone cares to help me or not. But I just setup mysql proxy running 0.8.3 on two mysql servers running master and slave configuration. I follow several instructions on the web to have it configured. when I used the admin monitoring to SELECT * FROM backends;

It showd that all of my backend servers are in "unknown" state:

mysql> SELECT * FROM backends;
+-------------+------------------+---------+------+------+-------------------+
| backend_ndx | address | state | type | uuid | connected_clients |
+-------------+------------------+---------+------+------+-------------------+
| 1 | 172.16.10.94:3306 | unknown | rw | NULL | 0 |
| 2 | 172.16.10.93:3306 | unknown | ro | NULL | 0 |
+-------------+------------------+---------+------+------+-------------------+
2 rows in set (0.00 sec)

Here is my config file:

# MySQL Proxy's configuration file (mysql-proxy.cnf)

[mysql-proxy]
daemon = true
proxy-address=172.16.10.45:4040
admin-lua-script = /opt/mysql-proxy-0.8.3/lib/mysql-proxy/lua/admin.lua
admin-username = admin
admin-password = xxxxxx
pid-file = /opt/mysql-proxy-0.8.3/mysql-proxy.pid
log-file = /opt/mysql-proxy-0.8.3/mysql-proxy.log
log-level = debug
plugins = proxy,admin
plugin-dir=/opt/mysql-proxy-0.8.3/lib/mysql-proxy/plugins
proxy-backend-addresses = 172.16.10.94:3306
proxy-read-only-backend-addresses = 172.16.10.93:3306
proxy-lua-script = /opt/mysql-proxy-0.8.3/lua/rw-splitting.lua
proxy-lua-script = /opt/mysql-proxy-0.8.3/lua/auditing.lua
proxy-lua-script = /opt/mysql-proxy-0.8.3/lua/active-queries.lua
proxy-lua-script = /opt/mysql-proxy-0.8.3/lua/ro-pooling.lua
keepalive = true


Not sure what I'm doing wrong??? Hopefully someone can help...

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql proxy issue: backend servers "State" is "Unknown"
6446
April 23, 2013 04:34PM


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.