Do you use sharding-proxy?
If you use sharding-proxy, you can send `sctl:set transaction_type=` before you begin transaction. you also can get information in https://shardingsphere.apache.org/document/current/en/manual/sharding-proxy/usage/ -- Yi Yang(Sion) Apache ShardingSphere At 2019-09-09 10:28:42, "Eric" <etmpoon...@gmail.com> wrote: >Hi Sion, > >Thank you. The document uses TransactionTypeHolder to modify transaction >type in Java. Is it possible to set it in proxy yaml file? > >Regards, >Eric Poon > >On Mon, Sep 9, 2019 at 8:45 AM Sion Yang <schoolp...@163.com> wrote: > >> Hi, >> >> >> There are three kinds of distributed transaction in ShardingSphere, local, >> two phase commit and BASE. >> Default is local transaction. >> >> >> For local transaction, if the SQL execute failed before commit, all >> sharding data node will be rollback. >> If failed in commit, the other sharding data node will not be rollback. >> >> >> Detail information can see the document >> https://shardingsphere.apache.org/document/current/en/features/transaction/ >> >> >> -- >> >> Yi Yang(Sion) >> Apache ShardingSphere >> >> >> >> At 2019-09-09 06:31:23, "Eric" <etmpoon...@gmail.com> wrote: >> >Hi, >> > >> >If a shard fail on a transaction, would the transactions on the other >> >shards rolled back together? >> > >> >Let say I have 100 payments being updated in one sql statement (e.g. >> update >> >payment set remark = 'xxx' where customer = 'yyy'), the records are >> >distributed on several shards. A shard failed to update the records. Would >> >other shards roll back the updates? >> > >> >Best Regards, >> >Eric Poon >>