| 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 |
# 1. Start the group making server 2 have a debug point to fail |
| 8 |
[connection server1] |
| 9 |
include/start_and_bootstrap_group_replication.inc |
| 10 |
[connection server2] |
| 11 |
SET @@GLOBAL.DEBUG= '+d,group_replication_group_action_start_msg_error'; |
| 12 |
include/start_group_replication.inc |
| 13 |
|
| 14 |
# 2. Execute an action to change group to single primary mode on server 1 |
| 15 |
# Server 2 shall abort |
| 16 |
[connection server1] |
| 17 |
SELECT group_replication_switch_to_single_primary_mode(); |
| 18 |
group_replication_switch_to_single_primary_mode() |
| 19 |
Mode switched to single-primary successfully. |
| 20 |
[connection server2] |
| 21 |
include/rpl_reconnect.inc |
| 22 |
[connection server2] |
| 23 |
|
| 24 |
# 5. Cleanup |
| 25 |
SET SESSION sql_log_bin=0; |
| 26 |
call mtr.add_suppression("A configuration change was killed in this member. The member will now leave the group as its configuration may have diverged."); |
| 27 |
call mtr.add_suppression("The server was automatically set into read only mode after an error was detected."); |
| 28 |
call mtr.add_suppression("On shutdown there was a timeout receiving a view change. This can lead to a possible inconsistent state. Check the log for more details"); |
| 29 |
call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going."); |
| 30 |
call mtr.add_suppression("Error while executing a group configuration operation: This member received an unknown action for execution."); |
| 31 |
call mtr.add_suppression("The plugin encountered a critical error and will abort: Fatal error during a Group Replication configuration change. This member received an unknown action for execution."); |
| 32 |
SET SESSION sql_log_bin=1; |
| 33 |
include/group_replication_end.inc |