Re: proxy-read-only-backend-addresses

[Tiago Cruz]

Same here... RHEL 5.1 x86_64


# lua -v
Lua 5.1.3 Copyright (C) 1994-2008 Lua.org, PUC-Rio

# pwd
/src/mysql-proxy-0.6.1

# mysql --port=4041 -h10.25.0.12
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 | lib/rw-splitting.lua |
| proxy.backend_addresses[0] | 10.25.0.12:3306 |
| proxy.fix_bug_25371 | 0 |
| proxy.profiling | 1 |
+----------------------------+----------------------+
6 rows in set (0.00 sec)

mysql> select * from proxy_connections;
+------+--------+-------+------+
| id | type | state | db |
+------+--------+-------+------+
| 0 | server | 0 | NULL |
| 1 | proxy | 0 | NULL |
| 2 | server | 10 | NULL |
+------+--------+-------+------+
3 rows in set (0.00 sec)



# LUA_PATH="lib/?.lua" src/mysql-proxy --proxy-read-only-backend-addresses=10.25.0.11:3306 --proxy-backend-addresses=10.25.0.12:3306 --proxy-lua-script=lib/rw-splitting.lua &



# ps -efww | grep proxy
root 13802 10753 0 18:02 pts/0 00:00:00 src/mysql-proxy --proxy-read-only-backend-addresses=10.25.0.11:3306 --proxy-backend-addresses=10.25.0.12:3306 --proxy-lua-script=lib/rw-splitting.lua

And loadbalance for R/W has not working...