Re: proxy-read-only-backend-addresses

[David Palmer]

For more detailed information, below is starting mysql-proxy then checking the proxy_config:

[root@106260-dev1 init.d]# /usr/local/bin/mysql-proxy  --proxy-read-only-backend-addresses=192.168.1.90 \
 --proxy-backend-addresses=192.168.1.84 --daemon --pid-file=/var/run/mysql-proxy
[root@106260-dev1 init.d]# mysql -P 4041 -h 127.0.0.1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.1.20-agent

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from proxy_config;
+----------------------------+--------------+
| option                     | value        |
+----------------------------+--------------+
| admin.address              | :4041        |
| proxy.address              | :4040        |
| proxy.lua_script           | NULL         |
| proxy.backend_addresses[0] | 192.168.1.84 |
| proxy.fix_bug_25371        | 0            |
| proxy.profiling            | 1            |
+----------------------------+--------------+
6 rows in set (0.00 sec)

mysql>

as you can see, the read-only backend is completely ignored.