MySQL Forums
Forum List  »  Router & Proxy

Re: R/W splitting. All requests only to write server.
Posted by: Diego Medina
Date: July 12, 2009 08:46AM

Hi,

I was looking at the rw-splitting.lua last night and I found where the problem was.

I forgot to add resultset_is_needed = true to a prepend query. I'm still working on a fix, vut the line I had to modify was


proxy.queries:prepend(2, string.char(proxy.COM_INIT_DB) .. c.default_db, { resultset_is_needed = true })

and then, see the function read_query_resul()

and you have to remove the comment before

if inj.id ~= 1
and

the matching


return proxy.PROXY_IGNORE_RESULT
end


I hope to have a clean working patch later this week.

--
Diego Medina, QA Engineer
Enterprise Tools - Database Group, Sun Microsystems

Are you MySQL certified? http://www.mysql.com/certification

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: R/W splitting. All requests only to write server.
3801
July 12, 2009 08:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.