Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.38-galera
-
Ubunut - 16.04
Description
I have configured 3 node Multi Master Galera Cluster in Production, Development, Testing and Stage environments.
Replication is working fine without any issues.
Recently, I had a requirement to create event for which I have created one. Post creation, it behaves differently between production and other non-prod instances.
For production, it's status is ENABLED in all 3 servers
For non-production, it's status is ENABLED only in the place where I create and other servers it has SLAVESIDE_DISABLED.
Can you please help me with the behaviour.
Please find the below script runs across environment.
CREATE DEFINER = `user`@`%` EVENT IF NOT EXISTS `order_event` |
ON SCHEDULE EVERY 15 SECOND |
STARTS NOW()
|
ON COMPLETION PRESERVE ENABLE COMMENT 'Dump filtered data' |
DO
|
BEGIN |
END |