Hi Sion, That's very helpful but I don't know how to send the SCTL to the proxy. Is it a custom Java program, command prompt, or inside a configuration file?
Please help. Best Regards, Eric Poon On Mon, Sep 9, 2019 at 10:52 AM Sion Yang <[email protected]> wrote: > 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" <[email protected]> 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 <[email protected]> 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" <[email protected]> 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 > >> >
