MySQL Forums
Forum List  »  Router & Proxy

Re: mysql proxy crash.
Posted by: cerlin gao
Date: September 12, 2007 09:06PM

in lua script there isnot define is_in_transaction,so i modify lua script as follows:
1)in function read_query(packet) add local is_in_transaction = 0
2)in function read_query_result( inj )
local res = assert(inj.resultset)
local flags = res.flags
locat is_in_transaction1 =0
if inj.id ~= 1 then -- ignore the result of the USE <default_db>
return proxy.PROXY_IGNORE_RESULT
end
is_in_transaction = flags.in_trans
if is_in_transaction1 == 0 then -- release the backend proxy.connection.backend_ndx = 0
endend

Only modify like this can achieve r/w splitting,but mysql proxy will crash.How to modify?

Options: ReplyQuote


Subject
Views
Written By
Posted
7508
September 12, 2007 07:51PM
2716
September 12, 2007 08:41PM
Re: mysql proxy crash.
2827
September 12, 2007 09:06PM


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.