Debian Codegraph @

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