Sunday, January 8, 2017

[google-cloud-sql-discuss] gtid_mode = off?

Is there any way to set gtid_mode off for a 2nd generation instance?  I tried a dynamic change, but got the "Super" error:

mysql> SET @@GLOBAL.GTID_MODE = OFF;
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I don't need it for the software I'm running, causing Mysqli errors to be logged and the software maintainer recommendation is to turn it off... which would be easy enough on a self-hosted instance, but not so straightforward in Cloud SQL apparently.

--
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/1c424061-d391-4197-9e75-d08ec989bfe2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment