| 1 |
include/group_replication.inc [rpl_server_count=3] |
| 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 |
# Setup a new group with two servers. |
| 8 |
# Check that server 2 receives a view event and writes another one |
| 9 |
# |
| 10 |
server1 |
| 11 |
include/start_and_bootstrap_group_replication.inc |
| 12 |
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB; |
| 13 |
server2 |
| 14 |
include/start_group_replication.inc |
| 15 |
include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # !Gtid_transaction # Gtid # Query/BEGIN # View_change # Query/COMMIT] |
| 16 |
# |
| 17 |
# Make server 2 leave and enter generating one more view change event |
| 18 |
# Check that only one view change transaction is written to the binlog |
| 19 |
# |
| 20 |
server2 |
| 21 |
include/stop_group_replication.inc |
| 22 |
include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # !Gtid_transaction # Gtid # Query/BEGIN # View_change # Query/COMMIT] |
| 23 |
include/start_group_replication.inc |
| 24 |
include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # !Gtid_transaction # Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT] |
| 25 |
# |
| 26 |
# Make server 3 join and leave while server 2 was away |
| 27 |
# Server 2 should receive 1 view change transaction from recovery and |
| 28 |
# write another |
| 29 |
# |
| 30 |
server2 |
| 31 |
include/stop_group_replication.inc |
| 32 |
server3 |
| 33 |
include/start_group_replication.inc |
| 34 |
include/stop_group_replication.inc |
| 35 |
server2 |
| 36 |
include/start_group_replication.inc |
| 37 |
include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # !Gtid_transaction # Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT] |
| 38 |
# |
| 39 |
# Cleaning up |
| 40 |
# |
| 41 |
server3 |
| 42 |
include/start_group_replication.inc |
| 43 |
DROP TABLE t1; |
| 44 |
include/group_replication_end.inc |