QuestionQ62

VerifiedDeploy scalable and highly available databases in Google Cloud

You administer a production MySQL database on Cloud SQL for a retail company. You conduct routine maintenance at midnight on Sundays, when traffic is low, but want to avoid routine maintenance during the year-end holiday shopping season. You must ensure that the production system remains available 24/7 throughout the holidays. What should you do?

Explanation

Cloud SQL lets an instance use a one-hour maintenance window and a deny maintenance period, which overrides the maintenance window for the blocked dates. Configuring Sunday from 12 AM to 1 AM and denying maintenance from November 1 through January 15 schedules maintenance during low traffic while preventing automatic maintenance during the holiday season. Deny periods can last up to 90 days.

Learn more

Community Discussion

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