| 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 |
############################################################ |
| 8 |
# 1. Persist configuration on server1. |
| 9 |
[connection server1] |
| 10 |
SET PERSIST group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME"; |
| 11 |
SET PERSIST group_replication_group_seeds= @@GLOBAL.group_replication_group_seeds; |
| 12 |
SET PERSIST group_replication_local_address= @@GLOBAL.group_replication_local_address; |
| 13 |
SET PERSIST group_replication_start_on_boot= ON; |
| 14 |
SET PERSIST group_replication_bootstrap_group= ON; |
| 15 |
SET PERSIST group_replication_recovery_get_public_key= ON; |
| 16 |
|
| 17 |
############################################################ |
| 18 |
# 2. Restart server1, it must bootstrap the group. |
| 19 |
# restart |
| 20 |
include/rpl_reconnect.inc |
| 21 |
include/gr_wait_for_member_state.inc |
| 22 |
SELECT variable_name, variable_source FROM performance_schema.variables_info WHERE variable_source IN ('PERSISTED'); |
| 23 |
variable_name variable_source |
| 24 |
group_replication_bootstrap_group PERSISTED |
| 25 |
group_replication_group_name PERSISTED |
| 26 |
group_replication_group_seeds PERSISTED |
| 27 |
group_replication_ip_allowlist PERSISTED |
| 28 |
group_replication_local_address PERSISTED |
| 29 |
group_replication_recovery_get_public_key PERSISTED |
| 30 |
group_replication_start_on_boot PERSISTED |
| 31 |
|
| 32 |
############################################################ |
| 33 |
# 3. Persist configuration on server2. |
| 34 |
[connection server2] |
| 35 |
SET PERSIST group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME"; |
| 36 |
SET PERSIST group_replication_group_seeds= @@GLOBAL.group_replication_group_seeds; |
| 37 |
SET PERSIST group_replication_local_address= @@GLOBAL.group_replication_local_address; |
| 38 |
SET PERSIST group_replication_start_on_boot= ON; |
| 39 |
SET PERSIST group_replication_recovery_get_public_key= ON; |
| 40 |
|
| 41 |
############################################################ |
| 42 |
# 4. Restart server2, it must join the group. |
| 43 |
# restart |
| 44 |
include/rpl_reconnect.inc |
| 45 |
include/gr_wait_for_member_state.inc |
| 46 |
include/rpl_gr_wait_for_number_of_members.inc |
| 47 |
SELECT variable_name, variable_source FROM performance_schema.variables_info WHERE variable_source IN ('PERSISTED'); |
| 48 |
variable_name variable_source |
| 49 |
group_replication_group_name PERSISTED |
| 50 |
group_replication_group_seeds PERSISTED |
| 51 |
group_replication_ip_allowlist PERSISTED |
| 52 |
group_replication_local_address PERSISTED |
| 53 |
group_replication_recovery_get_public_key PERSISTED |
| 54 |
group_replication_start_on_boot PERSISTED |
| 55 |
|
| 56 |
############################################################ |
| 57 |
# 5. Clean up. |
| 58 |
[connection server1] |
| 59 |
RESET PERSIST; |
| 60 |
SET GLOBAL group_replication_start_on_boot= OFF; |
| 61 |
[connection server2] |
| 62 |
RESET PERSIST; |
| 63 |
SET GLOBAL group_replication_start_on_boot= OFF; |
| 64 |
include/group_replication_end.inc |
| 65 |
Warnings: |
| 66 |
Warning 3615 Variable group_replication_ip_allowlist does not exist in persisted config file |
| 67 |
Warnings: |
| 68 |
Warning 3615 Variable group_replication_ip_allowlist does not exist in persisted config file |