| 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 |
# 0. Persist binlog_checksum. |
| 9 |
[connection server1] |
| 10 |
SET PERSIST binlog_checksum= @@global.binlog_checksum; |
| 11 |
|
| 12 |
############################################################ |
| 13 |
# 1. SET PERSIST GR specific variables. |
| 14 |
SET PERSIST group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME"; |
| 15 |
SET PERSIST group_replication_local_address= @@global.group_replication_local_address; |
| 16 |
SET PERSIST group_replication_bootstrap_group= ON; |
| 17 |
SET PERSIST group_replication_start_on_boot=ON; |
| 18 |
|
| 19 |
############################################################ |
| 20 |
# 2. Restart server, it must bootstrap the group |
| 21 |
# restart |
| 22 |
include/rpl_reconnect.inc |
| 23 |
include/gr_wait_for_member_state.inc |
| 24 |
|
| 25 |
############################################################ |
| 26 |
# 3. Clean up. |
| 27 |
SET GLOBAL group_replication_start_on_boot= OFF; |
| 28 |
SET GLOBAL group_replication_bootstrap_group= OFF; |
| 29 |
RESET PERSIST; |
| 30 |
include/group_replication_end.inc |
| 31 |
Warnings: |
| 32 |
Warning 3615 Variable group_replication_ip_allowlist does not exist in persisted config file |