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
7462
September 12, 2007 07:51PM
2693
September 12, 2007 08:41PM
Re: mysql proxy crash.
2801
September 12, 2007 09:06PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.