Re: R/W splitting. All requests only to write server.
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