Debian Codegraph @

mysql-test/suite/galera/t/galera_events.test

raw
1 #
2 # Test that the replication of MySQL events conforms to the behavior of stock MySQL replication as described here
3 # http://dev.mysql.com/doc/refman/5.6/en/replication-features-invoked.html
4 #
5
6 --source include/galera_cluster.inc
7 --source include/have_innodb.inc
8
9 --let $event_scheduler_orig = `SELECT @@event_scheduler;`
10
11 #
12 # Events arrive on slave as SLAVESIDE_DISABLED
13 #
14
15 --connection node_1
16 CREATE EVENT event1 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT 1;
17
18 --connection node_2
19 SELECT DEFINER= 'root@localhost', ORIGINATOR = 1, STATUS = 'SLAVESIDE_DISABLED', EVENT_TYPE = 'ONE TIME', ON_COMPLETION = 'NOT PRESERVE' FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME = 'event1';
20
21 --connection node_1
22 ALTER EVENT event1 DISABLE;
23
24 --connection node_2
25 # The definition on node 2 should still say SLAVESIDE_DISABLED
26 SELECT DEFINER= 'root@localhost', ORIGINATOR = 1, STATUS = 'SLAVESIDE_DISABLED', EVENT_TYPE = 'ONE TIME', ON_COMPLETION = 'NOT PRESERVE' FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME = 'event1';
27
28 #
29 # Expired event should be dropped from the slave
30 #
31
32 --connection node_2
33 SET GLOBAL event_scheduler = ON;
34 CREATE EVENT event2 ON SCHEDULE AT CURRENT_TIMESTAMP ON COMPLETION NOT PRESERVE DO SELECT 1;
35 --sleep 1
36
37 --connection node_1
38 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME = 'event2';
39
40 #
41 # DROP EVENT causes event to be dropped everywhere
42 #
43
44 --connection node_1
45 DROP EVENT event1;
46
47 --connection node_2
48 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME = 'event1';
49
50 # Cleanup
51
52 --connection node_2
53 --eval SET GLOBAL event_scheduler = $event_scheduler_orig;