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 Cluster

Use a replica group data recovery backup. Perform data recovery must ensure that the corresponding group has stopped tunning, data recovery will first clear the original node and log all the data and then restore the data from the backup configuration data and logs.

Data recovery tool Parameter Description

Parameter Description
-p [--bkpath] Backup source where the data path.
-i [--increaseid] Requires several incremental backups to restore to default back to the last time.
-n [--bkname] Need to restore the backup name.
-a [--action] Recovery behavior, "restore" indicates that the recobery, "list" indicates view backup information, defaults to "restore".
--isSelf Whether to restore the node data, the default is "true", when the value is "false", according to the following parameters to restore the data to the specified path:
--dbpath Must configure the data file directory.
--confpath Must configure the configuration file path.
--svcname Must configure the local service name or port.
--indexpath Indes file directory.
--logpath Log file directory.
--diagpath Diagnostic log file directory.
--bkuppath Backup file directory.
--replname Copy communications service name or port.
--shardname Slice communications service name or port.
--catalogname Catalog communicatios service name or port.
--httpname REST service name or port.

Recover Data

Note: If a replica group that contains multiple data nodes, you must stop the group and recover each data node. If the data is restored to a non-backup data nodes must use --isSelf false configuration parameters, and set the relevant configuration parameters.
  1. Connect to the coord node
    $ /opt/sequoiadb/bin/sdb
    > var db = new Sdb("localhost", 11810) ;
  2. > datarg = db.getRG ( "data" ) ;
  3. > datarg.stop()
  4. Login via terminal nodes corresponding data replica group, perform data recovery.
    sdbadmin@vmsvr2-suse-x64-1:/opt/sequoiadb> bin/sdbrestore -p  database/11820/bakfile -n test_bk
    Begin to clean dps logs...
    Begin to clean dms storages...
    Begin to init dps logs...
    Begin to restore...
    Begin to restore data file: 11820/bakfile/test_bk.1 ...
    Begin to restore su: test.1.data ...
    Begin to restore su: test.1.idx ...
    Begin to restore dps logs...
    *****************************************************
    Restore succeed!
    *****************************************************
  5. Check the file to a data node directory is restored.
    sdbadmin @vmsvr2-suse-x64-1:/ opt/sequoiadb /database/11820> ls -l
    total 299156
    drwxr-xr-x 2 sdbadmin sdbadmin      4096 Nov 13 16:06 bakfile
    drwxr-xr-x 2 sdbadmin sdbadmin      4096 Nov 13 15:48 diaglog
    drwxr-xr-x 2 sdbadmin sdbadmin      4096 Nov 13 17:39 replicalog
    -rw-r----- 1 sdbadmin sdbadmin 155254784 Nov 13 17:39 test.1.data
    -rw-r----- 1 sdbadmin sdbadmin 151060480 Nov 13 17:39 test.1.idx
  6. Delete the replica groups other data, all data nodes (or all the nodes. Data and. Idx files are copied to the other data node's data directory and index directory, and copy all the logs that node replicalog to other data nodes log directory, or copy the backup file to another data node, and through the restored tool recovers), restart the system.
please login to comment.
Latest Comment
  • 2015-02-15

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