mysql-proxy-discuss team mailing list archive

[Georg Moritz <georg.moritz@xxxxxxxxxxxx>]

>From the keyboard of Diego Medina [20.07.09,16:06]:

> Hi Georg,
> 
> Are you using a mysql proxy "in between" the replication between your
> master and slave? Or are you using a proxy in between your web
> application and the database?

Yes, I am using mysql in between the replication. But it is not a web
application - it is a SpamAssassin Bayes DB.
I am using a mysql proxy on each node. On the master node, additionally
the mysql master proxy is running, which gets all write requests.

> In either case, could you identify what query is causing the error?

The replication works fine. As you can see from the debug log, the query
is an UPDATE query:

[read_query] 10.1.2.3:35749
current backend = 0
client default db = database
client username = db_user
query = UPDATE my_table
SET field = '1247940149'
WHERE id = '2'
AND field < '1247940149'
statement = TK_SQL_UPDATE
sending to backend : 10.1.2.1:4040
is_slave : false
server default db: database
server username : db_user
in_trans : false
in_calc_found : false
COM_QUERY : true 

This is odd, since the same runs fine if I omit the rw-splitting lua script
from the mysql-proxy command line parameters. But doing so also directs all
read requests to the master proxy.

0--gg-

> Thanks.
> 
> Diego
> 
> On Sat, Jul 18, 2009 at 5:44 PM, Georg Moritz<georg.moritz@xxxxxxxxxxxx> wrote:
> >
> > IMHO MySQL-Proxy shold handle an EOF gracefully. If I omit the rw-splitting.lua
> > script, all queries are sent to the MySL Master Proxy - that works like a charm;
> > but I need read/write splitting...
> >
> > Any clues?
> >
> > 0--gg-
> >
> >
> > --
> > _($_=" "x(1<<5)."?\n".q/)Oo.  G\        /
> >                              /\_/(q    /
> > ----------------------------  \__(m.====.(_("always off the crowd"))."
> > ");sub _{s,/,($e="'Itrs `mnsgdq Gdbj O`qkdq")=~y/"-y/#-z/;$e,e && print}
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~mysql-proxy-discuss
> > Post to     : mysql-proxy-discuss@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~mysql-proxy-discuss
> > More help   : https://help.launchpad.net/ListHelp
> >
> 
> 
> 
> 

-- 
_($_=" "x(1<<5)."?\n".q·/)Oo.  G°\        /
                              /\_¯/(q    /
----------------------------  \__(m.====·.(_("always off the crowd"))."·
");sub _{s./.($e="'Itrs `mnsgdq Gdbj O`qkdq")=~y/"-y/#-z/;$e.e && print}