关键字:
KingbaseES、sys_ctl、ksql
1、数据库启动前环境检测
1.1 查看kingbase用户环境变量配置
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.4 查看数据库配置文件信息
根据实际的业务场景,调整数据库的默认配置。
2、启动数据库服务
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