Hello there,
We are trying to create an automated cloudsql backups validation process. We have read posts on cloudsql backups being corrupt and not being able to restore it. So we wanted to make sure the backups we take are valid!
This is our current set-up:
cloudsql-master
- cloudsql-read-replica
- cloudsql-failover-replica
We plan to do the following to validate our backups:
1. create a new instance: backup-instance
2. restore one of the backup files onto backup-instance
3. make backup-instance a read replica to cloudsql-master
4. run pt-table-checksum on cloudsql-master to verify if backups are valid and in sync with master
My question is:
- is it possible to do step 3 and 4?
- If not is there a better way to verify the validity of cloudsql-backups?
Thanks