MySQL Forums
Forum List  »  Events (Job Scheduler)

Re: Scheduled Events and DB Cluster
Posted by: Jonathan Stephens
Date: February 11, 2015 12:49PM

Here's my thinking:

Events are stored in the mysql.event table, which uses MyISAM; thus any events created on a given SQL node would be run only by that SQL node. This makes that SQL node a single point of failure, and MySQL Cluster is supposed to be all about avoiding those.

If we were to copy the event table manually between SQL nodes, or to change this table to use the NDB storage engine so that it'd be automatically accessible to all SQL nodes, then *every* SQL node that was connected to the cluster would attempt to execute the same events at the same time. The results of this wouldn't be pretty, to say the least.

cheers,

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

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
1967
February 11, 2015 11:42AM
1081
February 11, 2015 12:30PM
Re: Scheduled Events and DB Cluster
1041
February 11, 2015 12:49PM


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.