Debian Codegraph @

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

raw
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. Create table t1 with engine set to memory on server1
9 CREATE TABLE t1(a INT, b INT) engine=memory;
10 include/rpl_sync.inc
11
12 ############################################################
13 # 2. Restart server1 and start group replication
14 # 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
15 include/rpl_reconnect.inc
16 include/start_group_replication.inc
17
18 ############################################################
19 # 3. Create a new table based on t1. This will create an
20 # implicit commit due previous restart
21 CREATE TABLE t2 LIKE t1;
22 include/rpl_sync.inc
23
24 ############################################################
25 # 4. Wait for GTID_EXECUTED has 6 gtids
26
27 ############################################################
28 # 5. On binary log from first start we shall have: two
29 # views and a create table.
30 include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # !Q(CREATE.*)]
31
32 ############################################################
33 # 6. On binary log from second start we shall have: a view,
34 # a truncate table and a create table
35 include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # !Q(TRUNCATE.*) # Gtid # !Q(CREATE.*)]
36
37 ############################################################
38 # 7. On server 2 binary log we shall have: two views, a
39 # create table, a view, a truncate table and a create table
40 [connection server2]
41 include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # !Q(CREATE.*) # Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # !Q(TRUNCATE.*) # Gtid # !Q(CREATE.*)]
42
43 ############################################################
44 # 8. Cleanup
45 DROP TABLE t1;
46 DROP TABLE t2;
47 include/group_replication_end.inc