GBase 8s 主题实战指南

 一、环境与版本

系统：openEuler 22.03 LTS / 24.03 LTS x86_64

数据库：GBase 8s V8.8（x86_64）

主机：4 核 +、8G+、数据盘≥100G（生产建议 SSD）

字符集：zh_CN.UTF-8

# 查看系统 cat /etc/os-release uname -r

二、安装前准备（root 执行）

2.1 关闭防火墙与 SELinux（测试环境）

systemctl stop firewalld

 systemctl disable firewalld 

setenforce 0

 sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config

2.2 安装依赖

yum install -y libaio-devel ncurses-devel libstdc++-devel \ 

gcc make unzip flex bison readline-devel libnsl java-1.8.0-openjdk

2.3 内核参数优化

vi /etc/sysctl.conf

kernel.sem = 250 32000 100 128 kernel.shmmax = 17179869184 kernel.shmall = 4194304 kernel.shmmni = 4096 fs.file-max = 655350 net.ipv4.tcp_tw_reuse = 1 net.ipv4.tcp_timestamps = 1

2.4 创建用户与目录

groupadd gbasedbt useradd -g gbasedbt gbasedbt passwd gbasedbt # 设为 GBase@123 mkdir -p /opt/gbase/8s /opt/gbase/data /opt/gbase/logs /opt/gbase/backup chown -R gbasedbt:gbasedbt /opt/gbase chmod -R 755 /opt/gbase

三、上传解压与静默安装（gbasedbt 执行）

把 GBase8s_V8.8_x86_64.zip 传到 /opt/gbase

su - gbasedbt cd /opt/gbase unzip GBase8s_V8.8_x86_64.zip cd GBase8s_V8.8_x86_64

3.2 静默安装响应文件

vi install.properties

写入：

INSTALL_PATH=/opt/gbase/8s DATA_PATH=/opt/gbase/data LOG_PATH=/opt/gbase/logs INSTANCE_NAME=gbaseserver PORT=9088 DB_LOCALE=zh_CN.UTF-8 CLIENT_LOCALE=zh_CN.UTF-8

3.3 执行安装

./install.sh -f install.properties

四、环境变量与实例初始化

4.1 配置环境变量

vi /home/gbasedbt/.bashrc

写入：

export GBASEDBTSERVER=gbaseserver export GBASEDBTDIR=/opt/gbase/8s export PATH=$GBASEDBTDIR/bin:$PATH export LD_LIBRARY_PATH=$GBASEDBTDIR/lib:$LD_LIBRARY_PATH

生效：

source /home/gbasedbt/.bashrc

4.2 初始化实例

oninit -ivy

4.3 查看状态

oninit -ivy