Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_sync.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 STOP SLAVE;
7 Warnings:
8 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
9 CREATE DATABASE ndbsynctest;
10 USE ndbsynctest;
11 CREATE DATABASE ndbsynctest;
12 USE ndbsynctest;
13 CREATE TABLE t1 (c1 BIT(1) NOT NULL, c2 BIT(1) NOT NULL, c3 CHAR(15), PRIMARY KEY(c3)) ENGINE = NDB ;
14 INSERT INTO t1 VALUES (1,1,"row1"),(0,1,"row2"),(1,0,"row3"),(0,0,"row4");
15 CREATE TABLE t2 (c1 CHAR(15), c2 BIT(1) NOT NULL, c3 BIT(1) NOT NULL, PRIMARY KEY(c1)) ENGINE = NDB ;
16 INSERT INTO t2 VALUES ("ABC",1,1),("BCDEF",0,1),("CD",1,0),("DEFGHIJKL",0,0);
17 SELECT hex(c1),hex(c2),c3 FROM t1 ORDER BY c3;
18 hex(c1) hex(c2) c3
19 1 1 row1
20 0 1 row2
21 1 0 row3
22 0 0 row4
23 SELECT hex(c2),hex(c3),c1 FROM t2 ORDER BY c1;
24 hex(c2) hex(c3) c1
25 1 1 ABC
26 0 1 BCDEF
27 1 0 CD
28 0 0 DEFGHIJKL
29 UPDATE t1 SET c2=0 WHERE c3="row2";
30 SELECT hex(c1),hex(c2),c3 FROM t1 ORDER BY c3;
31 hex(c1) hex(c2) c3
32 1 1 row1
33 0 0 row2
34 1 0 row3
35 0 0 row4
36 SHOW TABLES;
37 Tables_in_ndbsynctest
38 DROP DATABASE ndbsynctest;
39 CREATE DATABASE ndbsynctest;
40 USE ndbsynctest;
41 SELECT hex(c1),hex(c2),c3 FROM t1 ORDER BY c3;
42 hex(c1) hex(c2) c3
43 1 1 row1
44 0 1 row2
45 1 0 row3
46 0 0 row4
47 SELECT hex(c2),hex(c3),c1 FROM t2 ORDER BY c1;
48 hex(c2) hex(c3) c1
49 1 1 ABC
50 0 1 BCDEF
51 1 0 CD
52 0 0 DEFGHIJKL
53 SELECT MAX(epoch) FROM mysql.ndb_apply_status into @the_epoch;
54 SELECT @the_epoch;
55 @the_epoch
56 <the_epoch>
57 @the_pos @the_file
58 <the_pos> master-bin.000001
59 CHANGE REPLICATION SOURCE TO
60 SOURCE_LOG_FILE = 'master-bin.000001',
61 SOURCE_LOG_POS = <the_pos> ;
62 START SLAVE;
63 Warnings:
64 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
65 include/check_slave_is_running.inc
66 SELECT hex(c1),hex(c2),c3 FROM t1 ORDER BY c3;
67 hex(c1) hex(c2) c3
68 1 1 row1
69 0 0 row2
70 1 0 row3
71 0 0 row4
72 SELECT hex(c2),hex(c3),c1 FROM t2 ORDER BY c1;
73 hex(c2) hex(c3) c1
74 1 1 ABC
75 0 1 BCDEF
76 1 0 CD
77 0 0 DEFGHIJKL
78 DROP DATABASE ndbsynctest;
79 STOP SLAVE;
80 Warnings:
81 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
82 reset master;
83 select * from mysql.ndb_binlog_index;
84 Position File epoch inserts updates deletes schemaops orig_server_id orig_epoch gci next_position next_file
85 reset slave;
86 Warnings:
87 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
88 select * from mysql.ndb_apply_status;
89 server_id epoch log_name start_pos end_pos
90 include/rpl_end.inc