QuestionQ31

VerifiedMigrate data solutions

Your organization has deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The most recent application release contained an error that caused extensive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?

Explanation

Cloud SQL for MySQL point-in-time recovery restores an instance to a specific time by using a backup and the continuous binary logs retained since that backup. Selecting a recovery time immediately before the corruption minimizes lost valid transactions. High-availability failover protects against infrastructure failure, but the standby reflects logical data corruption.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!