| 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. Define two uuid for use on view_change_uuid |
| 9 |
|
| 10 |
############################################################ |
| 11 |
# 2. Bootstrap group with VIEW_CHANGE_UUID |
| 12 |
SET @group_replication_view_change_uuid_save= @@GLOBAL.group_replication_view_change_uuid; |
| 13 |
SET GLOBAL group_replication_view_change_uuid = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"; |
| 14 |
Warnings: |
| 15 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 16 |
include/start_and_bootstrap_group_replication.inc |
| 17 |
Warnings: |
| 18 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 19 |
|
| 20 |
############################################################ |
| 21 |
# 3. To change view_change_uuid group replication shall be |
| 22 |
# stopped |
| 23 |
SET GLOBAL group_replication_view_change_uuid = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaab"; |
| 24 |
ERROR HY000: The group_replication_view_change_uuid cannot be changed when Group Replication is running |
| 25 |
|
| 26 |
############################################################ |
| 27 |
# 4. A member only can join if it has same view_change_uuid |
| 28 |
# that is defined on group |
| 29 |
[connection server2] |
| 30 |
SET SESSION sql_log_bin=0; |
| 31 |
call mtr.add_suppression(".*The member is configured with a group_replication_view_change_uuid option value .* different from the group .*. The member will now exit the group."); |
| 32 |
SET SESSION sql_log_bin=1; |
| 33 |
SET @group_replication_view_change_uuid_save= @@GLOBAL.group_replication_view_change_uuid; |
| 34 |
SET GLOBAL group_replication_view_change_uuid = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaab"; |
| 35 |
Warnings: |
| 36 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 37 |
SET GLOBAL group_replication_group_name = "GROUP_REPLICATION_GROUP_NAME"; |
| 38 |
START GROUP_REPLICATION; |
| 39 |
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log. |
| 40 |
include/assert_grep.inc [group_replication_view_change_uuid from joiner different from group] |
| 41 |
|
| 42 |
############################################################ |
| 43 |
# 5. Server 2 configured with view_change_uuid of group |
| 44 |
# can join |
| 45 |
SET GLOBAL group_replication_view_change_uuid = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"; |
| 46 |
Warnings: |
| 47 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 48 |
include/start_group_replication.inc |
| 49 |
Warnings: |
| 50 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 51 |
|
| 52 |
############################################################ |
| 53 |
# 6. Confirm both server have same GTID.EXECUTED from all |
| 54 |
# the views logged |
| 55 |
include/assert.inc [GTID_EXECUTED must only contain view changes] |
| 56 |
[connection server1] |
| 57 |
include/assert.inc [GTID_EXECUTED must only contain view changes] |
| 58 |
|
| 59 |
############################################################ |
| 60 |
# 7. Cleanup |
| 61 |
include/stop_group_replication.inc |
| 62 |
SET @@GLOBAL.group_replication_view_change_uuid= @group_replication_view_change_uuid_save; |
| 63 |
Warnings: |
| 64 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 65 |
[connection server2] |
| 66 |
include/stop_group_replication.inc |
| 67 |
SET @@GLOBAL.group_replication_view_change_uuid= @group_replication_view_change_uuid_save; |
| 68 |
Warnings: |
| 69 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 70 |
include/group_replication_end.inc |