>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<[email protected]> > 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 : [email protected] > > 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}
_______________________________________________ Mailing list: https://launchpad.net/~mysql-proxy-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~mysql-proxy-discuss More help : https://help.launchpad.net/ListHelp
