Limitations

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.

• MySQL, in the transaction block, the SQL execution is abnormal, and run , and data remains consistent.
• After XA transactions are configured, the maximum length of the storage unit name cannot exceed 45 characters.

• Does not support isolation level.