Bug #77870 Failing proxy when loadbalancing
Submitted: 29 Jul 2015 10:16 Modified: 11 May 2018 16:07
Reporter: PO co dlaczemu Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Proxy Severity:S5 (Performance)
Version: OS:FreeBSD
Assigned to: CPU Architecture:Any

[29 Jul 2015 10:16] PO co dlaczemu
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
[11 May 2018 16:07] Miguel Solorzano
MySQL Proxy is not GA, and is not recommended for Production use.
We recommend MySQL Router for production use. Download MySQL Router ยป