RocksDB: Restore

Restoring RocksDB is fairly straightforward with RocksDB "restore" command. 




Prior to restoring the RocksDB database. The database contents look like the following.

ls -las

total 5336

4 drwxr-xr-x 2 ubuntu ubuntu 4096 Apr 18 12:13 .

4 drwxrwxr-x 11 ubuntu ubuntu 4096 Apr 18 11:10 ..

52 -rw-r--r-- 1 ubuntu ubuntu 50223 Apr 18 12:13 000004.sst

0 -rw-r--r-- 1 ubuntu ubuntu 0 Apr 18 12:13 000006.log

4 -rw-r--r-- 1 ubuntu ubuntu 16 Apr 18 12:13 CURRENT

4 -rw-r--r-- 1 ubuntu ubuntu 37 Apr 18 11:10 IDENTITY

0 -rw-r--r-- 1 ubuntu ubuntu 0 Apr 18 11:10 LOCK

128 -rw-rw-r-- 1 ubuntu ubuntu 16399 Apr 18 12:13 LOG

128 -rw-rw-r-- 1 ubuntu ubuntu 13780 Apr 18 11:10 LOG.old.1524075040138844

128 -rw-rw-r-- 1 ubuntu ubuntu 15445 Apr 18 11:10 LOG.old.1524075040143328

128 -rw-rw-r-- 1 ubuntu ubuntu 15546 Apr 18 11:10 LOG.old.1524075079672369

128 -rw-rw-r-- 1 ubuntu ubuntu 15084 Apr 18 11:11 LOG.old.1524075079683013

128 -rw-rw-r-- 1 ubuntu ubuntu 15546 Apr 18 11:11 LOG.old.1524075087547290

128 -rw-rw-r-- 1 ubuntu ubuntu 15088 Apr 18 11:11 LOG.old.1524075087552152

128 -rw-rw-r-- 1 ubuntu ubuntu 15550 Apr 18 11:11 LOG.old.1524075100714403

128 -rw-rw-r-- 1 ubuntu ubuntu 15088 Apr 18 11:11 LOG.old.1524075100725789

128 -rw-rw-r-- 1 ubuntu ubuntu 15550 Apr 18 11:11 LOG.old.1524075125402198

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 11:12 LOG.old.1524075125404941

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 11:12 LOG.old.1524075171558512

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 11:12 LOG.old.1524075171561161

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 11:12 LOG.old.1524075190238360

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 11:13 LOG.old.1524075190239973

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 11:13 LOG.old.1524075194845338

128 -rw-rw-r-- 1 ubuntu ubuntu 15085 Apr 18 11:13 LOG.old.1524075194846823

128 -rw-rw-r-- 1 ubuntu ubuntu 15547 Apr 18 11:13 LOG.old.1524075325892307

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 11:15 LOG.old.1524075325895101

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 11:15 LOG.old.1524075329179111

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 11:15 LOG.old.1524075329183192

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 11:15 LOG.old.1524075535469131

128 -rw-rw-r-- 1 ubuntu ubuntu 7608 Apr 18 11:18 LOG.old.1524075598421473

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 11:19 LOG.old.1524075598423727

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 11:19 LOG.old.1524075604652854

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 11:20 LOG.old.1524075604655675

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 11:20 LOG.old.1524075695916467

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 11:21 LOG.old.1524075695918368

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 11:21 LOG.old.1524078475647987

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 12:07 LOG.old.1524078475649972

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 12:07 LOG.old.1524078501784982

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 12:08 LOG.old.1524078501787022

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 12:08 LOG.old.1524078508998757

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 12:08 LOG.old.1524078509000417

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 12:08 LOG.old.1524078548279053

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 12:09 LOG.old.1524078548285225

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 12:09 LOG.old.1524078571907249

128 -rw-rw-r-- 1 ubuntu ubuntu 15089 Apr 18 12:09 LOG.old.1524078571908932

128 -rw-rw-r-- 1 ubuntu ubuntu 15551 Apr 18 12:09 LOG.old.1524078654343110

128 -rw-rw-r-- 1 ubuntu ubuntu 7608 Apr 18 12:10 LOG.old.1524078728489411

128 -rw-rw-r-- 1 ubuntu ubuntu 7608 Apr 18 12:12 LOG.old.1524078818755099

4 -rw-r--r-- 1 ubuntu ubuntu 132 Apr 18 12:13 MANIFEST-000005

8 -rw-r--r-- 1 ubuntu ubuntu 4238 Apr 18 11:10 OPTIONS-000005

8 -rw-r--r-- 1 ubuntu ubuntu 4661 Apr 18 12:13 OPTIONS-000008

Restore database

./ldb --db=/home/ubuntu/dbtest1 restore backup_dir=/home/ubuntu/backup_directory/x.bk

open restore engine OK

restore from backup OK

After database restore

ls -las dbtest1
total 76
4 drwxr-xr-x 2 ubuntu ubuntu 4096 Apr 18 12:37 .
4 drwxrwxr-x 11 ubuntu ubuntu 4096 Apr 18 11:10 ..
52 -rw-r--r-- 1 ubuntu ubuntu 50223 Apr 18 12:37 000004.sst
4 -rw-r--r-- 1 ubuntu ubuntu 16 Apr 18 12:37 CURRENT
4 -rw-r--r-- 1 ubuntu ubuntu 132 Apr 18 12:37 MANIFEST-000005
8 -rw-r--r-- 1 ubuntu ubuntu 4661 Apr 18 12:37 OPTIONS-000008

Summary, make sure the application is able to pick up from where it left off. The transactions will be omitted and all bundled into 3 different directories. That's all, pretty straightforward.