Server IP : 49.212.180.16 / Your IP : 18.218.96.239 Web Server : Apache System : FreeBSD www2606.sakura.ne.jp 13.0-RELEASE-p14 FreeBSD 13.0-RELEASE-p14 #2: Mon Dec 9 13:54:55 JST 2024 root@www5301.sakura.ne.jp:/usr/obj/usr/src/amd64.amd64/sys/GENERIC amd64 User : utannto ( 1076) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : ON | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/rs/mysql/5.1/mysql-test/suite/rpl_ndb/t/ |
Upload File : |
--source include/have_ndb.inc # set up circular replication --let $rpl_topology= 1->2->1 --source include/rpl_init.inc --let $rpl_connection_name= master --let $rpl_server_number= 1 --source include/rpl_connect.inc --let $rpl_connection_name= slave --let $rpl_server_number= 2 --source include/rpl_connect.inc # create the table on the "slave" --connection slave CREATE TABLE t1 (a int key, b int) ENGINE=ndb; #CREATE TABLE t2 (a int key, b int) ENGINE=ndb; sync_slave_with_master master; # now we should have a table on the master as well SHOW TABLES; # insert some values on the slave and master --connection master INSERT INTO t1 VALUES (1,2); --connection slave INSERT INTO t1 VALUES (2,3); # ensure data has propagated both ways --connection slave sync_slave_with_master master; --sync_slave_with_master # connect to slave and ensure data it there. --connection slave SELECT * FROM t1 ORDER BY a; #SELECT * FROM t2 ORDER BY a; source include/check_slave_is_running.inc; # connect to master and ensure data it there. --connection master SELECT * FROM t1 ORDER BY a; #SELECT * FROM t2 ORDER BY a; source include/check_slave_is_running.inc; # stop replication on "master" as not to replicate # shutdown circularly, eg drop table --connection master STOP SLAVE; # cleanup --connection master DROP TABLE t1; -- sync_slave_with_master --let $rpl_only_running_threads= 1 --source include/rpl_end.inc