This post is a continuation of our previous post on Online Schema Upgrade in Galera using TOI method. We will now show you how to perform a schema upgrade using the Rolling Schema Upgrade (RSU) method. This requires that the new schema is backward compatible with the old schema, so it requires a bit more planning than the TOI method. In some cases, you might need to turn off any connections to the target node.
If you are using non-uniform hardware across your Galera cluster, RSU might be preferable as the more predictable process. RSU does not slow down your[Read more...]