Tuesday, October 17, 2017

[google-cloud-sql-discuss] Re: How to perform schema changes on replica?

Hi Roman, 

Replicas in the case of CloudSQL are maintained as exact copies of the original, in real time, so they are not defined as the other replicas you refer to. If you decide to rather use cloning, the way these clones are described on the "Cloning Instances" page, you can get similar results as from steps 1 to 5 above. So instead of replicating, you clone the instance, you modify this cloned instance and, when ready, you switch your app's traffic to the newly configured instance. It should not take shutting down your application for a whole day, as your editing of the cloned instance is not affecting current functionality. You may take your time and only switch traffic when you are ready. 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ee59ab99-d3e1-4448-81d7-54d2a81917eb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment