You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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:
Should we anticipate more updates to our servers outside of the maintenance time window that we configured?
Was there a way that we could have known about this update before it happened?
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Google Cloud SQL discuss
Thanks for sharing such a piece of great knowledge. Its really helpful for big man tree stand.