444 lines
22 KiB
Plaintext
444 lines
22 KiB
Plaintext
include/group_replication.inc [rpl_server_count=5]
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
[connection server1]
|
|
[connection server2]
|
|
include/start_and_bootstrap_group_replication.inc
|
|
include/start_slave.inc
|
|
[connection server3]
|
|
include/start_group_replication.inc
|
|
[connection server2]
|
|
include/rpl_gr_wait_for_number_of_members.inc
|
|
[connection server3]
|
|
include/assert.inc [QUEUEING_TRANSACTION was cleared in the group_replication_recovery channel after the member is online]
|
|
include/assert.inc [LAST_QUEUED_TRANSACTION was cleared in the group_replication_recovery channel after the member is online]
|
|
include/assert.inc [LAST_APPLIED_TRANSACTION is not cleared because channel group_replication_recovery applied view change log events for joining the group]
|
|
[connection server4]
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=SERVER_MYPORT_2, MASTER_USER='root', MASTER_AUTO_POSITION=1;
|
|
include/start_slave.inc
|
|
[connection server1]
|
|
CREATE DATABASE db1;
|
|
CREATE TABLE db1.t1(a INT PRIMARY KEY);
|
|
INSERT INTO db1.t1 VALUES(1);
|
|
UPDATE db1.t1 SET a= 2;
|
|
DELETE FROM db1.t1 WHERE a= 1;
|
|
DROP TABLE db1.t1;
|
|
DROP DATABASE db1;
|
|
include/sync_slave_sql_with_master.inc
|
|
[connection server2]
|
|
include/sync_slave_sql_with_master.inc
|
|
[connection server2]
|
|
include/sync_slave_sql_with_master.inc
|
|
[connection server2]
|
|
CREATE DATABASE db1;
|
|
CREATE TABLE db1.t1(a INT PRIMARY KEY);
|
|
INSERT INTO db1.t1 VALUES(1);
|
|
UPDATE db1.t1 SET a= 2;
|
|
DELETE FROM db1.t1 WHERE a= 1;
|
|
DROP TABLE db1.t1;
|
|
DROP DATABASE db1;
|
|
[connection server2]
|
|
include/sync_slave_sql_with_master.inc
|
|
[connection server2]
|
|
include/sync_slave_sql_with_master.inc
|
|
[connection server5]
|
|
include/start_group_replication.inc
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT increases from server1 to server2]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT > OCT on server2.]
|
|
include/assert.inc [Assert that ICT > OCT on server4.]
|
|
include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
|
|
include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT increases from server1 to server2]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT > OCT on server2.]
|
|
include/assert.inc [Assert that ICT > OCT on server4.]
|
|
include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
|
|
include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT increases from server1 to server2]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT > OCT on server2.]
|
|
include/assert.inc [Assert that ICT > OCT on server4.]
|
|
include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
|
|
include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT increases from server1 to server2]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT > OCT on server2.]
|
|
include/assert.inc [Assert that ICT > OCT on server4.]
|
|
include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
|
|
include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT increases from server1 to server2]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT > OCT on server2.]
|
|
include/assert.inc [Assert that ICT > OCT on server4.]
|
|
include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
|
|
include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT increases from server1 to server2]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT > OCT on server2.]
|
|
include/assert.inc [Assert that ICT > OCT on server4.]
|
|
include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
|
|
include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT increases from server1 to server2]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server1]
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server1 and server2.]
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is the same as ICT on server1]
|
|
include/assert.inc [Assert that ICT > OCT on server2.]
|
|
include/assert.inc [Assert that ICT > OCT on server4.]
|
|
include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
|
|
include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that ICT increases from server2 to server4]
|
|
[connection server_2]
|
|
include/assert.inc [Assert that the View_change_event ICT is bigger than zero for server_2.]
|
|
include/assert.inc [Assert that the View_change_event OCT is zero for server_2.]
|
|
[connection server_3]
|
|
include/assert.inc [Assert that the View_change_event ICT is bigger than zero for server_3.]
|
|
include/assert.inc [Assert that the View_change_event OCT is zero for server_3.]
|
|
[connection server_5]
|
|
include/assert.inc [Assert that the View_change_event ICT is bigger than zero for server_3.]
|
|
include/assert.inc [Assert that the View_change_event OCT is zero for server_3.]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that ICT increases from server2 to server4]
|
|
[connection server_2]
|
|
include/assert.inc [Assert that the View_change_event ICT is bigger than zero for server_2.]
|
|
include/assert.inc [Assert that the View_change_event OCT is zero for server_2.]
|
|
[connection server_3]
|
|
include/assert.inc [Assert that the View_change_event ICT is bigger than zero for server_3.]
|
|
include/assert.inc [Assert that the View_change_event OCT is zero for server_3.]
|
|
[connection server_5]
|
|
include/assert.inc [Assert that the View_change_event ICT is bigger than zero for server_3.]
|
|
include/assert.inc [Assert that the View_change_event OCT is zero for server_3.]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that ICT increases from server2 to server4]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that ICT increases from server2 to server4]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that ICT increases from server2 to server4]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that ICT increases from server2 to server4]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that ICT increases from server2 to server4]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server4]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server4.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that ICT increases from server2 to server4]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server3]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server3.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server3]
|
|
# 1. Save both timestamps (original/immediate) on all servers.
|
|
[connection server2]
|
|
[connection server5]
|
|
# 2. Verify that the timestamps are correct.
|
|
include/assert.inc [Assert that the OCT is the same on server2 and server5.]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server2]
|
|
include/assert.inc [Assert that OCT is smaller than ICT on server5]
|
|
[connection server2]
|
|
include/stop_slave.inc [FOR CHANNEL 'channel_1']
|
|
RESET SLAVE FOR CHANNEL 'channel_1';
|
|
[connection server4]
|
|
include/stop_slave.inc
|
|
CHANGE MASTER TO MASTER_AUTO_POSITION= 0;
|
|
include/group_replication_end.inc
|
|
RESET SLAVE ALL FOR CHANNEL 'channel_1';
|