MySQL Forums
Forum List  »  Events (Job Scheduler)

Re: Events and MySQL Cluster
Posted by: Jonathan Stephens
Date: July 01, 2007 01:57AM

(This is old, but I'll go ahead and answer it.)

Thomas, your guess is more or less correct.

Events are stored in mysql.event, which is a MyISAM table, so an event created on one SQL node is defined on that SQL node only.

However, if the event acts on an NDB table, that change is visible throughout the cluster.

BTW, you probably don't want events to propagate automatically to all SQL nodes, because, if they did, then each event would execute multiple times. In other words, if you had an event that inserted a new row into a table every 5 minutes, and you had 4 SQL nodes in the cluster, then 4 inserts would occur after each 5 minute interval. If the table used NDB, this could really mess things up.

If you have a local table that's updated by an event on one SQL node, and you want this table propagated across multiple SQL nodes, you might be better off just replicating the table to the other SQL nodes.

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
5060
March 11, 2006 01:39AM
Re: Events and MySQL Cluster
3662
July 01, 2007 01:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.