| 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. Setup Group Replication on server 1 and 2 with view |
| 9 |
# change uuid configured with an valid uuid |
| 10 |
SET @group_replication_view_change_uuid_save= @@GLOBAL.group_replication_view_change_uuid; |
| 11 |
SET GLOBAL group_replication_view_change_uuid = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"; |
| 12 |
Warnings: |
| 13 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 14 |
include/start_and_bootstrap_group_replication.inc |
| 15 |
Warnings: |
| 16 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 17 |
[connection server2] |
| 18 |
SET @group_replication_view_change_uuid_save= @@GLOBAL.group_replication_view_change_uuid; |
| 19 |
SET GLOBAL group_replication_view_change_uuid = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"; |
| 20 |
Warnings: |
| 21 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 22 |
include/start_group_replication.inc |
| 23 |
Warnings: |
| 24 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 25 |
|
| 26 |
############################################################ |
| 27 |
# 2. Create a table on server 1 that will add one |
| 28 |
# transaction to the group |
| 29 |
[connection server1] |
| 30 |
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB; |
| 31 |
include/rpl_sync.inc |
| 32 |
|
| 33 |
############################################################ |
| 34 |
# 3. Insert data into table on server 2 that will add one |
| 35 |
# transaction to the group |
| 36 |
[connection server2] |
| 37 |
INSERT INTO t1 VALUES (0); |
| 38 |
include/rpl_sync.inc |
| 39 |
|
| 40 |
############################################################ |
| 41 |
# 4. Remove and rejoin server 2, that will generate a new |
| 42 |
# view and will recompute intervals |
| 43 |
include/stop_group_replication.inc |
| 44 |
include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 2 transactions] |
| 45 |
include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 2 view changes] |
| 46 |
include/start_group_replication.inc |
| 47 |
Warnings: |
| 48 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 49 |
|
| 50 |
############################################################ |
| 51 |
# 5. Insert data into table on server 2 that will add one |
| 52 |
# transaction to the group |
| 53 |
INSERT INTO t1 VALUES (1); |
| 54 |
include/rpl_sync.inc |
| 55 |
|
| 56 |
############################################################ |
| 57 |
# 6. Transactions are added to the correct intervals and |
| 58 |
# views are logged with view uuid |
| 59 |
include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 3 transactions, two on first interval] |
| 60 |
include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 3 view changes] |
| 61 |
[connection server1] |
| 62 |
include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 3 transactions, two on first interval] |
| 63 |
include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 3 view changes] |
| 64 |
|
| 65 |
############################################################ |
| 66 |
# 7. Stop server 2 and on server 1 set GTID_NEXT to next |
| 67 |
# expected view uuid and execute a transaction. |
| 68 |
# Start server 2 |
| 69 |
[connection server2] |
| 70 |
include/stop_group_replication.inc |
| 71 |
[connection server1] |
| 72 |
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:4';; |
| 73 |
INSERT INTO t1 VALUES (2); |
| 74 |
[connection server2] |
| 75 |
include/start_group_replication.inc |
| 76 |
Warnings: |
| 77 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 78 |
|
| 79 |
############################################################ |
| 80 |
# 8. Assert the intervals were not used, the new view |
| 81 |
# change is correctly logged and the transaction using |
| 82 |
# the view uuid is also executed. |
| 83 |
include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 3 transactions, two on first interval] |
| 84 |
include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 4 view changes plus 1 transaction] |
| 85 |
[connection server1] |
| 86 |
include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 3 transactions, two on first interval] |
| 87 |
include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 4 view changes plus 1 transaction] |
| 88 |
|
| 89 |
############################################################ |
| 90 |
# 9. Cleanup |
| 91 |
SET GTID_NEXT= 'AUTOMATIC'; |
| 92 |
DROP TABLE t1; |
| 93 |
include/stop_group_replication.inc |
| 94 |
SET @@GLOBAL.group_replication_view_change_uuid= @group_replication_view_change_uuid_save; |
| 95 |
Warnings: |
| 96 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 97 |
[connection server2] |
| 98 |
include/stop_group_replication.inc |
| 99 |
SET @@GLOBAL.group_replication_view_change_uuid= @group_replication_view_change_uuid_save; |
| 100 |
Warnings: |
| 101 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 102 |
include/group_replication_end.inc |