| 1 |
include/group_replication.inc [rpl_server_count=3] |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 5 |
[connection server1] |
| 6 |
# |
| 7 |
# Create the test table on server 1 |
| 8 |
# |
| 9 |
[connection server1] |
| 10 |
CREATE TABLE IF NOT EXISTS t1 (a INT PRIMARY KEY); |
| 11 |
include/rpl_sync.inc |
| 12 |
# |
| 13 |
# Create the events in each member. |
| 14 |
# |
| 15 |
SET @old_event_scheduler= @@global.event_scheduler; |
| 16 |
SET SESSION sql_log_bin= 0; |
| 17 |
SET GLOBAL event_scheduler=on| |
| 18 |
CREATE EVENT IF NOT EXISTS test.event1 |
| 19 |
ON SCHEDULE |
| 20 |
EVERY 1 SECOND |
| 21 |
STARTS CURRENT_TIMESTAMP + INTERVAL 1 SECOND |
| 22 |
ENDS CURRENT_TIMESTAMP + INTERVAL 30 SECOND |
| 23 |
ON COMPLETION PRESERVE |
| 24 |
DISABLE |
| 25 |
COMMENT 'Test with events' |
| 26 |
DO |
| 27 |
BEGIN |
| 28 |
DECLARE v INTEGER; |
| 29 |
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END; |
| 30 |
SET v=0; |
| 31 |
WHILE v < 1000 |
| 32 |
DO |
| 33 |
SELECT max(a) + 1 INTO v FROM t1; |
| 34 |
INSERT INTO t1 values (v); |
| 35 |
SET v = v+1; |
| 36 |
END WHILE; |
| 37 |
END| |
| 38 |
SET SESSION sql_log_bin= 1; |
| 39 |
[connection server2] |
| 40 |
SET @old_event_scheduler= @@global.event_scheduler; |
| 41 |
SET SESSION sql_log_bin= 0; |
| 42 |
SET GLOBAL event_scheduler=on| |
| 43 |
CREATE EVENT IF NOT EXISTS test.event2 |
| 44 |
ON SCHEDULE |
| 45 |
EVERY 1 SECOND |
| 46 |
STARTS CURRENT_TIMESTAMP + INTERVAL 1 SECOND |
| 47 |
ENDS CURRENT_TIMESTAMP + INTERVAL 30 SECOND |
| 48 |
ON COMPLETION PRESERVE |
| 49 |
DISABLE |
| 50 |
COMMENT 'Test with events' |
| 51 |
DO |
| 52 |
BEGIN |
| 53 |
DECLARE v INTEGER; |
| 54 |
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END; |
| 55 |
SET v=0; |
| 56 |
WHILE v < 1000 |
| 57 |
DO |
| 58 |
SELECT max(a) + 1 INTO v FROM t1; |
| 59 |
INSERT INTO t1 values (v); |
| 60 |
SET v = v+1; |
| 61 |
END WHILE; |
| 62 |
END| |
| 63 |
SET SESSION sql_log_bin= 1; |
| 64 |
[connection server3] |
| 65 |
SET @old_event_scheduler= @@global.event_scheduler; |
| 66 |
SET SESSION sql_log_bin= 0; |
| 67 |
SET GLOBAL event_scheduler=on| |
| 68 |
CREATE EVENT IF NOT EXISTS test.event3 |
| 69 |
ON SCHEDULE |
| 70 |
EVERY 1 SECOND |
| 71 |
STARTS CURRENT_TIMESTAMP + INTERVAL 1 SECOND |
| 72 |
ENDS CURRENT_TIMESTAMP + INTERVAL 30 SECOND |
| 73 |
ON COMPLETION PRESERVE |
| 74 |
DISABLE |
| 75 |
COMMENT 'Test with events' |
| 76 |
DO |
| 77 |
BEGIN |
| 78 |
DECLARE v INTEGER; |
| 79 |
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END; |
| 80 |
SET v=0; |
| 81 |
WHILE v < 1000 |
| 82 |
DO |
| 83 |
SELECT max(a) + 1 INTO v FROM t1; |
| 84 |
INSERT INTO t1 values (v); |
| 85 |
SET v = v+1; |
| 86 |
END WHILE; |
| 87 |
END| |
| 88 |
SET SESSION sql_log_bin= 1; |
| 89 |
# |
| 90 |
# Start the events in each member. |
| 91 |
# |
| 92 |
[connection server1] |
| 93 |
SET GLOBAL event_scheduler=on; |
| 94 |
SET SESSION sql_log_bin= 0; |
| 95 |
ALTER EVENT event1 ENABLE; |
| 96 |
SET SESSION sql_log_bin= 1; |
| 97 |
[connection server2] |
| 98 |
SET GLOBAL event_scheduler=on; |
| 99 |
SET SESSION sql_log_bin= 0; |
| 100 |
ALTER EVENT event2 ENABLE; |
| 101 |
SET SESSION sql_log_bin= 1; |
| 102 |
[connection server3] |
| 103 |
SET GLOBAL event_scheduler=on; |
| 104 |
SET SESSION sql_log_bin= 0; |
| 105 |
ALTER EVENT event3 ENABLE; |
| 106 |
SET SESSION sql_log_bin= 1; |
| 107 |
# |
| 108 |
# Wait for the events to be disabled |
| 109 |
# |
| 110 |
[connection server1] |
| 111 |
[connection server2] |
| 112 |
[connection server3] |
| 113 |
# |
| 114 |
# Check the members are still operational |
| 115 |
# |
| 116 |
[connection server1] |
| 117 |
include/assert.inc ['The group replication applier channel is ON'] |
| 118 |
[connection server2] |
| 119 |
include/assert.inc ['The group replication applier channel is ON'] |
| 120 |
[connection server3] |
| 121 |
include/assert.inc ['The group replication applier channel is ON'] |
| 122 |
# |
| 123 |
# Remove the events and the data |
| 124 |
# |
| 125 |
[connection server1] |
| 126 |
SET SESSION sql_log_bin= 0; |
| 127 |
DROP EVENT IF EXISTS test.event1; |
| 128 |
SET SESSION sql_log_bin= 1; |
| 129 |
SET GLOBAL event_scheduler= @old_event_scheduler; |
| 130 |
[connection server2] |
| 131 |
SET SESSION sql_log_bin= 0; |
| 132 |
DROP EVENT IF EXISTS test.event2; |
| 133 |
SET SESSION sql_log_bin= 1; |
| 134 |
SET GLOBAL event_scheduler= @old_event_scheduler; |
| 135 |
[connection server3] |
| 136 |
SET SESSION sql_log_bin= 0; |
| 137 |
DROP EVENT IF EXISTS test.event3; |
| 138 |
SET SESSION sql_log_bin= 1; |
| 139 |
SET GLOBAL event_scheduler= @old_event_scheduler; |
| 140 |
[connection server1] |
| 141 |
DROP TABLE t1; |
| 142 |
include/group_replication_end.inc |