[google-cloud-sql-discuss] Re: Is MySQL event scheduler available on Cloud SQL?

You can set mysql flag from console

event_scheduler

on

regards

Indraneel

On Thursday, 5 July 2012 14:02:01 UTC+5:30, Vivek More wrote:

Thanks Razvan for info,
I already tried the same thing with AppEngine cron jobs it works fine there. But on Cloud SQL I am not even able to create event, It throws
"Error 1235: This version of MySQL doesn't yet support 'embedded server' " Error. Do you have any idea about it?

-Vivek

On Thursday, July 5, 2012 1:04:08 PM UTC+5:30, Razvan Musaloiu-E. wrote:

A Cloud SQL instance is becomes passive if there is no traffic (FAQ) so even if you enable the event scheduler your event might not execute if the database happens to be in the passive mode. You could use the cron service from App Egine (python/java/go) to trigger the stored procedures though.

sql> create table t(i integer);

0 row(s) affected.

sql> create event test_insert on schedule every 1 minute do insert into test.t values(1);

0 row(s) affected.

sql> select * from test.t;

+-------------+

| i           |

+-------------+

|           1 |

+-------------+

1 row in set (0.16 sec)

sql> select * from test.t;

+-------------+

| i           |

+-------------+

|           1 |

+-------------+

1 row in set (0.16 sec)

sql> select * from test.t;

+-------------+

| i           |

+-------------+

|           1 |

+-------------+

1 row in set (0.16 sec)

sql> select * from test.t;

+-------------+

| i           |

+-------------+

|           1 |

|           1 |

+-------------+

2 rows in set (0.16 sec)

-- Razvan ME

On Thu, Jul 5, 2012 at 12:05 AM, Vivek More <vivek...@gmail.com> wrote:

I have application in MySQL. I want to migrate it to Cloud SQL. As per my current design i have schedule MySQL events to call some procedures. So I want to know can we create scheduler events on clod SQL for same reason.

Thanks,
Vivek

--
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/981655d0-e349-48b8-9f8a-04789a4f6a7d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.