Monday, May 22, 2017

[google-cloud-sql-discuss] Verify couldsql backups.

Hi there,

We are trying to create a mechanism for periodic cloudsql-backup validation. 
This is our database setup:
cloudsql-master
  - cloudsql-failover
  - cloudsql-read-replica

We are running two replicas to our master and taking the backups of master every hour. 
As of now our plan is to 
- create a new cloudsql-instance
- restore one of the backups to the new cloudsql-instance
- make this cloudsql-instance a replica to the cloudsql-master
- run the pt-table-checksum against cloudsql-master which then verifies validity of master with all its replicas.

My questions:
- Is is possible to make the cloudsql-instance a replica to cloudsql-master? If so, is it safe to do so?
- Is there a better way to do this whole process altogether?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9c7efa78-e6d5-4917-abbf-88a0e8339378%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment