Bug #38341 proxy-read-only-backend-addresses don't work
Submitted: 24 Jul 2008 10:10 Modified: 28 Feb 2011 20:29
Reporter: Yordan Georgiev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Proxy: Core Severity:S1 (Critical)
Version:0.6.1 OS:Linux
Assigned to: MC Brown CPU Architecture:Any
Tags: mysql-proxy

[24 Jul 2008 10: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 16: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.
[21 Jan 2010 14:01] MC Brown 
This has now been addressed in a later version of mysql-proxy. You may also want to view http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy-using-admin.html
[7 Feb 2011 15:43] Jon Stephens 
Santo asked me about this on IRC -- apparently no changelog entry was ever written, so I'm setting it back to Documenting status.
[28 Feb 2011 20:29] Paul DuBois 
Noted in 0.8.1 changelog.

The --proxy-read-only-backend-addresses option did not work.