[Sqlrelay-discussion] Problems in setting up sqlrelay in rw-splitting mode. Using two mysql servers

[Abhijeet <abh...@gm...>]

Hi ,

My sqlrelay.conf file is as follows


<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
        <instance id="master" port="9001" socket="/tmp/master.lock"
dbase="mysql" connections="1" maxconnections="15" maxqueuelength="5"
growby="1" ttl="60" endofsession="commit" sessiontimeout="600"
runasuser="asane" runasgroup="asane" cursors="5" authtier="listener"
handoff="pass" deniedips="" allowedips="" debug="none"
maxquerysize="65536" maxstringbindvaluelength="4000"
maxlobbindvaluelength="71680" idleclienttimeout="-1">

                <users>
                        <user user="root" password="root"/>
                </users>
                <connections>
                        <connection connectionid="master"
string="user=root;password=root;db=tango_dev;host=a.b.c.d;port=3306;fakebinds=yes"
metric="1" behindloadbalancer="no"/>
                </connections>
        </instance>
        <instance id="slave" port="9002" socket="/tmp/slave.lock"
dbase="mysql" connections="1" maxconnections="15" maxqueuelength="5"
growby="1" ttl="60" endofsession="commit" sessiontimeout="600"
runasuser="asane" runasgroup="asane" cursors="5" authtier="listener"
handoff="pass" deniedips="" allowedips="" debug="none"
maxquerysize="65536" maxstringbindvaluelength="4000"
maxlobbindvaluelength="71680" idleclienttimeout="-1">

                <users>
                        <user user="root" password=""/>
                </users>
                <connections>
                        <connection connectionid="slave"
string="user=root;password=root;db=tango_dev;host=a.b.c.d;port=3307;fakebinds=yes"
metric="2" behindloadbalancer="no"/>
                </connections>
        </instance>
        <instance id="router" port="9000" socket="/tmp/slave.lock"
dbase="router" connections="1" maxconnections="15" maxqueuelength="5"
growby="1" ttl="60" endofsession="commit" sessiontimeout="600"
runasuser="asane" runasgroup="asane" cursors="5" authtier="listener"
handoff="pass" deniedips="" allowedips="" debug="none"
maxquerysize="65536" maxstringbindvaluelength="4000"
maxlobbindvaluelength="71680" idleclienttimeout="-1">
                <users>
                        <user user="root" password="root"/>
                </users>
                <router>
                        <route host="" port=""
socket="/tmp/master.lock" user="root" password="root">
                               <query pattern="^\s*create\s+table\s+"/>
                               <query pattern="^\s*drop\s+table\s+"/>
                               <query pattern="^\s*insert\s+into\s+"/>
                               <query pattern="^\s*delete\s+from\s+"/>
                               <query pattern="^\s*update\s+"/>
                        </route>
                        <route host="" port=""
socket="/tmp/slave.lock" user="root" password="root">
                               <query pattern=".*"/>
                        </route>
                </router>
        </instance>

</instances>


I am trying to setup sqlrelay in a rw-splitting mode. I have two mysql
databases which I am using in rw-splitting mode for performance
scaling .
It seems to me that when i configure only one database in the config
file and start sqlr-stat -id master  the connection is working as
expected .
( sqlrsh -id master   and select count(*) from tablename is working
correctly) ( No scaling possible)

But the moment i use the sqlr-start -id router . All process start but
sqlrsh is not showing me any data in fact it hangs.

> sqlrsh -id router
SQLRShell - Version 0.22
        Connected to: localhost:9000 as root

        type help; for a help.

0> use db;select count(*) from table_name;

(nothing  happens)


Please guide where my setting is going wrong .

Thanks in advance.

Abhijeet Anant Sane