Bug #38341 proxy-read-only-backend-addresses don't work
Submitted: 24 Jul 2008 12:10 Modified: 24 Jul 2008 18:17
Reporter: Yordan Georgiev
Status: Verified
Category:Proxy: Core Severity:S1 (Critical)
Version:0.6.1 OS:Linux
Assigned to: MC Brown Target Version:
Tags: mysql-proxy
Triage: D5 (Feature request)

[24 Jul 2008 12:10] Yordan Georgiev 
Description:
proxy-read-only-backend-addresses don't work

How to repeat:
1. ./configure --prefix=/usr/local/mysql-proxy
--with-mysql=/usr/local/mysql/bin/mysql_config --with-lua --enable-maintainer-mode
--enable-dependency-tracking  --with-gnu-ld
2. make
3. make install 

4. LUA_PATH="/usr/local/mysql-proxy/share/mysql-proxy/proxy/?.lua"
/usr/local/mysql-proxy/sbin/mysql-proxy --proxy-lua-script=./lib/rw-splitting.lua
--proxy-backend-addresses=10.10.10.208:3306
--proxy-read-only-backend-addresses=10.10.10.209:3306

5. mysql --host=10.10.10.208 --port=4041
mysql> select * from proxy_config;
+----------------------------+------------------------+
| option                     | value                  |
+----------------------------+------------------------+
| admin.address              | :4041                  |
| proxy.address              | :4040                  |
| proxy.lua_script           | ./lib/rw-splitting.lua |
| proxy.backend_addresses[0] | 10.10.10.208:3306      |
| proxy.fix_bug_25371        | 0                      |
| proxy.profiling            | 1                      |
+----------------------------+------------------------+
6 rows in set (0.00 sec)
[24 Jul 2008 18:17] Sveta Smirnova 
Thank you for the report.

Verified as described. Although this is limitation of the admin module: you can check
existance of read-only backend using custom lua script.