一、安装环境准备
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 | grep rdtscp命令查看是否支持rdtscp指令集。 |
| bmi2指令集（CentOS） | 执行lscpu | grep bmi2命令查看是否支持bmi2指令集。 |
| 工具 | 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链接下载地址，下载对应操作系统数据库安装包。
[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 |
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=#
可以看到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)
可以看到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一样有两个默认表空间。
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相同。
最后修改时间：2022-12-05 09:36:09
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
