| 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 |
# 1. Start GR on server1 & 2 |
| 8 |
[connection server1] |
| 9 |
include/start_and_bootstrap_group_replication.inc |
| 10 |
[connection server2] |
| 11 |
include/start_group_replication.inc |
| 12 |
|
| 13 |
# 2. Create new channel ch3_2: server2(slave), server3(master) |
| 14 |
[connection server2] |
| 15 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='localhost', SOURCE_USER='root', SOURCE_PORT=SERVER_3_PORT for channel 'ch3_2'; |
| 16 |
Warnings: |
| 17 |
Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 18 |
Note 1760 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. |
| 19 |
|
| 20 |
# 3. Add some data to server1 & 3 |
| 21 |
[connection server1] |
| 22 |
CREATE TABLE test.t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB; |
| 23 |
INSERT INTO test.t1 VALUES (1); |
| 24 |
[connection server3] |
| 25 |
CREATE TABLE test.t2 (c1 INT NOT NULL) ENGINE=InnoDB; |
| 26 |
INSERT INTO test.t2 VALUES (1); |
| 27 |
|
| 28 |
# 4. Verify the error scenarios. |
| 29 |
|
| 30 |
# 4.1 start slave and verify for error ER_REPLICA_FATAL_ERROR |
| 31 |
[connection server2] |
| 32 |
START SLAVE FOR CHANNEL 'ch3_2'; |
| 33 |
Warnings: |
| 34 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 35 |
include/wait_for_slave_io_error.inc [errno=13117 FOR CHANNEL 'ch3_2'] |
| 36 |
include/wait_for_slave_sql_error.inc [errno=13117 FOR CHANNEL 'ch3_2'] |
| 37 |
|
| 38 |
# 4.2 start slave io and verify for error ER_REPLICA_FATAL_ERROR |
| 39 |
START SLAVE IO_THREAD FOR CHANNEL 'ch3_2'; |
| 40 |
Warnings: |
| 41 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 42 |
include/wait_for_slave_io_error.inc [errno=13117 FOR CHANNEL 'ch3_2'] |
| 43 |
|
| 44 |
# 4.3 start slave sql and verify for error ER_REPLICA_FATAL_ERROR |
| 45 |
START SLAVE SQL_THREAD FOR CHANNEL 'ch3_2'; |
| 46 |
Warnings: |
| 47 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 48 |
include/wait_for_slave_sql_error.inc [errno=13117 FOR CHANNEL 'ch3_2'] |
| 49 |
|
| 50 |
# 5. Verify occurrence of error message |
| 51 |
Occurrences of 'Can't start replica IO THREAD of channel 'ch3_2' when group replication is running with single-primary mode on a secondary member.' in the input file: 2 |
| 52 |
Occurrences of 'Can't start replica SQL THREAD of channel 'ch3_2' when group replication is running with single-primary mode on a secondary member.' in the input file: 2 |
| 53 |
|
| 54 |
# 6. Verify channel ch3_2 IO & SQL THREAD is OFF |
| 55 |
include/assert.inc [Verify channel ch3_2 IO_THREAD is OFF] |
| 56 |
include/assert.inc [Verify channel ch3_2 SQL_THREAD is OFF] |
| 57 |
|
| 58 |
# 7. Verifying data(t2 table) didn't replicated from server3 to server1 & 2 |
| 59 |
include/rpl_sync.inc |
| 60 |
[connection server2] |
| 61 |
include/assert.inc [Verify only single table present i.e. t1] |
| 62 |
[connection server1] |
| 63 |
include/assert.inc [Verify only single table present i.e. t1] |
| 64 |
|
| 65 |
# 8. Clean Up |
| 66 |
[connection server2] |
| 67 |
RESET SLAVE ALL FOR CHANNEL 'ch3_2'; |
| 68 |
Warnings: |
| 69 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 70 |
[connection server1] |
| 71 |
DROP TABLE test.t1; |
| 72 |
[connection server3] |
| 73 |
DROP TABLE test.t2; |
| 74 |
include/group_replication_end.inc |