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
