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?
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?
To minimize ongoing costs for a non-critical Cloud SQL instance with a recovery point objective (RPO) of several days, the optimal approach is to turn on automated backups and turn off transaction log retention. Automated backups ensure that the instance is backed up regularly without requiring manual intervention, which helps minimize operational overhead. Turning off transaction log retention further reduces costs since transaction logs are not required for point-in-time recovery in this scenario.
C. Turn on automated backup, and turn off transaction log retention.
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.
There is no need to have the overload of using a manual backup, you could schedule an automatic one once a day
C: Turn on automated backup, and turn off transaction log retention.
Automatic backups are incremental where as manual backups are full. Other than compute time for manual backup, storage costs will also increase.
B is manual process and can't be the right approach for automation
I think that is C but I didn't find any link that corroborates with my opinion 😢
C is the one. Manual backups are always discouraged, and transaction log can be removed for a cheap, dev DB.
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.
Why not A. its a testing environment. why we need to have backup when we are low on budget.