MySQL update outside the maintenance window

105 views
Skip to first unread message

Shay Friedman

unread,
Nov 10, 2021, 4:53:00 AM11/10/21
to Google Cloud SQL discuss
Hi all!

Lately our MySQL server (hosted on Cloud SQL) had an update out of the maintenance time window. I'd like to understand a few things about that:

  1. Should we anticipate more updates to our servers outside of the maintenance time window that we configured?
  2. Was there a way that we could have known about this update before it happened? 
  3. Is there a way to make sure all updates will be executed within the maintenance window? 

Thank you!
Shay.

Pau Olivé Montejo

unread,
Nov 10, 2021, 10:28:45 AM11/10/21
to Google Cloud SQL discuss
When a preferred maintenance window is configured for instances, it only guarantees that the maintenance event will not start outside the window. It does not guarantee to finish within the specified window as stated here. (which I believe is probably what happened in your case).

Also, in addition to regular maintenance (which is done during the maintenance window) there are some other occasions when your instance may go through a downtime like this. Here are some examples:
  • You or another user on GCP changes instance size, flags, replication type, etc. 
  • Metadata update of an instance, which can be triggered by admin or users in the instance ACL (Access Control List).
  • The machine hosting your instance has a hardware failure. Redundant storage and ACID storage engine means your data is safe in such a case, but MySQL must then be started on a new instance, resulting in a downtime period.

Shay Friedman

unread,
Nov 11, 2021, 9:59:58 AM11/11/21
to Google Cloud SQL discuss
Thanks for the reply. Regarding the last bullet (the hardware failure option) - can I know in some way that this is what happened?

Aref Amiri (Cloud Platform Support)

unread,
Nov 11, 2021, 4:33:08 PM11/11/21
to Google Cloud SQL discuss
The machine hosting your instance is managed on Google backed and you won't have access to it, however, if you believe that is the issue, I'd suggest creating a Private Issue Tracker and provide the instance name and the project, and the engineering team can investigate it further.

Shaun Marry

unread,
Dec 22, 2021, 2:23:19 PM12/22/21
to Google Cloud SQL discuss
Thanks for sharing such a piece of great knowledge. Its really helpful for big man tree stand.
Reply all
Reply to author
Forward
0 new messages