Debian Codegraph @

mysql-test/suite/group_replication/r/gr_replicate_group_to_server.result

raw
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 [connection server1]
7 include/start_and_bootstrap_group_replication.inc
8 [connection server2]
9 include/start_group_replication.inc
10 CREATE TABLE test.t1 (i INT PRIMARY KEY);
11 INSERT INTO test.t1 VALUES(1);
12 include/rpl_sync.inc
13 [connection server3]
14 SET SESSION sql_log_bin= 0;
15 include/gtid_utils.inc
16 SET SESSION sql_log_bin= 1;
17 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_AUTO_POSITION=1;
18 include/start_slave.inc
19 [connection server2]
20 include/stop_group_replication.inc
21 include/start_group_replication.inc
22 INSERT INTO test.t1 VALUES(2);
23 include/rpl_sync.inc
24 [connection server1]
25 include/sync_slave_sql_with_master.inc
26 # On the slave (server3), test that the data is properly replicated
27 # after the start slave is complete.
28 include/diff_tables.inc [server1:test.t1, server3:test.t1]
29 include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT # !Gtid_transaction # !Gtid_transaction # Gtid # Query/BEGIN # View_change # Query/COMMIT # !Gtid_transaction]
30 [connection server1]
31 DROP TABLE test.t1;
32 include/sync_slave_sql_with_master.inc
33 include/stop_slave.inc
34 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION=0;
35 SET SESSION sql_log_bin= 0;
36 include/gtid_utils_end.inc
37 SET SESSION sql_log_bin= 1;
38 include/rpl_reset_slave.inc
39 include/group_replication_end.inc