Monday, October 16, 2017

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

Hello Roman, 

CloudSQL is a managed environment based on MySQL; this means that often used MySQL commands, in particular all those that require the SUPER privilege, are restricted and would not run. This is the meaning of the "access denied" message you received. 

A read replica is a copy of the master that reflects changes to the master instance in almost real time. You may gather more insight by reading the "Replication Options" document. The master does not reflect changes on replicas, but the other way round. You need to modify the master; this is what the managed environment allows. 

--
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/8f66bda6-eaf6-4c64-8c4d-f46f6d587d1c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment