--source include/have_multi_ndb.inc # # Setup # # # Create metadata # CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'lg1_undofile.dat' INITIAL_SIZE 16M UNDO_BUFFER_SIZE 1M ENGINE NDB; CREATE TABLESPACE ts1 ADD DATAFILE 'ts1_datafile.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 16M ENGINE NDB; CREATE TABLESPACE ts2 ADD DATAFILE 'ts2_datafile.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 16M ENGINE NDB; CREATE TABLE t1 ( a INT PRIMARY KEY, b INT ) ENGINE NDB; INSERT INTO t1 VALUES (1, 2); CREATE TABLE t2 ( a INT PRIMARY KEY, b INT ) ENGINE NDB TABLESPACE ts1 STORAGE DISK; INSERT INTO t2 VALUES (1, 1); # # Restart node 1 # --exec $NDB_MGM -e "1 RESTART -n" --exec $NDB_WAITER --nowait-nodes=2 --not-started --exec $NDB_MGM -e "1 START" --exec $NDB_WAITER # Check that the metadata is still present SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME FROM INFORMATION_SCHEMA.FILES WHERE ENGINE = "NDBCLUSTER"; SHOW TABLES; INSERT INTO t1 VALUES (2, 3); --sorted_result SELECT * FROM t1; INSERT INTO t2 VALUES (2, 3); --sorted_result SELECT * FROM t2; # # Restart node 1 --initial # --exec $NDB_MGM -e "1 RESTART -n -I" --exec $NDB_WAITER --nowait-nodes=2 --not-started --exec $NDB_MGM -e "1 START" --exec $NDB_WAITER # Check that the metadata is still present SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME FROM INFORMATION_SCHEMA.FILES WHERE ENGINE = "NDBCLUSTER"; SHOW TABLES; INSERT INTO t1 VALUES (3, 4); --sorted_result SELECT * FROM t1; INSERT INTO t2 VALUES (5, 8); --sorted_result SELECT * FROM t2; # # Restart all # --exec $NDB_MGM -e "ALL RESTART -N" --exec $NDB_WAITER --not-started --exec $NDB_MGM -e "ALL START" --exec $NDB_WAITER # Wait for mysqld to reconnect --source include/ndb_not_readonly.inc --echo # verify that the mysqld detected the restart --let $assert_text= Detect normal restart in MySQL Server 1 --let $assert_select= Detected a normal system restart --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.1.err --let $assert_only_after= NDB Binlog: Detected server start --let $assert_match= .*Detected a normal system restart.* --source include/assert_grep.inc --connection server2 # Wait for mysqld to reconnect --source include/ndb_not_readonly.inc --let $assert_text= Detect normal restart in MySQL Server 2 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.2.1.err --source include/assert_grep.inc --connection server1 # Check that the metadata is still present SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME FROM INFORMATION_SCHEMA.FILES WHERE ENGINE = "NDBCLUSTER"; SHOW TABLES; INSERT INTO t1 VALUES (4, 5); --sorted_result SELECT * FROM t1; INSERT INTO t2 VALUES (13, 21); SELECT * FROM t2 ORDER BY a; # # Restart all initial # --exec $NDB_MGM -e "ALL RESTART -N -I" --exec $NDB_WAITER --not-started --exec $NDB_MGM -e "ALL START" --exec $NDB_WAITER # Wait for mysqld to reconnect --source include/ndb_not_readonly.inc --echo # verify that the mysqld detected the initial restart --let $assert_text= Detect initial restart in MySQL Server 1 --let $assert_select= Detected an initial system restart --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.1.err --let $assert_only_after= NDB Binlog: Detected server start --let $assert_match= .*Detected an initial system restart.* --source include/assert_grep.inc --connection server2 # Wait for mysqld to reconnect --source include/ndb_not_readonly.inc --let $assert_text= Detect initial restart in MySQL Server 2 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.2.1.err --source include/assert_grep.inc --connection server1 # Check that the metadata has been deleted SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME FROM INFORMATION_SCHEMA.FILES WHERE ENGINE = "NDBCLUSTER"; SHOW TABLES;