Hello,
This question is already asked many times, but I want to help.
I understand Galera use "Snapshot Isolation" transaction level, which is special level between REPEATABLE READ and SERIALIZABLE.
#####
When using Galera Cluster in master-slave mode, all four levels are available to you, to the extend that MySQL supports it. In multi-master mode, however, you can only use the REPEATABLE-READ level.
#####
A above comment mean, in multi-master mode, it is necessary for using "Snapshot Isolation" to set tx_isolation = REPEATABLE-READ, is it alright ?
I don't understand why we can only use the REPEATABLE-READ level, so please help me...
Best regard,