Step by Step之非root用户使用PTK安装单机企业版MogDB5.0.5指南(Kylinv10sp3)

1. 使用场景

但某些客户场景下，不允许 root 直接远程登录操作，针对这种情况，PTK 也支持使用普通用户安装。

限制使用sudo，这时候需要使用非root用户，使用PTK工具来安装部署MogDB数据库。

2. 配置操作系统满足安装要求

硬件环境：虚拟机的内存4GB，4核心CPU，900G磁盘（非必须），测试通过。

cat /proc/cpuinfo |grep processor

free -m

 cat /etc/kylin-release

[root@node1 ~]# ## 检查CPU核数

[root@node1 ~]# cat /proc/cpuinfo |grep processor

processor : 0

processor : 1

processor : 2

processor : 3

[root@node1 ~]# ## 检查内存大小

[root@node1 ~]# free -m

              total        used        free      shared  buff/cache   available

Mem:           7803         498        6887          14         417        6994

Swap:         65535           0       65535

[root@node1 ~]# ## 检查系统版本

[root@node1 ~]# cat /etc/kylin-release

Kylin Linux Advanced Server release V10 (Lance)

[root@node1 ~]#

操作系统版本：

Kylinv10 sp3 x64

内核版本: 4.19.90-52.22.v2207.ky10.x86_64

数据库版本：

MogDB5.0.5企业版：MogDB-5.0.5-Kylin-x86_64-all.tar.gz

下载地址：https://MogDB.org/zh/download.html

环境配置 

单节点：

node1： 192.168.0.11

root：密码：root123

测试环境：配置双网卡，可以联网，使用网络yum源。

说明：

由于使用root_fix的脚本会执行yum install安装一些依赖，所以机器要配置yum源（可以配置本地yum源）

2.1. 修改/etc/hosts

## 检查主机名和IP地址是否配置正确，需要配置主机名和IP

hostname && ifconfig |grep broadcast|awk '{print $2}'

## 添加Hosts解析(假设主机名为node1，IP地址为192.168.0.11)

sed -i '/node1/d' /etc/hosts     #替换删除node1这一行

###新增加一行记录

echo "192.168.0.11 node1 ##mogdb OM IP Hosts Mapping" >>/etc/hosts

###检查增加的记录

cat /etc/hosts|grep mogdb

###检查主机名和IP地址是否配置正确

hostname && ifconfig |grep broadcast|awk '{print $2}'

cat /etc/hosts

#修改主机名

cat>/etc/hostname<<EOF

node1

EOF

2.2. 创建相关目录，用户，组

groupadd omm -g 2000

useradd omm -g 2000 -u 2000

echo "huawei@1234" | passwd --stdin omm

mkdir -p /opt/mogdb/software

mkdir -p /opt/mogdb/data

chown -R omm:omm /opt/mogdb

#注意：麒麟对密码复杂度有要求。

#用户需提前创建好运行数据库的系统用户（假设为 omm），并在 /etc/security/limits.conf 中配置 omm 用户的 ulimits 配置，确保以下满足以下需求，否则可能导致数据库无法启动：

cat>> /etc/security/limits.conf<<EOF

omm     soft    as      unlimited

omm     hard    as      unlimited

omm     soft    nproc   unlimited

omm     hard    nproc   unlimited

omm     soft    nofile  1000000

omm     hard    nofile  1000000

omm     soft    stack   unlimited

omm     hard    stack   unlimited

EOF

cat  /etc/security/limits.conf

2.3. 离线安装PTK部署工具 （使用omm）

下载地址：软件安装 | MogDB Docs

[omm@node1 software]$

su - omm

cd /opt/mogdb/software

wget https://cdn-mogdb.enmotech.com/ptk/latest/ptk_linux_x86_64.tar.gz

[omm@node1 software]$ ls

ptk_linux_x86_64.tar.gz

[omm@node1 software]$ tar -zxvf ptk_linux_x86_64.tar.gz

README.md

ptk

创建拓扑配置文件：

[omm@node1 software]$ /opt/mogdb/software/ptk  template -l > config.yaml

2.4. 预安装检查（root）

新开一个终端，ptk checkos -f 进行预安装检查 ：

[root@node1 ~]#  /opt/mogdb/software/ptk checkos -f /opt/mogdb/software/config.yaml

INFO[2024-03-27T10:09:51.463] 预检查依赖工具...

WARN[2024-03-27T10:09:51.498] [192.168.0.11][omm] net.ipv4.tcp_retries1=3, expect 5

WARN[2024-03-27T10:09:51.505] [192.168.0.11][omm] net.core.netdev_max_backlog=8000, expect 65535

WARN[2024-03-27T10:09:51.512] [192.168.0.11][omm] vm.min_free_kbytes=45056, expect 100259

WARN[2024-03-27T10:09:51.516] [192.168.0.11][omm] net.ipv4.tcp_retries2=15, expect 12

WARN[2024-03-27T10:09:51.521] [192.168.0.11][omm] net.ipv4.tcp_syn_retries=6, expect 5

WARN[2024-03-27T10:09:51.528] [192.168.0.11][omm] net.ipv4.tcp_max_tw_buckets=8192, expect 10000

WARN[2024-03-27T10:09:51.533] [192.168.0.11][omm] net.ipv4.tcp_wmem=4096        16384   4194304, expect 8192 250000 16777216

WARN[2024-03-27T10:09:51.535] [192.168.0.11][omm] net.core.somaxconn=512, expect 65535

ERRO[2024-03-27T10:09:51.540] [192.168.0.11][omm] kernel.sem=32000      1024000000      500     32000, expect 250 6400000 1000 25600

WARN[2024-03-27T10:09:51.542] [192.168.0.11][omm] net.ipv4.tcp_keepalive_intvl=75, expect 30

WARN[2024-03-27T10:09:51.545] [192.168.0.11][omm] net.ipv4.tcp_rmem=4096        131072  6291456, expect 8192 250000 16777216

WARN[2024-03-27T10:09:51.550] [192.168.0.11][omm] net.ipv4.tcp_fin_timeout=40, expect 60

WARN[2024-03-27T10:09:51.553] [192.168.0.11][omm] net.ipv4.tcp_keepalive_time=7200, expect 30

WARN[2024-03-27T10:09:51.565] [192.168.0.11][omm] net.ipv4.tcp_max_syn_backlog=2048, expect 65535

INFO[2024-03-27T10:09:51.565] [192.168.0.11][omm] 检查 kernel.core_pattern

INFO[2024-03-27T10:09:51.570] [192.168.0.11][omm] 检查 RemoveIPC 的值

INFO[2024-03-27T10:09:51.586] [192.168.0.11][omm] 检查 KillUserProcesses 的值

WARN[2024-03-27T10:09:51.601] [192.168.0.11][omm] device(/dev/sda) readahead value=8192, expect 16384.

ERRO[2024-03-27T10:09:51.639] [192.168.0.11][omm] selinux mode in /etc/selinux/config is 'enforcing'

INFO[2024-03-27T10:09:51.643] [192.168.0.11][omm] locale: LANG=en_US.UTF-8

INFO[2024-03-27T10:09:51.647] [192.168.0.11][omm] 交换内存 15626236kB，总内存 2005180kB

ERRO[2024-03-27T10:09:55.127] [192.168.0.11][omm] not found package: numactl

INFO[2024-03-27T10:09:55.132] [192.168.0.11][omm] 检查端口 26000

INFO[2024-03-27T10:09:55.139] [192.168.0.11][omm] 端口 26000 空闲

INFO[2024-03-27T10:09:55.139] [192.168.0.11][omm] platform: kylin_V10_64bit

INFO[2024-03-27T10:09:55.142] [192.168.0.11][omm] 内核版本: 4.19.90-52.22.v2207.ky10.x86_64

INFO[2024-03-27T10:09:55.146] [192.168.0.11][omm] 时区: +0800

ERRO[2024-03-27T10:09:55.151] [192.168.0.11][omm] transparent_hugepage status is 'always', expect 'never'

WARN[2024-03-27T10:09:55.157] [192.168.0.11][omm] device(sda) 'IO Request'=254, expect 256

ERRO[2024-03-27T10:09:55.172] [192.168.0.11][omm] firewall status='enabled', expect 'disabled'.

INFO[2024-03-27T10:09:55.172] 完成所有检查项

INFO[2024-03-27T10:09:55.172] 将修复 OS 脚本写入 root_fix_os.0327.100955.sh 成功

INFO[2024-03-27T10:09:55.172] 用时: 4s

# 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    | Warning

  A6.Check_SysCtl_Parameter         | Abnormal

  A7.Check_FileSystem_Configure     | OK

  A8.Check_Disk_Configure           | OK

  A9.Check_Logical_Block            | OK

  A9.Check_BlockDev_Configure       | Warning

  A10.Check_NR_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_Status         | Abnormal

  A14.Check_THP_Status              | Abnormal

  A15.Check_Dependent_Package       | Abnormal

  A16.Check_CPU_Instruction_Set     | OK

  A17.Check_Port                    | OK

  A18.Check_Selinux                 | Abnormal

  A19.Check_User_Ulimit             | OK

Total count 22, abnormal count 5, 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.0327.100955.sh for commands to resolve.

root执行修复脚本：

[root@node1 ~]# sh root_fix_os.0327.100955.sh

kernel.sysrq = 0

net.ipv4.ip_forward = 0

net.ipv4.conf.all.send_redirects = 0

net.ipv4.conf.default.send_redirects = 0

net.ipv4.conf.all.accept_source_route = 0

net.ipv4.conf.default.accept_source_route = 0

net.ipv4.conf.all.accept_redirects = 0

net.ipv4.conf.default.accept_redirects = 0

net.ipv4.conf.all.secure_redirects = 0

net.ipv4.conf.default.secure_redirects = 0

net.ipv4.icmp_echo_ignore_broadcasts = 1

net.ipv4.icmp_ignore_bogus_error_responses = 1

net.ipv4.conf.all.rp_filter = 1

net.ipv4.conf.default.rp_filter = 1

net.ipv4.tcp_syncookies = 1

kernel.dmesg_restrict = 1

net.ipv6.conf.all.accept_redirects = 0

net.ipv6.conf.default.accept_redirects = 0

kernel.sem = 250 6400000 1000 25600

Kylin Linux Advanced Server 10 - Os                               12 MB/s |  14 MB     00:01

Kylin Linux Advanced Server 10 - Updates                          13 MB/s |  19 MB     00:01

上次元数据过期检查：0:00:03 前，执行于 2024年03月27日 星期三 10时11分01秒。

依赖关系解决。

=================================================================================================

 Package             Architecture       Version                    Repository               Size

=================================================================================================

安装:

 numactl             x86_64             2.0.13-4.ky10              ks10-adv-os              60 k

事务概要

=================================================================================================

安装  1 软件包

总下载：60 k

安装大小：158 k

下载软件包：

numactl-2.0.13-4.ky10.x86_64.rpm                                 465 kB/s |  60 kB     00:00

-------------------------------------------------------------------------------------------------

总计                                                             459 kB/s |  60 kB     00:00

Kylin Linux Advanced Server 10 - Os                              1.7 MB/s | 1.7 kB     00:00

导入 GPG 公钥 0x7A486D9F:

 Userid: "NeoKylin (release key) <support@cs2c.com.cn>"

 指纹: B814 9E68 5286 4585 CE41 143B 41F8 AEBE 7A48 6D9F

 来自: /etc/pki/rpm-gpg/RPM-GPG-KEY-kylin

导入公钥成功

运行事务检查

事务检查成功。

运行事务测试

事务测试成功。

运行事务

  准备中  :                                                                                  1/1

  安装    : numactl-2.0.13-4.ky10.x86_64                                                     1/1

  运行脚本: numactl-2.0.13-4.ky10.x86_64                                                     1/1

  验证    : numactl-2.0.13-4.ky10.x86_64                                                     1/1

已安装:

  numactl-2.0.13-4.ky10.x86_64

完毕！

Created symlink /etc/systemd/system/basic.target.wants/disable-transparent-huge-pages.service → /etc/systemd/system/disable-transparent-huge-pages.service.

WARNING: You should reboot host to disable transparent huge pages(THP) permanently!

Removed /etc/systemd/system/multi-user.target.wants/firewalld.service.

Removed /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.

[root@node1 ~]#

reboot

#使用reboot再次检查,检查通过后，开始安装数据库。

再次检查：

[root@node1 ~]#  /opt/mogdb/software/ptk checkos -f /opt/mogdb/software/config.yaml

INFO[2024-03-27T10:13:44.772] 预检查依赖工具...

INFO[2024-03-27T10:13:44.811] [192.168.0.11][omm] 交换内存 15626236kB，总内存 956604kB

INFO[2024-03-27T10:13:44.817] [192.168.0.11][omm] 检查端口 26000

INFO[2024-03-27T10:13:44.824] [192.168.0.11][omm] 端口 26000 空闲

INFO[2024-03-27T10:13:44.862] [192.168.0.11][omm] 内核版本: 4.19.90-52.22.v2207.ky10.x86_64

INFO[2024-03-27T10:13:44.866] [192.168.0.11][omm] 时区: +0800

WARN[2024-03-27T10:13:44.875] [192.168.0.11][omm] device(sda) 'IO Request'=254, expect 256

INFO[2024-03-27T10:13:44.880] [192.168.0.11][omm] platform: kylin_V10_64bit

WARN[2024-03-27T10:13:44.883] [192.168.0.11][omm] net.ipv4.tcp_retries2=15, expect 12

WARN[2024-03-27T10:13:44.886] [192.168.0.11][omm] net.ipv4.tcp_rmem=4096        131072  6291456, expect 8192 250000 16777216

WARN[2024-03-27T10:13:44.897] [192.168.0.11][omm] net.ipv4.tcp_keepalive_time=7200, expect 30

WARN[2024-03-27T10:13:44.900] [192.168.0.11][omm] net.ipv4.tcp_wmem=4096        16384   4194304, expect 8192 250000 16777216

WARN[2024-03-27T10:13:44.911] [192.168.0.11][omm] net.ipv4.tcp_max_syn_backlog=2048, expect 65535

WARN[2024-03-27T10:13:44.915] [192.168.0.11][omm] net.ipv4.tcp_max_tw_buckets=8192, expect 10000

WARN[2024-03-27T10:13:44.923] [192.168.0.11][omm] net.ipv4.tcp_keepalive_intvl=75, expect 30

WARN[2024-03-27T10:13:44.926] [192.168.0.11][omm] net.ipv4.tcp_fin_timeout=40, expect 60

WARN[2024-03-27T10:13:44.928] [192.168.0.11][omm] net.core.netdev_max_backlog=8000, expect 65535

WARN[2024-03-27T10:13:44.935] [192.168.0.11][omm] net.ipv4.tcp_syn_retries=6, expect 5

WARN[2024-03-27T10:13:44.937] [192.168.0.11][omm] net.core.somaxconn=512, expect 65535

WARN[2024-03-27T10:13:44.943] [192.168.0.11][omm] net.ipv4.tcp_retries1=3, expect 5

WARN[2024-03-27T10:13:44.950] [192.168.0.11][omm] vm.min_free_kbytes=45056, expect 47830

INFO[2024-03-27T10:13:44.955] [192.168.0.11][omm] 检查 kernel.core_pattern

INFO[2024-03-27T10:13:44.960] [192.168.0.11][omm] 检查 RemoveIPC 的值

INFO[2024-03-27T10:13:44.968] [192.168.0.11][omm] 检查 KillUserProcesses 的值

INFO[2024-03-27T10:13:44.993] [192.168.0.11][omm] locale: LANG=en_US.UTF-8

WARN[2024-03-27T10:13:45.000] [192.168.0.11][omm] device(/dev/sda) readahead value=8192, expect 16384.

INFO[2024-03-27T10:13:49.063] 完成所有检查项

INFO[2024-03-27T10:13:49.063] 用时: 4s

# 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    | Warning

  A6.Check_SysCtl_Parameter         | Warning

  A7.Check_FileSystem_Configure     | OK

  A8.Check_Disk_Configure           | OK

  A9.Check_Logical_Block            | OK

  A9.Check_BlockDev_Configure       | Warning

  A10.Check_NR_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_Status         | OK

  A14.Check_THP_Status              | OK

  A15.Check_Dependent_Package       | Warning

  A16.Check_CPU_Instruction_Set     | OK

  A17.Check_Port                    | OK

  A18.Check_Selinux                 | OK

  A19.Check_User_Ulimit             | OK

Total count 22, abnormal count 0, warning count 5

[root@node1 ~]#

通过系统安装前检查，接下来可以安装数据库。

2.5. 上传并解压二进制文件（root或omm）

#如果使用root上传文件，则需要对文件更改属主，omm上传则不需要。

#此处使用root下载文件为例。

#上传数据库软件MogDB-5.0.5-Kylin-x86_64-all.tar.gz到/opt/mogdb/software/

[root@node1 ~]# cd /opt/mogdb/software

wget https://cdn-mogdb.enmotech.com/mogdb-media/5.0.5/Kylin_x86_64/MogDB-5.0.5-Kylin-x86_64-all.tar.gz

[root@node1 software]# ls -lrt

-rw-r--r--. 1 root root 137677267 Mar 25 14:44 MogDB-5.0.5-Kylin-x86_64-all.tar.gz

[root@node1 software]#

chown omm:omm MogDB-5.0.5-Kylin-x86_64-all.tar.gz

3、离线安装数据库（omm）

3.1 omm用户使用PTK离线安装数据库

su - omm

cd /opt/mogdb/software/

[omm@node1 software]$ ./ptk install -f config.yaml --pkg ./MogDB-5.0.5-Kylin-x86_64-all.tar.gz

INFO[2024-03-25T17:56:23.630] PTK Version: 1.3.2 release

INFO[2024-03-25T17:56:23.630] load config from config.yaml

If you continue to install the software,

you are accepting the license agreement of the software.

  [Y]: Accept and continue

  [C]: Show content of licence agreement

  [N]: Abort installation and exit

✔ Please enter (default: Y): y

Cluster Name: "pascal"

+--------------+--------------+-------------+-------+---------+----------------------+----------+

| az(priority) |      ip      | user(group) | port  |  role   |       data dir       | upstream |

+--------------+--------------+-------------+-------+---------+----------------------+----------+

| AZ1(1)       | 192.168.0.11 | omm(omm)    | 26000 | primary | /home/omm/mogdb/data | -        |

+--------------+--------------+-------------+-------+---------+----------------------+----------+

✔ Is cluster config correct (default=n) [y/n]: y

INFO[2024-03-25T17:56:27.423] start check hostname ...

INFO[2024-03-25T17:56:27.429] check hostname success

INFO[2024-03-25T17:56:27.429] start check os ...

INFO[2024-03-25T17:56:27.429] prechecking dependent tools...

INFO[2024-03-25T17:56:27.467] [192.168.0.11][omm] kernel version: 3.10.0-957.el7.x86_64

INFO[2024-03-25T17:56:27.471] [192.168.0.11][omm] timezone: +0800

INFO[2024-03-25T17:56:36.110] [192.168.0.11][omm] locale: LANG=en_US.UTF-8

INFO[2024-03-25T17:56:36.113] [192.168.0.11][omm] swap memory 67108860kB, total memory 7990276kB

INFO[2024-03-25T17:56:36.114] [192.168.0.11][omm] check port 26000

INFO[2024-03-25T17:56:36.122] [192.168.0.11][omm] port 26000 is free

INFO[2024-03-25T17:56:36.122] [192.168.0.11][omm] platform: centos_7_64bit

WARN[2024-03-25T17:56:36.128] [192.168.0.11][omm] net.ipv4.tcp_retries1=3, expect 5

WARN[2024-03-25T17:56:36.142] [192.168.0.11][omm] net.core.somaxconn=128, expect 65535

WARN[2024-03-25T17:56:36.148] [192.168.0.11][omm] vm.min_free_kbytes=67584, expect 399513

WARN[2024-03-25T17:56:36.159] [192.168.0.11][omm] net.ipv4.tcp_tw_recycle=0, expect 1

WARN[2024-03-25T17:56:36.162] [192.168.0.11][omm] net.ipv4.tcp_keepalive_intvl=75, expect 30

WARN[2024-03-25T17:56:36.168] [192.168.0.11][omm] net.ipv4.tcp_fin_timeout=30, expect 60

WARN[2024-03-25T17:56:36.182] [192.168.0.11][omm] net.ipv4.tcp_retries2=15, expect 12

WARN[2024-03-25T17:56:36.185] [192.168.0.11][omm] net.ipv4.tcp_max_syn_backlog=4096, expect 65535

WARN[2024-03-25T17:56:36.188] [192.168.0.11][omm] net.ipv4.tcp_syn_retries=6, expect 5

WARN[2024-03-25T17:56:36.191] [192.168.0.11][omm] net.core.netdev_max_backlog=1000, expect 65535

WARN[2024-03-25T17:56:36.206] [192.168.0.11][omm] net.ipv4.tcp_wmem=4096        16384   4194304, expect 8192 250000 16777216

WARN[2024-03-25T17:56:36.212] [192.168.0.11][omm] net.ipv4.tcp_tw_reuse=0, expect 1

WARN[2024-03-25T17:56:36.215] [192.168.0.11][omm] net.ipv4.tcp_keepalive_time=300, expect 30

WARN[2024-03-25T17:56:36.218] [192.168.0.11][omm] net.ipv4.tcp_rmem=4096        87380   6291456, expect 8192 250000 16777216

INFO[2024-03-25T17:56:36.222] [192.168.0.11][omm] check kernel.core_pattern

INFO[2024-03-25T17:56:36.228] [192.168.0.11][omm] check RemoveIPC value

INFO[2024-03-25T17:56:36.235] [192.168.0.11][omm] check KillUserProcesses value

WARN[2024-03-25T17:56:36.286] [192.168.0.11][omm] require root privilege to read block info, skip

WARN[2024-03-25T17:56:36.302] [192.168.0.11][omm] device(sda) 'IO Request'=128, expect 256

WARN[2024-03-25T17:56:36.305] [192.168.0.11][omm] require root privilege to read block info, skip

INFO[2024-03-25T17:56:36.338] all checkers finished

INFO[2024-03-25T17:56:36.338] time elapsed: 9s

INFO[2024-03-25T17:56:36.338] check os success

INFO[2024-03-25T17:56:36.338] start check distro ...

INFO[2024-03-25T17:56:36.338] check distro success

INFO[2024-03-25T17:56:36.338] start check user ...

INFO[2024-03-25T17:56:36.342] check user success

INFO[2024-03-25T17:56:36.342] start check port ...

INFO[2024-03-25T17:56:36.342] checking port 26000 on host 192.168.0.11 (db listen port) ...

INFO[2024-03-25T17:56:36.350] checking port 26001 on host 192.168.0.11 (db HA port) ...

INFO[2024-03-25T17:56:36.357] check port success

INFO[2024-03-25T17:56:36.357] start prepare installation package ...

INFO[2024-03-25T17:56:36.358] installation package is ready

INFO[2024-03-25T17:56:36.358] start validate installation package ...

INFO[2024-03-25T17:56:37.843] db product: MogDB, version: 5.0.5, number: 92.901, commit_id: b77f1a82

INFO[2024-03-25T17:56:37.843] validate installation package success

INFO[2024-03-25T17:56:37.843] start complete the configuration ...

✔ Please enter db password (8~15 characters, 3 classes): huawei@1234

✔ Retype db password:  huawei@1234

INFO[2024-03-25T17:57:01.637] complete the configuration success

INFO[2024-03-25T17:57:01.638] start distribute installation package ...

INFO[2024-03-25T17:57:01.714] distrubite packages success

INFO[2024-03-25T17:57:01.714] start install logic nodes ...

INFO[2024-03-25T17:57:01.714] deploy db to omm@192.168.0.11

INFO[2024-03-25T17:57:01.727] [192.168.0.11][omm] clean user omm's ipc resource

INFO[2024-03-25T17:57:01.731] [192.168.0.11][omm] make user omm's dir(s): /home/omm/mogdb/tool,/home/omm/mogdb/tool/ptk_tool/bin

INFO[2024-03-25T17:57:01.766] [192.168.0.11][omm] extract MogDB-5.0.5-Kylin-x86_64-all.tar.gz to dir /home/omm/mogdb/tool

INFO[2024-03-25T17:57:02.687] [192.168.0.11][omm] extract MogDB-5.0.5-CentOS-64bit-om.tar.gz to dir /home/omm/mogdb/tool

INFO[2024-03-25T17:57:02.986] [192.168.0.11][omm] try to fix psutil python lib

INFO[2024-03-25T17:57:03.003] [192.168.0.11][omm] write file /home/omm/mogdb/tool/ptk_tool/bin/README.md

INFO[2024-03-25T17:57:03.016] [192.168.0.11][omm] write file /home/omm/mogdb/tool/ptk_tool/bin/pscp

INFO[2024-03-25T17:57:03.026] [192.168.0.11][omm] write file /home/omm/mogdb/tool/ptk_tool/bin/pssh

INFO[2024-03-25T17:57:03.035] [192.168.0.11][omm] write file /home/omm/mogdb/tool/ptk_tool/bin/task_pool.py

INFO[2024-03-25T17:57:03.044] [192.168.0.11][omm] make user omm's dir(s): /home/omm/mogdb/app

INFO[2024-03-25T17:57:03.056] [192.168.0.11][omm] extract MogDB-5.0.5-CentOS-64bit.tar.gz to dir /home/omm/mogdb/app

INFO[2024-03-25T17:57:05.781] [192.168.0.11][omm] change mode of /home/omm/mogdb/app to 700

INFO[2024-03-25T17:57:05.792] [192.168.0.11][omm] make user omm's dir(s): /home/omm/mogdb/app/share/postgresql

INFO[2024-03-25T17:57:05.807] [192.168.0.11][omm] copy /home/omm/mogdb/tool/script/gspylib/etc/sql/pmk_schema.sql to /home/omm/mogdb/app/share/postgresql if exist

INFO[2024-03-25T17:57:05.812] [192.168.0.11][omm] copy /home/omm/mogdb/tool/script/gspylib/etc/sql/pmk_schema_single_inst.sql to /home/omm/mogdb/app/share/postgresql if exist

INFO[2024-03-25T17:57:05.817] [192.168.0.11][omm] write file /home/omm/mogdb/app/bin/transfer.py

INFO[2024-03-25T17:57:05.824] [192.168.0.11][omm] set user omm profiles

INFO[2024-03-25T17:57:05.926] [192.168.0.11][omm] validate and try to fix ld library for gs_initdb

INFO[2024-03-25T17:57:05.933] [192.168.0.11][omm] validate and try to fix ld library for mogdb

INFO[2024-03-25T17:57:05.944] [192.168.0.11][omm] make user omm's dir(s): /home/omm/mogdb/log/gs_profile,/home/omm/mogdb/log/pg_log,/home/omm/mogdb/log/pg_audit,/home/omm/mogdb/log/bin,/home/omm/mogdb/log/pg_log/dn_6001,/home/omm/mogdb/log/pg_audit/dn_6001

INFO[2024-03-25T17:57:06.032] [192.168.0.11][omm] make user omm's dir(s): /home/omm/mogdb/tmp

INFO[2024-03-25T17:57:06.043] [192.168.0.11][omm] save version to upgrade_version

INFO[2024-03-25T17:57:06.049] [192.168.0.11][omm] create file cluster_manual_start

INFO[2024-03-25T17:57:06.053] [192.168.0.11][omm] generate cluster_static_config file

INFO[2024-03-25T17:57:06.061] [192.168.0.11][omm] make user omm's dir(s): /home/omm/mogdb/data

INFO[2024-03-25T17:57:06.071] [192.168.0.11][omm] write file /home/omm/mogdb/tool/.ptk_deployer

INFO[2024-03-25T17:57:06.079] generate certification files

INFO[2024-03-25T17:57:06.337] download certification files

INFO[2024-03-25T17:57:06.405] certification files setup success

INFO[2024-03-25T17:57:06.405] initialize db on omm@192.168.0.11

INFO[2024-03-25T17:57:06.410] [192.168.0.11][omm] the database is initializing, please wait a few minutes

INFO[2024-03-25T17:57:28.961] [192.168.0.11][omm] config postgresql.conf

INFO[2024-03-25T17:57:28.996] [192.168.0.11][omm] config pg_hba.conf

INFO[2024-03-25T17:57:29.008] [192.168.0.11][omm] copy ssl files to data dir

INFO[2024-03-25T17:57:29.015] logic nodes installed success

INFO[2024-03-25T17:57:29.016] generating ptkc ...

INFO[2024-03-25T17:57:29.047] start build ssh trust ...

INFO[2024-03-25T17:57:29.084] ssh trust build success

INFO[2024-03-25T17:57:29.084] start launch db ...

INFO[2024-03-25T17:57:29.084] [192.168.0.11][omm] start db using gs_ctl ...

INFO[2024-03-25T17:57:29.084] [192.168.0.11][omm] the database is starting, please wait a few minutes

INFO[2024-03-25T17:57:31.326] [192.168.0.11][omm] start db success

INFO[2024-03-25T17:57:32.327] [192.168.0.11][omm] start alter db initial password ...

INFO[2024-03-25T17:57:32.381] [192.168.0.11][omm] alter db password success

INFO[2024-03-25T17:57:32.381] launch db success

INFO[2024-03-25T17:57:32.381] clear temp dirs ...

INFO[2024-03-25T17:57:32.398] clear temp dirs success

INFO[2024-03-25T17:57:32.398] time elapsed: 1m6s

  cluste_name |     host     | user | port  |    status     | message

--------------+--------------+------+-------+---------------+----------

  pascal      | 192.168.0.11 | omm  | 26000 | start_success | success

[omm@node1 software]$

安装成功。

3.2使用不同工具查看数据库状态：

#source ~/.bashrc环境变量生效

#修改#/home/omm/.ptk_mogdb_env环境变量，增加omm用户下的ptk路径（node1）

#也可以不修改，建议使用ptkc代替ptk。

参考：https://docs.mogdb.io/zh/ptk/v1.1/usage-ptkc

[omm@node1 ~]$ vi /home/omm/.ptk_mogdb_env

export PATH=$GPHOME/ptk_tool/bin:$GAUSSHOME/bin:$GPHOME/script:/opt/mogdb/software:$PATH

[omm@node1 software]$ source ~/.bashrc

[omm@node1 ~]$ ptk ls

...

[omm@node1 ~]$  ptkc status

[   Cluster State   ]

cluster_name                   : pascal

cluster_state                  : Normal

database_version               : MogDB 5.0.5 (build b77f1a82)

[  Datanode State   ]

  cluster_name |  id  |      ip      | port  | user | nodename | db_role | state  |  uptime  | upstream

---------------+------+--------------+-------+------+----------+---------+--------+----------+-----------

  pascal       | 6001 | 192.168.0.11 | 26000 | omm  | dn_6001  | primary | Normal | 00:02:03 | -

[omm@node1 ~]$

#查看数据库状态

[omm@node1 ~]$ gs_om -t status

-----------------------------------------------------------------------

cluster_name    : pascal

cluster_state   : Normal

redistributing  : No

-----------------------------------------------------------------------

[omm@node1 ~]$

[omm@node1 software]$ gs_ctl status

[2024-03-25 14:59:18.378][27315][][gs_ctl]: gs_ctl status,datadir is /opt/mogdb/data

gs_ctl: server is running (PID: 27225)

/opt/mogdb/software/MogDB-5.0.5-CentOS-64bit/bin/mogdb

3.3登录测试数据库

[omm@node1 software]$ gsql -r

gsql ((MogDB 5.0.5 build b77f1a82) compiled at 2023-12-08 03:11:50 commit 0 last mr 1804 )

Non-SSL connection (SSL connection is recommended when requiring high-security)

Type "help" for help.

MogDB=#

[omm@node1 ~]$ gsql  -c 'select version()'

                                                                       version

----------------------------------------------------------------------------------------------------------------------

 (MogDB 5.0.5 build b77f1a82) compiled at 2023-12-08 03:11:47 commit 0 last mr 1804  on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit

(1 row)

手动安装完成。

End。