[Sqlrelay-discussion] sqlrelay - mysql returns 10 rows always

[Sekou A. <sek...@to...>]

I have configured sqlrelay in the following scenario:

router instance routes/filters queries to two instances, =
sqlrelay-port9001
takes updates,inserts and all other type queries go to sqlrelay-port9002
mysql queries to sqlrelay-port9001 & sqlrelay-port9002 return full =
results
but mysql queries to router returns 10 rows of results no matter the =
query
type.

sqlrelay-port9001
<instance id=3D"master" port=3D"9001" socket=3D"/tmp/master.socket" =
dbase=3D"mysql"
connections=3D"12" maxconnections=3D"30" maxqueuelength=3D"10" =
growby=3D"2" ttl=3D"60"
endofsession=3D"commit" sessiontimeout=3D"600" runasuser=3D"nobody"
runasgroup=3D"nobody" cursors=3D"120" authtier=3D"listener" =
handoff=3D"pass"
maxquerysize=3D"655360" maxstringbindvaluelength=3D"40000"
maxlobbindvaluelength=3D"716800" idleclienttimeout=3D"-1">

sqlrelay-port9002
<instance id=3D"slave" port=3D"9002" socket=3D"/tmp/slave.socket" =
dbase=3D"mysql"
connections=3D"12" maxconnections=3D"60" maxqueuelength=3D"10" =
growby=3D"2" ttl=3D"60"
endofsession=3D"commit" sessiontimeout=3D"600" runasuser=3D"nobody"
runasgroup=3D"nobody" cursors=3D"20" authtier=3D"listener" =
handoff=3D"pass"
maxquerysize=3D"655360" maxstringbindvaluelength=3D"40000"
maxlobbindvaluelength=3D"716800" idleclienttimeout=3D"-1">

ROUTER
<instance id=3D"router" port=3D"9000" socket=3D"/tmp/router.socket" =
dbase=3D"router"
connections=3D"18" maxconnections=3D"90" maxqueuelength=3D"5" =
growby=3D"2" ttl=3D"60"
endofsession=3D"commit" sessiontimeout=3D"600" runasuser=3D"nobody"
runasgroup=3D"nobody" cursors=3D"10" authtier=3D"listener" =
handoff=3D"pass"
maxquerysize=3D"655360" maxstringbindvaluelength=3D"40000"
maxlobbindvaluelength=3D"716800" idleclienttimeout=3D"-1">

Any ideas?
			S. Sekou Abodunrin=20
		=09




This email is confidential and may also be privileged. If you are not =
the intended recipient please notify us immediately by telephoning +44 =
(0)20 7452 5300 or email pos...@to.... You should not copy =
it or use it for any purpose nor disclose its contents to any other =
person. Touch Local cannot accept liability for statements made which =
are clearly the sender's own and are not made on behalf of the firm.

Touch Local Limited
Registered Number: 2885607
VAT Number: GB896112114
Cardinal Tower, 12 Farringdon Road, London EC1M 3NN
+44 (0)20 7452 5300