Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2->3]
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 include/rpl_connect.inc [creating cluster1]
9 include/rpl_connect.inc [creating cluster2]
10 include/rpl_connect.inc [creating cluster3]
11 [connection cluster1]
12 CLUSTER1_SERVER_ID: 1
13 [connection cluster2]
14 show variables like 'server_id';
15 Variable_name Value
16 server_id 2
17 [connection cluster3]
18 show variables like 'server_id';
19 Variable_name Value
20 server_id 3
21 First show replication 1->2->3
22 [connection cluster1]
23 use test;
24 create table t1(a int primary key, b varchar(50)) engine=ndb;
25 insert into t1 values (1,'Summertime');
26 Cluster2 has insert and apply_status from Cluster1
27 show variables like 'server_id';
28 Variable_name Value
29 server_id 2
30 select * from mysql.ndb_apply_status order by server_id;
31 server_id epoch log_name start_pos end_pos
32 1 # cluster1-bin.000001 # #
33 select * from test.t1;
34 a b
35 1 Summertime
36 include/show_binlog_events.inc
37 ---- [cluster2] SHOW BINLOG EVENTS FROM <POSITION> ----
38 Log_name Pos Event_type Server_id End_log_pos Info
39 cluster2-bin.000001 # Query 1 # use `test`; create table t1(a int primary key, b varchar(50)) engine=ndb
40 cluster2-bin.000001 # Query 2 # BEGIN
41 cluster2-bin.000001 # Table_map 2 # table_id: # (test.t1)
42 cluster2-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
43 cluster2-bin.000001 # Write_rows 2 # table_id: #
44 cluster2-bin.000001 # Write_rows 1 # table_id: #
45 cluster2-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F
46 cluster2-bin.000001 # Query 2 # COMMIT
47 Cluster3 has insert and apply_status from Cluster1+2
48 show variables like 'server_id';
49 Variable_name Value
50 server_id 3
51 select * from mysql.ndb_apply_status order by server_id;
52 server_id epoch log_name start_pos end_pos
53 1 # cluster1-bin.000001 # #
54 2 # cluster2-bin.000001 # #
55 select * from test.t1;
56 a b
57 1 Summertime
58 Break Cluster3's link with Cluster2
59 [connection cluster3]
60 include/stop_slave.inc
61 Make further changes on Cluster1
62 [connection cluster1]
63 insert into test.t1 values (2, "The cotton is high");
64 insert into test.t1 values (3, "Daddys rich");
65 Show changes exist on Cluster2
66 select * from test.t1 order by a;
67 a b
68 1 Summertime
69 2 The cotton is high
70 3 Daddys rich
71 Check data on Cluster3
72 [connection cluster3]
73 select * from test.t1 order by a;
74 a b
75 1 Summertime
76 Now change Cluster3 to skip-over Cluster2 and get binlog direct from Cluster1
77 select * from mysql.ndb_apply_status order by server_id;
78 server_id epoch log_name start_pos end_pos
79 1 # cluster1-bin.000001 # #
80 2 # cluster2-bin.000001 # #
81 reset slave;
82 Warnings:
83 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
84 include/rpl_change_topology.inc [new topology=1->2,1->3]
85 Warnings:
86 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
87 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.
88 include/start_slave.inc
89 [connection cluster1]
90 Now show that cluster 3 is successfully replicating from Cluster1
91 [connection cluster3]
92 select * from test.t1 order by a;
93 a b
94 1 Summertime
95 2 The cotton is high
96 3 Daddys rich
97 Clean up
98 [connection cluster1]
99 drop table test.t1;
100 include/rpl_end.inc