MySQL Forums
Forum List  »  Replication

Re: Need help to enable EventSchedular on Slave
Posted by: Valerie Parham-Thompson
Date: December 09, 2014 01:02PM

Vivek,

You can enable the event scheduler on the slave with the following statement:

set global event_scheduler=on;

As far as any problems you could cause, it depends on what your events are doing. Here are two examples where it could cause an issue: (a) the event on the master adds a row to a table and that is replicated to the slave, and the event on the slave also adds a row to the table (causes duplicate, maybe conflicting data), or (b) the event on the master updates a field and the event on the slave updates the field, too (causes unnecessary work by the slave).

It sounds like you don't plan for the events on the master and slave to collide, but keep an eye on them by auditing with: select * from information_schema.events.

Note you can also enable or disable individual events themselves on the master and slave separately. This might be useful in a failover situation.

Valerie

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Need help to enable EventSchedular on Slave
881
December 09, 2014 01:02PM


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.