openeuler 2203发布后，自身所带的python版本也从3.7换成了3.9。openGauss/Mogdb目前适配的是3.7版本，要安装数据库，需要再安装3.7版本，以前尝试手工编译3.7.12，在MogDB安装最后一步，启动数据库失败。
经过测试，用miniconda管理python版本，顺利安装了MogDB3.0,下面是操作过程：
本次测试用vbox的三个虚拟机测试Mogdb3.0集群，地址分别是192.168.56.20/21/22
操作系统版本
[root@eu1 mogdb]# cat /etc/os-release
NAME="openEuler"
VERSION="22.03 LTS"
ID="openEuler"
VERSION_ID="22.03"
PRETTY_NAME="openEuler 22.03 LTS"
ANSI_COLOR="0;31"
获取miniconda
wget https://repo.anaconda.com/miniconda/Miniconda3-py37_4.12.0-Linux-x86_64.sh
执行sh Miniconda3-py37_4.12.0-Linux-x86_64.sh安装
因在数据库安装过程中用到root用户和omm用户，所以安装过程中另选安装目录，这里放在/opt/miniconda3下，以便所用户都可以用。
安装后在root用户的文件中增加了以下内容：
# >>> conda initialize >>>
# !! Contents within this block are managed by ‘conda init’ !!
__conda_setup="$(’/opt/miniconda3/bin/conda’ ‘shell.bash’ ‘hook’ 2> /dev/null)"
if [ ? -eq 0 ]; then eval "__conda_setup"
else
if [ -f “/opt/miniconda3/etc/profile.d/conda.sh” ]; then
. “/opt/miniconda3/etc/profile.d/conda.sh”
else
export PATH="/opt/miniconda3/bin:$PATH"
fi
fi
unset __conda_setup
# <<< conda initialize <<<
将以上内容复制到/etc/profile中，方便所有用户使用。
重复登录后python版本
python3 -V
Python 3.7.11
编辑mogdb的配置文件config.yaml
global:
cluster_name: "MogDB3.0"
user: "omm"
group: "dbgrp"
db_password: "pTk6M2U5YzhiYmI8RT49PUM+PXE2RFRXMVJ3NjVXM2llM0xhWU9hQlZ4bEU1cGdVTTZyRGJBeHRRTGZpZjg="
db_port: 26000
cm_server_port: 15300
base_dir: "/opt/mogdb"
app_dir: "/opt/mogdb/app"
log_dir: "/opt/mogdb/log"
data_dir: "/data/mogdb"
tool_dir: "/opt/mogdb/tool"
cm_dir: "/opt/mogdb/cm"
ssh_option:
port: 22
user: root
password: "pTk6M2U5YzhiYmI8RT49PUM+PXE2RFRXMVJ3NjVXM2llM0xhWU9hQlZ4bEU1cGdVTTZyRGJBeHRRTGZpZjg="
db_servers:
- host: "192.168.56.20"
db_port: 26000
ha_port: 26001
role: "primary"
- host: "192.168.56.21"
db_port: 26000
ha_port: 26001
role: "standby"
- host: "192.168.56.22"
db_port: 26000
ha_port: 26001
role: "standby"
用ptk执行安装，记录如下
[root@eu1 ~]# ptk install -f config.yaml --install-cm
INFO[2022-09-21T17:30:27.458] no package specified, use online package: https://cdn-mogdb.enmotech.com/mogdb-media/3.0.2/MogDB-3.0.2-openEuler-x86_64.tar.gz
INFO[2022-09-21T17:30:27.458] start check operating system
INFO[2022-09-21T17:30:28.285] prechecking dependent tools...
INFO[2022-09-21T17:30:31.178] platform: openEuler_22.03_64bit host=192.168.56.22
INFO[2022-09-21T17:30:31.178] platform: openEuler_22.03_64bit host=192.168.56.20
INFO[2022-09-21T17:30:31.178] platform: openEuler_22.03_64bit host=192.168.56.21
INFO[2022-09-21T17:30:31.182] kernel version: 5.10.0-60.18.0.50.oe2203.x86_64 host=192.168.56.20
INFO[2022-09-21T17:30:31.440] kernel version: 5.10.0-60.18.0.50.oe2203.x86_64 host=192.168.56.21
INFO[2022-09-21T17:30:31.593] kernel version: 5.10.0-60.18.0.50.oe2203.x86_64 host=192.168.56.22
INFO[2022-09-21T17:30:31.874] locale: LANG=en_US.UTF-8 host=192.168.56.20
INFO[2022-09-21T17:30:32.076] locale: LANG=en_US.UTF-8 host=192.168.56.21
INFO[2022-09-21T17:30:32.327] locale: LANG=en_US.UTF-8 host=192.168.56.22
INFO[2022-09-21T17:30:32.332] timezone: +0800 host=192.168.56.20
INFO[2022-09-21T17:30:32.597] timezone: +0800 host=192.168.56.21
INFO[2022-09-21T17:30:32.756] timezone: +0800 host=192.168.56.22
INFO[2022-09-21T17:30:32.761] swap memory 0kB, total memory 3493536kB host=192.168.56.20
INFO[2022-09-21T17:30:33.011] swap memory 0kB, total memory 3493536kB host=192.168.56.21
INFO[2022-09-21T17:30:33.163] swap memory 0kB, total memory 3493536kB host=192.168.56.22
WARN[2022-09-21T17:30:33.265] vm.min_free_kbytes=112640, expect 174676 host=192.168.56.20
INFO[2022-09-21T17:30:33.300] check kernel.core_pattern host=192.168.56.20
INFO[2022-09-21T17:30:33.309] check removeIPC value host=192.168.56.20
WARN[2022-09-21T17:30:34.030] kernel.sem=32000 1024000000 500 32000, expect 250 6400000 1000 25600 host=192.168.56.22
WARN[2022-09-21T17:30:35.725] net.ipv4.tcp_syn_retries=6, expect 5 host=192.168.56.22
WARN[2022-09-21T17:30:36.153] net.core.netdev_max_backlog=1000, expect 65535 host=192.168.56.22
WARN[2022-09-21T17:30:36.601] net.core.rmem_max=212992, expect 21299200 host=192.168.56.22
WARN[2022-09-21T17:30:38.343] net.ipv4.tcp_wmem=4096 16384 4194304, expect 8192 250000 16777216 host=192.168.56.22
WARN[2022-09-21T17:30:38.909] vm.min_free_kbytes=112640, expect 174676 host=192.168.56.21
WARN[2022-09-21T17:30:39.199] net.ipv4.tcp_tw_reuse=2, expect 1 host=192.168.56.22
WARN[2022-09-21T17:30:39.622] net.ipv4.tcp_retries2=15, expect 12 host=192.168.56.22
WARN[2022-09-21T17:30:40.516] vm.min_free_kbytes=112640, expect 174676 host=192.168.56.22
WARN[2022-09-21T17:30:40.948] net.ipv4.tcp_keepalive_time=7200, expect 30 host=192.168.56.22
INFO[2022-09-21T17:30:41.007] check kernel.core_pattern host=192.168.56.21
WARN[2022-09-21T17:30:41.371] net.ipv4.tcp_rmem=4096 131072 6291456, expect 8192 250000 16777216 host=192.168.56.22
INFO[2022-09-21T17:30:41.517] check removeIPC value host=192.168.56.21
WARN[2022-09-21T17:30:42.187] net.ipv4.tcp_keepalive_intvl=75, expect 30 host=192.168.56.22
WARN[2022-09-21T17:30:42.582] net.core.wmem_default=212992, expect 21299200 host=192.168.56.22
WARN[2022-09-21T17:30:42.969] net.core.rmem_default=212992, expect 21299200 host=192.168.56.22
WARN[2022-09-21T17:30:43.373] net.ipv4.tcp_max_syn_backlog=256, expect 65535 host=192.168.56.22
WARN[2022-09-21T17:30:43.794] net.ipv4.tcp_retries1=3, expect 5 host=192.168.56.22
WARN[2022-09-21T17:30:44.193] net.core.somaxconn=4096, expect 65535 host=192.168.56.22
WARN[2022-09-21T17:30:45.406] net.core.wmem_max=212992, expect 21299200 host=192.168.56.22
INFO[2022-09-21T17:30:45.808] check kernel.core_pattern host=192.168.56.22
INFO[2022-09-21T17:30:46.625] check removeIPC value host=192.168.56.22
WARN[2022-09-21T17:30:49.979] device(sda) 'IO Request'=64, expect 256 host=192.168.56.20
WARN[2022-09-21T17:30:49.979] device(sr0) 'IO Request'=2, expect 256 host=192.168.56.20
WARN[2022-09-21T17:30:49.979] device(dm-0) 'IO Request'=128, expect 256 host=192.168.56.20
WARN[2022-09-21T17:30:50.233] device(dm-0) 'IO Request'=128, expect 256 host=192.168.56.21
WARN[2022-09-21T17:30:50.233] device(sda) 'IO Request'=64, expect 256 host=192.168.56.21
WARN[2022-09-21T17:30:50.389] device(sda) 'IO Request'=64, expect 256 host=192.168.56.22
WARN[2022-09-21T17:30:50.389] device(dm-0) 'IO Request'=128, expect 256 host=192.168.56.22
⣾ executing...global:
cluster_name: "MogDB3.0"
user: "omm"
group: "dbgrp"
db_password: "pTk6M2U5YzhiYmI8RT49PUM+PXE2RFRXMVJ3NjVXM2llM0xhWU9hQlZ4bEU1cGdVTTZyRGJBeHRRTGZpZjg="
db_port: 26000
cm_server_port: 15300
base_dir: "/opt/mogdb"
app_dir: "/opt/mogdb/app"
log_dir: "/opt/mogdb/log"
data_dir: "/data/mogdb"
tool_dir: "/opt/mogdb/tool"
cm_dir: "/opt/mogdb/cm"
ssh_option:
port: 22
user: root
password: "pTk6M2U5YzhiYmI8RT49PUM+PXE2RFRXMVJ3NjVXM2llM0xhWU9hQlZ4bEU1cGdVTTZyRGJBeHRRTGZpZjg="
db_servers:
- host: "192.168.56.20"
db_port: 26000
ha_port: 26001
role: "primary"
- host: "192.168.56.21"
db_port: 26000
ha_port: 26001
role: "standby"
- host: "192.168.56.22"
db_port: 26000
ha_port: 26001
INFO[2022-09-21T17:31:00.511] check port 26000 host=192.168.56.22
INFO[2022-09-21T17:31:00.511] check port 26000 host=192.168.56.21
INFO[2022-09-21T17:31:00.511] check port 26000 host=192.168.56.20
INFO[2022-09-21T17:31:01.008] port 26000 is free host=192.168.56.20
INFO[2022-09-21T17:31:01.397] port 26000 is free host=192.168.56.21
INFO[2022-09-21T17:31:01.595] port 26000 is free host=192.168.56.22
INFO[2022-09-21T17:31:01.595] [stage=precheck]: start host=192.168.56.22
INFO[2022-09-21T17:31:01.595] check user 'omm' host=192.168.56.22
INFO[2022-09-21T17:31:01.595] [stage=precheck]: start host=192.168.56.20
INFO[2022-09-21T17:31:01.595] check user 'omm' host=192.168.56.20
⣾ executing...INFO[2022-09-21T17:31:01.595] [stage=precheck]: start host=192.168.56.21
INFO[2022-09-21T17:31:01.595] check user 'omm' host=192.168.56.21
INFO[2022-09-21T17:31:01.601] [stage=precheck]: successful host=192.168.56.20
INFO[2022-09-21T17:31:01.864] [stage=precheck]: successful host=192.168.56.21
INFO[2022-09-21T17:31:02.012] [stage=precheck]: successful host=192.168.56.22
=============================
global:
cluster_name: MogDB3.0
user: omm
group: dbgrp
db_port: 26000
base_dir: /opt/mogdb
app_dir: /opt/mogdb/app
data_dir: /data/mogdb
log_dir: /opt/mogdb/log
tool_dir: /opt/mogdb/tool
tmp_dir: /opt/mogdb/tmp
cm_dir: /opt/mogdb/cm
cm_server_port: 15300
cm_option:
dir: /opt/mogdb/cm
cm_server_port: 15300
cm_server_level: 1
db_service_vip: ""
db_servers:
- host: 192.168.56.20
db_port: 26000
ha_ips:
- 192.168.56.20
ha_port: 26001
role: primary
az_name: AZ1
az_priority: 1
- host: 192.168.56.21
db_port: 26000
ha_ips:
- 192.168.56.21
ha_port: 26001
role: standby
az_name: AZ1
az_priority: 1
- host: 192.168.56.22
db_port: 26000
ha_ips:
- 192.168.56.22
ha_port: 26001
role: standby
az_name: AZ1
az_priority: 1
=============================
Is cluster topo correct?[Y/N](default=Y) INFO[2022-09-21T17:31:02.013] downloading package...
> download MogDB-3.0.2-openEu...: 132.55 MiB / 134.29 MiB [---------->] 98.71% 10.18 MiB p/s ETA 0s
> download MogDB-3.0.2-openEu...: 134.29 MiB / 134.29 MiB [-------------] 100.00% 10.28 MiB p/s 13s
INFO[2022-09-21T17:31:22.214] validation: installation package is safe
INFO[2022-09-21T17:31:22.214] parse version.cfg from MogDB-3.0.2-openEuler-64bit.tar.gz
INFO[2022-09-21T17:31:24.144] detected db version: MogDB-3.0.2, number: 92.605, commit_id: 9bc79be5
INFO[2022-09-21T17:31:24.148] scp file from /root/.ptk/cache/MogDB-3.0.2-openEuler-x86_64.tar.gz to 192.168.56.20:/tmp/MogDB-3.0.2-openEuler-x86_64.tar.gz host=192.168.56.20
INFO[2022-09-21T17:31:24.148] scp file from /root/.ptk/cache/MogDB-3.0.2-openEuler-x86_64.tar.gz to 192.168.56.21:/tmp/MogDB-3.0.2-openEuler-x86_64.tar.gz host=192.168.56.21
INFO[2022-09-21T17:31:24.148] scp file from /root/.ptk/cache/MogDB-3.0.2-openEuler-x86_64.tar.gz to 192.168.56.22:/tmp/MogDB-3.0.2-openEuler-x86_64.tar.gz host=192.168.56.22
> upload MogDB-3.0.2-openEule...: 134.29 MiB / 134.29 MiB [------------] 100.00% 55.35 MiB p/s 2.6s
> upload MogDB-3.0.2-openEule...: 134.29 MiB / 134.29 MiB [------------] 100.00% 55.35 MiB p/s 2.5s
INFO[2022-09-21T17:31:26.926] [stage=initial]: start host=192.168.56.22
INFO[2022-09-21T17:31:26.926] [stage=initial]: start host=192.168.56.21
INFO[2022-09-21T17:31:26.926] [stage=initial]: start host=192.168.56.20
INFO[2022-09-21T17:31:26.932] total memory(3GB) is less then 4GB, use default guc config host=192.168.56.20
INFO[2022-09-21T17:31:26.932] create os user omm, group dbgrp host=192.168.56.20
INFO[2022-09-21T17:31:27.247] total memory(3GB) is less then 4GB, use default guc config host=192.168.56.21
INFO[2022-09-21T17:31:27.247] create os user omm, group dbgrp host=192.168.56.21
INFO[2022-09-21T17:31:27.364] set ulimits host=192.168.56.20
INFO[2022-09-21T17:31:27.370] set user omm profiles host=192.168.56.20
INFO[2022-09-21T17:31:27.413] total memory(3GB) is less then 4GB, use default guc config host=192.168.56.22
INFO[2022-09-21T17:31:27.413] create os user omm, group dbgrp host=192.168.56.22
INFO[2022-09-21T17:31:27.746] set ulimits host=192.168.56.21
INFO[2022-09-21T17:31:27.783] add c library /usr/local/lib to /etc/ld.so.conf.d/libc.conf host=192.168.56.20
INFO[2022-09-21T17:31:27.789] mkdir /opt/mogdb/tool host=192.168.56.20
INFO[2022-09-21T17:31:28.024] set user omm profiles host=192.168.56.21
INFO[2022-09-21T17:31:28.047] decompress MogDB-3.0.2-openEuler-x86_64.tar.gz to dir /opt/mogdb/tool host=192.168.56.20
INFO[2022-09-21T17:31:28.052] set ulimits host=192.168.56.22
INFO[2022-09-21T17:31:28.485] set user omm profiles host=192.168.56.22
INFO[2022-09-21T17:31:28.927] remove files /tmp/MogDB-3.0.2-openEuler-x86_64.tar.gz host=192.168.56.20
INFO[2022-09-21T17:31:28.943] decompress *-om.tar.gz to dir /opt/mogdb/tool host=192.168.56.20
INFO[2022-09-21T17:31:29.240] add c library /usr/local/lib to /etc/ld.so.conf.d/libc.conf host=192.168.56.21
INFO[2022-09-21T17:31:29.262] fix psutil lib host=192.168.56.20
WARN[2022-09-21T17:31:29.265]
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 proper,but not ptk and database host=192.168.56.20
INFO[2022-09-21T17:31:29.265] change /opt/mogdb/tool owner to omm host=192.168.56.20
INFO[2022-09-21T17:31:29.273] mkdir /opt/mogdb/app host=192.168.56.20
INFO[2022-09-21T17:31:29.562] mkdir /opt/mogdb/tool host=192.168.56.21
INFO[2022-09-21T17:31:29.766] decompress MogDB-3.0.2-openEuler-64bit.tar.gz to dir /opt/mogdb/app host=192.168.56.20
INFO[2022-09-21T17:31:29.940] add c library /usr/local/lib to /etc/ld.so.conf.d/libc.conf host=192.168.56.22
INFO[2022-09-21T17:31:30.424] mkdir /opt/mogdb/tool host=192.168.56.22
INFO[2022-09-21T17:31:30.842] decompress MogDB-3.0.2-openEuler-x86_64.tar.gz to dir /opt/mogdb/tool host=192.168.56.21
INFO[2022-09-21T17:31:31.935] decompress MogDB-3.0.2-openEuler-x86_64.tar.gz to dir /opt/mogdb/tool host=192.168.56.22
INFO[2022-09-21T17:31:32.318] fix dynamic library for gs_initdb host=192.168.56.20
INFO[2022-09-21T17:31:32.575] fix dynamic library for mogdb host=192.168.56.20
INFO[2022-09-21T17:31:32.813] change /opt/mogdb/app owner to omm host=192.168.56.20
INFO[2022-09-21T17:31:32.825] mkdir /opt/mogdb/log/gs_profile,/opt/mogdb/log/pg_log,/opt/mogdb/log/pg_audit,/opt/mogdb/log/bin,/opt/mogdb/log/pg_log/dn_6001,/opt/mogdb/log/pg_audit/dn_6001,/opt/mogdb/log/pg_log/dn_6002,/opt/mogdb/log/pg_audit/dn_6002,/opt/mogdb/log/pg_log/dn_6003,/opt/mogdb/log/pg_audit/dn_6003 host=192.168.56.20
INFO[2022-09-21T17:31:32.954] remove files /tmp/MogDB-3.0.2-openEuler-x86_64.tar.gz host=192.168.56.21
INFO[2022-09-21T17:31:33.245] decompress *-om.tar.gz to dir /opt/mogdb/tool host=192.168.56.21
INFO[2022-09-21T17:31:33.259] remove files /tmp/MogDB-3.0.2-openEuler-x86_64.tar.gz host=192.168.56.22
INFO[2022-09-21T17:31:33.730] decompress *-om.tar.gz to dir /opt/mogdb/tool host=192.168.56.22
INFO[2022-09-21T17:31:33.858] fix psutil lib host=192.168.56.21
WARN[2022-09-21T17:31:34.143]
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 proper,but not ptk and database host=192.168.56.21
INFO[2022-09-21T17:31:34.143] change /opt/mogdb/tool owner to omm host=192.168.56.21
INFO[2022-09-21T17:31:34.428] mkdir /opt/mogdb/app host=192.168.56.21
INFO[2022-09-21T17:31:34.556] fix psutil lib host=192.168.56.22
INFO[2022-09-21T17:31:35.792] decompress MogDB-3.0.2-openEuler-64bit.tar.gz to dir /opt/mogdb/app host=192.168.56.21
INFO[2022-09-21T17:31:35.956] change /opt/mogdb/tool owner to omm host=192.168.56.22
INFO[2022-09-21T17:31:36.401] mkdir /opt/mogdb/app host=192.168.56.22
INFO[2022-09-21T17:31:38.215] decompress MogDB-3.0.2-openEuler-64bit.tar.gz to dir /opt/mogdb/app host=192.168.56.22
INFO[2022-09-21T17:31:38.645] fix dynamic library for gs_initdb host=192.168.56.21
INFO[2022-09-21T17:31:40.433] fix dynamic library for mogdb host=192.168.56.21
INFO[2022-09-21T17:31:41.235] fix dynamic library for gs_initdb host=192.168.56.22
INFO[2022-09-21T17:31:41.249] change /opt/mogdb/app owner to omm host=192.168.56.21
INFO[2022-09-21T17:31:41.323] mkdir /opt/mogdb/tmp host=192.168.56.20
INFO[2022-09-21T17:31:41.556] mkdir /opt/mogdb/log/gs_profile,/opt/mogdb/log/pg_log,/opt/mogdb/log/pg_audit,/opt/mogdb/log/bin,/opt/mogdb/log/pg_log/dn_6001,/opt/mogdb/log/pg_audit/dn_6001,/opt/mogdb/log/pg_log/dn_6002,/opt/mogdb/log/pg_audit/dn_6002,/opt/mogdb/log/pg_log/dn_6003,/opt/mogdb/log/pg_audit/dn_6003 host=192.168.56.21
INFO[2022-09-21T17:31:42.971] save version to /opt/mogdb/app/bin/upgrade_version host=192.168.56.20
INFO[2022-09-21T17:31:43.214] create cluster_manual_start file host=192.168.56.20
INFO[2022-09-21T17:31:43.301] fix dynamic library for mogdb host=192.168.56.22
INFO[2022-09-21T17:31:43.665] generate static config to /opt/mogdb/app/bin/cluster_static_config host=192.168.56.20
INFO[2022-09-21T17:31:44.438] change /opt/mogdb/app owner to omm host=192.168.56.22
INFO[2022-09-21T17:31:44.857] mkdir /opt/mogdb/log/gs_profile,/opt/mogdb/log/pg_log,/opt/mogdb/log/pg_audit,/opt/mogdb/log/bin,/opt/mogdb/log/pg_log/dn_6001,/opt/mogdb/log/pg_audit/dn_6001,/opt/mogdb/log/pg_log/dn_6002,/opt/mogdb/log/pg_audit/dn_6002,/opt/mogdb/log/pg_log/dn_6003,/opt/mogdb/log/pg_audit/dn_6003 host=192.168.56.22
INFO[2022-09-21T17:31:45.778] change /opt/mogdb/app/bin/cluster_static_config owner to omm host=192.168.56.20
INFO[2022-09-21T17:31:45.783] mkdir /data/mogdb host=192.168.56.20
INFO[2022-09-21T17:31:46.787] change /data/mogdb owner to omm host=192.168.56.20
INFO[2022-09-21T17:31:46.791] initial database host=192.168.56.20
INFO[2022-09-21T17:32:01.815] mkdir /opt/mogdb/tmp host=192.168.56.21
INFO[2022-09-21T17:32:03.054] save version to /opt/mogdb/app/bin/upgrade_version host=192.168.56.21
INFO[2022-09-21T17:32:03.669] create cluster_manual_start file host=192.168.56.21
INFO[2022-09-21T17:32:04.142] generate static config to /opt/mogdb/app/bin/cluster_static_config host=192.168.56.21
⣽ executing...INFO[2022-09-21T17:32:04.535] change /opt/mogdb/app/bin/cluster_static_config owner to omm host=192.168.56.21
INFO[2022-09-21T17:32:04.787] mkdir /data/mogdb host=192.168.56.21
INFO[2022-09-21T17:32:05.326] change /data/mogdb owner to omm host=192.168.56.21
INFO[2022-09-21T17:32:05.586] initial database host=192.168.56.21
INFO[2022-09-21T17:32:12.205] mkdir /opt/mogdb/tmp host=192.168.56.22
INFO[2022-09-21T17:32:13.797] save version to /opt/mogdb/app/bin/upgrade_version host=192.168.56.22
INFO[2022-09-21T17:32:14.622] create cluster_manual_start file host=192.168.56.22
INFO[2022-09-21T17:32:15.248] generate static config to /opt/mogdb/app/bin/cluster_static_config host=192.168.56.22
⣾ executing...INFO[2022-09-21T17:32:15.839] change /opt/mogdb/app/bin/cluster_static_config owner to omm host=192.168.56.22
INFO[2022-09-21T17:32:16.252] mkdir /data/mogdb host=192.168.56.22
INFO[2022-09-21T17:32:17.112] change /data/mogdb owner to omm host=192.168.56.22
INFO[2022-09-21T17:32:17.537] initial database host=192.168.56.22
INFO[2022-09-21T17:33:06.955] set 192.168.56.20 postgresql.conf host=192.168.56.20
INFO[2022-09-21T17:33:07.490] set 192.168.56.20 hba config host=192.168.56.20
INFO[2022-09-21T17:33:08.006] mkdir /opt/mogdb/log/cm/om_monitor,/opt/mogdb/cm,/opt/mogdb/cm/cm_server,/opt/mogdb/cm/cm_agent host=192.168.56.20
INFO[2022-09-21T17:33:10.508] decompress *-cm.tar.gz to dir /opt/mogdb/app host=192.168.56.20
INFO[2022-09-21T17:33:10.629] change /opt/mogdb/app owner to omm host=192.168.56.20
INFO[2022-09-21T17:33:10.640] copy /opt/mogdb/app/share/config/cm_server.conf.sample to /opt/mogdb/cm/cm_server/cm_server.conf host=192.168.56.20
INFO[2022-09-21T17:33:10.861] copy /opt/mogdb/app/share/config/cm_agent.conf.sample to /opt/mogdb/cm/cm_agent/cm_agent.conf host=192.168.56.20
INFO[2022-09-21T17:33:11.083] update config file /opt/mogdb/cm/cm_agent/cm_agent.conf: set unix_socket_directory to '/opt/mogdb/tmp' host=192.168.56.20
INFO[2022-09-21T17:33:11.090] update config file /opt/mogdb/cm/cm_agent/cm_agent.conf: set db_service_vip to host=192.168.56.20
INFO[2022-09-21T17:33:11.094] update config file /opt/mogdb/cm/cm_server/cm_server.conf: set datastorage_threshold_value_check to 99 host=192.168.56.20
INFO[2022-09-21T17:33:11.102] update config file /opt/mogdb/cm/cm_server/cm_server.conf: set enable_transaction_read_only to off host=192.168.56.20
INFO[2022-09-21T17:33:11.109] add user omm to cron.allow host=192.168.56.20
INFO[2022-09-21T17:33:11.113] set corntab: */1 * * * * [ -f ~/.profile ] && source ~/.profile; [ -f ~/.bashrc ] && source ~/.bashrc; source ~/.ptk_mogdb_env; nohup /opt/mogdb/app/bin/om_monitor -L /opt/mogdb/log/cm/om_monitor >/dev/null 2>&1 & host=192.168.56.20
INFO[2022-09-21T17:33:11.573] create certification authority files host=192.168.56.20
INFO[2022-09-21T17:33:12.067] set 192.168.56.21 postgresql.conf host=192.168.56.21
INFO[2022-09-21T17:33:12.093] move certification authority files to server host=192.168.56.20
INFO[2022-09-21T17:33:12.112] download certification authority files from host 192.168.56.20 host=192.168.56.20
INFO[2022-09-21T17:33:12.174] [stage=initial]: successful host=192.168.56.20
INFO[2022-09-21T17:33:12.672] set 192.168.56.21 hba config host=192.168.56.21
INFO[2022-09-21T17:33:13.195] mkdir /opt/mogdb/log/cm/om_monitor,/opt/mogdb/cm,/opt/mogdb/cm/cm_server,/opt/mogdb/cm/cm_agent host=192.168.56.21
INFO[2022-09-21T17:33:17.973] set 192.168.56.22 postgresql.conf host=192.168.56.22
INFO[2022-09-21T17:33:18.740] set 192.168.56.22 hba config host=192.168.56.22
INFO[2022-09-21T17:33:19.513] mkdir /opt/mogdb/log/cm/om_monitor,/opt/mogdb/cm,/opt/mogdb/cm/cm_server,/opt/mogdb/cm/cm_agent host=192.168.56.22
INFO[2022-09-21T17:33:19.769] decompress *-cm.tar.gz to dir /opt/mogdb/app host=192.168.56.21
INFO[2022-09-21T17:33:20.151] change /opt/mogdb/app owner to omm host=192.168.56.21
INFO[2022-09-21T17:33:20.427] copy /opt/mogdb/app/share/config/cm_server.conf.sample to /opt/mogdb/cm/cm_server/cm_server.conf host=192.168.56.21
WARN[2022-09-21T17:33:20.963] /home/omm/.bashrc: line 10: pyenv: command not found host=192.168.56.21
INFO[2022-09-21T17:33:20.964] copy /opt/mogdb/app/share/config/cm_agent.conf.sample to /opt/mogdb/cm/cm_agent/cm_agent.conf host=192.168.56.21
WARN[2022-09-21T17:33:21.447] /home/omm/.bashrc: line 10: pyenv: command not found host=192.168.56.21
INFO[2022-09-21T17:33:21.447] update config file /opt/mogdb/cm/cm_agent/cm_agent.conf: set unix_socket_directory to '/opt/mogdb/tmp' host=192.168.56.21
INFO[2022-09-21T17:33:21.710] update config file /opt/mogdb/cm/cm_agent/cm_agent.conf: set db_service_vip to host=192.168.56.21
INFO[2022-09-21T17:33:21.978] update config file /opt/mogdb/cm/cm_server/cm_server.conf: set datastorage_threshold_value_check to 99 host=192.168.56.21
INFO[2022-09-21T17:33:22.250] update config file /opt/mogdb/cm/cm_server/cm_server.conf: set enable_transaction_read_only to off host=192.168.56.21
INFO[2022-09-21T17:33:22.535] add user omm to cron.allow host=192.168.56.21
INFO[2022-09-21T17:33:22.838] set corntab: */1 * * * * [ -f ~/.profile ] && source ~/.profile; [ -f ~/.bashrc ] && source ~/.bashrc; source ~/.ptk_mogdb_env; nohup /opt/mogdb/app/bin/om_monitor -L /opt/mogdb/log/cm/om_monitor >/dev/null 2>&1 & host=192.168.56.21
INFO[2022-09-21T17:33:23.364] waiting for generate certification authority files... host=192.168.56.21
INFO[2022-09-21T17:33:23.364] upload certification authority files host=192.168.56.21
INFO[2022-09-21T17:33:25.912] move certification authority files to server host=192.168.56.21
INFO[2022-09-21T17:33:26.199] [stage=initial]: successful host=192.168.56.21
INFO[2022-09-21T17:33:28.923] decompress *-cm.tar.gz to dir /opt/mogdb/app host=192.168.56.22
INFO[2022-09-21T17:33:29.423] change /opt/mogdb/app owner to omm host=192.168.56.22
INFO[2022-09-21T17:33:29.827] copy /opt/mogdb/app/share/config/cm_server.conf.sample to /opt/mogdb/cm/cm_server/cm_server.conf host=192.168.56.22
INFO[2022-09-21T17:33:30.431] copy /opt/mogdb/app/share/config/cm_agent.conf.sample to /opt/mogdb/cm/cm_agent/cm_agent.conf host=192.168.56.22
INFO[2022-09-21T17:33:31.028] update config file /opt/mogdb/cm/cm_agent/cm_agent.conf: set unix_socket_directory to '/opt/mogdb/tmp' host=192.168.56.22
INFO[2022-09-21T17:33:31.416] update config file /opt/mogdb/cm/cm_agent/cm_agent.conf: set db_service_vip to host=192.168.56.22
INFO[2022-09-21T17:33:31.803] update config file /opt/mogdb/cm/cm_server/cm_server.conf: set datastorage_threshold_value_check to 99 host=192.168.56.22
INFO[2022-09-21T17:33:32.191] update config file /opt/mogdb/cm/cm_server/cm_server.conf: set enable_transaction_read_only to off host=192.168.56.22
INFO[2022-09-21T17:33:32.597] add user omm to cron.allow host=192.168.56.22
INFO[2022-09-21T17:33:33.011] set corntab: */1 * * * * [ -f ~/.profile ] && source ~/.profile; [ -f ~/.bashrc ] && source ~/.bashrc; source ~/.ptk_mogdb_env; nohup /opt/mogdb/app/bin/om_monitor -L /opt/mogdb/log/cm/om_monitor >/dev/null 2>&1 & host=192.168.56.22
INFO[2022-09-21T17:33:33.924] waiting for generate certification authority files... host=192.168.56.22
INFO[2022-09-21T17:33:33.924] upload certification authority files host=192.168.56.22
INFO[2022-09-21T17:33:37.285] move certification authority files to server host=192.168.56.22
INFO[2022-09-21T17:33:37.691] [stage=initial]: successful host=192.168.56.22
INFO[2022-09-21T17:33:37.691] start make ssh mutual trust for omm
INFO[2022-09-21T17:33:40.416] make ssh mutual trust successfully
INFO[2022-09-21T17:33:40.416] [stage=launch]: start host=192.168.56.22
INFO[2022-09-21T17:33:40.416] start om_monitor host=192.168.56.22
INFO[2022-09-21T17:33:40.416] [stage=launch]: start host=192.168.56.20
INFO[2022-09-21T17:33:40.416] [stage=launch]: start host=192.168.56.21
INFO[2022-09-21T17:33:40.416] start om_monitor host=192.168.56.20
⣾ executing...INFO[2022-09-21T17:33:40.416] start om_monitor host=192.168.56.21
INFO[2022-09-21T17:33:40.663] start 192.168.56.20 database by cm_ctl host=192.168.56.20
INFO[2022-09-21T17:33:40.945] waiting for primary startup... host=192.168.56.21
INFO[2022-09-21T17:33:41.105] waiting for primary startup... host=192.168.56.22
INFO[2022-09-21T17:41:08.049] [stage=launch]: successful host=192.168.56.20
INFO[2022-09-21T17:41:08.049] [stage=launch]: successful host=192.168.56.22
INFO[2022-09-21T17:41:08.050] [stage=launch]: successful host=192.168.56.21
INFO[2022-09-21T17:41:08.050] Time elapsed: 10m45s
cluste_name | host | user | port | stage | status | message
--------------+---------------+------+-------+--------+---------------+----------
MogDB3.0 | 192.168.56.20 | omm | 26000 | launch | start_success | success
| 192.168.56.22 | omm | 26000 | launch | start_success | success
| 192.168.56.21 | omm | 26000 | launch | start_success | success
安装成功。
用gs_om查看集群状态
[omm@eu1 ~]$ gs_om -t status --detail
[ CMServer State ]
node node_ip instance state
-----------------------------------------------------------
1 eu1 192.168.56.20 1 /opt/mogdb/cm/cm_server Primary
2 eu2 192.168.56.21 2 /opt/mogdb/cm/cm_server Standby
3 eu3 192.168.56.22 3 /opt/mogdb/cm/cm_server Standby
[ Cluster State ]
cluster_state : Normal
redistributing : No
balanced : No
current_az : AZ_ALL
[ Datanode State ]
node node_ip instance state
---------------------------------------------------------
1 eu1 192.168.56.20 6001 /data/mogdb P Standby Normal
2 eu2 192.168.56.21 6002 /data/mogdb S Primary Normal
3 eu3 192.168.56.22 6003 /data/mogdb S Standby Normal
使用ptk命令查看集群状态
[root@eu1 ~]# ptk cluster status -n MogDB3.0
[ Cluster State ]
database_version : MogDB-3.0.2
cluster_name : MogDB3.0
cluster_state : Normal
current_az : AZ_ALL
[ CMServer State ]
node | node_ip | instance | state
--------±--------------±---------±---------
1 eu1 | 192.168.56.20 | 1 | Primary
2 eu2 | 192.168.56.21 | 2 | Standby
3 eu3 | 192.168.56.22 | 3 | Standby
[ Datanode State ]
id | ip | port | user | instance | db_role | state
-------±--------------±------±-----±---------±--------±--------
6002 | 192.168.56.21 | 26000 | omm | dn_6002 | primary | Normal
6001 | 192.168.56.20 | 26000 | omm | dn_6001 | standby | Normal
6003 | 192.168.56.22 | 26000 | omm | dn_6003 | standby | Normal
停止集群
[root@eu1 ~]# ptk cluster stop -n MogDB3.0
INFO[2022-09-21T18:12:12.082] Operating: Stopping.
INFO[2022-09-21T18:12:12.083] =========================================
INFO[2022-09-21T18:12:38.867] stopping cluster successfully
INFO[2022-09-21T18:12:38.867] =========================================
INFO[2022-09-21T18:12:38.867] Successfully stoped.
INFO[2022-09-21T18:12:38.867] Operation succeeded: Stop.
启动集群
[root@eu1 ~]# ptk cluster start -n MogDB3.0
INFO[2022-09-21T18:16:14.551] Operating: Starting.
INFO[2022-09-21T18:16:14.551] =========================================
INFO[2022-09-21T18:16:40.118] starting cluster successfully
INFO[2022-09-21T18:16:45.021] =========================================
INFO[2022-09-21T18:16:45.021] Successfully started.
INFO[2022-09-21T18:16:45.021] Operation succeeded: Start.
再看集群状态
[root@eu1 ~]# ptk cluster status -n MogDB3.0
[ Cluster State ]
database_version : MogDB-3.0.2
cluster_name : MogDB3.0
cluster_state : Normal
current_az : AZ_ALL
[ CMServer State ]
node | node_ip | instance | state
--------±--------------±---------±---------
1 eu1 | 192.168.56.20 | 1 | Primary
2 eu2 | 192.168.56.21 | 2 | Standby
3 eu3 | 192.168.56.22 | 3 | Standby
[ Datanode State ]
id | ip | port | user | instance | db_role | state
-------±--------------±------±-----±---------±--------±--------
6002 | 192.168.56.21 | 26000 | omm | dn_6002 | primary | Normal
6001 | 192.168.56.20 | 26000 | omm | dn_6001 | standby | Normal
6003 | 192.168.56.22 | 26000 | omm | dn_6003 | standby | Normal
用CM命令查看集群状态
[omm@eu1 ~]$ cm_ctl query -v -C
[ CMServer State ]
node instance state
1 eu1 1 Primary
2 eu2 2 Standby
3 eu3 3 Standby
[ Cluster State ]
cluster_state : Normal
redistributing : No
balanced : No
current_az : AZ_ALL
[ Datanode State ]
node instance state | node instance state | node instance state
1 eu1 6001 P Standby Normal | 2 eu2 6002 S Primary Normal | 3 eu3 6003 S Standby Normal
停止一个节点，用iP出错
(base) [omm@eu1 ~]$ gs_om -t stop -mf -h 192.168.56.22
[GAUSS-51619] : The host name [192.168.56.22] is not in the cluster.
用hostname
(base) [omm@eu1 ~]$ gs_om -t stop -mf -h eu3
Stopping node.
=========================================
Successfully stopped node.
=========================================
End stop node.
现在集群状态
192.168.56.22上cm和datanode都停了，再启动该节点
(base) [omm@eu1 ~]$ gs_om -t start -h eu3
Starting node.
======================================================================
Successfully started node.
======================================================================
End start node.
Successfully started node.
登录数据库验证
数据库小版本升级了
上次做测试时版本
[mogdb@node1 ~]$ gsql -r
gsql ((MogDB 3.0.1 build 1a363ea9) compiled at 2022-08-05 17:31:04 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type “help” for help.
最后修改时间：2022-09-22 17:58:57
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
