List:Cluster« Previous MessageNext Message »
From:Stewart Smith Date:December 9 2010 11:28pm
Subject:Re: Best practices for using Event Scheduler in Cluster?
View as plain text  
On Thu, 9 Dec 2010 19:59:42 +0000 (UTC), Theodore Hope <hope@stripped> wrote:
> I had never before used the Event Scheduler with Cluster (only with
> InnoDB on a single machine).  Now that I began to experiment with
> it on Cluster it dawned on me that mysql.event is a MyISAM table
> and therefore  won't be replicated in the Cluster. 
> 
> I ended up deleting the NDB version of mysql.event and recreating
> the MyISAM version :-( :-( 

The server just isn't really able to deal with mysql.foo tables in a
different engine.

There are a number of reasons behind this, but to fix it will require
source changes.

-- 
Stewart Smith
Thread
Best practices for using Event Scheduler in Cluster? Theodore Hope9 Dec
  • Re: Best practices for using Event Scheduler in Cluster?Stewart Smith10 Dec
  • Re: Best practices for using Event Scheduler in Cluster?Jon Stephens10 Dec
  • Re: Best practices for using Event Scheduler in Cluster?Theodore Hope10 Dec
  • Re: Best practices for using Event Scheduler in Cluster?Theodore Hope10 Dec