| 1 |
include/group_replication.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 server1] |
| 6 |
# |
| 7 |
# TU#1: Test that group_replication_primary_member is SERVER_UUID when PRIMARY is in ONLINE state. |
| 8 |
# |
| 9 |
[connection server1] |
| 10 |
include/start_and_bootstrap_group_replication.inc |
| 11 |
include/gr_wait_for_member_state.inc |
| 12 |
include/assert.inc [Verify MEMBER_STATE is ONLINE] |
| 13 |
include/assert.inc [Verify group_replication_primary_member is SERVER_UUID] |
| 14 |
# |
| 15 |
# TU#2: Test that group_replication_primary_member is EMPTY when SECONDARY is in OFFLINE state. |
| 16 |
# |
| 17 |
[connection server2] |
| 18 |
SET SESSION sql_log_bin= 0; |
| 19 |
call mtr.add_suppression("Table 't1' already exists"); |
| 20 |
call mtr.add_suppression("The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group"); |
| 21 |
call mtr.add_suppression("Fatal error during execution on the Applier process of Group Replication. The server will now leave the group."); |
| 22 |
call mtr.add_suppression("Unable to ensure the execution of group transactions received during recovery."); |
| 23 |
call mtr.add_suppression("Fatal error during the Recovery process of Group Replication. The server will leave the group."); |
| 24 |
call mtr.add_suppression("The server was automatically set into read only mode after an error was detected."); |
| 25 |
call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going."); |
| 26 |
call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped,*"); |
| 27 |
call mtr.add_suppression("Skipping leave operation: member already left the group."); |
| 28 |
SET SESSION sql_log_bin= 1; |
| 29 |
include/assert.inc [Verify MEMBER_STATE is OFFLINE] |
| 30 |
include/assert.inc [Verify group_replication_primary_member is EMPTY("")] |
| 31 |
# |
| 32 |
# TU#3: Test that group_replication_primary_member is SERVER_UUID when SECONDARY is in RECOVERING state. |
| 33 |
# |
| 34 |
SET sql_log_bin=0; |
| 35 |
CREATE TABLE t1 (a INT PRIMARY KEY NOT NULL); |
| 36 |
SET sql_log_bin=1; |
| 37 |
SET @@GLOBAL.DEBUG='+d,recovery_thread_wait_before_finish'; |
| 38 |
include/start_group_replication.inc |
| 39 |
include/assert.inc [Verify MEMBER_STATE is RECOVERING] |
| 40 |
include/assert.inc [Verify group_replication_primary_member is SERVER_UUID] |
| 41 |
# |
| 42 |
# TU#4: Test that group_replication_primary_member is UNDEFINED when SECONDARY is in ERROR state. |
| 43 |
# |
| 44 |
[connection server2] |
| 45 |
SET DEBUG_SYNC= "now WAIT_FOR signal.recovery_thread_wait_before_finish_reached"; |
| 46 |
SET @@GLOBAL.DEBUG='-d,recovery_thread_wait_before_finish'; |
| 47 |
SET DEBUG_SYNC= "now SIGNAL signal.recovery_end"; |
| 48 |
include/gr_wait_for_member_state.inc |
| 49 |
SET DEBUG_SYNC= 'RESET'; |
| 50 |
[connection server1] |
| 51 |
CREATE TABLE t1 (a INT PRIMARY KEY NOT NULL); |
| 52 |
[connection server2] |
| 53 |
include/gr_wait_for_member_state.inc |
| 54 |
include/rpl_gr_wait_for_number_of_members.inc |
| 55 |
include/assert.inc [Verify MEMBER_STATE is ERROR] |
| 56 |
include/assert.inc [Verify group_replication_primary_member is UNDEFINED] |
| 57 |
# |
| 58 |
# TU#5: Test that group_replication_primary_member is SERVER_UUID when SECONDARY is in ONLINE state. |
| 59 |
# |
| 60 |
include/stop_group_replication.inc |
| 61 |
SET sql_log_bin=0; |
| 62 |
DROP TABLE t1; |
| 63 |
SET sql_log_bin=1; |
| 64 |
include/start_group_replication.inc |
| 65 |
include/gr_wait_for_member_state.inc |
| 66 |
include/assert.inc [Verify MEMBER_STATE is ONLINE] |
| 67 |
include/assert.inc [Verify group_replication_primary_member is SERVER_UUID] |
| 68 |
[connection server1] |
| 69 |
DROP TABLE t1; |
| 70 |
include/group_replication_end.inc |