| 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. Try setting group_replication_ip_whitelist variable to AUTOMATIC |
| 8 |
SET @@GLOBAL.group_replication_ip_whitelist= "AUTOMATIC"; |
| 9 |
Warnings: |
| 10 |
Warning 1287 'group_replication_ip_whitelist' is deprecated and will be removed in a future release. Please use group_replication_ip_allowlist instead |
| 11 |
|
| 12 |
# 2. Try setting group_replication_ip_whitelist variable. |
| 13 |
SET @@GLOBAL.group_replication_ip_whitelist = "127.0.0.1/8";; |
| 14 |
Warnings: |
| 15 |
Warning 1287 'group_replication_ip_whitelist' is deprecated and will be removed in a future release. Please use group_replication_ip_allowlist instead |
| 16 |
include/start_and_bootstrap_group_replication.inc |
| 17 |
Warnings: |
| 18 |
Warning 1287 'group_replication_ip_whitelist' is deprecated and will be removed in a future release. Please use group_replication_ip_allowlist instead |
| 19 |
include/assert_grep.inc [Deprecation warning is not logged when shown in client.] |
| 20 |
|
| 21 |
# 3. Reboot server setting group_replication_ip_whitelist variable. |
| 22 |
# restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_bootstrap_group=1 --group_replication_start_on_boot=1 --group_replication_ip_whitelist=127.0.0.1/8 |
| 23 |
include/rpl_reconnect.inc |
| 24 |
include/gr_wait_for_member_state.inc |
| 25 |
include/assert_grep.inc [Deprecation warning is logged when not shown in client.] |
| 26 |
|
| 27 |
# 4. Cleanup. |
| 28 |
include/stop_group_replication.inc |
| 29 |
SET SESSION sql_log_bin = 0; |
| 30 |
call mtr.add_suppression("\\[GCS\\] Automatically adding IPv. localhost address to the allowlist. It is mandatory that it is added."); |
| 31 |
SET SESSION sql_log_bin = 1; |
| 32 |
SET @@GLOBAL.group_replication_ip_whitelist= GROUP_REPLICATION_IP_WHITELIST; |
| 33 |
Warnings: |
| 34 |
Warning 1287 'group_replication_ip_whitelist' is deprecated and will be removed in a future release. Please use group_replication_ip_allowlist instead |
| 35 |
# restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_bootstrap_group=1 |
| 36 |
include/rpl_reconnect.inc |
| 37 |
include/group_replication_end.inc |