50 lines
2.3 KiB
Plaintext
50 lines
2.3 KiB
Plaintext
include/group_replication.inc
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
[connection server1]
|
|
[connection server1]
|
|
SET SESSION sql_log_bin= 0;
|
|
call mtr.add_suppression(".*The group replication user is not present in the server *.*");
|
|
SET SESSION sql_log_bin= 1;
|
|
#
|
|
# Assert the user exist from the start
|
|
#
|
|
[connection server1]
|
|
include/assert.inc [The group replication user should exist in this member]
|
|
#
|
|
# Start group replication and check all is OK
|
|
#
|
|
include/start_and_bootstrap_group_replication.inc
|
|
include/assert.inc [The group replication user should exist in this member]
|
|
#
|
|
# Delete the user and watch GR fail at start
|
|
#
|
|
include/stop_group_replication.inc
|
|
DROP USER "mysql.session"@"localhost";
|
|
START GROUP_REPLICATION;
|
|
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
|
|
#
|
|
# Recreate the user with an upgrade and see that GR works
|
|
#
|
|
Run mysql_upgrade
|
|
# 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 --upgrade=FORCE
|
|
include/rpl_reconnect.inc
|
|
include/start_and_bootstrap_group_replication.inc
|
|
#
|
|
# Uninstall plugin and verify that user is still there
|
|
#
|
|
include/uninstall_group_replication_plugin.inc
|
|
include/assert.inc [The group replication user should exist after install]
|
|
#
|
|
# Cleaning
|
|
#
|
|
include/install_group_replication_plugin.inc
|
|
SET SESSION sql_log_bin= 0;
|
|
call mtr.add_suppression("There was an error when trying to access the server with user: mysql.session.*");
|
|
call mtr.add_suppression("Failed to establish an internal server connection to execute plugin operations");
|
|
call mtr.add_suppression("Error calling group communication interfaces while trying to leave the group");
|
|
call mtr.add_suppression("On plugin shutdown it was not possible to reset the server read mode settings. Try to reset it manually.");
|
|
SET SESSION sql_log_bin= 1;
|
|
include/group_replication_end.inc
|