Hi there! I have a problem with percona mysql replication (master-slave) and events. When i create any event on master
EVERY 1 MINUTE
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?