Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Transaction Isolation Levels are Consistent
Updated on 2024-11-30 GMT+08:00

Checking Whether the Transaction Isolation Levels are Consistent

During MySQL migration, the transaction isolation levels of the source and destination databases must be the same.

Failure Cause

The transaction isolation levels of the source and destination databases are inconsistent.

Handling Suggestion

Change the value of the database isolation level parameter (tx_isolation or transaction_isolation) to ensure that the transaction isolation levels of the source and destination databases are the same.

  • MySQL 5.7 and 5.6: tx_isolation
  • MySQL 8.0: transaction_isolation