| 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 |