| 1 |
include/master-slave.inc |
| 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 master] |
| 6 |
[connection slave] |
| 7 |
CALL mtr.add_suppression('Replica failed to initialize connection metadata structure from the repository'); |
| 8 |
CALL mtr.add_suppression('This operation cannot be performed with a running replica'); |
| 9 |
CALL mtr.add_suppression('Could not find target log file mentioned in applier metadata in the index file'); |
| 10 |
CALL mtr.add_suppression('Could not find relay log file'); |
| 11 |
CALL mtr.add_suppression('A replica with the same server_uuid/server_id as this replica has connected to the source'); |
| 12 |
SET @saved_event_scheduler= @@GLOBAL.event_scheduler; |
| 13 |
SET @saved_relay_log_purge= @@GLOBAL.relay_log_purge; |
| 14 |
SET @@GLOBAL.event_scheduler= OFF; |
| 15 |
include/stop_slave.inc |
| 16 |
CREATE EVENT e_change_master_io_ch0 ON SCHEDULE EVERY 1 SECOND DO CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_HOST='127.0.0.1', SOURCE_PORT=SOURCE_PORT FOR CHANNEL ''; |
| 17 |
CREATE EVENT e_change_master_sql_ch0 ON SCHEDULE EVERY 1 SECOND DO CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE='slave-relay-bin.000001', RELAY_LOG_POS=4 FOR CHANNEL ''; |
| 18 |
CREATE EVENT e_start_slave_io_ch0 ON SCHEDULE EVERY 1 SECOND DO START SLAVE IO_THREAD FOR CHANNEL ''; |
| 19 |
Warnings: |
| 20 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 21 |
CREATE EVENT e_stop_slave_io_ch0 ON SCHEDULE EVERY 1 SECOND DO STOP SLAVE IO_THREAD FOR CHANNEL ''; |
| 22 |
Warnings: |
| 23 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 24 |
CREATE EVENT e_reset_slave_ch0 ON SCHEDULE EVERY 1 SECOND DO RESET SLAVE FOR CHANNEL ''; |
| 25 |
Warnings: |
| 26 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 27 |
CREATE EVENT e_reset_slave_all_ch0 ON SCHEDULE EVERY 1 SECOND DO RESET SLAVE ALL FOR CHANNEL ''; |
| 28 |
Warnings: |
| 29 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 30 |
CREATE EVENT e_start_slave_sql_ch0 ON SCHEDULE EVERY 1 SECOND DO START SLAVE SQL_THREAD FOR CHANNEL ''; |
| 31 |
Warnings: |
| 32 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 33 |
CREATE EVENT e_stop_slave_sql_ch0 ON SCHEDULE EVERY 1 SECOND DO STOP SLAVE SQL_THREAD FOR CHANNEL ''; |
| 34 |
Warnings: |
| 35 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 36 |
CREATE EVENT e_sss_ch0 ON SCHEDULE EVERY 1 SECOND DO SHOW SLAVE STATUS FOR CHANNEL ''; |
| 37 |
Warnings: |
| 38 |
Warning 1287 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead |
| 39 |
CREATE EVENT e_reset_master ON SCHEDULE EVERY 1 SECOND DO RESET MASTER; |
| 40 |
CREATE EVENT e_ils ON SCHEDULE EVERY 1 SECOND DO SELECT * FROM performance_schema.log_status; |
| 41 |
CREATE EVENT e_change_master_io_ch1 ON SCHEDULE EVERY 1 SECOND DO CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_HOST='127.0.0.1', SOURCE_PORT=SOURCE_PORT FOR CHANNEL 'ch1'; |
| 42 |
CREATE EVENT e_change_master_sql_ch1 ON SCHEDULE EVERY 1 SECOND DO CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE='slave-relay-bin-ch1.000001', RELAY_LOG_POS=4 FOR CHANNEL 'ch1'; |
| 43 |
CREATE EVENT e_start_slave_io_ch1 ON SCHEDULE EVERY 1 SECOND DO START SLAVE IO_THREAD FOR CHANNEL 'ch1'; |
| 44 |
Warnings: |
| 45 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 46 |
CREATE EVENT e_stop_slave_io_ch1 ON SCHEDULE EVERY 1 SECOND DO STOP SLAVE IO_THREAD FOR CHANNEL 'ch1'; |
| 47 |
Warnings: |
| 48 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 49 |
CREATE EVENT e_reset_slave_ch1 ON SCHEDULE EVERY 1 SECOND DO RESET SLAVE FOR CHANNEL 'ch1'; |
| 50 |
Warnings: |
| 51 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 52 |
CREATE EVENT e_reset_slave_all_ch1 ON SCHEDULE EVERY 1 SECOND DO RESET SLAVE ALL FOR CHANNEL 'ch1'; |
| 53 |
Warnings: |
| 54 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 55 |
CREATE EVENT e_start_slave_sql_ch1 ON SCHEDULE EVERY 1 SECOND DO START SLAVE SQL_THREAD FOR CHANNEL 'ch1'; |
| 56 |
Warnings: |
| 57 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 58 |
CREATE EVENT e_stop_slave_sql_ch1 ON SCHEDULE EVERY 1 SECOND DO STOP SLAVE SQL_THREAD FOR CHANNEL 'ch1'; |
| 59 |
Warnings: |
| 60 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 61 |
CREATE EVENT e_sss_ch1 ON SCHEDULE EVERY 1 SECOND DO SHOW SLAVE STATUS FOR CHANNEL 'ch1'; |
| 62 |
Warnings: |
| 63 |
Warning 1287 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead |
| 64 |
CREATE EVENT e_change_master_io_ch2 ON SCHEDULE EVERY 1 SECOND DO CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_HOST='127.0.0.1', SOURCE_PORT=SOURCE_PORT FOR CHANNEL 'ch2'; |
| 65 |
CREATE EVENT e_change_master_sql_ch2 ON SCHEDULE EVERY 1 SECOND DO CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE='slave-relay-bin-ch2.000001', RELAY_LOG_POS=4 FOR CHANNEL 'ch2'; |
| 66 |
CREATE EVENT e_start_slave_io_ch2 ON SCHEDULE EVERY 1 SECOND DO START SLAVE IO_THREAD FOR CHANNEL 'ch2'; |
| 67 |
Warnings: |
| 68 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 69 |
CREATE EVENT e_stop_slave_io_ch2 ON SCHEDULE EVERY 1 SECOND DO STOP SLAVE IO_THREAD FOR CHANNEL 'ch2'; |
| 70 |
Warnings: |
| 71 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 72 |
CREATE EVENT e_reset_slave_ch2 ON SCHEDULE EVERY 1 SECOND DO RESET SLAVE FOR CHANNEL 'ch2'; |
| 73 |
Warnings: |
| 74 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 75 |
CREATE EVENT e_reset_slave_all_ch2 ON SCHEDULE EVERY 1 SECOND DO RESET SLAVE ALL FOR CHANNEL 'ch2'; |
| 76 |
Warnings: |
| 77 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 78 |
CREATE EVENT e_start_slave_sql_ch2 ON SCHEDULE EVERY 1 SECOND DO START SLAVE SQL_THREAD FOR CHANNEL 'ch2'; |
| 79 |
Warnings: |
| 80 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 81 |
CREATE EVENT e_stop_slave_sql_ch2 ON SCHEDULE EVERY 1 SECOND DO STOP SLAVE SQL_THREAD FOR CHANNEL 'ch2'; |
| 82 |
Warnings: |
| 83 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 84 |
CREATE EVENT e_sss_ch2 ON SCHEDULE EVERY 1 SECOND DO SHOW SLAVE STATUS FOR CHANNEL 'ch2'; |
| 85 |
Warnings: |
| 86 |
Warning 1287 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead |
| 87 |
SET @@GLOBAL.event_scheduler= ON; |
| 88 |
Let the requests to run in parallel for 10 seconds |
| 89 |
DROP EVENT e_sss_ch2; |
| 90 |
DROP EVENT e_stop_slave_sql_ch2; |
| 91 |
DROP EVENT e_start_slave_sql_ch2; |
| 92 |
DROP EVENT e_reset_slave_all_ch2; |
| 93 |
DROP EVENT e_reset_slave_ch2; |
| 94 |
DROP EVENT e_stop_slave_io_ch2; |
| 95 |
DROP EVENT e_start_slave_io_ch2; |
| 96 |
DROP EVENT e_change_master_sql_ch2; |
| 97 |
DROP EVENT e_change_master_io_ch2; |
| 98 |
DROP EVENT e_sss_ch1; |
| 99 |
DROP EVENT e_stop_slave_sql_ch1; |
| 100 |
DROP EVENT e_start_slave_sql_ch1; |
| 101 |
DROP EVENT e_reset_slave_all_ch1; |
| 102 |
DROP EVENT e_reset_slave_ch1; |
| 103 |
DROP EVENT e_stop_slave_io_ch1; |
| 104 |
DROP EVENT e_start_slave_io_ch1; |
| 105 |
DROP EVENT e_change_master_sql_ch1; |
| 106 |
DROP EVENT e_change_master_io_ch1; |
| 107 |
DROP EVENT e_ils; |
| 108 |
DROP EVENT e_reset_master; |
| 109 |
DROP EVENT e_sss_ch0; |
| 110 |
DROP EVENT e_stop_slave_sql_ch0; |
| 111 |
DROP EVENT e_start_slave_sql_ch0; |
| 112 |
DROP EVENT e_reset_slave_all_ch0; |
| 113 |
DROP EVENT e_reset_slave_ch0; |
| 114 |
DROP EVENT e_stop_slave_io_ch0; |
| 115 |
DROP EVENT e_start_slave_io_ch0; |
| 116 |
DROP EVENT e_change_master_sql_ch0; |
| 117 |
DROP EVENT e_change_master_io_ch0; |
| 118 |
SET @@GLOBAL.event_scheduler= OFF; |
| 119 |
# Wait until all scheduler activity has finished |
| 120 |
STOP SLAVE FOR CHANNEL 'ch2'; |
| 121 |
STOP SLAVE FOR CHANNEL 'ch1'; |
| 122 |
STOP SLAVE FOR CHANNEL ''; |
| 123 |
RESET SLAVE ALL; |
| 124 |
CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_HOST='127.0.0.1', SOURCE_PORT=SOURCE_PORT; |
| 125 |
SET @@GLOBAL.event_scheduler = @saved_event_scheduler; |
| 126 |
SET @@GLOBAL.relay_log_purge = @saved_relay_log_purge; |
| 127 |
include/start_slave.inc |
| 128 |
include/rpl_end.inc |