MySQL Forums
Forum List  »  Router & Proxy

Can mysql-proxy hanlde multiple tables transaction ?
Posted by: fangyi qi
Date: March 16, 2012 07:10PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Can mysql-proxy hanlde multiple tables transaction ?
4236
March 16, 2012 07:10PM


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.