Comments on: Various Ways to Perform Schema Upgrades with Percona XtraDB Cluster https://www.percona.com/blog/various-ways-to-perform-schema-upgrades-with-percona-xtradb-cluster/ Wed, 18 Nov 2020 21:19:08 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Juan Manuel https://www.percona.com/blog/various-ways-to-perform-schema-upgrades-with-percona-xtradb-cluster/#comment-10972754 Wed, 07 Oct 2020 11:50:12 +0000 https://www.percona.com/blog/?p=71784#comment-10972754 I have a doubt about how you have managed to use gh-ost with Galera / XtraDB cluster, since the use of locks is a limitation that has it and makes impossible the operation of gh-ost in normal conditions [1]. The only two ways I know to make it work with gh-ost are:

* Using only one node for the writes and using the two-step cutover [2].
* Using the trigger cutover that I added to gh-ost [3]

How have you dealt with this problem?

[1]: https://gonlo2.github.io/blog/en/blog/2020-03-04-why-dont-you-see-ghosts-in-galeras/
[2]: https://github.com/github/gh-ost/issues/224#issuecomment-410521022
[3]: https://github.com/github/gh-ost/pull/780

]]>