Restoring single table with galera replication

MySQL & MariaDB Percona XtraBackup
1

Hi,

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,

Daniel

2

Hello,

If you do a xtrabackup restore of a single table, that one will not appear on the other nodes. Basically, you are doing a binary copy that is not using the binary log and therefore Galera library have no idea that table has been created and added to the database. If you want to restore a table and make it appear on all the other nodes, you need to restore a mysqldump. It contains the SQL (create, insert…) and that will be replicated to other nodes.

Regards.