ndb_binlog_ddl_multi.result 4.14 KB
Newer Older
1 2 3
drop database if exists mysqltest;
drop table if exists t1,t2;
drop database if exists mysqltest;
unknown's avatar
unknown committed
4
drop table if exists t1,t2;
5 6 7 8 9 10
reset master;
reset master;
create database mysqltest;
use mysqltest;
create table t1 (a int primary key) engine=ndb;
create table t2 (a int primary key) engine=ndb;
11
show binlog events from <binlog_start>;
12 13 14 15
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin1.000001	#	Query	#	#	create database mysqltest
master-bin1.000001	#	Query	#	#	use `mysqltest`; create table t1 (a int primary key) engine=ndb
master-bin1.000001	#	Query	#	#	use `test`; create table t2 (a int primary key) engine=ndb
16
show binlog events from <binlog_start>;
17 18 19 20 21 22 23
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	create database mysqltest
master-bin.000001	#	Query	#	#	use `mysqltest`; create table t1 (a int primary key) engine=ndb
master-bin.000001	#	Query	#	#	use `test`; create table t2 (a int primary key) engine=ndb
reset master;
reset master;
alter table t2 add column (b int);
24
show binlog events from <binlog_start>;
25 26
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin1.000001	#	Query	#	#	BEGIN
27
master-bin1.000001	#	Table_map	#	#	cluster.apply_status
28 29
master-bin1.000001	#	Write_rows	#	#	
master-bin1.000001	#	Query	#	#	COMMIT
30
master-bin1.000001	#	Query	#	#	use `test`; alter table t2 add column (b int)
31 32 33
reset master;
reset master;
ALTER DATABASE mysqltest CHARACTER SET latin1;
34
drop table mysqltest.t1;
35
show binlog events from <binlog_start>;
36 37 38
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	ALTER DATABASE mysqltest CHARACTER SET latin1
master-bin.000001	#	Query	#	#	BEGIN
39
master-bin.000001	#	Table_map	#	#	cluster.apply_status
40 41 42 43 44
master-bin.000001	#	Write_rows	#	#	
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	use `mysqltest`; drop table `t1`
reset master;
reset master;
45
use test;
46 47 48
insert into t2 values (1,2);
drop database mysqltest;
create table t1 (a int primary key) engine=ndb;
49
show binlog events from <binlog_start>;
50 51
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin1.000001	#	Query	#	#	BEGIN
52
master-bin1.000001	#	Table_map	#	#	cluster.apply_status
53
master-bin1.000001	#	Write_rows	#	#	
54
master-bin1.000001	#	Table_map	#	#	test.t2
55 56 57 58
master-bin1.000001	#	Write_rows	#	#	
master-bin1.000001	#	Query	#	#	COMMIT
master-bin1.000001	#	Query	#	#	drop database mysqltest
master-bin1.000001	#	Query	#	#	use `test`; create table t1 (a int primary key) engine=ndb
59
drop table t2;
60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
reset master;
reset master;
CREATE LOGFILE GROUP lg1
ADD UNDOFILE 'undofile.dat'
INITIAL_SIZE 16M
UNDO_BUFFER_SIZE = 1M
ENGINE=NDB;
ALTER LOGFILE GROUP lg1
ADD UNDOFILE 'undofile02.dat'
INITIAL_SIZE = 4M 
ENGINE=NDB;
CREATE TABLESPACE ts1
ADD DATAFILE 'datafile.dat'
USE LOGFILE GROUP lg1
INITIAL_SIZE 12M
ENGINE NDB;
ALTER TABLESPACE ts1
ADD DATAFILE 'datafile02.dat'
INITIAL_SIZE = 4M 
ENGINE=NDB;
ALTER TABLESPACE ts1 
DROP DATAFILE 'datafile.dat' 
ENGINE = NDB;
ALTER TABLESPACE ts1 
DROP DATAFILE 'datafile02.dat' 
ENGINE = NDB;
DROP TABLESPACE ts1 
ENGINE = NDB;
DROP LOGFILE GROUP lg1 
ENGINE =NDB;
drop table t1;
91
show binlog events from <binlog_start>;
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin1.000001	#	Query	#	#	CREATE LOGFILE GROUP lg1
ADD UNDOFILE 'undofile.dat'
INITIAL_SIZE 16M
UNDO_BUFFER_SIZE = 1M
ENGINE=NDB
master-bin1.000001	#	Query	#	#	ALTER LOGFILE GROUP lg1
ADD UNDOFILE 'undofile02.dat'
INITIAL_SIZE = 4M 
ENGINE=NDB
master-bin1.000001	#	Query	#	#	CREATE TABLESPACE ts1
ADD DATAFILE 'datafile.dat'
USE LOGFILE GROUP lg1
INITIAL_SIZE 12M
ENGINE NDB
master-bin1.000001	#	Query	#	#	ALTER TABLESPACE ts1
ADD DATAFILE 'datafile02.dat'
INITIAL_SIZE = 4M 
ENGINE=NDB
master-bin1.000001	#	Query	#	#	ALTER TABLESPACE ts1 
DROP DATAFILE 'datafile.dat' 
ENGINE = NDB
master-bin1.000001	#	Query	#	#	ALTER TABLESPACE ts1 
DROP DATAFILE 'datafile02.dat' 
ENGINE = NDB
master-bin1.000001	#	Query	#	#	DROP TABLESPACE ts1 
ENGINE = NDB
master-bin1.000001	#	Query	#	#	DROP LOGFILE GROUP lg1 
ENGINE =NDB
master-bin1.000001	#	Query	#	#	BEGIN
122
master-bin1.000001	#	Table_map	#	#	cluster.apply_status
123 124 125
master-bin1.000001	#	Write_rows	#	#	
master-bin1.000001	#	Query	#	#	COMMIT
master-bin1.000001	#	Query	#	#	use `test`; drop table `t1`