Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?
A.
Use Cloud SQL serverless exports.
B.
Create a read replica, and then use the mysqldump utility to export each table.
C.
Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
D.
Use the mysqldump utility on the primary database instance to export the backup.
A: https://cloud.google.com/blog/products/databases/introducing-cloud-sql-serverless-exports
Serverless exports enables you to export data from your MySQL and PostgreSQL database instances without any impact on performance or risk to your production workloads.
A.
Minimal operational overhead eliminates B and C. Minimal risk to production workloads eliminates D. That leaves A. Least amount of work and doesn't impact the primary instance.
Cloud SQL backups are incremental. They contain only data that changed after the previous backup was taken. Your oldest backup is a similar size to your database, but the sizes of subsequent backups depend on the rate of change of your data. When the oldest backup is deleted, the size of the next oldest backup increases so that a full backup still exists.
With serverless export, Cloud SQL creates a separate, temporary instance to offload the export operation. Offloading the export operation allows databases on the primary instance to continue to serve queries and perform operations at the usual performance rate. BUT is is export (logical backup) and will never be incremental. and the recovery is slow. for 5TB server is it not an option. (only for mini databases). I believe The better option is C
A: Use Cloud SQL serverless exports.
Serverless exports enables you to export data from your MySQL and PostgreSQL database instances without any impact on performance or risk to your production workloads. Cloud SQL exports, which offer portable data formats (SQL, CSV), can be triggered anytime and are written to Cloud Storage buckets that you control.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
GCP72
Highly Voted 1 year, 10 months agoPime13
Most Recent 6 months agodynamic_dba
1 year, 7 months agoNirca
1 year, 7 months agoNirca
1 year, 7 months agopk349
1 year, 10 months agochelbsik
1 year, 10 months agojitu028
1 year, 10 months agorange9005
1 year, 10 months ago