Debian Codegraph @

mysql-test/suite/group_replication/r/gr_protocol_stack_tables_and_migration.result

raw
1 # 1. Start the group normally.
2 include/group_replication.inc
3 Warnings:
4 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
5 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.
6 [connection server1]
7 # 2. Assert that the value in group_replication_communication_stack is the
8 # same as the one the in P_S table for incoming connections
9 include/assert.inc [Assert that the configured communication stack is the same as reported in P_S tables]
10 include/assert.inc [Assert that the configured communication stack is the same as reported in P_S tables]
11 # 3. Stop both servers and backup the communication stack value, local_address
12 # and seeds
13 include/stop_group_replication.inc
14 include/assert.inc [Assert that the configured communication stack remains valid with a stopped server]
15 include/stop_group_replication.inc
16 # 4. In server 1, change to MySQL stack and adjust the local_address and seeds
17 # accordingly
18 # 5. Start and bootstrap the group with server 1
19 SET GLOBAL group_replication_communication_stack= MySQL;
20 include/start_and_bootstrap_group_replication.inc
21 # 6. In server 2, change to MySQL stack and adjust the local_address and seeds
22 # accordingly
23 # 7. Start server 2.
24 SET GLOBAL group_replication_communication_stack= MySQL;
25 include/start_group_replication.inc
26 # 8. Assert that the value in group_replication_communication_stack is the
27 # same as the one the in P_S table for incoming connections
28 include/assert.inc [Assert that the configured communication stack is the same as reported in P_S tables]
29 include/assert.inc [Assert that the configured communication stack is the same as reported in P_S tables]
30 # 9. In server 1, change the protocol to XCom and check that it differs
31 # group_replication_communication_stack
32 # 10. Stop server 1
33 SET GLOBAL group_replication_communication_stack= XCOM;
34 include/assert.inc [Assert that the configured communication stack is different then the one reported in P_S tables]
35 include/stop_group_replication.inc
36 # 11. In server 2, change the protocol to XCom and check that it differs
37 # group_replication_communication_stack
38 # 12. Stop server 2
39 SET GLOBAL group_replication_communication_stack= XCOM;
40 include/assert.inc [Assert that the configured communication stack is different then the one reported in P_S tables]
41 include/stop_group_replication.inc
42 # 13. Bootstrap the group with server 1.
43 SET GLOBAL group_replication_communication_stack= XCOM;
44 include/start_and_bootstrap_group_replication.inc
45 # 14. Join Server 2.
46 SET GLOBAL group_replication_communication_stack= XCOM;
47 include/start_group_replication.inc
48 # 15. Clean up.
49 include/group_replication_end.inc