MySQL Forums
Forum List  »  Router & Proxy

R/W splitting. All requests only to write server.
Posted by: Pavel Scherbakov
Date: June 01, 2009 06:15AM

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?

Options: ReplyQuote




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.