I recently worked on a case where one node of a Galera cluster had its schema desynchronized with the other nodes. And that was although Total Order Isolation method was in effect to perform the schema changes. Let’s see what happened.
For those of you who are not familiar with how Galera can perform schema changes, here is a short recap:
- Two methods are available depending on the value of the
wsrep_OSU_methodsetting. Both have benefits and drawbacks, it is not the main topic of this post.
- With TOI (Total Order Isolation), a DDL statement is performed …