Myshiner opened a new issue #2625: Which transaction type should in sharding-proxy URL: https://github.com/apache/incubator-shardingsphere/issues/2625 Hello, I used sharding-proxy, which transaction type should i configure in the server.yaml, Local ? BASE or XA ? whats the difference about this three types ? I encountered a problem when i use proxy to connect mysql. if I open a trancation in the programn code, start transaction and then insert into test_update(uname,addr) values('Daixin','Jiaxing') and then select * from test_update where uname='Daixin', you know i can't get the desired result before commit(end the transaction), why ? but if i dont use proxy connect to mysql directly, it works. eg. start transaction; insert into test_update(uname,addr) values('Daixin','Jiaxing'); select * from test_update where uname='Daixin'; commit; before the "commit;"， you cant get result by "select * from test_update where uname='Daixin';" In this case, i configed transaction type to be "LOCAL" and also try "BASE" in server.yaml.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
