I had a look at the documentation on how to restore a single table, but when I try this in a percona cluster with galera replication, the table is not replicated to the other 2 nodes. Is it even possible to restore a single table in this case and if so how? As far as I am aware “alter table” is one of the restrictions and should not be used except for via the pt-online-schema-change tool. However, because the table contained triggers, it’s not possible to use the pt-online-schema-change tool.
Thanks for any advice,