暂无图片
暂无图片
1
暂无图片
暂无图片
暂无图片
首页 / openGauss系列之_Centos 7.6 使用 PTK v0.5 安装部署单机版 MogDB v3.0.3

openGauss系列之_Centos 7.6 使用 PTK v0.5 安装部署单机版 MogDB v3.0.3

原创 尚雷 2022-12-02
1253

一、安装环境准备

1.1 硬件环境要求

根据MogDB官网信息，安装部署MogDB对于硬件有一定要求，如部署生产环境请参照要求进行配置。

项目 配置描述
内存 功能调试32GB以上。 性能测试和商业部署时，单实例部署建议128GB以上。 复杂的查询对内存的需求量比较高，在高并发场景下，可能出现内存不足。此时建议使用大内存的机器，或使用负载管理限制系统的并发。
CPU 功能调试最小1×8 核，2.0GHz。 性能测试和商业部署时，单实例部署建议1×16核，2.0GHz。 CPU超线程和非超线程两种模式都支持。但是，MogDB各节点的设置需保持一致。
硬盘 用于安装MogDB的硬盘需最少满足如下要求： - 至少1GB用于安装MogDB的应用程序。 - 每个主机需大约300MB用于元数据存储。 - 预留70%以上的磁盘剩余空间用于数据存储。 建议系统盘配置为RAID1，数据盘配置为RAID5，且规划4组RAID5数据盘用于安装MogDB。有关RAID的配置方法在本手册中不做介绍。请参考硬件厂家的手册或互联网上的方法进行配置，其中Disk Cache Policy一项需要设置为Disabled，否则机器异常掉电后有数据丢失的风险。 MogDB支持使用SSD盘作为数据库的主存储设备，支持SAS接口和NVME协议的SSD盘，以RAID的方式部署使用。
网络要求 300兆以上以太网。 建议网卡设置为双网卡冗余bond。有关网卡冗余bond的配置方法在本手册中不做介绍。请参考硬件厂商的手册或互联网上的方法进行配置。 MogDB网络如果配置bond，请保证bond模式一致，不一致的bond配置可能导致MogDB工作异常。

1.2 软件环境要求

根据MogDB官网信息，安装部署MogDB对于部分软件有一定要求，请参照官网要求配置如下软件。

软件类型 配置描述
rdtscp指令集（x86） 执行`lscpu
bmi2指令集（CentOS） 执行`lscpu
工具 Huawei JDK 1.8.0、psmisc、bzip2
Python - openEuler：支持Python 3.7.X - CentOS：支持Python 3.6.X - 麒麟：支持Python 3.7.X 说明： python需要通过–enable-shared方式编译。

1.3 操作系统要求

根据MogDB官网信息，安装部署MogDB对于操作系统版本是有一定要求，在安装部署MogDB前要检测所使用的操作系统是否符合要求。

操作系统 PTK方式 OM方式 手动方式
CentOS 7 (x86_64) √ √ √
CentOS 8 (arm64) √ √
CentOS 8 (x86_64) √ √
EulerOS 2 (arm64) √ √
EulerOS 2 (x86_64) √ √
Kylin V10 (arm64) √ √ √
Kylin V10 (x86_64) √ √ √
NeoKylin V7 (x86_64) √ √
Oracle Linux 7 (x86_64) √ √
Oracle Linux 8 (x86_64) √ √
Red Hat Enterprise Linux 7 (x86_64) √ √ √
Red Hat Enterprise Linux 8 (x86_64) √ √
Rocky Linux 7 (x86_64) √ √
Rocky Linux 8 (x86_64) √ √
SLES 12 (arm64) √ √
UOS 20 (arm64) √ √ √
UOS 20 (x86_64) √ √ √
Ubuntu 18 (x86_64) √ √
openEuler 20 (arm64) √ √ √
openEuler 20 (x86_64) √ √ √
openEuler 22 (arm64) √ √
openEuler 22 (x86_64) √ √

1.4 软件依赖要求

根据MogDB官网信息，安装部署MogDB需要依赖一些软件包，所以在部署MogDB前，要检查如下依赖包是否已安装。

所需软件 建议版本
libaio-devel 建议版本：0.3.109-13
flex 要求版本：2.5.31 以上
bison 建议版本：2.7-4
ncurses-devel 建议版本：5.9-13.20130511
glibc-devel 建议版本：2.17-111
patch 建议版本：2.7.1-10
redhat-lsb-core 建议版本：4.1
readline-devel 建议版本：7.0-13
libnsl（openEuler+x86环境中） 建议版本：2.28-36
openSSH 建议版本 ：8.4p1
expect 建议版本 ：5.45.4 
-- 检查依赖包
rpm  -qa  --queryformat  "%{NAME}-%{VERSION}-%{RELEASE}  (%{ARCH})\n"  |  grep  -E "libaio-devel|flex|bison|ncurses-devel|glibc-devel|patch|redhat-lsb-core|readline-devel|openSSH|expect|zlib*|lsof|bzip2|numactl"
-- 安装依赖包
yum -y install libaio-devel flex bison ncurses-devel glibc-devel patch redhat-lsb-core readline-devel openSSH expect zlib* lsof bzip2 numactl

二、操作系统设置

2.1 安装python3

# 本次选择安装python 3.6.5版本
mkdir /usr/local/python3
cd /usr/local/python3
wget https://www.python.org/ftp/python/3.6.5/Python-3.6.5.tgz
tar -zxf Python-3.6.5.tgz
cd /usr/local/python3/Python-3.6.5
-- 不加CFLAGS=-fPIC，会在升级3.0的时候遇到编译问题
./configure --prefix=/usr/local/python3 --enable-shared CFLAGS=-fPIC  
make && make install
ln -s /usr/local/python3/bin/python3 /usr/bin/python3
ln -s /usr/local/python3/bin/pip3 /usr/bin/pip3

-- 设置环境变量
cat >>/etc/profile<<EOF
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/python3/bin
EOF
source /etc/profile

2.2 关闭操作系统防火墙

-- root 用户执行
systemctl disable firewalld.service
systemctl stop firewalld.service
systemctl status firewalld.service

2.3 设置字符集参数

-- root 用户执行
cat >>/etc/profile <<EOF
export LANG=en_US.UTF-8
EOF
source /etc/profile
# 检查字符集
cat /etc/profile | grep LANG
env |grep -i lang

2.4 设置时区和时间

-- root 用户执行
cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
-- 查看
date

2.5 关闭swap交换内存

-- root 用户执行
-- 永久关闭
注释 swap 行
vim /etc/fstab

-- 查看
free -h 查看 swap一行全是 0 表示swap关闭

2.6 设置网卡MTU

-- root 用户操作
-- 设置网卡为1500
ifconfig 网卡名 mtu 1500

-- 查看
ifconfig -a |grep -i mtu

2.7 设置root用户远程登录

-- root 用户操作
cat >>/etc/ssh/sshd_config<<EOF
PermitRootLogin yes
EOF
-- 检查
cat /etc/ssh/sshd_config |grep PermitRootLogin

2.8 关闭透明大页

-- root 用户操作
cat >> /etc/rc.d/rc.local<<EOF
if test -f /sys/kernel/mm/transparent_hugepage/enabled;
	then
		echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag;
	then
		echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi
EOF

-- 查看是否关闭：
cat /sys/kernel/mm/transparent_hugepage/enabled
cat /sys/kernel/mm/transparent_hugepage/defrag

2.9 修改 Banner 配置

-- root 用户操作
cat >>/etc/ssh/sshd_config<<EOF
Banner none
EOF
-- 检查
cat /etc/ssh/sshd_config | grep Banner

-- 重启生效
systemctl restart sshd.service

三、安装MogDB

3.1 在线安装PTK

-- 本次选择在线安装最新版PTK
-- root 用户执行
[root@opensource-db ~]# curl --proto '=https' --tlsv1.2 -sSf https://cdn-mogdb.enmotech.com/ptk/install.sh | sh
Downloading ptk package...
Detected shell: bash
Shell profile:  /root/.bash_profile
ptk has been added to PATH in /root/.bash_profile
open a new terminal or source /root/.bash_profile to active it
Installed path: /root/.ptk/bin/ptk

-- 配置环境变量
按照上述提示，重新打开一个会话窗口或者执行 source /root/.bash_profile
[root@opensource-db ~]# source /root/.bash_profile
[root@opensource-db ~]# ptk -v
PTK Version: v0.5.4 release
Go Version: go1.18.1
Build Date: 2022-12-01T19:38:20
Git Hash: 9796069
[root@opensource-db ~]# ptk --help
ptk is a command-line management tool that can help you to
deploy or manage MogDB clusters.

Usage:
  ptk [flags] <command> [args...]
  ptk [command]

Available Commands:
  env         Print ptk loaded environment values
  gen-om-xml  Generate an XML file for gs_om
  self        Modify the ptk installation
  version     Print version of ptk
  help        Help for ptk
  completion  Generate the autocompletion script for the specified shell

Pre Install Commands:
  candidate   Print software version list which PTK supported
  download    Download MogDB package online
  checkos     Check cluster servers os dependencies
  encrypt     Provides a convenient way to encrypt your text/password
  template    Print template of configuration
  exec        execute shell command or script

Install Commands:
  install     Install the MogDB database cluster based on configuration
  uninstall   Uninstall a database cluster

Post Install Commands:
  ls          List MogDB clusters
  cluster     Operations for manage database cluster

Experimental Commands:
  register    Register some PTK internal types to fulfill specific requirements

Flags:
  -h, --help                Help for ptk
      --log-file string     Specify a log output file
      --log-format string   Specify the log message format. Options: [text, json] (default "text")
      --log-level string    Specify the log level. Options: [debug, info, warning, error, panic] (default "info")
  -v, --version             Print version of ptk

Use "ptk [command] --help" for more information about a command.

3.2 下载MogDB安装包

登陆https://www.mogdb.io/downloads/allDownload链接下载地址，下载对应操作系统数据库安装包。

image20221201204818509.png

[root@opensource-db ~]# cd /opt/software/mogdb/
[root@opensource-db mogdb]# wget https://cdn-mogdb.enmotech.com/mogdb-media/3.0.3/MogDB-3.0.3-CentOS-x86_64.tar.gz
--2022-12-01 20:51:27--  https://cdn-mogdb.enmotech.com/mogdb-media/3.0.3/MogDB-3.0.3-CentOS-x86_64.tar.gz
[root@opensource-db mogdb]# ll
total 136000
-rw-r--r-- 1 root root 139260078 Oct 31 16:33 MogDB-3.0.3-CentOS-x86_64.tar.gz

3.3 创建config.yaml配置文件

PTK安装数据库需设置配置文件config.yaml。

-- root 用户执行
[root@opensource-db ~]# cd /opt/software/mogdb/
-- 创建config.yaml配置文件 
cat > config.yaml <<EOF
global:
    cluster_name: mogdb
    user: omm
    group: omm
    base_dir: /db/mogdb
db_servers:
    - host: 127.0.0.1
      db_port: 26000
EOF

3.4 执行预检查

-- root 用户执行
[root@opensource-db mogdb]# ptk checkos -f config.yaml
INFO[2022-12-01T21:01:16.090] prechecking dependent tools...               
INFO[2022-12-01T21:01:16.189] [192.168.73.21][omm] timezone: +0800         
INFO[2022-12-01T21:01:16.214] [192.168.73.21][omm] check port 26000        
INFO[2022-12-01T21:01:16.262] [192.168.73.21][omm] port 26000 is free      
INFO[2022-12-01T21:01:16.267] [192.168.73.21][omm] kernel version: 3.10.0-1160.80.1.el7.x86_64 
WARN[2022-12-01T21:01:16.278] [192.168.73.21][omm] device(dm-7) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.278] [192.168.73.21][omm] device(sdat) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.278] [192.168.73.21][omm] device(sdaw) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.278] [192.168.73.21][omm] device(sdax) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.278] [192.168.73.21][omm] device(sdc) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.278] [192.168.73.21][omm] device(dm-14) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.278] [192.168.73.21][omm] device(dm-17) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(dm-12) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(dm-8) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdbf) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdk) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdn) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdp) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(dm-0) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(dm-5) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdaq) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdba) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdbc) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdbn) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdb) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdg) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdw) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(dm-4) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdap) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdav) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdbg) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdbi) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(dm-16) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(dm-6) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdaa) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sda) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdj) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.279] [192.168.73.21][omm] device(sdr) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdab) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdai) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(dm-15) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdam) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdbj) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdd) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdl) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdq) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdv) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(dm-9) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdar) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sr0) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdaf) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdu) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdy) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdak) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdan) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdau) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(dm-10) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(dm-18) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(dm-2) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(dm-3) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdac) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdaj) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdbb) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdbk) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdi) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdo) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.280] [192.168.73.21][omm] device(sdz) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(dm-13) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdag) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdaz) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdbe) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdbm) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdh) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(dm-1) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdae) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdah) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdt) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdx) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(dm-11) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdad) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdao) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdas) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sday) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdbd) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdbh) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdm) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sds) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdal) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdbl) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sde) 'IO Request'=128, expect 256 
WARN[2022-12-01T21:01:16.281] [192.168.73.21][omm] device(sdf) 'IO Request'=128, expect 256 
INFO[2022-12-01T21:01:22.189] [192.168.73.21][omm] platform: centos_7_64bit 
INFO[2022-12-01T21:01:22.199] [192.168.73.21][omm] swap memory 0kB, total memory 65755452kB 
WARN[2022-12-01T21:01:22.213] [192.168.73.21][omm] net.ipv4.tcp_retries2=15, expect 12 
WARN[2022-12-01T21:01:22.220] [192.168.73.21][omm] net.ipv4.tcp_max_syn_backlog=2048, expect 65535 
WARN[2022-12-01T21:01:22.232] [192.168.73.21][omm] net.ipv4.tcp_syn_retries=6, expect 5 
WARN[2022-12-01T21:01:22.238] [192.168.73.21][omm] net.core.wmem_max=212992, expect 21299200 
WARN[2022-12-01T21:01:22.245] [192.168.73.21][omm] net.core.rmem_default=212992, expect 21299200 
WARN[2022-12-01T21:01:22.251] [192.168.73.21][omm] net.ipv4.tcp_tw_recycle=0, expect 1 
WARN[2022-12-01T21:01:22.257] [192.168.73.21][omm] net.ipv4.tcp_keepalive_time=7200, expect 30 
WARN[2022-12-01T21:01:22.263] [192.168.73.21][omm] net.ipv4.tcp_retries1=3, expect 5 
WARN[2022-12-01T21:01:22.268] [192.168.73.21][omm] net.core.rmem_max=212992, expect 21299200 
WARN[2022-12-01T21:01:22.291] [192.168.73.21][omm] net.ipv4.tcp_rmem=4096       87380   6291456, expect 8192 250000 16777216 
WARN[2022-12-01T21:01:22.302] [192.168.73.21][omm] kernel.sem=250       32000   32      128, expect 250 6400000 1000 25600 
WARN[2022-12-01T21:01:22.313] [192.168.73.21][omm] net.ipv4.tcp_keepalive_intvl=75, expect 30 
WARN[2022-12-01T21:01:22.323] [192.168.73.21][omm] net.core.somaxconn=128, expect 65535 
WARN[2022-12-01T21:01:22.334] [192.168.73.21][omm] net.ipv4.tcp_wmem=4096       16384   4194304, expect 8192 250000 16777216 
WARN[2022-12-01T21:01:22.340] [192.168.73.21][omm] net.core.wmem_default=212992, expect 21299200 
WARN[2022-12-01T21:01:22.355] [192.168.73.21][omm] net.core.netdev_max_backlog=1000, expect 65535 
WARN[2022-12-01T21:01:22.367] [192.168.73.21][omm] vm.min_free_kbytes=90112, expect 3287772 
WARN[2022-12-01T21:01:22.373] [192.168.73.21][omm] net.ipv4.tcp_tw_reuse=0, expect 1 
INFO[2022-12-01T21:01:22.373] [192.168.73.21][omm] check kernel.core_pattern 
INFO[2022-12-01T21:01:22.383] [192.168.73.21][omm] check removeIPC value   
INFO[2022-12-01T21:01:22.459] [192.168.73.21][omm] locale: LANG=en_US.UTF-8 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdo) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdz) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdaq) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdbl) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdbn) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdk) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdv) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdau) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdh) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdt) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdat) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdbc) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.765] [192.168.73.21][omm] device(/dev/sdbd) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdbk) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdi) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdx) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdar) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdav) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdaw) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdc) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdg) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdan) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdao) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdas) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdbj) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdw) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdak) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdd) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdr) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdae) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdai) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdbe) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdbm) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdj) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdm) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdn) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdaj) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdbb) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdbi) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sda) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdab) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdax) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdac) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdam) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sday) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.766] [192.168.73.21][omm] device(/dev/sdl) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdbg) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdp) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdbf) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdf) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdq) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdba) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sds) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdaz) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdbh) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdu) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdad) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdah) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdag) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sde) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdy) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdaa) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdaf) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdal) readahead value=256, expect 16384. 
WARN[2022-12-01T21:01:22.767] [192.168.73.21][omm] device(/dev/sdap) readahead value=256, expect 16384. 
INFO[2022-12-01T21:01:23.182] all checkers finished                        
INFO[2022-12-01T21:01:23.182] Time elapsed: 7s                             
# Check Results
                Item                |  Level    
------------------------------------+-----------
  A1.Check_OS_Version               | OK        
  A2.Check_Kernel_Version           | OK        
  A3.Check_Unicode                  | OK        
  A4.Check_TimeZone                 | OK        
  A5.Check_Swap_Memory_Configure    | OK        
  A6.Check_SysCtl_Parameter         | Warning   
  A7.Check_FileSystem_Configure     | OK        
  A8.Check_Disk_Configure           | OK        
  A9.Check_BlockDev_Configure       | Warning   
  A9.Check_Logical_Block            | OK        
  A10.Check_IO_Request              | Warning   
  A10.Check_Asynchronous_IO_Request | OK        
  A10.Check_IO_Configure            | OK        
  A11.Check_Network_Configure       | OK        
  A12.Check_Time_Consistency        | OK        
  A13.Check_Firewall_Service        | OK        
  A14.Check_THP_Service             | OK        
  A15.Check_Dependent_Package       | OK        
  A16.Check_CPU_Instruction_Set     | Abnormal  
  A17.Check_Port                    | OK        
Total count 20, abnormal count 1, warning count 3
Failed to check os, can’t perform installation unless fix all the abnormal items
You can use 'ptk checkos -i ITEM --detail' to get detail message
Please check root_fix_os.[TIMESTAMP].sh for commands to resolve.

# 确保输出的检查结果均为 OK 或 Warning ，如有 Abnormal 或 ExecuteError出现，需根据日志提示修正系统参数后再安装

每次执行ptk checkos -f config.yaml都会在当前目录下生成诸如 root_fix_os.年.月日.时分秒.sh这样的文件，查看该文件，如果提示缺少包，会在该sh脚本文件里提示，并可以按照该脚本来执行一些缺少的包，该文件内容如下。

[root@opensource-db mogdb]# cat root_fix_os.2022.1201.210005.sh
#!/usr/bin/env bash

local_ips=$(ip addr | grep 'inet' | grep -v 'inet6\|127.0.0.1' | grep -v grep | awk -F '/' '{print $1}' | awk '{print $2}')

# fix suggestions for host: 192.168.73.21
for ip in ${local_ips}; do
if [[ "${ip}" == "192.168.73.21" ]]; then
yum install -y numactl
exit 0
fi
done

根据ptk checkos -f config.yaml执行的结果，可通过如下方式查看具体的告警信息。

[root@opensource-db mogdb]# ptk checkos -i A16 --detail
INFO[2022-12-01T21:10:31.360] prechecking dependent tools...               
INFO[2022-12-01T21:10:31.442] all checkers finished                        
INFO[2022-12-01T21:10:31.442] Time elapsed: 0s                             
# Check Results
              Item              |  Level   |                              Message                                
--------------------------------+----------+------------------------------------------------------------
A16.Check_CPU_Instruction_Set | Abnormal | [192.168.73.21] [PTK-508001] not found cpu instruction set: [bmi2]  
Total count 1, abnormal count 1, warning count 0
Failed to check os, can’t perform installation unless fix all the abnormal items
You can use 'ptk checkos -i ITEM --detail' to get detail message
Please check root_fix_os.[TIMESTAMP].sh for commands to resolve.

# 出现该告警的原因是我当前数据库服务器无法查询到cpu的bmi2信息

3.5 执行安装

对于预检查的 Abnormal告警未设置bmi2信息，本次选择采用如下安装方式暂时忽略。

-- root 用户执行
[root@opensource-db ~]# cd /opt/software/mogdb/
[root@opensource-db mogdb]# ptk install --assumeyes \
> --pkg /opt/software/mogdb/MogDB-3.0.3-CentOS-x86_64.tar.gz \
> --skip-check-distro --skip-check-os --file=/opt/software/mogdb/config.yaml
# 执行过程及结果如下
INFO[2022-12-01T21:36:45.015] PTK Version: 0.5.4 release                   
INFO[2022-12-01T21:36:45.015] load config from /opt/software/mogdb/config.yaml 
INFO[2022-12-01T21:36:45.027] skip check os                                
INFO[2022-12-01T21:36:45.027] skip check distro                            
INFO[2022-12-01T21:36:45.027] start check user ...                         
INFO[2022-12-01T21:36:45.035] check user success                           
INFO[2022-12-01T21:36:45.035] start check port ...                         
INFO[2022-12-01T21:36:45.122] check port success                           
INFO[2022-12-01T21:36:45.122] start prepare installation package ...       
INFO[2022-12-01T21:36:45.123] installation package is ready                
INFO[2022-12-01T21:36:45.123] start validate installation package ...      
INFO[2022-12-01T21:36:47.221] parsed kernel package name: MogDB-3.0.3-CentOS-64bit.tar.gz 
INFO[2022-12-01T21:36:50.750] db product: MogDB, version: 3.0.3, number: 92.605, commit_id: 23ba838d 
INFO[2022-12-01T21:36:50.750] validate installation package success        
INFO[2022-12-01T21:36:50.750] start complete the configuration ...         
Please enter db password (8~16 characters):     -- 设置db数据库口令 如 Passw0rd@1234
Retype db password:   -- 再次输入相同口令
INFO[2022-12-01T21:40:09.124] complete the configuration success           
INFO[2022-12-01T21:40:09.125] start distribute installation package ...    
INFO[2022-12-01T21:40:09.282] distrubite packages success                  
INFO[2022-12-01T21:40:09.282] start setup db ...                           
INFO[2022-12-01T21:40:09.292] [192.168.73.21][omm] create os user omm, group omm 
INFO[2022-12-01T21:40:09.612] [192.168.73.21][omm] set ulimit configs      
INFO[2022-12-01T21:40:09.619] [192.168.73.21][omm] set user omm profiles   
INFO[2022-12-01T21:40:09.912] [192.168.73.21][omm] check or set C library  
INFO[2022-12-01T21:40:09.921] [192.168.73.21][omm] make dir(s): /db/mogdb/tool,/db/mogdb/tool/ptk_tool/bin 
INFO[2022-12-01T21:40:10.164] [192.168.73.21][omm] decompress MogDB-3.0.3-CentOS-x86_64.tar.gz to dir /db/mogdb/tool 
INFO[2022-12-01T21:40:11.340] [192.168.73.21][omm] decompress *-om.tar.gz to dir /db/mogdb/tool 
INFO[2022-12-01T21:40:11.897] [192.168.73.21][omm] try to fix psutil python lib 
WARN[2022-12-01T21:40:11.903] [192.168.73.21][omm] 
Not found python3.6 or 3.7, skip fix psutil dynamic lib, 
please install proper python and fix it manually or reinstall by ptk
if you don't fix this, it will cause that gs_om and cm_ctl cannot run properly, but not ptk and database 
INFO[2022-12-01T21:40:11.903] [192.168.73.21][omm] write file /db/mogdb/tool/ptk_tool/bin/README.md 
INFO[2022-12-01T21:40:11.935] [192.168.73.21][omm] write file /db/mogdb/tool/ptk_tool/bin/pscp 
INFO[2022-12-01T21:40:11.963] [192.168.73.21][omm] write file /db/mogdb/tool/ptk_tool/bin/pssh 
INFO[2022-12-01T21:40:11.988] [192.168.73.21][omm] write file /db/mogdb/tool/ptk_tool/bin/task_pool.py 
INFO[2022-12-01T21:40:12.014] [192.168.73.21][omm] change /db/mogdb/tool owner to omm 
INFO[2022-12-01T21:40:12.032] [192.168.73.21][omm] make dir(s): /db/mogdb/app 
INFO[2022-12-01T21:40:12.115] [192.168.73.21][omm] decompress MogDB-3.0.3-CentOS-64bit.tar.gz to dir /db/mogdb/app 
INFO[2022-12-01T21:40:15.455] [192.168.73.21][omm] fix dynamic linker for gs_initdb 
INFO[2022-12-01T21:40:15.513] [192.168.73.21][omm] fix dynamic linker for mogdb 
INFO[2022-12-01T21:40:15.575] [192.168.73.21][omm] change /db/mogdb/app owner to omm 
INFO[2022-12-01T21:40:15.591] [192.168.73.21][omm] make dir(s): /db/mogdb/log/gs_profile,/db/mogdb/log/pg_log,/db/mogdb/log/pg_audit,/db/mogdb/log/bin,/db/mogdb/log/pg_log/dn_6001,/db/mogdb/log/pg_audit/dn_6001 
INFO[2022-12-01T21:40:16.386] [192.168.73.21][omm] make dir(s): /db/mogdb/tmp 
INFO[2022-12-01T21:40:16.484] [192.168.73.21][omm] save version to upgrade_version 
INFO[2022-12-01T21:40:16.548] [192.168.73.21][omm] create file cluster_manual_start 
INFO[2022-12-01T21:40:16.592] [192.168.73.21][omm] generate cluster_static_config file 
INFO[2022-12-01T21:40:16.604] [192.168.73.21][omm] change /db/mogdb/app/bin/cluster_static_config owner to omm 
INFO[2022-12-01T21:40:16.609] [192.168.73.21][omm] make dir(s): /db/mogdb/data 
INFO[2022-12-01T21:40:16.699] [192.168.73.21][omm] change /db/mogdb/data owner to omm 
INFO[2022-12-01T21:40:16.704] [192.168.73.21][omm] the database is initializing, please wait a few minutes 
INFO[2022-12-01T21:40:39.107] [192.168.73.21][omm] config postgresql.conf  
INFO[2022-12-01T21:40:39.220] [192.168.73.21][omm] config pg_hba.conf      
INFO[2022-12-01T21:40:39.277] setup db success                             
INFO[2022-12-01T21:40:39.277] generate certification files                 
INFO[2022-12-01T21:40:39.780] download certification files                 
INFO[2022-12-01T21:40:39.951] certification files setup success            
INFO[2022-12-01T21:40:39.951] start build ssh trust ...                    
INFO[2022-12-01T21:40:40.094] ssh trust build success                      
INFO[2022-12-01T21:40:40.095] start launch db ...                          
INFO[2022-12-01T21:40:40.095] [192.168.73.21][omm] start db by gs_ctl ...  
INFO[2022-12-01T21:40:40.095] [192.168.73.21][omm] the database is starting, please wait a few minutes 
INFO[2022-12-01T21:40:42.791] [192.168.73.21][omm] start db success        
INFO[2022-12-01T21:40:42.791] [192.168.73.21][omm] start alter db initial password ... 
INFO[2022-12-01T21:40:42.904] [192.168.73.21][omm] alter db password success 
INFO[2022-12-01T21:40:42.904] launch db success                            
INFO[2022-12-01T21:40:42.904] clear temp dirs ...                          
INFO[2022-12-01T21:40:42.938] clear temp dirs success                      
INFO[2022-12-01T21:40:42.938] Time elapsed: 3m58s                          

  cluste_name |     host      | user | port  |    status     | message  
--------------+---------------+------+-------+---------------+----------
  mogdb       | 192.168.73.21 | omm  | 26000 | start_success | success

3.6 查看实例信息


[root@opensource-db mogdb]# ptk ls
  cluster_name |  id  |        addr         | user |    data_dir    |          db_version          |     create_time     | comment  
---------------+------+---------------------+------+----------------+------------------------------+----
  mogdb        | 6001 | 192.168.73.21:26000 | omm  | /db/mogdb/data | MogDB 3.0.3 (build 23ba838d) | 2022-12-01 21:40:09 |

image20221201214351956.png

3.7 访问数据库

3.7.1 访问数据库

[root@opensource-db mogdb]# su - omm
Last login: Thu Dec  1 21:47:17 CST 2022 on pts/0
[omm@opensource-db ~]$ gsql -d postgres -p 26000
gsql ((MogDB 3.0.3 build 23ba838d) compiled at 2022-10-22 09:50:41 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

MogDB=# \l
                                 List of databases
   Name    | Owner | Encoding | Collate | Ctype | Access privileges | Compatibility 
-----------+-------+----------+---------+-------+-------------------+---------------
 postgres  | omm   | UTF8     | C       | C     |                   | A
 template0 | omm   | UTF8     | C       | C     | =c/omm           +| A
           |       |          |         |       | omm=CTc/omm       | 
 template1 | omm   | UTF8     | C       | C     | =c/omm           +| A
           |       |          |         |       | omm=CTc/omm       | 
(3 rows)

MogDB=#

image20221201214933692.png

可以看到MogDB的访问方式和openGauss一样。

3.7.2 查询数据库信息

查询数据库版本信息

[omm@opensource-db ~]$ gsql -d postgres -p 26000
gsql ((MogDB 3.0.3 build 23ba838d) compiled at 2022-10-22 09:50:41 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

MogDB=# show server_version;
 server_version 
----------------
 9.2.4
(1 row)

MogDB=# SELECT * FROM pg_settings WHERE NAME='server_version';
      name      | setting | unit |    category    |        short_desc         | extra_desc | context  | vartype | source  | min_val | max_val | enumvals | boot_val | reset_val | sourcefile | sourceline 
----------------+---------+------+----------------+---------------------------+------------+----------+---------+---------+---------+---------+----------+----------+-----------+------------+------------
 server_version | 9.2.4   |      | Preset Options | Shows the server version. |            | internal | string  | default |         |         |          | 9.2.4    | 9.2.4     |            |           
(1 row)

image.png

可以看到MogDB 3.0 同 openGauss 3.0 一样也是基于 postgres 9.2.4 基础上开发的。

查看当前数据库信息

[omm@opensource-db ~]$ gsql -d postgres -p 26000
gsql ((MogDB 3.0.3 build 23ba838d) compiled at 2022-10-22 09:50:41 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

MogDB=# \l
                                 List of databases
   Name    | Owner | Encoding | Collate | Ctype | Access privileges | Compatibility 
-----------+-------+----------+---------+-------+-------------------+---------------
 postgres  | omm   | UTF8     | C       | C     |                   | A
 template0 | omm   | UTF8     | C       | C     | =c/omm           +| A
           |       |          |         |       | omm=CTc/omm       | 
 template1 | omm   | UTF8     | C       | C     | =c/omm           +| A
           |       |          |         |       | omm=CTc/omm       | 
(3 rows)
MogDB=# \db
      List of tablespaces
    Name    | Owner | Location 
------------+-------+----------
 pg_default | omm   | 
 pg_global  | omm   | 
(2 rows)

MogDB 数据库下也是含有三个数据库，默认postgres数据库和两个模板库。和openGauss一样有两个默认表空间。

image.png

MogDB目录结构

[root@opensource-db ~]# cd /db/mogdb/data
[root@opensource-db data]# ll
total 4976
drwx------ 6 omm omm      78 Dec  1 21:40 base
-rw------- 1 omm omm    4407 Dec  1 21:40 cacert.pem
-rw------- 1 omm omm      72 Dec  1 21:40 gaussdb.state
drwx------ 2 omm omm    4096 Dec  1 21:40 global
-rw------- 1 omm omm     354 Dec  1 21:40 gs_gazelle.conf
-rw------- 1 omm omm 4915200 Dec  1 21:40 gswlm_userinfo.cfg
-rw------- 1 omm omm   20218 Dec  1 21:40 mot.conf
drwx------ 2 omm omm      34 Dec  1 21:40 pg_clog
drwx------ 2 omm omm      34 Dec  1 21:40 pg_csnlog
-rw------- 1 omm omm       0 Dec  1 21:40 pg_ctl.lock
drwx------ 2 omm omm      10 Dec  1 21:40 pg_errorinfo
-rw------- 1 omm omm    4583 Dec  1 21:40 pg_hba.conf
-rw------- 1 omm omm    4583 Dec  1 21:40 pg_hba.conf.bak
-rw------- 1 omm omm    1024 Dec  1 21:40 pg_hba.conf.lock
-rw------- 1 omm omm    1636 Dec  1 21:40 pg_ident.conf
drwx------ 4 omm omm      51 Dec  1 21:40 pg_llog
drwx------ 2 omm omm      10 Dec  1 21:40 pg_location
drwx------ 2 omm omm      43 Dec  2 09:40 pg_logical
drwx------ 4 omm omm      48 Dec  1 21:40 pg_multixact
drwx------ 2 omm omm      34 Dec  1 21:40 pg_notify
drwx------ 2 omm omm      10 Dec  1 21:40 pg_replslot
drwx------ 2 omm omm      10 Dec  1 21:40 pg_serial
drwx------ 2 omm omm      10 Dec  1 21:40 pg_snapshots
drwx------ 2 omm omm      33 Dec  2 09:40 pg_stat_tmp
drwx------ 2 omm omm      10 Dec  1 21:40 pg_tblspc
drwx------ 2 omm omm      10 Dec  1 21:40 pg_twophase
-rw------- 1 omm omm       4 Dec  1 21:40 PG_VERSION
drwx------ 3 omm omm     180 Dec  2 05:41 pg_xlog
-rw------- 1 omm omm   34640 Dec  1 21:40 postgresql.conf
-rw------- 1 omm omm   34640 Dec  1 21:40 postgresql.conf.bak
-rw------- 1 omm omm    1024 Dec  1 21:40 postgresql.conf.lock
-rw------- 1 omm omm      61 Dec  1 21:40 postmaster.opts
-rw------- 1 omm omm      72 Dec  1 21:40 postmaster.pid
-rw------- 1 omm omm       0 Dec  1 21:40 postmaster.pid.lock
-rw------- 1 omm omm    4410 Dec  1 21:40 server.crt
-rw------- 1 omm omm    1766 Dec  1 21:40 server.key
-rw------- 1 omm omm      56 Dec  1 21:40 server.key.cipher
-rw------- 1 omm omm      24 Dec  1 21:40 server.key.rand
drwx------ 5 omm omm      87 Dec  1 21:40 undo

MogDB的PGDATA目录下和openGauss的PGDATA目录下和openGauss的PGDATA相同。

image.png

墨力计划墨力原创作者计划opengauss训练营学习心得mogdbopengauss
最后修改时间：2022-12-05 09:36:09
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论