震惊：使用PTK部署MogDB竟也能如此丝滑
一、安装环境准备
本次选择在集群环境规划的节点一节点使用PTK来部署MogDB集群，初期未创建omm数据库操作系统用户，通过PTK来创建omm用户及对应组。
本次部署一主两备环境，计划后期测试集群的增删节点。
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 |
-- 检查操作系统依赖包
-- root 用户【所有节点】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版本-- root 用户【所有节点】mkdir /usr/local/python3cd /usr/local/python3wget https://www.python.org/ftp/python/3.6.5/Python-3.6.5.tgztar -zxf Python-3.6.5.tgzcd /usr/local/python3/Python-3.6.5-- 不加CFLAGS=-fPIC，会在升级3.0的时候遇到编译问题./configure --prefix=/usr/local/python3 --enable-shared CFLAGS=-fPICmake && make installln -s /usr/local/python3/bin/python3 /usr/bin/python3ln -s /usr/local/python3/bin/pip3 /usr/bin/pip3-- 设置环境变量cat >>/etc/profile<<EOFexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/python3/binEOFsource /etc/profile
2.2 关闭操作系统防火墙
-- root 用户【所有节点】systemctl disable firewalld.servicesystemctl stop firewalld.servicesystemctl status firewalld.service
2.3 设置字符集参数
root 用户【所有节点】cat >>/etc/profile <<EOFexport LANG=en_US.UTF-8EOFsource /etc/profile# 检查字符集cat /etc/profile | grep LANGenv |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 用户【所有节点】-- 设置网卡为1500ifconfig 网卡名 mtu 1500-- 查看ifconfig -a |grep -i mtu
2.7 设置root用户远程登录
root 用户【所有节点】cat >>/etc/ssh/sshd_config<<EOFPermitRootLogin yesEOF检查cat /etc/ssh/sshd_config |grep PermitRootLogin
2.8 关闭透明大页
-- root 用户【所有节点】cat >> /etc/rc.d/rc.local<<EOFif test -f /sys/kernel/mm/transparent_hugepage/enabled;thenecho never > /sys/kernel/mm/transparent_hugepage/enabledfiif test -f /sys/kernel/mm/transparent_hugepage/defrag;thenecho never > /sys/kernel/mm/transparent_hugepage/defragfiEOF-- 查看是否关闭：cat /sys/kernel/mm/transparent_hugepage/enabledcat /sys/kernel/mm/transparent_hugepage/defrag
2.9 修改 Banner 配置
root 用户【所有节点】cat >>/etc/ssh/sshd_config<<EOFBanner noneEOF检查cat /etc/ssh/sshd_config | grep Banner重启生效systemctl restart sshd.service
三、安装MogDB集群
3.1 在线安装PTK
-- 本次选择在集群节点一节点在线安装最新版PTK-- root 用户 【节点一】[root@mogdb-db1 ~]# curl --proto '=https' --tlsv1.2 -sSf https://cdn-mogdb.enmotech.com/ptk/install.sh | shDownloading ptk package...Detected shell: bashShell profile: /root/.bash_profileptk has been added to PATH in /root/.bash_profileopen a new terminal or source /root/.bash_profile to active itInstalled path: /root/.ptk/bin/ptk-- 配置环境变量根据在线安装提示，重新打开一个会话窗口或执行 source /root/.bash_profile生效PTK环境变量[root@mogdb-db1 ~]# source /root/.bash_profile[root@mogdb-db1 ~]# more /root/.bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then. ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHexport PATH=/root/.ptk/bin:$PATH-- 查看PTK版本[root@mogdb-db1 ~]# ptk -vPTK Version: v0.5.5 releaseGo Version: go1.18.1Build Date: 2022-12-05T19:41:46Git Hash: 6c0ef5f
3.2 下载MogDB安装包
登陆https://www.mogdb.io/downloads/allDownload链接下载地址，下载对应操作系统数据库安装包。
-- root 用户 【节点一】[root@mogdb-db1 ~]# cd /opt/software/mogdb/[root@mogdb-db1 mogdb]# wget https://cdn-mogdb.enmotech.com/mogdb-media/3.0.3/MogDB-3.0.3-CentOS-x86_64.tar.gz--2022-12-07 11:22:41-- https://cdn-mogdb.enmotech.com/mogdb-media/3.0.3/MogDB-3.0.3-CentOS-x86_64.tar.gzResolving cdn-mogdb.enmotech.com (cdn-mogdb.enmotech.com)... 122.193.130.107Connecting to cdn-mogdb.enmotech.com (cdn-mogdb.enmotech.com)|122.193.130.107|:443... connected.HTTP request sent, awaiting response... 200 OKLength: 139260078 (133M) [application/gzip]Saving to: ‘MogDB-3.0.3-CentOS-x86_64.tar.gz’100%[=====================================================================================================] 139,260,078 21.4MB/s in 6.8s2022-12-07 11:22:48 (19.6 MB/s) - ‘MogDB-3.0.3-CentOS-x86_64.tar.gz’ saved [139260078/139260078]
3.3 创建config.yaml配置文件
PTK安装集群环境需配置config.yaml集群配置文件。
参照官网可使用ptk template > config.yaml方式进行手动配置生成集群yaml文件；
也可以采用ptk template create根据提示交互式一步步生成集群ymal文件。
PTK详细用法及参数说明请参阅官网文档：https://docs.mogdb.io/zh/ptk/v0.5/usage-config
加密 root口令mogdb]# ptk encrypt rootroot: pTk6YjEwYWI2ZGE9PjxDPUJAQ2VmYzZpOHBHMUdzSWd0dTRWUmNpM1hobDNtSmRxdlMya1kzOGxkMGxzcTA=加密 db_password 口令mogdb]# ptk encrypt Mogdb@passwd: pTk6YjQ4ZjhkYTY9PjxDPUJARFhFWGVjNUV1SFVCMVJQWi1xWFNXcnhwN2lYN184SUpvSG1fZS0xNjV6SW8=root 用户 【节点一】~]# cd /opt/software/mogdb/创建config.yaml配置文件config.yaml <<EOFglobal:集群名称 -->cluster_name: cluster_mogdb运行数据库操作系统用户名 -->user: omm运行数据库的操作系统用户组 -->group: dbgrp数据库的初始用户密码，若配置文件中未填写，会在安装时通过交互式要求输入 -->db_password: pTk6YjQ4ZjhkYTY9PjxDPUJARFhFWGVjNUV1SFVCMVJQWi1xWFNXcnhwN2lYN184SUpvSG1fZS0xNjV6SW8=数据库安装的基础目录，指定该目录后，app_dir，data_dir，log_dir和tool_dir 参数中若未配置的，PTK 会自动在该安装目录下会创建对应的目录 -->base_dir: /opt/mogdbCM 配置信息 (可选) -->cm_option:CM 安装目录 -->dir: /opt/mogdb/cmcm server 监听端口 -->cm_server_port: 15300数据库提供服务的虚拟IP -->db_service_vip: ""集群内的数据库实例服务器配置信息 -->db_servers:数据库实例服务器 IP (仅支持 IPv4) -->host: 192.168.17.112数据库端口 -->db_port: 27000数据库主备实例IP地址列表 -->ha_ips:-数据库主备实例日志传输端口 -->ha_port: 27001数据库实例角色，若不填，PTK 会随机选择一个实例作为主库，其余自动为备库 -->role: primaryAvailable Zone (可用区) 名称 -->az_name: BJ可用区使用的优先级，数值越小优先级越高 -->az_priority: 1SSH 登录信息，登录用户需为 **root** 或者具有 sudo 权限的用户 -->ssh_option:SSH 登录用户端口 -->port: 22SSH 登录用户账号 -->user: rootSSH 登录用户账号口令 -->password: pTk6YjEwYWI2ZGE9PjxDPUJAQ2VmYzZpOHBHMUdzSWd0dTRWUmNpM1hobDNtSmRxdlMya1kzOGxkMGxzcTA=SSH 执行单条命令时的超时时间 -->conn_timeout: 5m0s跳板服务器登录信息，如果目标服务器无法直连时，支持通过中间跳板机方式连接 -->exec_timeout: 5m0shost: 192.168.17.113db_port: 27000ha_ips:-ha_port: 27001role: standbyaz_name: SHaz_priority: 2ssh_option:port: 22user: rootpassword: pTk6YjEwYWI2ZGE9PjxDPUJAQ2VmYzZpOHBHMUdzSWd0dTRWUmNpM1hobDNtSmRxdlMya1kzOGxkMGxzcTA=conn_timeout: 5m0sexec_timeout: 5m0shost: 192.168.17.139db_port: 27000ha_ips:-ha_port: 27001cascade_standby 表示级联备库 -->role: cascade_standby当实例角色为 cascade_standby 时，该字段表示要跟随的上游备库 IP -->upstream_host: 192.168.17.113注意级联备库的az_name要和standby备库相同，否则集群部署完毕后会显示级联备库状态为Need Repar(Connecting...)az_name: SH注意级联备库的az_priority要和standby备库相同az_priority: 2ssh_option:port: 22user: rootpassword: pTk6YjEwYWI2ZGE9PjxDPUJAQ2VmYzZpOHBHMUdzSWd0dTRWUmNpM1hobDNtSmRxdlMya1kzOGxkMGxzcTA=conn_timeout: 5m0sexec_timeout: 5m0s集群内的CM服务部署机器列表 -->cm_servers:CM Server 服务器 IP (仅支持 IPv4) -->host: 192.168.17.112CM Server 监听端口 -->port: 25300role: ""host: 192.168.17.113port: 25300role: ""host: 192.168.17.139port: 25300role: ""EOF
3.4 执行预检查
-- root 用户执行[root@opensource-db mogdb]# ptk checkos -f config.yaml[root@mogdb-db1 mogdb]# ptk checkos -f config.yamlINFO[2022-12-07T16:09:45.364] prechecking dependent tools...WARN[2022-12-07T16:09:46.761] [192.168.17.112][omm] vm.min_free_kbytes=813306, expect 813374INFO[2022-12-07T16:09:46.767] [192.168.17.112][omm] check kernel.core_patternINFO[2022-12-07T16:09:46.777] [192.168.17.112][omm] check removeIPC valueWARN[2022-12-07T16:09:47.635] [192.168.17.139][omm] vm.min_free_kbytes=503638, expect 503721WARN[2022-12-07T16:09:48.040] [192.168.17.113][omm] vm.min_free_kbytes=813306, expect 813374INFO[2022-12-07T16:09:48.083] [192.168.17.113][omm] check kernel.core_patternINFO[2022-12-07T16:09:48.171] [192.168.17.113][omm] check removeIPC valueINFO[2022-12-07T16:09:49.176] [192.168.17.139][omm] check kernel.core_patternINFO[2022-12-07T16:09:49.274] [192.168.17.139][omm] check removeIPC valueWARN[2022-12-07T16:09:49.336] [192.168.17.112][omm] device(sda) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.336] [192.168.17.112][omm] device(sdb) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.336] [192.168.17.112][omm] device(sr0) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.336] [192.168.17.112][omm] device(dm-0) 'IO Request'=128, expect 256WARN[2022-12-07T16:09:49.336] [192.168.17.112][omm] device(dm-1) 'IO Request'=128, expect 256WARN[2022-12-07T16:09:49.336] [192.168.17.112][omm] device(fd0) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.370] [192.168.17.139][omm] device(sdc) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.371] [192.168.17.139][omm] device(sdf) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.371] [192.168.17.139][omm] device(sr0) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.371] [192.168.17.139][omm] device(sda) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.371] [192.168.17.139][omm] device(dm-1) 'IO Request'=128, expect 256WARN[2022-12-07T16:09:49.371] [192.168.17.139][omm] device(sdb) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.371] [192.168.17.139][omm] device(sdd) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.371] [192.168.17.139][omm] device(sdg) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.371] [192.168.17.139][omm] device(dm-0) 'IO Request'=128, expect 256WARN[2022-12-07T16:09:49.371] [192.168.17.139][omm] device(dm-4) 'IO Request'=128, expect 256WARN[2022-12-07T16:09:49.371] [192.168.17.139][omm] device(dm-3) 'IO Request'=128, expect 256WARN[2022-12-07T16:09:49.371] [192.168.17.139][omm] device(fd0) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.372] [192.168.17.139][omm] device(sde) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.372] [192.168.17.139][omm] device(dm-2) 'IO Request'=128, expect 256WARN[2022-12-07T16:09:49.439] [192.168.17.113][omm] device(fd0) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.439] [192.168.17.113][omm] device(sda) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.439] [192.168.17.113][omm] device(sdb) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.439] [192.168.17.113][omm] device(sr0) 'IO Request'=32768, expect 256WARN[2022-12-07T16:09:49.440] [192.168.17.113][omm] device(dm-0) 'IO Request'=128, expect 256WARN[2022-12-07T16:09:49.440] [192.168.17.113][omm] device(dm-1) 'IO Request'=128, expect 256INFO[2022-12-07T16:09:50.257] [192.168.17.112][omm] kernel version: 3.10.0-693.el7.x86_64INFO[2022-12-07T16:09:50.303] [192.168.17.113][omm] kernel version: 3.10.0-693.el7.x86_64INFO[2022-12-07T16:09:50.312] [192.168.17.139][omm] kernel version: 3.10.0-693.el7.x86_64INFO[2022-12-07T16:09:50.318] [192.168.17.112][omm] swap memory 0kB, total memory 16267496kBINFO[2022-12-07T16:09:50.358] [192.168.17.113][omm] swap memory 0kB, total memory 16267496kBINFO[2022-12-07T16:09:50.373] [192.168.17.139][omm] swap memory 0kB, total memory 10074432kBINFO[2022-12-07T16:09:50.554] [192.168.17.139][omm] platform: centos_7_64bitINFO[2022-12-07T16:09:50.554] [192.168.17.112][omm] platform: centos_7_64bitINFO[2022-12-07T16:09:50.554] [192.168.17.113][omm] platform: centos_7_64bitERRO[2022-12-07T16:09:59.604] [192.168.17.139][omm] not found package: numactlINFO[2022-12-07T16:10:03.249] [192.168.17.139][omm] check port 27000INFO[2022-12-07T16:10:03.249] [192.168.17.112][omm] check port 27000? executing...INFO[2022-12-07T16:10:03.249] [192.168.17.113][omm] check port 27000INFO[2022-12-07T16:10:03.452] [192.168.17.112][omm] port 27000 is freeINFO[2022-12-07T16:10:03.688] [192.168.17.139][omm] port 27000 is freeINFO[2022-12-07T16:10:04.041] [192.168.17.113][omm] port 27000 is freeINFO[2022-12-07T16:10:04.149] [192.168.17.112][omm] locale: LANG=en_US.UTF-8INFO[2022-12-07T16:10:04.181] [192.168.17.139][omm] locale: LANG=en_US.UTF-8INFO[2022-12-07T16:10:04.186] [192.168.17.113][omm] locale: LANG=en_US.UTF-8INFO[2022-12-07T16:10:06.718] [192.168.17.112][omm] timezone: +0800INFO[2022-12-07T16:10:06.815] [192.168.17.113][omm] timezone: +0800INFO[2022-12-07T16:10:06.818] [192.168.17.139][omm] timezone: +0800INFO[2022-12-07T16:10:06.818] all checkers finishedINFO[2022-12-07T16:10:06.818] write fix os script to root_fix_os.2022.1207.161006.sh successINFO[2022-12-07T16:10:06.819] Time elapsed: 22s# Check ResultsItem | Level------------------------------------+-----------A1.Check_OS_Version | OKA2.Check_Kernel_Version | OKA3.Check_Unicode | OKA4.Check_TimeZone | OKA5.Check_Swap_Memory_Configure | OKA6.Check_SysCtl_Parameter | WarningA7.Check_FileSystem_Configure | OKA8.Check_Disk_Configure | OKA9.Check_Logical_Block | OKA9.Check_BlockDev_Configure | OKA10.Check_IO_Request | WarningA10.Check_Asynchronous_IO_Request | OKA10.Check_IO_Configure | OKA11.Check_Network_Configure | OKA12.Check_Time_Consistency | OKA13.Check_Firewall_Service | OKA14.Check_THP_Service | OKA15.Check_Dependent_Package | AbnormalA16.Check_CPU_Instruction_Set | AbnormalA17.Check_Port | OKTotal count 20, abnormal count 2, warning count 2Failed to check os, can’t perform installation unless fix all the abnormal itemsYou can use 'ptk checkos -i ITEM --detail' to get detail messagePlease 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@mogdb-db1 mogdb]# cat root_fix_os.2022.1207.161006.shlocal_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.17.139for ip in ${local_ips}; doif [[ "${ip}" == "192.168.17.139" ]]; thenyum install -y numactlexit 0fidone
根据ptk checkos -f config.yaml执行的结果，可通过如下方式查看具体的告警信息。
[root@mogdb-db1 mogdb]# ptk checkos -i A6 --detailINFO[2022-12-07T16:11:57.801] prechecking dependent tools...WARN[2022-12-07T16:11:58.007] [192.168.17.112][omm] vm.min_free_kbytes=813306, expect 813374INFO[2022-12-07T16:11:58.025] [192.168.17.112][omm] check kernel.core_patternINFO[2022-12-07T16:11:58.033] [192.168.17.112][omm] check removeIPC valueINFO[2022-12-07T16:11:58.039] all checkers finishedINFO[2022-12-07T16:11:58.039] Time elapsed: 0s# Check ResultsItem | Level | Message----------------------------+---------+----------------------------------------------------------------A6.Check_SysCtl_Parameter | Warning | [192.168.17.112] Warning: vm.min_free_kbytes=813306, expect 813374Total count 1, abnormal count 0, warning count 1-- 根据提示进行修改设置
3.5 执行安装
对于预检查的 一些Abnormal告警信息，本次选择采用如下安装方式暂时忽略。
-- root 用户执行[root@mogdb-db1 ~]# cd /opt/software/mogdb/[root@mogdb-db1 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-07T17:15:39.875] PTK Version: 0.5.5 releaseINFO[2022-12-07T17:15:39.875] load config from /opt/software/mogdb/config.yamlINFO[2022-12-07T17:15:40.700] skip check osINFO[2022-12-07T17:15:40.700] skip check distroINFO[2022-12-07T17:15:40.700] start check user ...INFO[2022-12-07T17:15:40.795] check user successINFO[2022-12-07T17:15:40.795] start check port ...INFO[2022-12-07T17:15:41.605] check port successINFO[2022-12-07T17:15:41.605] start prepare installation package ...INFO[2022-12-07T17:15:41.605] installation package is readyINFO[2022-12-07T17:15:41.606] start validate installation package ...INFO[2022-12-07T17:15:44.450] parsed kernel package name: MogDB-3.0.3-CentOS-64bit.tar.gzINFO[2022-12-07T17:15:49.234] db product: MogDB, version: 3.0.3, number: 92.605, commit_id: 23ba838dINFO[2022-12-07T17:15:49.235] validate installation package successINFO[2022-12-07T17:15:49.235] start complete the configuration ...INFO[2022-12-07T17:15:49.235] complete the configuration successINFO[2022-12-07T17:15:49.236] start distribute installation package ...> upload MogDB-3.0.3-CentOS-x...: 132.81 MiB / 132.81 MiB [----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------] 100.00% 22.06 MiB p/s 6.2s> upload MogDB-3.0.3-CentOS-x...: 132.81 MiB / 132.81 MiB [----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------] 100.00% 22.06 MiB p/s 6.2sINFO[2022-12-07T17:15:55.578] distrubite packages successINFO[2022-12-07T17:15:55.578] start setup db ...INFO[2022-12-07T17:15:55.584] [192.168.17.112][omm] create os user omm, group dbgrpINFO[2022-12-07T17:15:55.628] [192.168.17.113][omm] create os user omm, group dbgrpINFO[2022-12-07T17:15:55.637] [192.168.17.139][omm] create os user omm, group dbgrpINFO[2022-12-07T17:15:55.805] [192.168.17.112][omm] set ulimit configsINFO[2022-12-07T17:15:55.810] [192.168.17.112][omm] set user omm profilesINFO[2022-12-07T17:15:55.939] [192.168.17.113][omm] set ulimit configsINFO[2022-12-07T17:15:55.984] [192.168.17.113][omm] set user omm profilesINFO[2022-12-07T17:15:55.987] [192.168.17.112][omm] check or set C libraryINFO[2022-12-07T17:15:56.030] [192.168.17.139][omm] set ulimit configsINFO[2022-12-07T17:15:56.060] [192.168.17.112][omm] make dir(s): /opt/mogdb/tool,/opt/mogdb/tool/ptk_tool/binINFO[2022-12-07T17:15:56.124] [192.168.17.139][omm] set user omm profilesINFO[2022-12-07T17:15:56.696] [192.168.17.112][omm] decompress MogDB-3.0.3-CentOS-x86_64.tar.gz to dir /opt/mogdb/toolINFO[2022-12-07T17:15:56.902] [192.168.17.113][omm] check or set C libraryINFO[2022-12-07T17:15:56.990] [192.168.17.113][omm] make dir(s): /opt/mogdb/tool,/opt/mogdb/tool/ptk_tool/binINFO[2022-12-07T17:15:57.089] [192.168.17.139][omm] check or set C libraryINFO[2022-12-07T17:15:57.253] [192.168.17.139][omm] make dir(s): /opt/mogdb/tool,/opt/mogdb/tool/ptk_tool/binINFO[2022-12-07T17:15:57.718] [192.168.17.113][omm] decompress MogDB-3.0.3-CentOS-x86_64.tar.gz to dir /opt/mogdb/toolINFO[2022-12-07T17:15:58.067] [192.168.17.139][omm] decompress MogDB-3.0.3-CentOS-x86_64.tar.gz to dir /opt/mogdb/toolINFO[2022-12-07T17:15:58.706] [192.168.17.112][omm] decompress *-om.tar.gz to dir /opt/mogdb/toolINFO[2022-12-07T17:15:59.498] [192.168.17.112][omm] try to fix psutil python libWARN[2022-12-07T17:15:59.503] [192.168.17.112][omm]Not found python3.6 or 3.7, skip fix psutil dynamic lib,please install proper python and fix it manually or reinstall by ptkif you don't fix this, it will cause that gs_om and cm_ctl cannot run properly, but not ptk and databaseINFO[2022-12-07T17:15:59.503] [192.168.17.112][omm] write file /opt/mogdb/tool/ptk_tool/bin/README.mdINFO[2022-12-07T17:15:59.526] [192.168.17.112][omm] write file /opt/mogdb/tool/ptk_tool/bin/pscpINFO[2022-12-07T17:15:59.550] [192.168.17.112][omm] write file /opt/mogdb/tool/ptk_tool/bin/psshINFO[2022-12-07T17:15:59.571] [192.168.17.112][omm] write file /opt/mogdb/tool/ptk_tool/bin/task_pool.pyINFO[2022-12-07T17:15:59.596] [192.168.17.112][omm] change /opt/mogdb/tool owner to ommINFO[2022-12-07T17:15:59.610] [192.168.17.112][omm] make dir(s): /opt/mogdb/appINFO[2022-12-07T17:15:59.842] [192.168.17.112][omm] decompress MogDB-3.0.3-CentOS-64bit.tar.gz to dir /opt/mogdb/appINFO[2022-12-07T17:16:00.046] [192.168.17.139][omm] decompress *-om.tar.gz to dir /opt/mogdb/toolINFO[2022-12-07T17:16:00.061] [192.168.17.113][omm] decompress *-om.tar.gz to dir /opt/mogdb/toolINFO[2022-12-07T17:16:00.726] [192.168.17.139][omm] try to fix psutil python libWARN[2022-12-07T17:16:00.784] [192.168.17.139][omm]Not found python3.6 or 3.7, skip fix psutil dynamic lib,please install proper python and fix it manually or reinstall by ptkif you don't fix this, it will cause that gs_om and cm_ctl cannot run properly, but not ptk and databaseINFO[2022-12-07T17:16:00.784] [192.168.17.139][omm] write file /opt/mogdb/tool/ptk_tool/bin/README.mdINFO[2022-12-07T17:16:00.980] [192.168.17.139][omm] write file /opt/mogdb/tool/ptk_tool/bin/pscpINFO[2022-12-07T17:16:01.136] [192.168.17.113][omm] try to fix psutil python libINFO[2022-12-07T17:16:01.194] [192.168.17.139][omm] write file /opt/mogdb/tool/ptk_tool/bin/psshWARN[2022-12-07T17:16:01.203] [192.168.17.113][omm]Not found python3.6 or 3.7, skip fix psutil dynamic lib,please install proper python and fix it manually or reinstall by ptkif you don't fix this, it will cause that gs_om and cm_ctl cannot run properly, but not ptk and databaseINFO[2022-12-07T17:16:01.203] [192.168.17.113][omm] write file /opt/mogdb/tool/ptk_tool/bin/README.mdINFO[2022-12-07T17:16:01.337] [192.168.17.139][omm] write file /opt/mogdb/tool/ptk_tool/bin/task_pool.pyINFO[2022-12-07T17:16:01.435] [192.168.17.113][omm] write file /opt/mogdb/tool/ptk_tool/bin/pscpINFO[2022-12-07T17:16:01.479] [192.168.17.139][omm] change /opt/mogdb/tool owner to ommINFO[2022-12-07T17:16:01.534] [192.168.17.139][omm] make dir(s): /opt/mogdb/appINFO[2022-12-07T17:16:01.721] [192.168.17.113][omm] write file /opt/mogdb/tool/ptk_tool/bin/psshINFO[2022-12-07T17:16:01.942] [192.168.17.139][omm] decompress MogDB-3.0.3-CentOS-64bit.tar.gz to dir /opt/mogdb/appINFO[2022-12-07T17:16:02.053] [192.168.17.113][omm] write file /opt/mogdb/tool/ptk_tool/bin/task_pool.pyINFO[2022-12-07T17:16:02.375] [192.168.17.113][omm] change /opt/mogdb/tool owner to ommINFO[2022-12-07T17:16:02.497] [192.168.17.113][omm] make dir(s): /opt/mogdb/appINFO[2022-12-07T17:16:03.059] [192.168.17.113][omm] decompress MogDB-3.0.3-CentOS-64bit.tar.gz to dir /opt/mogdb/appINFO[2022-12-07T17:16:05.397] [192.168.17.112][omm] fix dynamic linker for gs_initdbINFO[2022-12-07T17:16:05.493] [192.168.17.112][omm] fix dynamic linker for mogdbINFO[2022-12-07T17:16:05.631] [192.168.17.112][omm] change /opt/mogdb/app owner to ommINFO[2022-12-07T17:16:05.661] [192.168.17.112][omm] make dir(s): /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_6001INFO[2022-12-07T17:16:06.749] [192.168.17.139][omm] fix dynamic linker for gs_initdbINFO[2022-12-07T17:16:06.970] [192.168.17.139][omm] fix dynamic linker for mogdbINFO[2022-12-07T17:16:07.202] [192.168.17.139][omm] change /opt/mogdb/app owner to ommINFO[2022-12-07T17:16:07.317] [192.168.17.139][omm] make dir(s): /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_6003,/opt/mogdb/log/pg_audit/dn_6003INFO[2022-12-07T17:16:08.961] [192.168.17.112][omm] make dir(s): /opt/mogdb/tmpINFO[2022-12-07T17:16:09.068] [192.168.17.113][omm] fix dynamic linker for gs_initdbINFO[2022-12-07T17:16:09.229] [192.168.17.112][omm] save version to upgrade_versionINFO[2022-12-07T17:16:09.330] [192.168.17.113][omm] fix dynamic linker for mogdbINFO[2022-12-07T17:16:09.381] [192.168.17.112][omm] create file cluster_manual_startINFO[2022-12-07T17:16:09.500] [192.168.17.112][omm] generate cluster_static_config fileINFO[2022-12-07T17:16:09.516] [192.168.17.112][omm] change /opt/mogdb/app/bin/cluster_static_config owner to ommINFO[2022-12-07T17:16:09.523] [192.168.17.112][omm] make dir(s): /opt/mogdb/dataINFO[2022-12-07T17:16:09.545] [192.168.17.113][omm] change /opt/mogdb/app owner to ommINFO[2022-12-07T17:16:09.653] [192.168.17.113][omm] make dir(s): /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_6002,/opt/mogdb/log/pg_audit/dn_6002INFO[2022-12-07T17:16:09.782] [192.168.17.112][omm] change /opt/mogdb/data owner to ommINFO[2022-12-07T17:16:09.789] [192.168.17.112][omm] the database is initializing, please wait a few minutesINFO[2022-12-07T17:16:11.690] [192.168.17.139][omm] make dir(s): /opt/mogdb/tmpINFO[2022-12-07T17:16:11.954] [192.168.17.139][omm] save version to upgrade_versionINFO[2022-12-07T17:16:12.182] [192.168.17.139][omm] create file cluster_manual_startINFO[2022-12-07T17:16:12.290] [192.168.17.139][omm] generate cluster_static_config fileINFO[2022-12-07T17:16:12.346] [192.168.17.139][omm] change /opt/mogdb/app/bin/cluster_static_config owner to ommINFO[2022-12-07T17:16:12.391] [192.168.17.139][omm] make dir(s): /opt/mogdb/dataINFO[2022-12-07T17:16:12.643] [192.168.17.139][omm] change /opt/mogdb/data owner to ommINFO[2022-12-07T17:16:12.699] [192.168.17.139][omm] the database is initializing, please wait a few minutesINFO[2022-12-07T17:16:14.099] [192.168.17.113][omm] make dir(s): /opt/mogdb/tmpINFO[2022-12-07T17:16:14.369] [192.168.17.113][omm] save version to upgrade_versionINFO[2022-12-07T17:16:14.592] [192.168.17.113][omm] create file cluster_manual_startINFO[2022-12-07T17:16:14.700] [192.168.17.113][omm] generate cluster_static_config fileINFO[2022-12-07T17:16:14.760] [192.168.17.113][omm] change /opt/mogdb/app/bin/cluster_static_config owner to ommINFO[2022-12-07T17:16:14.816] [192.168.17.113][omm] make dir(s): /opt/mogdb/dataINFO[2022-12-07T17:16:15.123] [192.168.17.113][omm] change /opt/mogdb/data owner to ommINFO[2022-12-07T17:16:15.202] [192.168.17.113][omm] the database is initializing, please wait a few minutesINFO[2022-12-07T17:16:36.930] [192.168.17.112][omm] config postgresql.confINFO[2022-12-07T17:16:37.162] [192.168.17.112][omm] config pg_hba.confINFO[2022-12-07T17:16:40.917] [192.168.17.113][omm] config postgresql.confINFO[2022-12-07T17:16:41.024] [192.168.17.139][omm] config postgresql.confINFO[2022-12-07T17:16:41.089] [192.168.17.113][omm] config pg_hba.confINFO[2022-12-07T17:16:41.219] [192.168.17.139][omm] config pg_hba.confINFO[2022-12-07T17:16:41.453] setup db successINFO[2022-12-07T17:16:41.454] generate certification filesINFO[2022-12-07T17:16:42.567] download certification filesINFO[2022-12-07T17:16:42.684] upload certification files to (192.168.17.113,omm)INFO[2022-12-07T17:16:44.055] upload certification files to (192.168.17.139,omm)INFO[2022-12-07T17:16:44.996] certification files setup successINFO[2022-12-07T17:16:44.996] start build ssh trust ...INFO[2022-12-07T17:16:46.047] ssh trust build successINFO[2022-12-07T17:16:46.048] start launch db ...INFO[2022-12-07T17:16:46.048] [192.168.17.113][omm] start db by gs_ctl ...INFO[2022-12-07T17:16:46.048] [192.168.17.112][omm] start db by gs_ctl ...INFO[2022-12-07T17:16:46.048] [192.168.17.112][omm] the database is starting, please wait a few minutesINFO[2022-12-07T17:16:46.048] [192.168.17.139][omm] start db by gs_ctl ...INFO[2022-12-07T17:16:46.049] [192.168.17.139][omm] the database is starting, please wait a few minutesINFO[2022-12-07T17:16:46.048] [192.168.17.113][omm] the database is starting, please wait a few minutesINFO[2022-12-07T17:16:48.354] [192.168.17.112][omm] start db successINFO[2022-12-07T17:16:48.354] [192.168.17.112][omm] start alter db initial password ...INFO[2022-12-07T17:16:48.569] [192.168.17.112][omm] alter db password successINFO[2022-12-07T17:16:48.648] [192.168.17.113][omm] start db successINFO[2022-12-07T17:16:48.840] [192.168.17.139][omm] start db successINFO[2022-12-07T17:16:48.841] build standbys ...INFO[2022-12-07T17:16:48.841] [192.168.17.113][omm] start build db ...INFO[2022-12-07T17:16:48.841] [192.168.17.113][omm] the database is building from upstream, please wait a few minutesINFO[2022-12-07T17:17:01.595] [192.168.17.113][omm] build db successINFO[2022-12-07T17:17:01.595] standbys build successINFO[2022-12-07T17:17:01.595] build cascade standbys ...INFO[2022-12-07T17:17:01.595] [192.168.17.139][omm] start build db ...INFO[2022-12-07T17:17:01.595] [192.168.17.139][omm] the database is building from upstream, please wait a few minutesINFO[2022-12-07T17:17:15.634] [192.168.17.139][omm] build db successINFO[2022-12-07T17:17:15.634] cascade standbys build successINFO[2022-12-07T17:17:15.634] launch db successINFO[2022-12-07T17:17:15.634] clear temp dirs ...INFO[2022-12-07T17:17:15.730] clear temp dirs successINFO[2022-12-07T17:17:15.731] Time elapsed: 1m35scluste_name | host | user | port | status | message----------------+----------------+------+-------+---------------+----------cluster_mogdb | 192.168.17.112 | omm | 27000 | start_success | success| 192.168.17.113 | omm | 27000 | start_success | success| 192.168.17.139 | omm | 27000 | start_success | success
3.6 查看实例信息
[root@mogdb-db1 opt]# ptk lscluster_name | id | addr | user | data_dir | db_version | create_time | comment----------------+------+----------------------+------+-----------------+------------------------------+---------------------+----------cluster_mogdb | 6001 | 192.168.17.112:27000 | omm | /opt/mogdb/data | MogDB 3.0.3 (build 23ba838d) | 2022-12-07 17:15:49 || 6002 | 192.168.17.113:27000 | omm | /opt/mogdb/data | | || 6003 | 192.168.17.139:27000 | omm | /opt/mogdb/data |
3.7 查看集群状态
[root@mogdb-db1 mogdb]# ptk cluster -n cluster_mogdb status[ Cluster State ]database_version : MogDB 3.0.3 (build 23ba838d)cluster_name : cluster_mogdbcluster_state : Normal[ Datanode State ]cluster_name | id | ip | port | user | nodename | db_role | state | upstream----------------+------+----------------+-------+------+----------+-----------------+--------+-----------------cluster_mogdb | 6001 | 192.168.17.112 | 27000 | omm | dn_6001 | primary | Normal | -| 6002 | 192.168.17.113 | 27000 | omm | dn_6002 | standby | Normal | -| 6003 | 192.168.17.139 | 27000 | omm | dn_6003 | cascade_standby | Normal | 192.168.17.113
3.8 访问数据库
3.8.1 访问数据库
[omm@mogdb-db1 ~]$ gsql -d postgres -p 27000gsql ((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=# \lList of databasesName | Owner | Encoding | Collate | Ctype | Access privileges | Compatibility-----------+-------+----------+---------+-------+-------------------+---------------postgres | omm | UTF8 | C | C | | Atemplate0 | omm | UTF8 | C | C | =c/omm +| A| | | | | omm=CTc/omm |template1 | omm | UTF8 | C | C | =c/omm +| A| | | | | omm=CTc/omm |(3 rows)MogDB=# \dbList of tablespacesName | Owner | Location------------+-------+----------pg_default | omm |pg_global | omm |(2 rows)MogDB=# \dn+List of schemasName | Owner | Access privileges | Description | WithBlockChain-----------------+-------+-------------------+----------------------------------+----------------blockchain | omm | | blockchain schema | fcstore | omm | | reserved schema for DELTA tables | fdb4ai | omm | omm=UC/omm +| db4ai schema | f| | =U/omm | |dbe_perf | omm | | dbe_perf schema | fdbe_pldebugger | omm | omm=UC/omm +| dbe_pldebugger schema | f| | =U/omm | |dbe_pldeveloper | omm | omm=UC/omm +| dbe_pldeveloper schema | f| | =U/omm | |pkg_service | omm | | pkg_service schema | fpublic | omm | omm=UC/omm +| standard public schema | f| | =U/omm | |snapshot | omm | | snapshot schema | fsqladvisor | omm | omm=UC/omm +| sqladvisor schema | f| | =U/omm | |(10 rows)
可以看到MogDB的访问方式和openGauss一样。
3.8.2 查询数据库信息
查询数据库版本信息
[omm@mogdb-db1 ~]$ gsql -d postgres -p 27000gsql ((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 基础上开发的。
四、卸载MogDB集群
卸载MogDB集群时，要先停集群，然后再进行卸载，/opt/mogdb卸载后需手工删除。
[root@mogdb-db1 mogdb]# ptk cluster -n cluster_mogdb stopINFO[2022-12-07T17:33:18.781] operation: stopINFO[2022-12-07T17:33:18.782] ========================================INFO[2022-12-07T17:33:18.782] stop db [192.168.17.139:27000] ...INFO[2022-12-07T17:33:20.041] stop db [192.168.17.139:27000] successfullyINFO[2022-12-07T17:33:20.041] stop db [192.168.17.113:27000] ...INFO[2022-12-07T17:33:21.304] stop db [192.168.17.113:27000] successfullyINFO[2022-12-07T17:33:21.304] stop db [192.168.17.112:27000] ...INFO[2022-12-07T17:33:22.480] stop db [192.168.17.112:27000] successfullyINFO[2022-12-07T17:33:22.480] ========================================INFO[2022-12-07T17:33:22.480] stop successfully[root@mogdb-db1 mogdb]#[root@mogdb-db1 mogdb]# ptk uninstall -n cluster_mogdbINFO[2022-12-07T17:33:37.842] PTK Version: 0.5.5 releaseCluster Name: "cluster_mogdb"+--------------+----------------+-------------+-------+-----------------+-----------------+----------------+| az(priority) | ip | user(group) | port | role | data dir | upstream |+--------------+----------------+-------------+-------+-----------------+-----------------+----------------+| BJ(1) | 192.168.17.112 | omm(dbgrp) | 27000 | primary | /opt/mogdb/data | - || SH(2) | 192.168.17.113 | omm(dbgrp) | 27000 | standby | /opt/mogdb/data | - || GZ(3) | 192.168.17.139 | omm(dbgrp) | 27000 | cascade_standby | /opt/mogdb/data | 192.168.17.113 |+--------------+----------------+-------------+-------+-----------------+-----------------+----------------+Do you really want to uninstall this cluster? Please confirm carefully[Y/N](default=N) YDo you want to delete db data?[Y/N](default=N) YDo you want to delete os user?[Y/N](default=N) YINFO[2022-12-07T17:33:44.200] check db dirs owner host=192.168.17.112INFO[2022-12-07T17:33:44.201] check db dirs owner host=192.168.17.113INFO[2022-12-07T17:33:44.201] check db dirs owner host=192.168.17.139INFO[2022-12-07T17:33:44.222] check db process status host=192.168.17.112INFO[2022-12-07T17:33:44.390] check db process status host=192.168.17.113INFO[2022-12-07T17:33:44.408] check db process status host=192.168.17.139INFO[2022-12-07T17:33:44.535] clean crontab host=192.168.17.112INFO[2022-12-07T17:33:44.535] clean crontab host=192.168.17.113INFO[2022-12-07T17:33:44.535] clean crontab host=192.168.17.139INFO[2022-12-07T17:33:44.691] kill omm's processes host=192.168.17.112INFO[2022-12-07T17:33:44.755] kill omm's processes host=192.168.17.139INFO[2022-12-07T17:33:44.803] kill omm's processes host=192.168.17.113INFO[2022-12-07T17:33:44.906] remove files /opt/mogdb/app,/opt/mogdb/tool,/opt/mogdb/tmp,/opt/mogdb/data,/opt/mogdb/log,/opt/mogdb/cm host=192.168.17.112INFO[2022-12-07T17:33:44.991] remove files /opt/mogdb/app,/opt/mogdb/tool,/opt/mogdb/tmp,/opt/mogdb/data,/opt/mogdb/log,/opt/mogdb/cm host=192.168.17.139INFO[2022-12-07T17:33:45.180] remove files /opt/mogdb/app,/opt/mogdb/tool,/opt/mogdb/tmp,/opt/mogdb/data,/opt/mogdb/log,/opt/mogdb/cm host=192.168.17.113INFO[2022-12-07T17:33:45.342] delete os user omm host=192.168.17.139INFO[2022-12-07T17:33:45.468] delete os user omm host=192.168.17.112INFO[2022-12-07T17:33:45.548] clearing /etc/cron.allow host=192.168.17.139INFO[2022-12-07T17:33:45.568] clearing /etc/cron.allow host=192.168.17.112INFO[2022-12-07T17:33:45.577] delete os user omm host=192.168.17.113INFO[2022-12-07T17:33:45.580] clearing /etc/security/limits.conf host=192.168.17.112INFO[2022-12-07T17:33:45.648] clearing /etc/security/limits.conf host=192.168.17.139INFO[2022-12-07T17:33:45.835] clearing /etc/cron.allow host=192.168.17.113INFO[2022-12-07T17:33:45.953] clearing /etc/security/limits.conf host=192.168.17.113-- 卸载集群前应该先停止集群，否则直接卸载会报如下提示[192.168.17.112omm]: db process still alive (pid[4482]), please stop it first[192.168.17.113omm]: db process still alive (pid[7368]), please stop it first[192.168.17.139omm]: db process still alive (pid[9238]), please stop it first
原文作者：尚雷的驿站；如有侵权，请联系管理员删除。
请登录后发表评论
登录
全部评论
最新文章
- 记一次 Oracle 19c RAC 因为硬件时钟异常导致 CRS 无法正常启动故障处理记录
- AI万能胶：从挂钩到黏合，一切都靠“智”造
- 跟着博主学习 Halo 数据库带你高薪带你飞
- 【故障处理系列】elasticsearch 索引未正常分片导致集群状态异常如何分析处理
- Elasticsearch max_result_window 含义及参数调整
- Oracle ACE夜话--和首席-总监一起跟大家谈一谈分布式数据库
- openGauss 6.0.0 一主二备集群安装及使用zcbus实现Oracle到openGauss的数据全量和增量同步
- ES检测kibana端口是否宕并自动拉起进程
- clickhouse备份恢复学习分享
- 臭宝，满足您的需求，上大招，今天再分享一个我编写且非常好用处理Elasticsearch集群异常状态的脚本
