What Is the Performance Impact of 2nd Gen On-Demand Backups?

[Skyler Slade]

Hi there,

I would like to perform backups of my second generation Cloud SQL master more frequently than the automated backups schedule currently allows. I would like to make a backup every hour, or ever few hours, if possible. In the second generation docs, of on-demand backups, it's written:

For Second Generation instances, the FLUSH TABLES WITH READ LOCK flag is not used for backups. This means that writes and other operations are unaffected by backup operations.

 

https://cloud.google.com/sql/docs/mysql/backup-recovery/backups 

This doesn't say anything specifically about the performance implications of on-demand backups, however. What performance impact is there to a second generation Cloud SQL instance when performing an on-demand backup. Is there no, or negligible impact? Is there a reason I should not perform backups once per hour?

Thank you in advance.

[David Newgas]

Second Generation on demand backups have the same performance impact as the scheduled backups, ie negligible.

--
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+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/231b3266-cafd-4cad-89db-cb04094b87c1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Skyler Slade]

Wonderful, thank you!