How is backup consistency guaranteed and checked in PXC?

1

Hi there,

I would like to learn more about how to verify data consistency in PXC backups.

When taking a backup of a running Galera/PXC node (xtrabackup tool), how exactly is consistency verified? Are there specific variables, metrics, logs, or files that I should check? Also, which tools should be used to examine the backup consistency?

I assume the best approach is to perform a test restore and then check the data, but are there any other methods to verify the backup without doing a full restore?

Your contribution would be much appreciated!

2

As long as the backup completes with the status **“Completed OK!”**and it is “prepared” without any errors; it can be considered consistent. However, the recommended best practice is to validate backup consistency by performing a restore test and configuring the restored instance as a replica of the existing database node.

1 Like
3

Thank you so much @Abhinav_Gupta for your precise and clear answer!

1 Like