Debian Codegraph @

mysql-test/suite/galera/r/galera_log_bin.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_2;
4 set global wsrep_on=OFF;
5 reset master;
6 set global wsrep_on=ON;
7 connection node_1;
8 set global wsrep_on=OFF;
9 reset master;
10 set global wsrep_on=ON;
11 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
12 INSERT INTO t1 VALUES (1);
13 CREATE TABLE t2 (id INT) ENGINE=InnoDB;
14 INSERT INTO t2 VALUES (1);
15 INSERT INTO t2 VALUES (1);
16 connection node_2;
17 SELECT COUNT(*) = 1 FROM t1;
18 COUNT(*) = 1
19 1
20 SELECT COUNT(*) = 2 FROM t2;
21 COUNT(*) = 2
22 1
23 connection node_1;
24 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
25 include/show_binlog_events.inc
26 Log_name Pos Event_type Server_id End_log_pos Info
27 mysqld-bin.000001 # Gtid # # GTID #-#-#
28 mysqld-bin.000001 # Query # # use `test`; CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB
29 mysqld-bin.000001 # Gtid # # BEGIN GTID #-#-#
30 mysqld-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
31 mysqld-bin.000001 # Table_map # # table_id: # (test.t1)
32 mysqld-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
33 mysqld-bin.000001 # Xid # # COMMIT /* XID */
34 mysqld-bin.000001 # Gtid # # GTID #-#-#
35 mysqld-bin.000001 # Query # # use `test`; CREATE TABLE t2 (id INT) ENGINE=InnoDB
36 mysqld-bin.000001 # Gtid # # BEGIN GTID #-#-#
37 mysqld-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1)
38 mysqld-bin.000001 # Table_map # # table_id: # (test.t2)
39 mysqld-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
40 mysqld-bin.000001 # Xid # # COMMIT /* XID */
41 mysqld-bin.000001 # Gtid # # BEGIN GTID #-#-#
42 mysqld-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1)
43 mysqld-bin.000001 # Table_map # # table_id: # (test.t2)
44 mysqld-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
45 mysqld-bin.000001 # Xid # # COMMIT /* XID */
46 mysqld-bin.000001 # Gtid # # GTID #-#-#
47 mysqld-bin.000001 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN f2 INTEGER
48 connection node_2;
49 SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
50 COUNT(*) = 2
51 1
52 include/show_binlog_events.inc
53 Log_name Pos Event_type Server_id End_log_pos Info
54 mysqld-bin.000001 # Gtid # # GTID #-#-#
55 mysqld-bin.000001 # Query # # use `test`; CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB
56 mysqld-bin.000001 # Gtid # # BEGIN GTID #-#-#
57 mysqld-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
58 mysqld-bin.000001 # Table_map # # table_id: # (test.t1)
59 mysqld-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
60 mysqld-bin.000001 # Xid # # COMMIT /* XID */
61 mysqld-bin.000001 # Gtid # # GTID #-#-#
62 mysqld-bin.000001 # Query # # use `test`; CREATE TABLE t2 (id INT) ENGINE=InnoDB
63 mysqld-bin.000001 # Gtid # # BEGIN GTID #-#-#
64 mysqld-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1)
65 mysqld-bin.000001 # Table_map # # table_id: # (test.t2)
66 mysqld-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
67 mysqld-bin.000001 # Xid # # COMMIT /* XID */
68 mysqld-bin.000001 # Gtid # # BEGIN GTID #-#-#
69 mysqld-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1)
70 mysqld-bin.000001 # Table_map # # table_id: # (test.t2)
71 mysqld-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
72 mysqld-bin.000001 # Xid # # COMMIT /* XID */
73 mysqld-bin.000001 # Gtid # # GTID #-#-#
74 mysqld-bin.000001 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN f2 INTEGER
75 DROP TABLE t1;
76 DROP TABLE t2;
77 #cleanup
78 connection node_1;
79 SET GLOBAL wsrep_on=OFF;
80 RESET MASTER;
81 SET GLOBAL wsrep_on=ON;