[Sqlrelay-discussion] sqlrelay - mysql returns 10 rows always
Brought to you by:
mused
|
From: Sekou A. <sek...@to...> - 2007-04-26 09:15:45
|
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 |