why rw-splitting.lua not work .
I want to check rw-spliting ,mysql proxy version is 0.6.0
master is 172.16.52.54 slave is 172.16.52.48
replication db is backup
on master :
mysql>use backup;
mysql>show tables;
+------------------+
| Tables_in_backup |
+------------------+
| proxy |
+------------------+
mysql>select * from proxy;
+----------+
| name |
+----------+
| testing |
| lsps-efd |
+----------+
on slave :
mysql>use backup;
mysql>show tables;
+------------------+
| Tables_in_backup |
+------------------+
| proxy |
+------------------+
mysql>select * from proxy;
+----------+
| name |
+----------+
| testing |
| 2 |
| lsps-efd |
+----------+
# ./mysql-proxy --proxy-read-only-backend-addresses=172.16.52.48:3306 --proxy-lua-script=rw-splitting.lua
in the client :172.16.52.12
C:\>mysql -h172.16.52.54 -utesting -ptesting -P 4040 -D backup -e "select * from proxy;"
+----------+
| name |
+----------+
| testing |
| lsps-efd |
+----------+
this resultset is from master not slave ,so rw-spliting.lua do not work , my rw-spliting.lua content come from
http://svn.mysql.com/svnpublic/mysql-proxy/trunk/examples/tutorial-keepalive.lua
Can you tell me the reason ?
How can I do ?
thank you ..