R/W splitting. All requests only to write server.
I have mysql-proxy-0.6.1.
Start script:
#!/bin/bash
MASTERDB=10.0.87.138
SLAVEDB01=10.0.87.223
SLAVEDB02=10.0.87.163
ROOT_DIR=/usr
LUA_PATH="$ROOT_DIR/share/mysql-proxy/?.lua" $ROOT_DIR/sbin/mysql-proxy \
--daemon \
--proxy-backend-addresses=$MASTERDB:3306 \
--proxy-read-only-backend-addresses=$SLAVEDB01:3306 \
--proxy-read-only-backend-addresses=$SLAVEDB02:3306 \
--proxy-read-only-backend-addresses=$SLAVEDB03:3306 \
--proxy-lua-script=$ROOT_DIR/share/mysql-proxy/rw-splitting.lua
When I connect to port 4040, all my requests go only to one host - 10.0.87.138.
Why SELECT request don't go to slave DB?
Subject
Views
Written By
Posted
R/W splitting. All requests only to write server.
5583
June 01, 2009 06:15AM
3225
June 01, 2009 09:45AM
4312
June 03, 2009 06:03AM
3192
June 03, 2009 01:11PM
2871
July 01, 2009 07:07AM
2527
July 09, 2009 01:11AM
4588
July 12, 2009 08:46AM
2850
July 12, 2009 07:44PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.