Not the answer you need?
Register and ask your own question!

Restoring single table with galera replication

dnoblednoble EntrantLegacy User Role Beginner
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

Comments

  • miguelangelnietomiguelangelnieto Member Inactive User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.