Description:
mysql> select * from backends;
+-------------+---------------------+---------+------+------+-------------------+
| backend_ndx | address | state | type | uuid | connected_clients |
+-------------+---------------------+---------+------+------+-------------------+
| 1 | 10.10.10.4:3306 | up | rw | NULL | 0 |
| 2 | 10.10.10.5:3306 | unknown | ro | NULL | 0 |
+-------------+---------------------+---------+------+------+-------------------+
2 rows in set (0.00 sec)
Why this is happening? there is no answer over internet to this.
How to repeat:
1. set two instances of mysql 5.6
2. set up a replication master->slave
3. add this to mysql-proxy
[mysql-proxy]
daemon = true
user = mysql
proxy-skip-profiling = true
keepalive = true
max-open-files = 2048
event-threads = 50
pid-file = /var/run/mysql-proxy.pid
log-file = /var/log/mysql-proxy.log
log-level = debug
admin-address = 10.1.0.4:4401
admin-username = admin
admin-password = 12546
proxy-address = 10.1.0.4:3306
proxy-read-only-backend-addresses = 10.10.10.5:3306
proxy-backend-addresses = 10.123.123.123:3306
plugin-dir=/usr/local/lib/mysql-proxy/plugins
plugins=proxy,admin,debug,replicant
LUA_PATH = /usr/lib/mysql-proxy/lua/proxy/?.lua
LUA_CPATH = /usr/lib/mysql-proxy/lua/?.so
admin-lua-script=/usr/local/lib/mysql-proxy/lua/admin.lua
proxy-lua-script=/usr/local/lib/mysql-proxy/lua/proxy/rw-splitting.lua
proxy-lua-script=/usr/local/lib/mysql-proxy/lua/proxy/balance.lua
