[GitHub] [incubator-shardingsphere] Myshiner opened a new issue #2625: Which transaction type should in sharding-proxy

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org


With regards,
Apache Git Services