openGauss 3.0学习第一天：安装部署

原创杨凯同学 2022-09-26

1088

一、服务器配置

硬件配置 CPU：4核内存：4GB 硬盘：50GB

操作系统 CentOS 7.6

二、安装部署

2.1 下载并解压安装包

（1）以root用户登录，创建规划创建安装包目录

[root@huaweidb opt]#mkdir -p /opt/software/openGauss

[root@huaweidb opt]#chmod 755 -R /opt/software/

（2）把安装包上传到/opt/software/openGauss并解压

[root@huaweidb openGauss]#tar -xvf openGauss-3.0.0-CentOS-64bit-all.tar.gz

[root@huaweidb openGauss]#tar -xvf openGauss-3.0.0-CentOS-64bit-om.tar.gz

获取安装包方法

2.2安装依赖包

[root@huaweidb openGauss]#yum install -y libaio-devel flex bison ncurses-devel glibc.devel patch lsb_release python3 bzip2

2.3修改Python版本

服务器需要用到Python-3.x命令，但CentOS 7.6 默认版本Python-2.7.x，需要切换到Python-3.x版本

[root@huaweidb openGauss]#cd /usr/bin/

[root@huaweidb openGauss]#mv python python.bak
[root@huaweidb openGauss]#ln -s python3 /usr/bin/python

三、安装数据库

安装openGuass数据库需要创建XML配置文件。

3.1 创建XML配置文件

[root@localhost openGauss]# vi /opt/software/openGauss/cluster_config.xml
<?xml version="1.0" encoding="utf-8"?>
<ROOT>
<CLUSTER>
<PARAM name="clusterName" value="huaweidbCluster" />
<PARAM name="nodeNames" value="huaweidb"/>
<PARAM name="gaussdbAppPath" value="/opt/huawei/install/app" />
<PARAM name="gaussdbLogPath" value="/var/log/omm" />
<PARAM name="tmpMppdbPath" value="/opt/huawei/tmp"/>
<PARAM name="gaussdbToolPath" value="/opt/huawei/install/om" />
<PARAM name="corePath" value="/opt/huawei/corefile"/>
<PARAM name="backIp1s" value="172.16.110.52"/>
</CLUSTER>

<DEVICELIST>
<DEVICE sn="huaweidb">
<PARAM name="name" value="huaweidb"/>
<PARAM name="azName" value="AZ1"/>
<PARAM name="azPriority" value="1"/>
<PARAM name="backIp1" value="172.16.110.52"/>
<PARAM name="sshIp1" value="172.16.110.52"/>

<PARAM name="dataNum" value="1"/>
<PARAM name="dataPortBase" value="15400"/>
<PARAM name="dataNode1" value="/opt/huawei/install/data/dn"/>
<PARAM name="dataNode1_syncNum" value="0"/>
</DEVICE>
</DEVICELIST>
</ROOT>

3.2执行预安装脚本

为了保证openGauss正确安装，需要对主机环境进行初始化

[root@huaweidb openGauss]# cd /opt/software/openGauss/script/

[root@huaweidb script]# ./gs_preinstall -U omm -G dbgrp -X /opt/software/openGauss/cluster_config.xml

3.3执行安装

安装需要用到omm用户

[root@huaweidb script]# su - omm
Last login: Mon Sep 26 11:46:48 CST 2022
[omm@huaweidb ~]$ gs_install -X /opt/software/openGauss/cluster_config.xml

四、数据库使用

（1）启动数据库

[root@huaweidb script]# su - omm
Last login: Mon Sep 26 11:47:19 CST 2022 on pts/2
[omm@huaweidb ~]$ gs_om -t start
Starting cluster.
=========================================
[SUCCESS] huaweidb:
[2022-09-26 12:52:43.609][21503][][gs_ctl]: gs_ctl started,datadir is /opt/huawei/install/data/dn
[2022-09-26 12:52:43.618][21503][][gs_ctl]: another server might be running; Please use the restart command
=========================================
Successfully started.

（2）连接数据库、创建用户、数据库、schema

[omm@huaweidb ~]$ gsql -d postgres -p 15400
gsql ((openGauss 3.0.0 build 02c14696) compiled at 2022-04-01 18:12:34 commit 0 last mr )

[omm@huaweidb ~]$ gsql -d postgres -p 15400
gsql ((openGauss 3.0.0 build 02c14696) compiled at 2022-04-01 18:12:34 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

openGauss=# create user yangkai with password "YangKai@123";
CREATE ROLE
openGauss=# create database db_yangkai owner yangkai;
CREATE DATABASE
openGauss=# \c db_yangkai yangkai;
Password for user yangkai:
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "db_yangkai" as user "yangkai".
db_yangkai=> create schema yangkai authorization yangkai;
CREATE SCHEMA
db_yangkai=> create table yangkai(id int,name varchar(200));
CREATE TABLE
db_yangkai=> insert into yangkai values (1,'杨凯');
INSERT 0 1
db_yangkai=> select * from yangkai;
id | name
----+---------
1 | 杨凯
(1 row)

db_yangkai=>