v1.10

Document

How to Start SequoiaDB

Basic Operation

Data Model

Database Management

Aggregation

Index

Replication

Cluster

Connector

Reference

Development

Release Note

FAQ

  • Content
  • Comments
  • History

Backup & Recovery Using File System Snapshot

The current version, data backup support offline backup, or data backups need to interrupt the insert, update, delete, etc. change operation, only support query operations. Current backup supports two modes: full backup and incremental backup.

  • Full backup: Backing up the entire database configuration, data and logs.
  • Incremental backup: In the last full backup or incremental backup on the basis of the new log and configuration.

Offline backup parameter description

Parameter Explanation
Name Backup name, the default name places the current time format, such as "2013-11-13-15:00:00".
Description Backup user description
Path The backup path is specified, the default for the configuration parameter "bkuppath" in the path specified.
EnsureInc Backup, true means that incremental backups, false that full backup, the default is false.
OverWrite For the same name as the backup to overwrite, true represeentation covering, false means not overwritten if the same name is an error, lack of true.
GroupName Backup of the specified group, the default for the whole system backup, when you need to back up multiple groups can be specified as an array type, such as: ["datagroup1","datagroup2"]

Backup the entire database

1. Connect to the coord node

$ /opt/sequoiadb/bin/sdb
> var db = new Sdb("localhost",11810);

2. Perform the bacup command

> db.backupOffline({Name:"backupName",Description:"backup for all"})

Database backup designated group

1. Connect to the coord node

$ /opt/sequoiadb/bin/sdb
> var db = new Sdb("localhost",11810);

2. Perform the backup command

> db.backupOffline({Name:"backupName",Description:"backup group1",GroupName:"datagroup1"})

Specified node database backup

1. Connected to the specified node

$ /opt/sequoiadb/bin/sdb
> var dbdata = new Sdb("hostname1","servicename1");

2. Perform the backup command

> dbdata.backupOffline({Name:"backupName",Description:"backup data node"}))
Note: catalog name of the group is fixed to SYSCatalogGroup.

List backup information manually through the client and see.

List backup information Parameter Description

Parameter Description
Name Backup name, and then list the default directory for all backup information.
Path Check the backup path is specified, the default for the configuration parameter "bkuppath" in the path specified.
GroupName Specifies a group of backup information, which defaults to list full system backup information, when you need to list multiple set of backup information can be specified as an array type, such as: ["datagroup1","datagroup2"]。

List full system backup information

1. Connect to the coord node

$ /opt/sequoiadb/bin/sdb
> var db = new Sdb("localhost",11810);

2. Do list backup information command

> db.listBackup()
{
  "Name": "test_bk",
  "NodeName": "vmsvr2-suse-x64-1:11800",
  "GroupName": "SYSCatalogGroup",
  "EnsureInc": false,
  "BeginLSNOffset": 0,
  "EndLSNOffset": 18744,
  "StartTime": "2013-11-13-16:06:31",
  "HasError": false
}
{
  "Name": "test_bk",
  "NodeName": "vmsvr2-suse-x64-1:11820",
  "GroupName": "db1",
  "EnsureInc": false,
  "BeginLSNOffset": 0,
  "EndLSNOffset": 920424,
  "StartTime": "2013-11-13-16:06:31",
  "HasError": false
}

List backup information specified name

1. Connect to the coord node

$ /opt/sequoiadb/bin/sdb
> var db = new Sdb("localhost",11810);

2. Do list backup information command

> db.listBackup({Name:"backup1"})
{
  "Name": "backup1",
  "NodeName": "vmsvr2-suse-x64-1:11820",
  "GroupName": "group1",
  "EnsureInc": false,
  "BeginLSNOffset": 0,
  "EndLSNOffset": 108744,
  "StartTime": "2013-11-13-16:06:31",
  "HasError": false
}

Hand-list backup information

Hand-list backup information directly through the terminal login specified machine and into the appropriate backup directory, run "ls -l"

use@vmsvr2-suse-x64-1:/opt/sequoiadb/database/11820/bakfile> ls -l
total 37328
-rw-r----- 1 sdbadmin sdbadmin  38157784 Nov 13 16:06 test_bk.1
-rw-r----- 1 sdbadmin sdbadmin     65536 Nov 13 16:06 test_bk.bak
please login to comment.
Latest Comment
  • 2015-02-14

About Us

SequoiaDB is a financial-level distributed database vendor and is the first Chinese database listed in Gartner’s Magic Quadrant OPDBMS report. SequoiaDB has recently released version 3.0.
SequoiaDB is now penetrating the vertical sector Financial Industry quickly and had more than 50 banking clients and hundreds of enterprise customers in industries including government, telecommunication, Internet and IoT.

Beijing:
Tower R, No.8 North Star East Road, Chaoyang District, Beijing,China
Guangzhou:
Tower A, No.22 Qinglan Street, Panyu District, Guangzhou,China
Shenzhen:
Tsing Hua Tech Park, Nanshan District, Shenzhen,China
Tel:400-8038-339
E-mail:contact@sequoiadb.com