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

Database Configuration

Parameter Instruction

Parameter Name Acronym Type Description
--help -h -- Print help information
--dbpath -d str 1. It specifies the path of data file. 2. If it is not specified, the default path is current path.
--indexpath -i str 1. It specifies the path of index file 2. If it is not specified, the default path is the same with 'dbpath'.
--confpath -c str 1. Specified configuration file path (doesn't contain fiel name). The system will find under confpath. 2. contains necessary configuration items. The format of a configuration item is "parameter name=value" like "svcname=11810" and "diaglevel=3". 3. If this parameter is not specified, system will automatically search for sdb.conf in current path. 4. There may not be sdb.conf.
--logpath -l str 1. Synchronous log files will be created when replication node does full sync. This parameter is used to specified the path of synchronous log file. 2. If it is not specified, the default path is "Data file path/replicalog".
--diagpath -- str 1. It specifies the catalog of diagnostic log. 2. If it is not specified, the default path is "Data file path/diaglog".
--diagnum -- num 1. It specifies the number of diagnostic log file. 2. If it is not specified, the default 20; -1 means unlimited.
--bkuppath -- str 1. It specifies the catalog of backup file. 2. If it is not specified, the default path is "Data file path/bakfile".
--maxpool -- str 1. It specifies the amount of thread in thread pool. 2. If it is not specified, the default value is 0.
--svcname -p str 1. It specifies local service port. 2. If it is not specified, the default value are 11810 for coord, 11800 for catalog, 11820 for datanode.
--replname -r str 1. It specifies data synch port. 2. If it is not specified, the default value is "svcname+1".
--shardname -a str 1. It specifies shard port. 2. If it is not specified, the default value is "svcname+2".
--catalogname -x str 1. It specifies catalog port. 2. If it is not specified, the default value is "svcname+3".
--httpname -s str 1. It specifies http port. 2. If it is not specified, the default value is "svcname+4".
--diaglevel -v num 1. It specifies the print level of diagnostic log. Diagnostic log in sequoiaDB, 0-5 respectively represent: SEVERE, ERROR, EVENT,WARNING, INFO, DEBUG. 2. If it is not specified, the default value is "WARNING".
--role -o str 1. It specifies serving role. In sequoiaDB, "data/coord/catalog/standalone" represents "data node/coord node/catalog node/stand-alone machine". 2. If it is not specified, the default value is "standalone".
--catalogaddr -t str 1. It specifies the address of catalog node. The format is "hostname1:catalogname1,hostname2:catalogname2,...". 2. It should specify address of at least one catalog.
--logfilesz -f num 1. It specifies the size of sync log file. It is between 64(MB) and 2048(MB). 2. If it is not specified, the default value is 64 (MB).
--logfilenum -n num 1. It specifies the amount of synchronous log file. 2. If it is not specified, the default value is 20.
--transactionon -e boolean 1. It specifies whether transaction turns on or not. 2. If it is not specifed, the default value is false.
--numpreload -- num The number of pre-loaders, default:0, value range:[0,100]
--maxprefpool -- num The maximum number of prefetchers, default:0, value range:[0,1000]
--maxreplsync -- num The maximum number of repl-sync threads, default:10, value range:[0, 200], 0:disable concurrent repl-sync
--logbuffsize -- num The number of pages ( in 64KB ) for replica log memory ( default:1024, value range:[512,1024000] ), the size should be smaller than log space
--tmppath -- num The path of temp files, default is 'dbpath'+'/tmp'
--sortbuf -- num Size of the sorting buf(MB), default:256, min value:128
--hjbuf -- num Size of the hash join buf(MB), default:128, min value:64
--syncstrategy -- str The control strategy of data sync in repl group, value enumeration: none,keepnormal,keepall, default:keepnormal.
--preferedinstance -- str 1. It specifies the instance on which to query. 2. If it is not specifed, the default value is A. 3. value enum: M--read and write instance, S--read only instance, A--any instance, 1-7--the nth instance
--numpagecleaners -- num The number of page cleaner threads to start during database startup. 0 means do not start any page cleaners, default 0, value range:[0, 50].
--pagecleaninterval -- num The minimum interval between two cleanup actions for each CS Unit: ms, Default: 10000, Min: 1000
--lobpath -- str 1. It specifies the catalog of lob. 2. If it is not specified, the default path is "Data file path".
--directioinlob -- boolean If it is not spcified, the default value is "false"
--sparsefile -- boolean If it is not spcified, the default value is "false"
Note:

SequoiaDB supports setting configuration with command line,configuration file, or both of them. When both of them are used, parameters in command line will overwrite those in configuration file.

The total size of synch log (logfilesz * logfilenum)determines the fault tolerance in the process of sync. If log is bigger, the possiblity of full sync is lower.

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