环境准备:
系统版本:CentOS Linux release 7.9.2009 (Core)
硬件配置:4C4G200G
安装包准备:KingbaseES_V008R006C008B0020_Lin64_install.iso
https://www.kingbase.com.cn/xzzx/index.htm
license准备:license_企业版.zip
https://www.kingbase.com.cn/xzzx/index.htm
计划:
数据库版本:KingbaseES_V008R006C008M020B0025_Lin64_install(mysql定制版)
数据库用户名:system
数据库用户名密码:xxxxxxxxx
数据库端口:54321
数据库硬件要求
https://help.kingbase.com.cn/v8/install-updata/install-linux/index.html
部署
内核参数调整
(/etc/sysctl.conf):【/sbin/sysctl -p && /sbin/sysctl -a】
fs.aio-max-nr= 1048576
fs.file-max= 6815744
kernel.shmall= 2097152
kernel.shmmax= 4294967295
kernel.shmmni= 4096
kernel.sem= 250 32000 100 128
net.ipv4.ip_local_port_range= 9000 65500
net.core.rmem_default= 262144
net.core.rmem_max= 4194304
net.core.wmem_default= 262144
net.core.wmem_max= 1048576
系统资源调整
(/etc/security/limits.conf)
* soft nofile 65536
# 注意:设置nofile的hard limit不能大于/proc/sys/fs/nr_open,否则注销后将无法正常登陆
* hard nofile 65536
* soft nproc 65536
* hard nproc 65536
* soft core unlimited
* hard core unlimited
RemoveIPC参数调整
(/etc/systemd/logind.conf)
RemoveIPC=no
--
systemctl daemon-reload
systemctl restart systemd-logind.service
用户及数据目录配置
useradd -m kingbase
passwd kingbase
Yhkj2024.
安装目录
mkdir /app/Kingbase/ES/V8 -p
chmod o+rwx /app/Kingbase/ES/V8
数据目录
mkdir /app/Kingbase/ES/V8/data
挂载安装包
mkdir /home/kingbaseiso
mount KingbaseES_V008R006C008M020B0025_Lin64_install.iso /home/kingbaseiso/
安装KingbaseES(以命令行安装为例)
su - kingbase
echo $LANG
export LANG=zh_CN.UTF-8
cd /home/kingbaseiso
sh setup.sh -i console
注册成系统服务
关闭服务
su – kingbase
cd /app/kingbase/ES/V8/Server/bin
#关闭kingbase
./sys_ctl stop -m fast -w -D /app/kingbase/ES/V8/data
ps:不做成系统服务,启动的方式
su - kingbase
cd /app/kingbase/ES/V8/Server/bin
sys_ctl -w start -D ${Data文件目录} -l "${Data文件目录}/sys_log/startup.log"
启动服务
su
systemctl start kingbased
systemctl status kingbased
进入数据库验证
[kingbase@mail bin]$ pwd
/app/kingbase/ES/V8/Server/bin
[kingbase@mail bin]$ ./kingbase -V
KINGBASE (KingbaseES) V008R006C008M020B0025
[kingbase@mail bin]$ ./ksql -p 54321 -U system test
Password for user system:
Type "help" for help.
test=#
test=# select version();
version
--------------------------------------------------------------------------------------------------------------------------
KingbaseES V008R006C008M020B0025 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit
(1 row)
标签:bin,金仓,app,人大,kingbase,V8,KingbaseES,ES
From: https://www.cnblogs.com/haiyoyo/p/18472455