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?
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.