【kingbase】kingbase安装

1.创建用户属组
[root@node01 ~]# groupadd kingbase
[root@node01 ~]# useradd -g kingbase kingbase

2.创建目录、授权
[root@node01 ~]# mkdir -p /KingbaseES/V8
[root@node01 ~]# mkdir -p /data
[root@node01 ~]# mkdir -p /backup
[root@node01 ~]# mkdir -p /archive
[root@node01 ~]# mkdir -p /install


[root@node01 ~]# chown -R kingbase.kingbase /KingbaseES
[root@node01 ~]# chown -R kingbase.kingbase /backup
[root@node01 ~]# chown -R kingbase.kingbase /archive
[root@node01 ~]# chown -R kingbase.kingbase /data
[root@node01 ~]# chown -R kingbase.kingbase /install


[root@node01 ~]# chmod 755 /KingbaseES
[root@node01 ~]# chmod 755 /backup
[root@node01 ~]# chmod 755 /archive
[root@node01 ~]# chmod 755 /install
[root@node01 ~]# chmod 755 /data


3.上传安装包
[root@node01 install]# cd /install/
[root@node01 install]# ls -lrt
total 852328
-rw-r--r--. 1 root root 872781824 Dec 2 10:03 KingbaseES_V008R006C005B0023_Lin64_single_install.iso
[root@node01 install]# md5sum KingbaseES_V008R006C005B0023_Lin64_single_install.iso
0a135a2451529ef62fd1be828fea56d4 KingbaseES_V008R006C005B0023_Lin64_single_install.iso
[root@node01 install]# mount -o loop KingbaseES_V008R006C005B0023_Lin64_single_install.iso /mnt
mount: /dev/loop0 is write-protected, mounting read-only
[root@node01 install]# ls -lrt /mnt
total 6
dr-xr-xr-x. 2 root root 2048 Nov 5 2021 setup
-r-xr-xr-x. 1 root root 3820 Nov 5 2021 setup.sh
[root@node01 install]#


[kingbase@node01 ~]$ cp -r /mnt/* /install/KES-V8-INSTALL/
[kingbase@node01 ~]$ du -sm /mnt
833 /mnt
[kingbase@node01 ~]$ du -sm /install/KES-V8-INSTALL/
833 /install/KES-V8-INSTALL/
[kingbase@node01 ~]$


4.上传授权文件
[root@node01 ~]# chown -R kingbase.kingbase /install/license_*
[root@node01 ~]# ll /install/license_12350_0.dat
-rw-r--r--. 1 kingbase kingbase 3351 Dec 2 10:27 /install/license_12350_0.dat
[root@node01 ~]#

5.安装KES程序
5.1.指定授权文件
===============================================================================
Choose License File
-------------------


File Path: /install/license_12350_0.dat

License序列号 --- 启用 --- 74FE7946-4378-11EC-AE8E-000C29CBE49F
生产日期 --- 启用 --- 2021-11-12
产品名称 --- 启用 --- KingbaseES V8
细分版本模板名 --- 启用 --- SALES-开发版 V8R6
产品版本号 --- 启用 --- V008R006C
浮动基准日期 ------ 启用
有效期间 --- 启用 --- 0
用户名称 --- 启用 --- 官方网站试用授权
项目名称 --- 启用 --- 官方网站试用授权
CPU检查 --- 启用 --- 0
容器名称 --- 禁用 --- 0
MAC地址 --- 启用 --- 00:00:00:00:00:00
最大连接数 --- 启用 --- 10
分区 --- 启用 --- 0
物理同步 --- 启用 --- 0
读写分离模块 --- 启用 --- 0
恢复到指定时间点 --- 启用 --- 0
集群对网络故障的容错 --- 启用 --- 0
快速加载 --- 启用 --- 0
日志压缩 --- 启用 --- 0
全文检索 --- 启用 --- 0
性能优化包(性能诊断) --- 启用 --- 0
性能优化包(性能调优) --- 启用 --- 0
保密通讯协议 --- 启用 --- 0
审计 --- 启用 --- 0
三权分立 --- 启用 --- 0
透明加密 --- 启用 --- 0
强制访问控制 --- 启用 --- 0
列加密 --- 启用 --- 0
密码复杂度 --- 启用 --- 0
用户锁定 --- 启用 --- 0
集群管理软件 --- 启用 --- 0
集群配置工具 --- 启用 --- 0
集群高级管理包 --- 启用 --- 0
并行查询 --- 启用 --- 0
并行备份还原 --- 启用 --- 0
异构数据源 --- 启用 --- 0
日志解析 --- 启用 --- 0


5.2.指定安装目录
===============================================================================
Choose Install Folder
---------------------

Where would you like to install?

Default Install Folder: /opt/Kingbase/ES/V8

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT
: /KingbaseES/V8

INSTALL FOLDER IS: /KingbaseES/V8
IS THIS CORRECT? (Y/N): y


6.创建和初始化数据库集簇
6.1.指定数据目录
===============================================================================
Choose a Folder for data directory
----------------------------------

Please choose a folder. the folder must be empty

Data folder (Default: /KingbaseES/V8/data): /data

6.2.配置数据库初始化参数
===============================================================================
Port
----


Port (Default: 54321):




===============================================================================
User
----


User: (Default: system):




===============================================================================
Enter Password
--------------


Please Enter the Password: Please Enter the Password:*********



===============================================================================
Enter Password again
--------------------


Please Enter the Password Again: Please Enter the Password Again:*********



===============================================================================
Server-encoding
---------------


->1- UTF8
2- GBK
3- GB18030

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:




===============================================================================
Database_Mode
-------------


1- PG
->2- ORACLE

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:



7.将KES服务注册为Linux系统服务
[root@node01 install]# /KingbaseES/V8/Scripts/root.sh
Starting KingbaseES V8:
waiting for server to start.... done
server started
KingbaseES V8 started successfully
[root@node01 install]#


8.检查安装日志
如果安装过程存在报错，会出现安装报错日志，如果安装过程正常，则没有该日志文件

9.检查进程
[root@node01 install]# ps -ef | grep kingbase
root 20845 19862 0 10:30 pts/1 00:00:00 su - kingbase
kingbase 20846 20845 0 10:30 pts/1 00:00:00 -bash
kingbase 26029 1 0 10:39 ? 00:00:00 /KingbaseES/V8/Server/bin/kingbase -D /data
kingbase 26030 26029 0 10:39 ? 00:00:00 kingbase: logger
kingbase 26032 26029 0 10:39 ? 00:00:00 kingbase: checkpointer
kingbase 26033 26029 0 10:39 ? 00:00:00 kingbase: background writer
kingbase 26034 26029 0 10:39 ? 00:00:00 kingbase: walwriter
kingbase 26035 26029 0 10:39 ? 00:00:00 kingbase: autovacuum launcher
kingbase 26036 26029 0 10:39 ? 00:00:00 kingbase: stats collector
kingbase 26037 26029 0 10:39 ? 00:00:00 kingbase: ksh writer
kingbase 26038 26029 0 10:39 ? 00:00:00 kingbase: ksh collector
kingbase 26039 26029 0 10:39 ? 00:00:00 kingbase: kwr collector
kingbase 26040 26029 0 10:39 ? 00:00:00 kingbase: logical replication launcher
root 26393 17732 0 10:40 pts/0 00:00:00 grep --color=auto kingbase
[root@node01 install]#

10.登陆数据库
[kingbase@node01 bin]$ cd /KingbaseES/V8/Server/bin
[kingbase@node01 bin]$ ./ksql test system
ksql (V8.0)
Type "help" for help.

test=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
security | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
template0 | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/system +
| | | | | system=CTc/system
template1 | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/system +
| | | | | system=CTc/system
test | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
(4 rows)

test=#

10.检查服务是否已设为开机自启
[kingbase@node01 bin]$ systemctl list-dependencies | grep kingbase
● ├─kingbase8d.service
[kingbase@node01 bin]$


11.配置环境变量
[kingbase@node01 ~]$ vi .bash_profile
export PATH
export PATH=/KingbaseES/V8/Server/bin:$PATH

[kingbase@node01 ~]$ source .bash_profile

[kingbase@node01 ~]$ ksql test system
ksql (V8.0)
Type "help" for help.

test=#