Can mysql-proxy hanlde multiple tables transaction ?

[fangyi qi]

I tested mysql-proxy0.8.2 based mysql5.1.6 last week,the case is:
front: mysql-proxy
backends: one master,one slave
transaction: insert two records into different two tables on one database

But i foud sometimes the transaction can not rollback successfully. In this case i use rw-splitting.lua. Through mysql-proxy's log, i found :

[read_query] 192.168.1.140:53128
current backend = 0
client default db = testdb
client username = test
query = insert into test(...) value(...)
sending to backend : 192.168.1.213:3000
is_slave : false
server default db : testdb
server username = test
in_trans : false
in_calc_fount : false
COM_QUERY : true


after the first sql. Why "in_trans" somestimes was true,sometimes was false?

Questions:
1.I want to know if mysql-proxy can support transaction across multiplue tables.
2.Can i use rw-splitting.lua to handle transaction across multiplue tables? or what can i do?

thanks a lot!



Edited 4 time(s). Last edit at 03/17/2012 07:59PM by fangyi qi.