Re: R/W splitting. All requests only to write server.

[Diego Medina]

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