Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_row_innodb_w_compression.result

raw
1 include/master-slave.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 master]
6 ******************************************************
7 * 1. Set compression to ON
8 ******************************************************
9 SET GLOBAL binlog_transaction_compression = ON;
10 ******************************************************
11 * 2. Replicate data
12 ******************************************************
13 SET binlog_format = ROW;
14 Warnings:
15 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
16 [connection master]
17 create table t1 (a int key, b int) engine innodb;
18 create table t2 (a int key, b int) engine innodb;
19
20 include/sync_slave_sql_with_master.inc
21 alter table t1 engine ndb;
22 alter table t2 engine ndb;
23
24 *** Test 1 ***
25
26 [connection master]
27 insert into t1 values (1,2);
28 include/show_binlog_events.inc
29 Log_name Pos Event_type Server_id End_log_pos Info
30 master-bin.000001 # Query # # BEGIN
31 master-bin.000001 # Table_map # # table_id: # (test.t1)
32 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
33 master-bin.000001 # Xid # # COMMIT /* XID */
34 include/sync_slave_sql_with_master.inc
35 select log_name, start_pos from mysql.ndb_apply_status
36
37 *** Test 1B ***
38
39 [connection master]
40 begin;
41 insert into t1 values (2,3);
42 insert into t2 values (3,4);
43 commit;
44 include/show_binlog_events.inc
45 Log_name Pos Event_type Server_id End_log_pos Info
46 master-bin.000001 # Query # # BEGIN
47 master-bin.000001 # Table_map # # table_id: # (test.t1)
48 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
49 master-bin.000001 # Table_map # # table_id: # (test.t2)
50 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
51 master-bin.000001 # Xid # # COMMIT /* XID */
52 include/sync_slave_sql_with_master.inc
53 select log_name, start_pos from mysql.ndb_apply_status
54 [connection master]
55 DROP TABLE test.t1, test.t2;
56 include/sync_slave_sql_with_master.inc
57 SHOW TABLES;
58 Tables_in_test
59
60 *** Test 2 ***
61
62 [connection master]
63 DROP DATABASE IF EXISTS tpcb;
64 CREATE DATABASE tpcb;
65
66 CREATE TABLE tpcb.account (id INT, bid INT, balance DECIMAL(10,2),
67 filler CHAR(255), PRIMARY KEY(id));
68
69 CREATE TABLE tpcb.branch (bid INT, balance DECIMAL(10,2), filler VARCHAR(255),
70 PRIMARY KEY(bid));
71
72 CREATE TABLE tpcb.teller (tid INT, balance DECIMAL(10,2), filler VARCHAR(255),
73 PRIMARY KEY(tid));
74
75 CREATE TABLE tpcb.history (id MEDIUMINT NOT NULL AUTO_INCREMENT,aid INT,
76 tid INT, bid INT, amount DECIMAL(10,2),
77 tdate DATETIME, teller CHAR(20), uuidf LONGBLOB,
78 filler CHAR(80),PRIMARY KEY (id));
79
80 --- Create stored procedures & functions ---
81
82
83 *** Stored Procedures Created ***
84
85 include/sync_slave_sql_with_master.inc
86 USE tpcb;
87 ALTER TABLE account ENGINE NDB;
88 ALTER TABLE branch ENGINE NDB;
89 ALTER TABLE teller ENGINE NDB;
90 ALTER TABLE history ENGINE NDB;
91 [connection master]
92 COMMIT
93 COMMIT
94 COMMIT
95 COMMIT
96 COMMIT
97 include/show_binlog_events.inc
98 Log_name Pos Event_type Server_id End_log_pos Info
99 master-bin.000001 # Xid # # COMMIT /* XID */
100 include/sync_slave_sql_with_master.inc
101 select log_name, start_pos from mysql.ndb_apply_status
102
103 ** Test 3 **
104
105 [connection master]
106 FLUSH LOGS;
107 COMMIT
108 COMMIT
109 COMMIT
110 COMMIT
111 COMMIT
112 include/show_binlog_events.inc
113 Log_name Pos Event_type Server_id End_log_pos Info
114 master-bin.000002 # Xid # # COMMIT /* XID */
115 include/sync_slave_sql_with_master.inc
116 select log_name, start_pos from mysql.ndb_apply_status
117
118 ** Test 4 **
119
120 [connection master]
121 include/rpl_reset.inc
122
123 [connection master]
124 COMMIT
125 COMMIT
126 COMMIT
127 COMMIT
128 COMMIT
129 include/show_binlog_events.inc
130 Log_name Pos Event_type Server_id End_log_pos Info
131 master-bin.000001 # Xid # # COMMIT /* XID */
132 include/sync_slave_sql_with_master.inc
133 select log_name, start_pos from mysql.ndb_apply_status
134 include/diff_tables.inc [tpcb.account, master:tpcb.account]
135 include/diff_tables.inc [tpcb.teller, master:tpcb.teller]
136 include/diff_tables.inc [tpcb.branch, master:tpcb.branch]
137 include/diff_tables.inc [tpcb.history, master:tpcb.history]
138 [connection master]
139 DROP DATABASE tpcb;
140 include/sync_slave_sql_with_master.inc
141 ******************************************************
142 * 3. Cleanup
143 ******************************************************
144 [connection master]
145 SET GLOBAL binlog_transaction_compression = SAVED;
146 include/rpl_end.inc