Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->6,2->3,5->7]
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 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 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.
8 Warnings:
9 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
10 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.
11 include/rpl_connect.inc [creating source.1]
12 include/rpl_connect.inc [creating source.2]
13 include/rpl_connect.inc [creating replica.3]
14 include/rpl_connect.inc [creating source.4]
15 include/rpl_connect.inc [creating source.5]
16 include/rpl_connect.inc [creating replica.6]
17 include/rpl_connect.inc [creating replica.7]
18 [connection source.1]
19 CREATE TABLE t1 (k INT PRIMARY KEY, c CHAR) ENGINE = NDB;
20 INSERT INTO t1 VALUES (1, 'a');
21 # Sync the replication topology (propagates the table to all clusters)
22 include/rpl_sync.inc
23 [connection source.2]
24 INSERT INTO t1 VALUES (2, 'b');
25 [connection source.4]
26 SET sql_log_bin= OFF;
27 INSERT INTO t1 VALUES (3, 'c');
28 SET sql_log_bin= ON;
29 INSERT INTO t1 VALUES (4, 'd');
30 [connection source.5]
31 INSERT INTO t1 VALUES (5, 'e');
32 # Sync the replication topology (propagates the data changes)
33 include/rpl_sync.inc
34 [connection replica.3]
35 SELECT * FROM t1 ORDER BY k;
36 k c
37 1 a
38 2 b
39 3 c
40 4 d
41 5 e
42 [connection source.4]
43 SELECT * FROM t1 ORDER BY k;
44 k c
45 1 a
46 2 b
47 3 c
48 4 d
49 5 e
50 [connection source.5]
51 SELECT * FROM t1 ORDER BY k;
52 k c
53 1 a
54 2 b
55 3 c
56 4 d
57 5 e
58 [connection replica.7]
59 # Must not have k = 3
60 SELECT * FROM t1 ORDER BY k;
61 k c
62 1 a
63 2 b
64 4 d
65 5 e
66 [connection replica.6]
67 # Must not have k = 3
68 SELECT * FROM t1 ORDER BY k;
69 k c
70 1 a
71 2 b
72 4 d
73 5 e
74 Cleanup
75 [connection source.1]
76 DROP TABLE t1;
77 include/rpl_end.inc