1 --source include/have_ndb.inc
2 --source include/have_binlog_format_mixed_or_row.inc
3 --source include/ndb_master-slave.inc
6 DROP TABLE IF EXISTS t1;
10 # Basic test of disk tables for NDB
14 # Start by creating a logfile group
17 CREATE LOGFILE GROUP lg1
18 ADD UNDOFILE 'undofile.dat'
23 alter logfile group lg1
24 add undofile 'undofile02.dat'
25 initial_size 4M engine=ndb;
28 # Create a tablespace connected to the logfile group
32 ADD DATAFILE 'datafile.dat'
38 add datafile 'datafile02.dat'
39 initial_size 4M engine=ndb;
42 # Create a table using this tablespace
46 (pk1 int not null primary key, b int not null, c int not null)
47 tablespace ts1 storage disk
54 insert into t1 values (1,2,3);
55 select * from t1 order by pk1;
58 # check that the data is also on the slave
61 --sync_slave_with_master
63 select * from t1 order by pk1;
70 -- source include/show_binlog_events2.inc
78 drop datafile 'datafile.dat'
81 drop datafile 'datafile02.dat'
83 DROP TABLESPACE ts1 ENGINE=NDB;
84 DROP LOGFILE GROUP lg1 ENGINE=NDB;
85 --source include/rpl_end.inc