Skip navigation links

MySQL Forums :: Proxy :: R/W splitting. All requests only to write server.


Advanced Search

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
R/W splitting. All requests only to write server. 4370 Pavel Scherbakov 06/01/2009 06:15AM
Re: R/W splitting. All requests only to write server. 2629 Diego Medina 06/01/2009 09:45AM
Re: R/W splitting. All requests only to write server. 3660 Pavel Scherbakov 06/03/2009 06:03AM
Re: R/W splitting. All requests only to write server. 2582 Diego Medina 06/03/2009 01:11PM
Re: R/W splitting. All requests only to write server. 2277 Danila Lelaev 07/01/2009 07:07AM
Re: R/W splitting. All requests only to write server. 1983 Emmanuel Dyan 07/09/2009 01:11AM
Re: R/W splitting. All requests only to write server. 3009 Diego Medina 07/12/2009 08:46AM
Re: R/W splitting. All requests only to write server. 2297 Diego Medina 07/12/2009 07:44PM


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.