1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
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
91
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
122
123
124
125
126
127
128
129
130
131
132
133
134
|
######################################################################
# Test restoring backups with blob columns
######################################################################
-- source include/have_ndb.inc
-- source include/ndb_default_cluster.inc
--disable_warnings
use test;
drop table if exists t1,t2;
--enable_warnings
# length 61
set @s0 = 'rggurloniukyehuxdbfkkyzlceixzrehqhvxvxbpwizzvjzpucqmzrhzxzfau';
set @s1 = 'ykyymbzqgqlcjhlhmyqelfoaaohvtbekvifukdtnvcrrjveevfakxarxexomz';
set @s2 = 'dbnfqyzgtqxalcrwtfsqabknvtfcbpoonxsjiqvmhnfikxxhcgoexlkoezvah';
set @v1 = repeat(@s0, 100); # 1d42dd9090cf78314a06665d4ea938c35cc760f4
set @v2 = repeat(@s1, 200); # 10d3c783026b310218d10b7188da96a2401648c6
set @v3 = repeat(@s2, 300); # a33549d9844092289a58ac348dd59f09fc28406a
set @v4 = repeat(@s0, 400); # daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
set @v5 = repeat(@s1, 500); # 70fc9a7d08beebc522258bfb02000a30c77a8f1d
set @v6 = repeat(@s2, 600); # 090565c580809efed3d369481a4bbb168b20713e
create table t1 (
a int auto_increment,
b text,
primary key (a)
)
engine ndbcluster;
insert into t1(b) values(@v1);
insert into t1(b) values(@v2);
insert into t1(b) values(@v3);
create table t2 (
a text,
b varchar(8),
c mediumblob,
d int,
e tinyblob,
f varchar(2),
primary key (b, d, f)
)
engine ndbcluster;
insert into t2 values(@v1, 'a', @v2, 1, 'xx1', 'u');
insert into t2 values(@v3, 'a', @v4, 1, 'yy1', 'v');
insert into t2 values(@v5, 'a', @v6, 2, 'zz1', 'v');
insert into t2 values(@v1, 'abc', @v2, 1, 'xx2', 'u');
insert into t2 values(@v3, 'abc', @v4, 1, 'yy2', 'v');
insert into t2 values(@v5, 'abc', @v6, 2, 'zz2', 'v');
insert into t2 values(@v1, 'abcdefgh', @v2, 1, 'xx3', 'u');
insert into t2 values(@v3, 'abcdefgh', @v4, 1, 'yy3', 'v');
insert into t2 values(@v5, 'abcdefgh', @v6, 2, 'zz3', 'v');
# grmbl
# select TABLE_NAME,ENGINE from INFORMATION_SCHEMA.TABLES
# where TABLE_SCHEMA = 'test' and TABLE_NAME in ('t1','t2');
select a, sha1(b) from t1 order by a;
select sha1(a), sha1(c), e from t2 order by b, d, f;
--source include/ndb_backup.inc
drop table t1, t2;
--exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -m -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
--exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
select a, sha1(b) from t1 order by a;
select sha1(a), sha1(c), e from t2 order by b, d, f;
drop table t1,t2;
# same on disk
create logfile group lg1 add undofile 'undofile.dat'
initial_size 16M undo_buffer_size 1M engine=ndb;
create tablespace ts1 add datafile 'datafile.dat'
use logfile group lg1 initial_size 32M engine=ndb;
create table t1 (
a int,
b text,
primary key (a)
)
tablespace ts1 storage disk
engine ndbcluster;
insert into t1 values(1, @v1);
insert into t1 values(2, @v2);
insert into t1 values(3, @v3);
create table t2 (
a text,
b varchar(8),
c mediumblob,
d int,
e tinyblob,
f varchar(2),
primary key (b, d, f)
)
tablespace ts1 storage disk
engine ndbcluster;
insert into t2 values(@v1, 'a', @v2, 1, 'xx1', 'u');
insert into t2 values(@v3, 'a', @v4, 1, 'yy1', 'v');
insert into t2 values(@v5, 'a', @v6, 2, 'zz1', 'v');
insert into t2 values(@v1, 'abc', @v2, 1, 'xx2', 'u');
insert into t2 values(@v3, 'abc', @v4, 1, 'yy2', 'v');
insert into t2 values(@v5, 'abc', @v6, 2, 'zz2', 'v');
insert into t2 values(@v1, 'abcdefgh', @v2, 1, 'xx3', 'u');
insert into t2 values(@v3, 'abcdefgh', @v4, 1, 'yy3', 'v');
insert into t2 values(@v5, 'abcdefgh', @v6, 2, 'zz3', 'v');
# grmbl
# select TABLE_NAME,ENGINE from INFORMATION_SCHEMA.TABLES
# where TABLE_SCHEMA = 'test' and TABLE_NAME in ('t1','t2');
select a, sha1(b) from t1 order by a;
select sha1(a), sha1(c), e from t2 order by b, d, f;
--source include/ndb_backup.inc
drop table t1, t2;
--exec $NDB_RESTORE --no-defaults -d -b $the_backup_id -n 1 -m -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
--exec $NDB_RESTORE --no-defaults -d -b $the_backup_id -n 2 -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
select a, sha1(b) from t1 order by a;
select sha1(a), sha1(c), e from t2 order by b, d, f;
drop table t1,t2;
alter tablespace ts1 drop datafile 'datafile.dat' engine=ndb;
drop tablespace ts1 engine=ndb;
drop logfile group lg1 engine=ndb;
|
