100 lines
3.6 KiB
Plaintext
100 lines
3.6 KiB
Plaintext
create table all_data (id int primary key, val int) engine=ndb;
|
|
create table part_data (id int primary key, val int) engine=ndb;
|
|
create table all_logs (txt varchar(512)) engine=ndb;
|
|
create table part_logs (txt varchar(512)) engine=ndb;
|
|
create table txt (a varchar(512)) engine=ndb;
|
|
insert into part_data values (1,1), (2,2), (3,3), (4,4), (5,5), (6,6), (7,7), (8,8);
|
|
|
|
Starting backup
|
|
Backup started
|
|
update part_data set val = 0;
|
|
|
|
Waiting for backup to complete
|
|
Backup completed
|
|
delete from part_data;
|
|
Restore data of part 4 on node 2
|
|
Check that part data does not overlap with already restored data
|
|
select count(*) from part_data join all_data where part_data.id = all_data.id;
|
|
count(*)
|
|
0
|
|
Capture backup logs of part 4 on node 2
|
|
Check that part logs do not overlap with logs from other parts
|
|
select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
|
|
count(*)
|
|
0
|
|
Restore data of part 3 on node 2
|
|
Check that part data does not overlap with already restored data
|
|
select count(*) from part_data join all_data where part_data.id = all_data.id;
|
|
count(*)
|
|
0
|
|
Capture backup logs of part 3 on node 2
|
|
Check that part logs do not overlap with logs from other parts
|
|
select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
|
|
count(*)
|
|
0
|
|
Restore data of part 2 on node 2
|
|
Check that part data does not overlap with already restored data
|
|
select count(*) from part_data join all_data where part_data.id = all_data.id;
|
|
count(*)
|
|
0
|
|
Capture backup logs of part 2 on node 2
|
|
Check that part logs do not overlap with logs from other parts
|
|
select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
|
|
count(*)
|
|
0
|
|
Restore data of part 1 on node 2
|
|
Check that part data does not overlap with already restored data
|
|
select count(*) from part_data join all_data where part_data.id = all_data.id;
|
|
count(*)
|
|
0
|
|
Capture backup logs of part 1 on node 2
|
|
Check that part logs do not overlap with logs from other parts
|
|
select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
|
|
count(*)
|
|
0
|
|
Restore data of part 4 on node 1
|
|
Check that part data does not overlap with already restored data
|
|
select count(*) from part_data join all_data where part_data.id = all_data.id;
|
|
count(*)
|
|
0
|
|
Capture backup logs of part 4 on node 1
|
|
Check that part logs do not overlap with logs from other parts
|
|
select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
|
|
count(*)
|
|
0
|
|
Restore data of part 3 on node 1
|
|
Check that part data does not overlap with already restored data
|
|
select count(*) from part_data join all_data where part_data.id = all_data.id;
|
|
count(*)
|
|
0
|
|
Capture backup logs of part 3 on node 1
|
|
Check that part logs do not overlap with logs from other parts
|
|
select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
|
|
count(*)
|
|
0
|
|
Restore data of part 2 on node 1
|
|
Check that part data does not overlap with already restored data
|
|
select count(*) from part_data join all_data where part_data.id = all_data.id;
|
|
count(*)
|
|
0
|
|
Capture backup logs of part 2 on node 1
|
|
Check that part logs do not overlap with logs from other parts
|
|
select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
|
|
count(*)
|
|
0
|
|
Restore data of part 1 on node 1
|
|
Check that part data does not overlap with already restored data
|
|
select count(*) from part_data join all_data where part_data.id = all_data.id;
|
|
count(*)
|
|
0
|
|
Capture backup logs of part 1 on node 1
|
|
Check that part logs do not overlap with logs from other parts
|
|
select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
|
|
count(*)
|
|
0
|
|
drop table txt;
|
|
drop table part_data;
|
|
drop table part_logs;
|
|
drop table all_data;
|
|
drop table all_logs;
|