金仓数据库KingbaseES的启动与访问

一、数据库启动前环境检测
1.1 查看kingbase用户环境变量配置

图1-1 查看.bashrc环境变量配置

1.2 应用环境变量
[kingbase@node1 ~]$ source .bashrc
[kingbase@node1 ~]$ which ksql
/opt/Kingbase/ES/V8R6_021/Server/bin/ksql
[kingbase@node1 ~]$ which sys_ctl
/opt/Kingbase/ES/V8R6_021/Server/bin/sys_ctl

1.3 查看数据库数据存储路径
在数据库软件包安装目录的Logs目录下查看相关的日志，可以获取到数据库数据存储路径，如下图1-2所示：

图1-2 查看数据库数据存储路径

1.4 查看数据库配置文件信息
根据实际的业务场景，调整数据库的默认配置。

图1-3 kingbase.conf 配置信息
二、启动数据库服务
2.1 查看启动工具(sys_ctl)帮助信息
[kingbase@node1 ~]$ sys_ctl --help
sys_ctl is a utility to initialize, start, stop, or control a Kingbase server.

Usage:
sys_ctl start [-D DATADIR] [-l FILENAME] [-W] [-t SECS] [-s]
[-o OPTIONS] [-p PATH] [-c]
sys_ctl stop [-D DATADIR] [-m SHUTDOWN-MODE] [-W] [-t SECS] [-s]
sys_ctl restart [-D DATADIR] [-m SHUTDOWN-MODE] [-W] [-t SECS] [-s]
[-o OPTIONS] [-c]
sys_ctl reload [-D DATADIR] [-s]
sys_ctl status [-D DATADIR]
sys_ctl promote [-D DATADIR] [-W] [-t SECS] [-s]
sys_ctl logrotate [-D DATADIR] [-s]
sys_ctl kill SIGNALNAME PID

Common options:
-D, --kingbase-data=DATADIR location of the database storage area
-s, --silent only print errors, no informational messages
-t, --timeout=SECS seconds to wait when using -w option
-V, --version output version information, then exit
-w, --wait wait until operation completes (default)
-W, --no-wait do not wait until operation completes
-?, --help show this help, then exit
If the -D option is omitted, the environment variable KINGBASE_DATA is used.

Options for start or restart:
-c, --core-files allow kingbase to produce core files
-l, --log=FILENAME write (or append) serve