Not the answer you need?
Register and ask your own question!

event scheduler in replication master - slave

nobodynobody EntrantCurrent User Role Beginner
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?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.