--source include/master-slave.inc DELIMITER $$; DROP EVENT IF EXISTS `MIS_CUMULATIVE_REV_EVENT` $$ CREATE EVENT IF NOT EXISTS `MIS_CUMULATIVE_REV_EVENT` ON SCHEDULE EVERY 30 MINUTE STARTS sysdate() ON COMPLETION PRESERVE DO BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION SELECT CONCAT('SQL EXCEPTION - TERMINATING EVENT FOR STORED PROCEDURE CALL'); END $$ DELIMITER ;$$ --sync_slave_with_master select * from mysql.event; --vertical_results show slave status;