You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?
A.
Take no backups, and turn off transaction log retention.
B.
Take one manual backup per day, and turn off transaction log retention.
C.
Turn on automated backup, and turn off transaction log retention.
D.
Turn on automated backup, and turn on transaction log retention.
C and not B because as per: https://cloud.google.com/sql/docs/mysql/backup-recovery/backups
On-demand backups are not automatically deleted the way automated backups are. They persist until you delete them or until their instance is deleted. Because they are not automatically deleted, on-demand backups can have a long-term effect on your billing charges.
C.
A is wrong since there is an RPO. B requires manual intervention which partly defeats the object of using a managed service like Cloud SQL. D is wrong since retaining transaction logs would permit point-in-time recovery which is not required. That leaves C.
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.
hussain.sain
10 months, 3 weeks agojuliorevk
1 year, 7 months agotheseawillclaim
1 year, 7 months agofelipeschossler
2 years agoPilot50
2 years, 1 month agodynamic_dba
2 years, 1 month agocsrazdan
2 years, 3 months agoGCP72
2 years, 4 months agopk349
2 years, 4 months agofredcaram
2 years, 4 months ago