Second Generation on demand backups have the same performance impact as the scheduled backups, ie negligible.
On Mon, Apr 24, 2017 at 10:38 AM, Skyler Slade <skyler.slade@sharpspring.com> wrote:
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.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.
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/231b3266-cafd-4cad- 89db-cb04094b87c1% 40googlegroups.com
For more options, visit https://groups.google.com/d/optout .
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/CAJZK_ba9XQQmRqxFZV1FWUds4u0phupYYBm9DJuW8TbXvU-S4w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment