openGauss每日一练第1天 | 环境部署与作业

【备注，在本地环境部署了OpenGauss3.0版 主备环境】

[omm@fdb62pd2 ~]$ gs_om -t status --detail
[ Cluster State ]

cluster_state : Normal
redistributing : No
current_az : AZ_ALL

[ Datanode State ]

node node_ip port instance state
----------------------------------------------------------------------------------------------------
1 fdb62pd2 192.168.205.62 26000 6001 /apps2/opengauss/install/data/dn P Primary Normal
2 fdb63pd3 192.168.205.63 26000 6002 /apps2/opengauss/install/data/dn S Standby Normal

第1周作业主要是学习从操作系统层面和使用openGauss工具查看数据库的状态、版本和数据文件目录。

gs_ctl，它是openGauss提供的数据库服务控制工具，可以用来启停数据库服务和查询数据库状态。主要供openGauss管理模块调用。gs_ctl工具由操作系统用户omm执行。可以执行：启动、停止、重启openGauss节点。

[omm@fdb62pd2 ~]$ gs_ctl stop
[2022-11-30 14:52:25.614][13873][][gs_ctl]: gs_ctl stopped ,datadir is /apps2/opengauss/install/data/dn
waiting for server to shut down..... done
server stopped

[omm@fdb62pd2 ~]$ gs_ctl start
[2022-11-30 14:52:30.324][13877][][gs_ctl]: gs_ctl started,datadir is /apps2/opengauss/install/data/dn
[2022-11-30 14:52:30.369][13877][][gs_ctl]: waiting for server to start...
.0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.

………………

[2022-11-30 14:52:31.885][13877][][gs_ctl]: done
[2022-11-30 14:52:31.885][13877][][gs_ctl]: server started (/apps2/opengauss/install/data/dn)

1.从操作系统层面查看数据库进程和线程,判断数据库是否启动。

ps -ef|grep gauss

2.使用gs_ctl工具查看数据库状态,判断数据库是否启动。

gs_ctl status显示：gs_ctl: server is running (PID: 737)

3.使用gs_ctl查看数据文件的目录

gs_ctl notify显示gs_ctl notify ,datadir is /apps2/opengauss/install/data/dn

4.从环境变量查看数据文件的目录

[omm@fdb62pd2 ~]$ cat .bashrc | grep PGDATA
export PGDATA=/apps2/opengauss/install/data/dn

完整的环境变量信息如下：

[omm@fdb62pd2 ~]$ cat .bashrc
# .bashrc

# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi

# Uncomment the following line if you don't like systemctl's auto-paging feature:
# export SYSTEMD_PAGER=

# User specific aliases and functions
export SSH_AUTH_SOCK=/home/omm/gaussdb_tmp/gauss_socket_tmp
export SSH_AGENT_PID=16857
export GPHOME=/apps2/opengauss/install/om
export PATH=$GPHOME/script/gspylib/pssh/bin:$GPHOME/script:$PATH
export LD_LIBRARY_PATH=$GPHOME/lib:$LD_LIBRARY_PATH
export PYTHONPATH=$GPHOME/lib
export GAUSSHOME=/apps2/opengauss/install/app
export PATH=$GAUSSHOME/bin:$PATH
export LD_LIBRARY_PATH=$GAUSSHOME/lib:$LD_LIBRARY_PATH
export S3_CLIENT_CRT_FILE=$GAUSSHOME/lib/client.crt
export GAUSS_VERSION=3.1.0
export PGHOST=/apps2/opengauss/tmp
export GAUSSLOG=/apps2/opengauss/omm/omm
umask 077
export GAUSS_ENV=2
export GS_CLUSTER_NAME=gscluster2
export PGDATA=/apps2/opengauss/install/data/dn

5.在gsql中查看数据文件目录、数据库版本

openGauss=# show data_directory;
data_directory
----------------------------------
/apps2/opengauss/install/data/dn
(1 row)

openGauss=# select version();
version
------------------------------------------------------------------------------------------------------------------------------------------------------
(openGauss 3.1.0 build 4e931f9a) compiled at 2022-09-29 14:19:24 commit 0 last mr on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit
(1 row)

openGauss=# 

任务完成。