Table of Contents
- 参考
- 目标
- 实验机器配置
- 实验
- 配置python
- 安装必备前置软件
- 配置安装路径以及下载安装包
- 配置xml文件用于后续软件安装
- 将performance.sh中参数vm.min_free_kbytes注释
- 设置字符集以及openGauss的lib的位置配置到环境变量中
- 解压安装包openGauss-2.0.0-openEuler-64bit并给文件夹权限
- 采用交互模式执行，并在执行过程中会创建root用户互信和openGauss用户互信(密码: Admin@123)
- 开始安装openGauss(密码: Admin@123)
- 检查DB状态
- 检查配置中的port
- 测试DB基本操作
- 基本启动/停止/状态操作
- gsql基本操作
- gs_checkos
- gs_checkperf
参考
目标
本实验在安装了openEuler ARM操作系统的华为云主机上安装openGauss数据库，
通过安装过程中的参数配置、命令行安装、工具使用等等方式，
加深对openGauss数据库关联文件作用的理解，熟悉openGauss数据库安装相关的操作。
实验机器配置
计费模式：按需计费（一定要选按需计费，注意配置费用）
区域：华北-北京四（推荐，其他区域可能会导致无法选择openEuler公共镜像）
CPU架构 鲲鹏通用计算增强型规格：最新系列 2vCPUs|4GB
镜像：公共镜像：openEuleropenEuler 20.03 64bit with ARM(40GB)
系统盘：通用型SSD 40G
实验
配置python
cd /usr/bin mv python python.bak ln -s python3 /usr/bin/python python -V复制
安装必备前置软件
yum install -y libaio*复制
配置安装路径以及下载安装包
mkdir -p /opt/software/openGauss chmod 755 -R /opt/software cd /opt/software/openGauss wget https://openGauss.obs.cn-south-1.myhuaweicloud.com/2.0.0/arm/openGauss-2.0.0-openEuler-64bit-all.tar.gz复制
配置xml文件用于后续软件安装
cd /opt/software/openGauss cat >clusterconfig.xml<<EOF <?xml version="1.0" encoding="UTF-8"?> <ROOT> <CLUSTER> <PARAM name="clusterName" value="dbCluster" /> <PARAM name="nodeNames" value="ecs-opengauss" /> <PARAM name="backIp1s" value="192.168.0.193"/> <PARAM name="gaussdbAppPath" value="/opt/gaussdb/app" /> <PARAM name="gaussdbLogPath" value="/var/log/gaussdb" /> <PARAM name="gaussdbToolPath" value="/opt/huawei/wisequery" /> <PARAM name="corePath" value="/opt/opengauss/corefile"/> <PARAM name="clusterType" value="single-inst"/> </CLUSTER> <DEVICELIST> <DEVICE sn="1000001"> <PARAM name="name" value="ecs-opengauss"/> <PARAM name="azName" value="AZ1"/> <PARAM name="azPriority" value="1"/> <PARAM name="backIp1" value="192.168.0.193"/> <PARAM name="sshIp1" value="192.168.0.193"/> <!--dbnode--> <PARAM name="dataNum" value="1"/> <PARAM name="dataPortBase" value="26000"/> <PARAM name="dataNode1" value="/gaussdb/data/db1"/> </DEVICE> </DEVICELIST> </ROOT> EOF复制
注意： 将IP替换成实际的私有IP，其他保持不变
将performance.sh中参数vm.min_free_kbytes注释
vi /etc/profile.d/performance.sh #sysctl -w vm.min_free_kbytes=112640 &> /dev/null复制
设置字符集以及openGauss的lib的位置配置到环境变量中
cat >>/etc/profile<<EOF export LANG=en_US.UTF-8 export packagePath=/opt/software/openGauss export LD_LIBRARY_PATH=$packagePath/script/gspylib/clib:$LD_LIBRARY_PATH EOF source /etc/profile复制
解压安装包openGauss-2.0.0-openEuler-64bit并给文件夹权限
cd /opt/software/openGauss tar -zxvf openGauss-2.0.0-openEuler-64bit-all.tar.gz tar -zxvf openGauss-2.0.0-openEuler-64bit-om.tar.gz chmod -R 755 /opt/software/openGauss/script/复制
采用交互模式执行，并在执行过程中会创建root用户互信和openGauss用户互信(密码: Admin@123)
cd /opt/software/openGauss/script/ python gs_preinstall -U omm -G dbgrp -X /opt/software/openGauss/clusterconfig.xml复制
开始安装openGauss(密码: Admin@123)
su - omm gs_install -X /opt/software/openGauss/clusterconfig.xml --gsinit-parameter="--encoding=UTF8" --dn-guc="max_process_memory=4GB" --dn-guc="shared_buffers=256MB" --dn-guc="bulk_write_ring_size=256MB" --dn-guc="cstore_buffers=16MB"复制
检查DB状态
gs_om -t status --detail复制
检查配置中的port
cat /gaussdb/data/db1/postgresql.conf | grep port复制
测试DB基本操作
[omm@ecs-opengauss ~]$ gsql -d postgres -p 26000 -r gsql ((openGauss 2.0.0 build 78689da9) compiled at 2021-03-31 21:03:52 commit 0 last mr ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help. postgres=# CREATE USER usr_XXX WITH PASSWORD "XXXXXX@123"; postgres=# CREATE DATABASE db_XXX OWNER usr_XXX; postgres=# \q gsql -d db_XXX -p 26000 -U usr_XXX -W XXXXXX@123 -r [omm@ecs-opengauss ~]$ gsql -d db_XXX -p 26000 -U usr_XXX -W XXXXXX@123 -r gsql ((openGauss 2.0.0 build 78689da9) compiled at 2021-03-31 21:03:52 commit 0 last mr ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help. db_XXX=> CREATE SCHEMA sch_XXXX AUTHORIZATION usr_XXX; CREATE SCHEMA db_XXX=> CREATE TABLE mytable (id int); db_XXX=> INSERT INTO mytable values (100); db_XXX=> \q [omm@ecs-opengauss ~]$复制
基本启动/停止/状态操作
gs_om -t start gs_om -t status gs_om -t stop复制
gsql基本操作
gsql --help postgres=# help You are using gsql, the command-line interface to gaussdb. Type: \copyright for distribution terms \h for help with SQL commands \? for help with gsql commands \g or terminate with semicolon to execute query \q to quit postgres=# \copyright GaussDB Kernel Database Management System Copyright (c) Huawei Technologies Co., Ltd. 2018. All rights reserved. postgres=# \h postgres=# \? postgres=# \q复制
gs_checkos
gs_checkos -i A [root@ecs-opengauss script]# /root/gauss_om/omm/script/gs_checkos -i A Checking items: A1. [ OS version status ] : Normal A2. [ Kernel version status ] : Normal A3. [ Unicode status ] : Normal A4. [ Time zone status ] : Normal A5. [ Swap memory status ] : Normal A6. [ System control parameters status ] : Warning A7. [ File system configuration status ] : Warning A8. [ Disk configuration status ] : Normal A9. [ Pre-read block size status ] : Normal A10.[ IO scheduler status ] : Normal BondMode Null A11.[ Network card configuration status ] : Warning A12.[ Time consistency status ] : Warning A13.[ Firewall service status ] : Normal A14.[ THP service status ] : Normal Total numbers:14. Abnormal numbers:0. Warning numbers:4. [root@ecs-opengauss script]#复制
gs_checkperf
[omm@ecs-opengauss ~]$ gs_checkperf Cluster statistics information: Host CPU busy time ratio : 15.22 % MPPDB CPU time % in busy time : 7.56 % Shared Buffer Hit ratio : 95.60 % In-memory sort ratio : 0 Physical Reads : 366 Physical Writes : 84 DB size : 42 MB Total Physical writes : 84 Active SQL count : 4 Session count : 6 [omm@ecs-opengauss ~]$ [omm@ecs-opengauss ~]$ gs_checkperf --detail Cluster statistics information: Host CPU usage rate: Host total CPU time : 3889660.000 Jiffies Host CPU busy time : 621030.000 Jiffies Host CPU iowait time : 23690.000 Jiffies Host CPU busy time ratio : 15.97 % Host CPU iowait time ratio : .61 % MPPDB CPU usage rate: MPPDB CPU time % in busy time : 16.61 % MPPDB CPU time % in total time : 2.65 % Shared buffer hit rate: Shared Buffer Reads : 816 Shared Buffer Hits : 44870 Shared Buffer Hit ratio : 98.21 % In memory sort rate: In-memory sort count : 0 In-disk sort count : 0 In-memory sort ratio : 0 I/O usage: Number of files : 94 Physical Reads : 425 Physical Writes : 213 Read Time : 108601 ms Write Time : 1920 ms Disk usage: DB size : 42 MB Total Physical writes : 213 Average Physical write : 110937.50 Maximum Physical write : 213 Activity statistics: Active SQL count : 4 Session count : 6 Node statistics information: dn_6001: MPPDB CPU Time : 103170 Jiffies Host CPU Busy Time : 621030 Jiffies Host CPU Total Time : 3889660 Jiffies MPPDB CPU Time % in Busy Time : 16.61 % MPPDB CPU Time % in Total Time : 2.65 % Physical memory : 3121086464 Bytes DB Memory usage : 3675848704 Bytes Shared buffer size : 268435456 Bytes Shared buffer hit ratio : 98.21 % Sorts in memory : 0 Sorts in disk : 0 In-memory sort ratio : 0 Number of files : 94 Physical Reads : 425 Physical Writes : 213 Read Time : 108601 Write Time : 1920 Session statistics information(Top 10): Session CPU statistics: 1 dn_6001-postgres-omm: Session CPU time : 2 Database CPU time : 103360 Session CPU time % : 0.00 % 2 dn_6001-postgres-omm: Session CPU time : 0 Database CPU time : 103360 Session CPU time % : 0.00 % 3 dn_6001-postgres-omm: Session CPU time : 0 Database CPU time : 103360 Session CPU time % : 0.00 % 4 dn_6001-postgres-omm: Session CPU time : 0 Database CPU time : 103360 Session CPU time % : 0.00 % Session Memory statistics: 1 dn_6001-postgres-omm: Buffer Reads : 1009 Shared Buffer Hit ratio : 100.00 In Memory sorts : 1 In Disk sorts : 0 In Memory sorts ratio : 100.00 Total Memory Size : 8879168 Used Memory Size : 6797760 2 dn_6001-postgres-omm: Buffer Reads : 283 Shared Buffer Hit ratio : 100.00 In Memory sorts : 0 In Disk sorts : 0 In Memory sorts ratio : 0 Total Memory Size : 5890184 Used Memory Size : 4521944 3 dn_6001-postgres-omm: Buffer Reads : 283 Shared Buffer Hit ratio : 100.00 In Memory sorts : 0 In Disk sorts : 0 In Memory sorts ratio : 0 Total Memory Size : 5881992 Used Memory Size : 4521184 4 dn_6001-postgres-omm: Buffer Reads : 282 Shared Buffer Hit ratio : 99.65 In Memory sorts : 0 In Disk sorts : 0 In Memory sorts ratio : 0 Total Memory Size : 5857416 Used Memory Size : 4511992 Session IO statistics: 1 dn_6001-postgres-omm: Physical Reads : 1 Read Time : 6 2 dn_6001-postgres-omm: Physical Reads : 0 Read Time : 0 3 dn_6001-postgres-omm: Physical Reads : 0 Read Time : 0 4 dn_6001-postgres-omm: Physical Reads : 0 Read Time : 0 [omm@ecs-opengauss ~]$复制
最后修改时间：2024-03-15 15:14:35
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
xiao_mini
4月前
评论
0x86包的下载地址:
https://opengauss.obs.cn-south-1.myhuaweicloud.com/2.0.0/x86_openEuler/openGauss-2.0.0-openEuler-64bit-all.tar.gz
4月前
点赞 评论
相关阅读
2025年3月国产数据库大事记
墨天轮编辑部
911次阅读
2025-04-03 15:21:16
MogDB 发布更新，解决 openGauss 数据库在长事务情况下Ustore表膨胀问题
MogDB
289次阅读
2025-04-17 10:41:41
openGauss 7.0.0-RC1 版本正式发布!
Gauss松鼠会
210次阅读
2025-04-01 12:27:03
MogDB 发布更新，解决 openGauss 数据库在长事务情况下Ustore表膨胀问题
云和恩墨
191次阅读
2025-04-16 09:52:02
openGauss 7.0.0-RC1 版本体验：一主一备快速安装指南
孙莹
187次阅读
2025-04-01 10:30:07
鲲鹏RAG一体机解决方案正式发布 openGauss DataVec向量数据库助力DeepSeek行业应用
Gauss松鼠会
126次阅读
2025-03-31 10:00:29
荣誉时刻！openGauss认证证书快递已发，快来看看谁榜上有名！
墨天轮小教习
116次阅读
2025-04-23 17:39:13
GitCode 成 openGauss 新归宿，国产开源数据库里程碑事件
严少安
99次阅读
2025-04-27 11:37:53
openGauss6.0.0适配操作系统自带的软件，不依赖三方库
来杯拿铁
79次阅读
2025-04-18 10:49:53
opengauss使用gs_probackup进行增量备份恢复
进击的CJR
70次阅读
2025-04-09 16:11:58
