Answers: <p>I contacted the support of Google Cloud about this question and they told me that Cloud SQL isn't build to perform this change without downtime. If I want to be able to make these changes, I should look at Cloud Spanner which is a horizontal scalable SQL solution provided by Google. </p>
  
Answers: CC BY-SA 4.0
Answers: 2020-03-30T06:14:04.480Z
Answers: 2020-03-30T06:14:04.480Z
Answers: Roberto Geuke
Body: <p>I want to update the machine type of my Google Cloud instance, but this takes several minutes to update (second generation instance). The instance will be unavailable until the instance has restarted. Because of this downtime, we have to update the machine type at night time, so our visitors are the least troubled by this update.</p>
  
  <p>Is there a workflow how we can minimise this downtime to zero or maybe a few seconds? I already thought about possible solutions like adding a temporary failover or maybe make use of read replica.</p>
  
Tags: <google-cloud-platform>
Title: Google Cloud SQL: Can I change machine type with zero downtime on my database clients?
UserDisplayName: Roberto Geuke
ThreadText: # Google Cloud SQL: Can I change machine type with zero downtime on my database clients?
  
  (Asked by: username_0 on 2020-03-26)
  
  I want to update the machine type of my Google Cloud instance, but this takes several minutes to update (second generation instance). The instance will be unavailable until the instance has restarted. Because of this downtime, we have to update the machine type at night time, so our visitors are the least troubled by this update.
  
  Is there a workflow how we can minimise this downtime to zero or maybe a few seconds? I already thought about possible solutions like adding a temporary failover or maybe make use of read replica.
  
  **Tags:** google-cloud-platform
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2020-03-30. Score: 3 | Accepted answer
  
  I contacted the support of Google Cloud about this question and they told me that Cloud SQL isn't build to perform this change without downtime. If I want to be able to make these changes, I should look at Cloud Spanner which is a horizontal scalable SQL solution provided by Google.
  
  
  ---
  
  