| Server IP : 104.21.38.3 / Your IP : 162.158.163.118 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/ndb_rpl/r/ |
Upload File : |
include/rpl_init.inc [topology=1->2->3] Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. include/rpl_connect.inc [creating cluster1] include/rpl_connect.inc [creating cluster2] include/rpl_connect.inc [creating cluster3] [connection cluster1] CLUSTER1_SERVER_ID: 1 [connection cluster2] show variables like 'server_id'; Variable_name Value server_id 2 [connection cluster3] show variables like 'server_id'; Variable_name Value server_id 3 First show replication 1->2->3 [connection cluster1] use test; create table t1(a int primary key, b varchar(50)) engine=ndb; insert into t1 values (1,'Summertime'); Cluster2 has insert and apply_status from Cluster1 show variables like 'server_id'; Variable_name Value server_id 2 select * from mysql.ndb_apply_status order by server_id; server_id epoch log_name start_pos end_pos 1 # # # # select * from test.t1; a b 1 Summertime Cluster3 has insert and apply_status from Cluster1+2 show variables like 'server_id'; Variable_name Value server_id 3 select * from mysql.ndb_apply_status order by server_id; server_id epoch log_name start_pos end_pos 1 # # # # 2 # # # # select * from test.t1; a b 1 Summertime Break Cluster3's link with Cluster2 [connection cluster3] include/stop_slave.inc Make further changes on Cluster1 [connection cluster1] insert into test.t1 values (2, "The cotton is high"); insert into test.t1 values (3, "Daddys rich"); Show changes exist on Cluster2 select * from test.t1 order by a; a b 1 Summertime 2 The cotton is high 3 Daddys rich Check data on Cluster3 [connection cluster3] select * from test.t1 order by a; a b 1 Summertime Now change Cluster3 to skip-over Cluster2 and get binlog direct from Cluster1 select * from mysql.ndb_apply_status order by server_id; server_id epoch log_name start_pos end_pos 1 # # # # 2 # # # # reset slave; include/rpl_change_topology.inc [new topology=1->2,1->3] Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. include/start_slave.inc [connection cluster1] Now show that cluster 3 is successfully replicating from Cluster1 [connection cluster3] select * from test.t1 order by a; a b 1 Summertime 2 The cotton is high 3 Daddys rich Clean up [connection cluster1] drop table test.t1; include/rpl_end.inc