# event scheduler in replication master - slave

**URL:** <https://forums.percona.com/t/event-scheduler-in-replication-master-slave/5754>\
**Category:** Percona Server for MySQL 5.6\
**Created:** [July 20, 2017, 6:38am UTC](https://forums.percona.com/t/event-scheduler-in-replication-master-slave/5754 "2017-07-20T06:38:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![nobody](https://avatars.discourse-cdn.com/v4/letter/n/94ad74/32.png) [@nobody](https://forums.percona.com/u/nobody)\
**Post date:** [July 20, 2017, 6:38am UTC](https://forums.percona.com/t/event-scheduler-in-replication-master-slave/5754/1 "2017-07-20T06:38:31Z")

</div>

Hi there! I have a problem with percona mysql replication (master-slave) and events. When i create any event on master

CREATE EVENT `test_event`  
ON SCHEDULE  
EVERY 1 MINUTE  
ON COMPLETION  
PRESERVE  
DO  
insert into test1 (unix\_time) values (NOW() + 0);

on master i see for this event STATUS: ENABLED and on slave STATUS: SLAVESIDE\_DISABLED - this is ok, all works correct. But if i change roles between master and slave: on new master this event stay SLAVESIDE\_DISABLED and on new slave - ENABLED. Why? Why event status don’t change when roles changed? How i can do it automatically?
