| 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 |
############################################################ |
| 8 |
# 1. Prepare all the servers for crash such that when server crashes |
| 9 |
# the crashed node joins the group immediately. |
| 10 |
[connection server1] |
| 11 |
set session sql_log_bin=0; |
| 12 |
call mtr.add_suppression("Members removed from the group*"); |
| 13 |
call mtr.add_suppression("Member with address*"); |
| 14 |
call mtr.add_suppression("\\[GCS\\]*"); |
| 15 |
call mtr.add_suppression("The group_replication_group_name option is mandatory"); |
| 16 |
call mtr.add_suppression("Unable to start Group Replication on boot"); |
| 17 |
set session sql_log_bin=1; |
| 18 |
[connection server2] |
| 19 |
set session sql_log_bin=0; |
| 20 |
call mtr.add_suppression("Members removed from the group*"); |
| 21 |
call mtr.add_suppression("Member with address*"); |
| 22 |
call mtr.add_suppression("\\[GCS\\]*"); |
| 23 |
call mtr.add_suppression("The group_replication_group_name option is mandatory"); |
| 24 |
call mtr.add_suppression("Unable to start Group Replication on boot"); |
| 25 |
set session sql_log_bin=1; |
| 26 |
[connection server3] |
| 27 |
set session sql_log_bin=0; |
| 28 |
call mtr.add_suppression("Members removed from the group*"); |
| 29 |
call mtr.add_suppression("Member with address*"); |
| 30 |
call mtr.add_suppression("\\[GCS\\]*"); |
| 31 |
call mtr.add_suppression("The group_replication_group_name option is mandatory"); |
| 32 |
call mtr.add_suppression("Unable to start Group Replication on boot"); |
| 33 |
set session sql_log_bin=1; |
| 34 |
|
| 35 |
############################################################ |
| 36 |
# 2. Start all servers. |
| 37 |
[connection server1] |
| 38 |
include/start_and_bootstrap_group_replication.inc |
| 39 |
[connection server2] |
| 40 |
include/start_group_replication.inc |
| 41 |
[connection server3] |
| 42 |
include/start_group_replication.inc |
| 43 |
|
| 44 |
############################################################ |
| 45 |
# 3. Kill and re-start primary server 3 times. |
| 46 |
#### 3 #### |
| 47 |
include/gr_find_a_primary.inc |
| 48 |
[connection server1] |
| 49 |
# Kill and restart |
| 50 |
include/rpl_reconnect.inc |
| 51 |
include/gr_wait_for_member_state.inc |
| 52 |
include/rpl_gr_wait_for_number_of_members.inc |
| 53 |
#### 2 #### |
| 54 |
include/gr_find_a_primary.inc |
| 55 |
[connection server3] |
| 56 |
# Kill and restart |
| 57 |
include/rpl_reconnect.inc |
| 58 |
include/gr_wait_for_member_state.inc |
| 59 |
include/rpl_gr_wait_for_number_of_members.inc |
| 60 |
#### 1 #### |
| 61 |
include/gr_find_a_primary.inc |
| 62 |
[connection server1] |
| 63 |
# Kill and restart |
| 64 |
include/rpl_reconnect.inc |
| 65 |
include/gr_wait_for_member_state.inc |
| 66 |
include/rpl_gr_wait_for_number_of_members.inc |
| 67 |
|
| 68 |
############################################################ |
| 69 |
# 4. Cleanup. |
| 70 |
[connection server3] |
| 71 |
include/stop_group_replication.inc |
| 72 |
[connection server2] |
| 73 |
include/stop_group_replication.inc |
| 74 |
[connection server1] |
| 75 |
include/stop_group_replication.inc |
| 76 |
include/group_replication_end.inc |