Re: Is MySQL event scheduler available on Cloud SQL?

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 <vivektmore@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