CODEWITHSUNDEEP
mysqleventsschedulergoogle-cloud-sql
usermajuser
usermajuser

Reputation: 77

Is event_scheduler unavoidably disabled in Google Cloud SQL?

I am just now discovering that Google Cloud SQL may not allow MySQL's event_scheduler to be activated, as activating it is a (restricted) SUPER privilege.

Currently

"select @@GLOBAL.event_scheduler;"

returns:

@@GLOBAL.event_scheduler
OFF

and

"set global event_scheduler=ON;"

returns:

*Access denied; you need (at least one of) the SUPER privilege(s) for this operation*

This is really messing up a very scheduler-reliant production system I'm trying to migrate to the Cloud! Is the only work-around for this to implement Cron Jobs in GAE, or has anyone out there done anything clever with their SQL instance?

Upvotes: 2

Views: 1984

Answers (1)

Tony Tseng
Tony Tseng

Reputation: 479

The event scheduler option can now be configured via flags: https://cloud.google.com/sql/docs/mysql-flags

Upvotes: 4

Related Questions