Although Apache ShardingSphere aims at being compatible with all distributed scenario and providing the best performance, under the CAP theorem guidance, there is no sliver bullet with distributed transaction solution.
The Apache ShardingSphere community chose instead to give the users the ability to choose their preferred distributed transaction type and use the most suitable solution according to their scenarios.
Does not support the cross-database transactions caused by network or hardware crash. For example, when updating two databases in transaction, if one database crashes before commit, then only the data of the other database can commit.
Recover committing and rolling back in other machines after the service is down.
MySQL, in the transaction block, the SQL execution is abnormal, and run Commit, and data remains consistent.
After XA transactions are configured, the maximum length of the storage unit name cannot exceed 45 characters.