Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Check event originator (server_id that created the event) SELECT event_name, originator FROM information_schema.events; -- On replica, disable all events: SET GLOBAL event_scheduler = OFF; -- Or disable specific event on replica after failover: ALTER EVENT daily_cleanup ENABLE; -- only on new primary -- my.cnf approach (disable events globally on replicas): -- event_scheduler = OFF -- Only enable on the primary server
Result
Open