0


GaussDB 24.1.30 分布式3节点命令行方式部署

GaussDB介绍

华为自主创新研发的分布式关系型数据库。该产品具备企业级复杂事务混合负载能力,同时支持分布式事务,同城跨AZ部署,数据0丢失,支持1000+的扩展能力,PB级海量存储。同时拥有云上高可用,高可靠,高安全,弹性伸缩,一键部署,快速备份恢复,监控告警等关键能力,能为企业提供功能全面,稳定可靠,扩展性强,性能优越的企业级数据库服务。

服务器环境

--查操作系统版本cat /etc/.kyinfo--查cpu信息lscpu--查内存free -g--查磁盘df -h

安装前准备

配置会话不中断

echo 'export TMOUT=0' >> /etc/profilesource /etc/profile

更改主机名

--节点1hostnamectl set-hostname node01exec bash--节点2hostnamectl set-hostname node02exec bash--节点3hostnamectl set-hostname node03exec bash

配置/etc/hosts

--节点1  节点2  节点3  分别执行cp /etc/hosts /etc/hosts_bak_`date +%F`cat >> /etc/hosts << "EOF"192.168.30.51 node01192.168.30.52 node02192.168.30.53 node03EOF

配置ssh互信

📎ssh.sh

#下载脚本wget https://gitcode.net/myneth/tools/-/raw/master/tool/ssh.shchmod +x ssh.sh#执行互信./ssh.sh -user root -hosts "node01 node02 node03" -advanced -exverify -confirmchmod 600 /root/.ssh/config#检查互信su - rootfor i in node{01,02,03};dossh $i hostname done

操作系统配置

关闭防火墙并禁止开机启动

systemctl stop firewalld.servicesystemctl disable firewalld.servicesystemctl status firewalld.service

更改selinux配置

修改 /etc/selinux/config 文件中的 SELINUX 值为 permissive

vi /etc/selinux/configSELINUX=enforcing改成SELINUX=permissive --重启系统reboot

设置字符集参数

将各主机的字符集设置为相同的字符集

vi /etc/profile尾部增加export LANG=en_US.UTF-8--配置文件生效source /etc/profile

设置时区和时间

检查时区和时间

date

设置时区与时间

将 /usr/share/zoneinfo/ 目录下的时区文件拷贝到 /etc/localtime

mv /etc/localtime /etc/localtime_bak_20240820cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime

使用 date -s 命令将各主机的时间设置为统一时间

date -s "2024-08-20 17:11:12"

关闭swap交换内存

swapoff -a

checklist检查清单

检查服务器firewalld是否关闭 输出:Active: inactive (dead)

systemctl status firewalld

检查iptables是否开启 输出:Active: inactive (dead)

systemctl status iptables

是否关闭selinux 输出Disabled

getenforce

检查服务器时间是否一致

date

检查数据磁盘文件系统类型 期望值:ext4

df -T

服务器字符集 期望值:en_US.UTF-8

echo $LANG

输出如下:

[root@node02 ~]# echo $LANGen_US.UTF-8

swap交换内存 期望值:关闭 swap显示0

free

输出如下:

[root@node02 ~]# free              total        used        free      shared  buff/cache   availableMem:       31620992      712156    30208228       15012      700608    30259976Swap:             0           0           0

java版本

期望值:>=1.8.0

java -version

输出如下:

[root@node02 ~]# java -versionopenjdk version "1.8.0_272"OpenJDK Runtime Environment Bisheng (build 1.8.0_272-b10)OpenJDK 64-Bit Server VM Bisheng (build 25.272-b10, mixed mode)

python3版本

期望值:>3.7.4(arm) >3.7.9(x86)

python3

输出如下:

[root@node02 ~]# python3Python 3.7.9 (default, Mar  2 2021, 02:43:11)[GCC 7.3.0] on linuxType "help", "copyright", "credits" or "license" for more information.

expect

期望值:有回显

expect -v

输出如下:

[root@node01 ~]# expect -vexpect version 5.45.4

openssl

期望值:有回显

[root@node01 ~]# openssl versionOpenSSL 1.1.1f  31 Mar 2020

root密码一致

期望值:所有节点的root密码一致

注意:

用户密码中不能含有admin(不区分大小写)单词

用户密码中不能出现连续的重复字符,以及连续的数字不能超过两个

不然后面安装时会报错

root用户ssh连通性

期望值:集群节点root用户的ssh连通

--节点1ssh node02ssh node03--节点2ssh node01ssh node03--节点3ssh node01ssh node02

上传软件包和安装脚本

联系华为厂商申请并下载相应版本的安装介质。本文档是GaussDB 24.1.30 分布式

安装脚本另外联系华为厂商获取:GaussDBInstaller_1.0.5.6_20230630015648.tar.gz

--创建存放安装介质的目录mkdir -p /gaussdb/soft/pkg

将安装包上传到了/gaussdb/soft目录下。

安装脚本:GaussDBInstaller_1.0.5.6_20230630015648.tar.gz

安装介质:

总共3个文件:GaussDB-Kernel_505.1.0.B026_Om_X86_Distributed.tar.gz 分集中式分布式注意版本

GaussDB-Kernel_505.1.0.B026_Server_X86_Distributed.tar.gz 分集中式分布式注意版本

  • DBS-GaussDB-Kernel_24.1.30.835752444875136.tar.gz(windows上用7z打开逐层打开直到看到如下2个文件,将如下2个文件上传至/gaussdb/soft/pkg目录下)
[root@node01 pkg]# ls -l Gau*-rw-r--r-- 1 root root  32392827  4月 18 23:49 GaussDB-Kernel_505.1.0.B026_Om_X86_Distributed.tar.gz-rw-r--r-- 1 root root 861349604  4月 18 23:49 GaussDB-Kernel_505.1.0.B026_Server_X86_Distributed.tar.gz
  • DBS-MetaDB_Kylin_Centralized_505.1.RC1.SPC0100.B006 .tar.gz(windows上用7z打开逐层打开直到看到如下2个文件,将如下2个文件上传至/gaussdb/soft/pkg目录下)
[root@node01 pkg]# ls -l *Ad*-rw-r--r-- 1 root root 427997  3月 29 10:21 DBS-GaussDB-Adaptor_2.23.07.265.1708416436.tar.gz

安装脚本配置

解压安装脚本

cd /gaussdb/soft/pkgunzip GaussDBInstaller_1.0.5.6_20230630015648.tar.gz

输出如下:

[root@node01 pkg]# tar -xvf GaussDBInstaller_1.0.5.6_20230630015648.tar.gzGaussDBInstaller/GaussDBInstaller/install_cluster.confGaussDBInstaller/ReadMe.txtGaussDBInstaller/gaussdb_install.pyGaussDBInstaller/pkgDir/GaussDBInstaller/pkgDir/ReadMe.txtGaussDBInstaller/jsonFileSample/GaussDBInstaller/jsonFileSample/3_nodes_centralized_paxos.jsonGaussDBInstaller/jsonFileSample/3_nodes_distributed.jsonGaussDBInstaller/jsonFileSample/4_nodes_distributed_4shards.jsonGaussDBInstaller/jsonFileSample/1_node.jsonGaussDBInstaller/jsonFileSample/5_nodes_distributed.jsonGaussDBInstaller/jsonFileSample/2_nodes_centralized_1primary_1standby_1logger.jsonGaussDBInstaller/jsonFileSample/4_nodes_distributed_8shards.jsonGaussDBInstaller/jsonFileSample/5_nodes_centralized.jsonGaussDBInstaller/jsonFileSample/9_nodes_distributed_8shards.jsonGaussDBInstaller/jsonFileSample/9_nodes_distributed_4shards.jsonGaussDBInstaller/jsonFileSample/3_nodes_centralized.jsonGaussDBInstaller/jsonFileSample/3_nodes_centralized_1primary_1standby_1logger.jsonGaussDBInstaller/install_cluster.sh

安装包移动

下面三个软件包上传至 /data/GaussDBInstaller/pkgDir 目录下 ,版本号根据具体的项目更改。

DBS-GaussDB-Adaptor_2.23.07.265.1708416436.tar.gz

GaussDB-Kernel_505.1.0.B026_Om_X86_Distributed.tar.gz

GaussDB-Kernel_505.1.0.B026_Server_X86_Distributed.tar.gz

cp /gaussdb/soft/pkg/DBS-GaussDB-Adaptor_2.23.07.265.1708416436.tar.gz /gaussdb/soft/pkg/GaussDBInstaller/pkgDir/cp /gaussdb/soft/pkg/GaussDB-Kernel_505.1.0.B026_Om_X86_Distributed.tar.gz /gaussdb/soft/pkg/GaussDBInstaller/pkgDir/cp /gaussdb/soft/pkg/GaussDB-Kernel_505.1.0.B026_Server_X86_Distributed.tar.gz /gaussdb/soft/pkg/GaussDBInstaller/pkgDir/

配置文件修改

修改 安装脚本中的install_cluster.conf 配置文件 install_cluster.conf 配置文件参数说明 注意:密码中不能用连续的数字

cd /gaussdb/soft/pkg/GaussDBInstaller/cp install_cluster.conf install_cluster.conf_bak_`date +%F`cat install_cluster.conf[COMMON]    os_user = omm    #不修改!!! -操作系统上安装数据库的用户os_user_group = ${os_user}    #不修改!!! -操作系统上安装数据库的用户组os_user_home = /home/${os_user}    #不修改!!! -数据库用户家目录os_user_passwd = Gauss_246   #不修改!!! -操作系统上安装数据库的用户的密码建议与下面的root密码一致root_passwd = Huawei@135  #os root密码 修改为自己实际的,保证所有节点密码一致ssh_port = 22 #ssh端口node_ip_list = 192.168.0.162,192.168.0.192,192.168.0.164 ##所有节点的IP,数据库安装涉及到的全都要写,修改为自己实际的,以,进行隔开[OMAGENT]gauss_home = /data/cluster #集群安装目录,将此处的/data修改为自己磁盘的实际挂载目录,确保/data下的cluster目录提前不存在,需要选择磁盘容量超过50G的分区目录om_agent_port = 30170  #不修改!!!omagent服务端口,确保该端口未被使用,需要注意的是om_agent端口不能与install_cluster.json中的dbPort相同mgr_net =  #不修改!!!mgr_net data_net virtual_net三个参数无需配置,1.0.3以后的版本自动配置data_net =   #不修改!!!mgr_net data_net virtual_net三个参数无需配置,1.0.3以后的版本自动配置virtual_net =  #不修改!!!mgr_net data_net virtual_net三个参数无需配置,1.0.3以后的版本自动配置log_dir     = ${gauss_home}/logs/gaussdb  ##不修改!!!${gauss_home}表示的是/data/cluster,如果有特殊需要可自行修改cn_dir     = ${gauss_home}/data/cn #不修改!!!${gauss_home}表示的是/data/cluster,如果有特殊需要可自行修改gtm_dir     = ${gauss_home}/data/gtm  #不修改!!!${gauss_home}表示的是/data/cluster,如果有特殊需要可自行修改cm_dir      = ${gauss_home}/data/cm  #不修改!!!${gauss_home}表示的是/data/cluster,如果有特殊需要可自行修改tmp_dir     = ${gauss_home}/temp  #不修改!!!${gauss_home}表示的是/data/cluster,如果有特殊需要可自行修改data_dir    = ${gauss_home}/data/dn  #不修改!!!${gauss_home}表示的是/data/cluster,如果有特殊需要可自行修改tool_dir    = ${gauss_home}/tools  #不修改!!!${gauss_home}表示的是/data/cluster,如果有特殊需要可自行修改etcd_dir    = ${gauss_home}/data/etcd  #不修改!!!${gauss_home}表示的是/data/cluster,如果有特殊需要可自行修改

补充:

数据库安装目录:默认路径都是/data/cluster

1.如果没有自定义路径的需求,默认即可

2.如果有自定义cn、dn、etcd、gtm路径安装的需求:

举例:需要把cn_dir路径配置到/data/cn路径下配置修改格式:cn dir=/data/cn

其他路径的自定义路径同上

修改后的install_cluster.conf 配置文件

cd /gaussdb/soft/pkg/GaussDBInstaller/vi install_cluster.conf[COMMON]os_user = ommos_user_group = ${os_user}os_user_home = /home/${os_user}os_user_passwd = Topnet@123root_passwd = Topnet@123ssh_port = 22node_ip_list = 192.168.30.51,192.168.30.52,192.168.30.53[OMAGENT]gauss_home = /gaussdb/clusterom_agent_port = 30170mgr_net =data_net =virtual_net =log_dir     = ${gauss_home}/logs/gaussdbcn_dir     = ${gauss_home}/data/cngtm_dir     = ${gauss_home}/data/gtmcm_dir      = ${gauss_home}/data/cmtmp_dir     = ${gauss_home}/tempdata_dir    = ${gauss_home}/data/dntool_dir    = ${gauss_home}/toolsetcd_dir    = ${gauss_home}/data/etcd

查看脚本安装内容 说明:如下所示为常见的不同部署方式的配置文件,根据自己的需要选择即可:

centralized:集中式

distributed:分布式

[root@node01 ~]# ll /gaussdb/soft/pkg/GaussDBInstaller/jsonFileSample/total 68-rw------- 1 root root 1021 Jun 30  2023 1_node.json-rw------- 1 root root 2138 Jun 30  2023 2_nodes_centralized_1primary_1standby_1logger.json-rw------- 1 root root 2246 Jun 30  2023 3_nodes_centralized_1primary_1standby_1logger.json-rw------- 1 root root 2187 Jun 30  2023 3_nodes_centralized.json-rw------- 1 root root 2186 Jun 30  2023 3_nodes_centralized_paxos.json-rw------- 1 root root 4048 Jun 30  2023 3_nodes_distributed.json-rw------- 1 root root 3860 Jun 30  2023 4_nodes_distributed_4shards.json-rw------- 1 root root 5889 Jun 30  2023 4_nodes_distributed_8shards.json-rw------- 1 root root 2811 Jun 30  2023 5_nodes_centralized.json-rw------- 1 root root 6128 Jun 30  2023 5_nodes_distributed.json-rw------- 1 root root 6128 Jun 30  2023 9_nodes_distributed_4shards.json-rw------- 1 root root 9456 Jun 30  2023 9_nodes_distributed_8shards.json

修改 install_cluster.json 配置文件

拷贝json文件

拷贝指定部署方式的json文件(以3节点分布式为例)到脚本解压后的目录GaussDBInstaller下

cp /gaussdb/soft/pkg/GaussDBInstaller/jsonFileSample/3_nodes_distributed.json /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.json

修改 install_cluster.json 配置文件

说明:以下参数如无特殊说明都不要进行修改,使用时请删除掉注释

cat /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.jsoncp /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.json /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.json_bak_`date +%F`cat /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.json{#安装数据库时创建的omm用户是操作系统数据库用户,真正的数据库用户和密码如下rdsAdminUser和rdsAdminPasswd "rdsAdminUser":"rdsAdmin", "rdsAdminPasswd":"Gauss_123", "rdsMetricUser":"rdsMetric", "rdsMetricPasswd":"huawei@123Pwd", "rdsReplUser":"rdsRepl", "rdsReplPasswd":"huawei@123Pwd", "rdsBackupUser":"rdsBackup", "rdsBackupPasswd":"huawei@123Pwd", "dbPort":"8000", "dbUser":"root", "dbUserPasswd":"Topnet@123",  #修改为自己的root账户密码 "clusterMode":"combined", "params":{     "enable_thread_pool":"on",     "enable_bbox_dump":"on",     "bbox_dump_path":"/home/core" }, "cnParams":{ }, "dnParams":{ }, "cmParams":{ }, "clusterConf":{     "clusterName":"Gauss_XuanYuan",     "encoding": "utf8",     "shardingNum": 3,     "replicaNum": 3,     "solution":"hws",     "cm":[         {      "rack": "node01",  #将下列中的所有rack值修改为自己的服务器节点主机名,将对应节点下面的IP全部换成节点的IP值,如node01节点下所有的IP为192.168.1.101      "az": "AZ1",      "ip": "192.168.30.51",      "dataIp":"192.168.30.51",      "virtualIp":"192.168.30.51"    },    {      "rack": "node02",      "az": "AZ2",      "ip": "192.168.30.52",      "dataIp":"192.168.30.52",      "virtualIp":"192.168.30.52"    },    {      "rack": "node03",      "az": "AZ3",      "ip": "192.168.30.53",      "dataIp":"192.168.30.53",      "virtualIp":"192.168.30.53"    }    ],    "cn":[     {      "rack": "node01",      "az": "AZ1",      "ip": "192.168.30.51",      "dataIp":"192.168.30.51",      "virtualIp":"192.168.30.51"    },    {      "rack": "node02",      "az": "AZ2",      "ip": "192.168.30.52",      "dataIp":"192.168.30.52",      "virtualIp":"192.168.30.52"    },    {      "rack": "node03",      "az": "AZ3",      "ip": "192.168.30.53",      "dataIp":"192.168.30.53",      "virtualIp":"192.168.30.53"    }    ],    "gtm":[     {      "rack": "node01",      "az": "AZ1",      "ip": "192.168.30.51",      "dataIp":"192.168.30.51",      "virtualIp":"192.168.30.51"    },    {      "rack": "node02",      "az": "AZ2",      "ip": "192.168.30.52",      "dataIp":"192.168.30.52",      "virtualIp":"192.168.30.52"    },    {      "rack": "node03",      "az": "AZ3",      "ip": "192.168.30.53",      "dataIp":"192.168.30.53",      "virtualIp":"192.168.30.53"    }    ],    "shards":[      [    {      "rack": "node01",      "az": "AZ1",      "ip": "192.168.30.51",      "dataIp":"192.168.30.51",      "virtualIp":"192.168.30.51"    },    {      "rack": "node02",      "az": "AZ2",      "ip": "192.168.30.52",      "dataIp":"192.168.30.52",      "virtualIp":"192.168.30.52"    },    {      "rack": "node03",      "az": "AZ3",      "ip": "192.168.30.53",      "dataIp":"192.168.30.53",      "virtualIp":"192.168.30.53"    }      ],      [     {      "rack": "node02",      "az": "AZ2",      "ip": "192.168.30.52",      "dataIp":"192.168.30.52",      "virtualIp":"192.168.30.52"    },     {      "rack": "node01",      "az": "AZ1",      "ip": "192.168.30.51",      "dataIp":"192.168.30.51",      "virtualIp":"192.168.30.51"    },    {      "rack": "node03",      "az": "AZ3",      "ip": "192.168.30.53",      "dataIp":"192.168.30.53",      "virtualIp":"192.168.30.53"    }       ],     [    {      "rack": "node03",      "az": "AZ3",      "ip": "192.168.30.53",      "dataIp":"192.168.30.53",      "virtualIp":"192.168.30.53"    },    {      "rack": "node02",      "az": "AZ2",      "ip": "192.168.30.52",      "dataIp":"192.168.30.52",      "virtualIp":"192.168.30.52"    },    {      "rack": "node01",      "az": "AZ1",      "ip": "192.168.30.51",      "dataIp":"192.168.30.51",      "virtualIp":"192.168.30.51"    }     ]    ],     "etcd":{       "nodes":[    {      "rack": "node01",      "az": "AZ1",      "ip": "192.168.30.51",      "dataIp":"192.168.30.51",      "virtualIp":"192.168.30.51"    },    {      "rack": "node02",      "az": "AZ2",      "ip": "192.168.30.52",      "dataIp":"192.168.30.52",      "virtualIp":"192.168.30.52"    },    {      "rack": "node03",      "az": "AZ3",      "ip": "192.168.30.53",      "dataIp":"192.168.30.53",      "virtualIp":"192.168.30.53"    }       ]     } }}

安装包检查

查看pkgDir目录下的安装包 注意:此处注意清理掉其他所有文件,仅仅保留以下的几个文件

[root@node01 ~]# ls -l /gaussdb/soft/pkg/GaussDBInstaller/pkgDirtotal 873224-rw-r--r-- 1 root root    427997 Aug 20 19:11 DBS-GaussDB-Adaptor_2.23.07.265.1708416436.tar.gz-rw-r--r-- 1 root root  32392827 Aug 20 19:11 GaussDB-Kernel_505.1.0.B026_Om_X86_Distributed.tar.gz-rw-r--r-- 1 root root 861349604 Aug 20 19:11 GaussDB-Kernel_505.1.0.B026_Server_X86_Distributed.tar.gz

补充:实例安装原理

GaussDB 数据库使用 adaptor接口方式的安装,在adaptor、om-agent安装完成后,会调用 adaptor接口来执行实例的预安装和安装。

安装

--切换目录cd /gaussdb/soft/pkg/GaussDBInstallerpwd  --输出 /gaussdb/soft/pkg/GaussDBInstaller--执行安装命令python3 gaussdb_install.py --action main

环境变量配置

vi /etc/profile增加export GAUSSDB_HOME=/gaussdb/cluster/core/app_da28c417PATH尾部增加export PATH=$PATH:$UNPACKPATH/script/gspylib/pssh/bin:$UNPACKPATH/script:$GAUSSDB_HOME/binLD_LIBRARY_PATH尾部增加export LD_LIBRARY_PATH=/gaussdb/cluster/pylib/libsimsearch:$LD_LIBRARY_PATH:$GAUSSDB_HOME/lib--环境变量生效source /etc/profile

查看集群状态

查看集群状态

必须切换到安装用户omm下才有结果输出。

su - omm  cm_ctl query -Cvipd | grep cluster_state或cm_ctl query -Cvipd

输出如下:

[root@node01 GaussDBInstaller]# su - ommLast login: Wed Aug 21 11:50:13 CST 2024 on pts/1[omm@node01 ~]$ cm_ctl query -Cvipd | grep cluster_statecluster_state   : Normal[omm@node01 ~]$ cm_ctl query -Cvipd[  CMServer State   ]node             node_ip         instance                                state--------------------------------------------------------------------------------1  192.168.30.51 192.168.30.51   1    /gaussdb/cluster/data/cm/cm_server Primary2  192.168.30.52 192.168.30.52   2    /gaussdb/cluster/data/cm/cm_server Standby3  192.168.30.53 192.168.30.53   3    /gaussdb/cluster/data/cm/cm_server Standby[    ETCD State     ]node             node_ip         instance                        state------------------------------------------------------------------------------1  192.168.30.51 192.168.30.51   7001 /gaussdb/cluster/data/etcd StateLeader2  192.168.30.52 192.168.30.52   7002 /gaussdb/cluster/data/etcd StateFollower3  192.168.30.53 192.168.30.53   7003 /gaussdb/cluster/data/etcd StateFollower[   Cluster State   ]cluster_state   : Normalredistributing  : Nobalanced        : Yescurrent_az      : AZ_ALL[ Coordinator State ]node             node_ip         instance                             state----------------------------------------------------------------------1  192.168.30.51 192.168.30.51   5001 8000   /gaussdb/cluster/data/cn Normal2  192.168.30.52 192.168.30.52   5002 8000   /gaussdb/cluster/data/cn Normal3  192.168.30.53 192.168.30.53   5003 8000   /gaussdb/cluster/data/cn Normal[ Central Coordinator State ]node             node_ip         instance                      state----------------------------------------------------------------------1  192.168.30.51 192.168.30.51   5001 /gaussdb/cluster/data/cn Normal[     GTM State     ]node             node_ip         instance                       state                    sync_state-------------------------------------------------------------------------------------------------------1  192.168.30.51 192.168.30.51   1001 /gaussdb/cluster/data/gtm P Primary Connection ok  Sync2  192.168.30.52 192.168.30.52   1002 /gaussdb/cluster/data/gtm S Standby Connection ok  Sync3  192.168.30.53 192.168.30.53   1003 /gaussdb/cluster/data/gtm S Standby Connection ok  Sync[  Datanode State   ]node             node_ip         instance                                     state            | node             node_ip         instance                               state            | node             node_ip         instance                                     state---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1  192.168.30.51 192.168.30.51   6001 33100  /gaussdb/cluster/data/dn/dn_6001 P Primary Normal | 2  192.168.30.52 192.168.30.52   6002 33100  /gaussdb/cluster/data/dn/dn_6002 S Standby Normal | 3  192.168.30.53 192.168.30.53   6003 33100  /gaussdb/cluster/data/dn/dn_6003 S Standby Normal2  192.168.30.52 192.168.30.52   6004 33120  /gaussdb/cluster/data/dn/dn_6004 P Primary Normal | 1  192.168.30.51 192.168.30.51   6005 33120  /gaussdb/cluster/data/dn/dn_6005 S Standby Normal | 3  192.168.30.53 192.168.30.53   6006 33120  /gaussdb/cluster/data/dn/dn_6006 S Standby Normal3  192.168.30.53 192.168.30.53   6007 33140  /gaussdb/cluster/data/dn/dn_6007 P Primary Normal | 2  192.168.30.52 192.168.30.52   6008 33140  /gaussdb/cluster/data/dn/dn_6008 S Standby Normal | 1  192.168.30.51 192.168.30.51   6009 33140  /gaussdb/cluster/data/dn/dn_6009 S Standby Normal

问题处理

--查看集群状态[root@node01 GaussDBInstaller]# cm_ctl query -cvip-bash: cm_ctl: command not found[root@node01 ~]# cm_ctl query -cvipcm_ctl: error while loading shared libraries: libcjson.so.1: cannot open shared object file: No such file or directory--问题原因未配置环境变量导致--解决办法按照上面的环境变量配置解决

问题处理

ERROR: install_cluster.conf checked failed

--问题描述[root@node01 GaussDBInstaller]# python3 gaussdb_install.py --action main[2024-08-21 10:43:35][root][INFO]:Start to execute cmd: sh /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.sh getCurrentIp  192.168.30.51 192.168.30.52 192.168.30.53[2024-08-21 10:43:36][root][INFO]:End to execute cmd sh /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.sh getCurrentIp  192.168.30.51 192.168.30.52 192.168.30.53 192.168.30.52 192.168.30.53[2024-08-21 10:43:36][root][INFO]:Start to execute preProcess...[2024-08-21 10:43:36][root][INFO]:ADAPTOR_PACKAGE exists[2024-08-21 10:43:36][root][INFO]:AGENT_PACKAGE exists[2024-08-21 10:43:36][root][INFO]:SERVER_PACKAGE exists[2024-08-21 10:43:36][root][INFO]:Integrity check passed[2024-08-21 10:43:36][root][ERROR]:User passwd check failed! The password can't contain more than two consecutive digits.[2024-08-21 10:43:36][root][ERROR]:conf key:os_user_passwd check failedERROR: install_cluster.conf checked failed--问题原因密码不能包含两个以上的连续数字--解决办法更改服务器root用户密码符合要求su - rootpasswd

install_cluster.json file ip not configure

--问题描述安装提示[root@node01 GaussDBInstaller]# python3 gaussdb_install.py --action main[2024-08-21 10:52:03][root][INFO]:Start to execute cmd: sh /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.sh getCurrentIp  192.168.30.51 192.168.30.52 192.168.30.53[2024-08-21 10:52:03][root][INFO]:End to execute cmd sh /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.sh getCurrentIp  192.168.30.51 192.168.30.52 192.168.30.53 192.168.30.52 192.168.30.53[2024-08-21 10:52:03][root][INFO]:Start to execute preProcess...[2024-08-21 10:52:03][root][INFO]:ADAPTOR_PACKAGE exists[2024-08-21 10:52:03][root][INFO]:AGENT_PACKAGE exists[2024-08-21 10:52:03][root][INFO]:SERVER_PACKAGE exists[2024-08-21 10:52:03][root][INFO]:Integrity check passed[2024-08-21 10:52:03][root][INFO]:Start to execute cmd: mkdir -p /gaussdb/cluster[2024-08-21 10:52:03][root][INFO]:End to execute cmd mkdir -p /gaussdb/cluster[2024-08-21 10:52:03][root][INFO]:Start check json file[2024-08-21 10:52:03][root][INFO]:Start to execute cmd: cat /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.json[2024-08-21 10:52:03][root][INFO]:End to execute cmd cat /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.json[2024-08-21 10:52:03][root][INFO]:preProcess start check disk capacity[2024-08-21 10:52:03][root][INFO]:Start to execute cmd: df -h /gaussdb/cluster |grep "/" |awk '{print $4}' | awk '$1=$1'[2024-08-21 10:52:03][root][INFO]:End to execute cmd df -h /gaussdb/cluster |grep "/" |awk '{print $4}' | awk '$1=$1'[2024-08-21 10:52:03][root][INFO]:Start check json file[2024-08-21 10:52:03][root][INFO]:Start to execute cmd: cat /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.json[2024-08-21 10:52:03][root][INFO]:End to execute cmd cat /gaussdb/soft/pkg/GaussDBInstaller/install_cluster.json[2024-08-21 10:52:03][root][INFO]:mgr_net_ip = , data_net_ip= , virtual_net_ip=[2024-08-21 10:52:03][root][ERROR]:preProcess check failed: install_cluster.json file ip not configureFalse--问题原因/gaussdb/soft/pkg/GaussDBInstaller/install_cluster.json  未更改--解决办法/gaussdb/soft/pkg/GaussDBInstaller/install_cluster.json  更改参数文件中的参数

扩展

实例安装原理

GaussDB 数据库使用 adaptor接口方式的安装,在adaptor、om-agent安装完成后,会调用 adaptor接口来执行实例的预安装和安装。

安装步骤分解

GaussDB管理平台的agent

adaptor接口日志位置:/home/omm/log/adaptor_log

om_agent安装

--安装om-agentpython3 /gaussdb/soft/pkg/GaussDBInstaller/pkgDir/omagent/agent/mgr/install.py,其中,/gaussdb/soft/pkg/GaussDBInstaller路径为om-agent包的解压路径--查看om_agent  om_agent.py进程在表示安装成功ps -ef | grep om_agent--日志位置/home/omm/log/om_agent/home/omm/log/om_tmp

预安装、安装

预安装、安装由上层组装json体,通过调用adaptor接口来实现

预安装的目的是在实例安装前完成实例的环境配置,以保证实例安装的正常进行预安装的 adaptor 接口名称为 preinstall,预安装需要在待安装实例的所有节点上以实例用户身份来执行。预安装完成后,就可以进行实例的安装了。实例安装的 adaptor 接口名称为 install,只需以实例用户身份在实例任一个节点上执行即可。

安装日志位置:/gaussdb/soft/pkg/GaussDBInstaller 下的install_cluster.log

安装成功标志:

--查看集群状态 必须切换到安装用户omm下才有结果输出。su - omm  cm_ctl query -Cvipd

本文作者:董小姐

标签: gaussdb 分布式 wpf

本文转载自: https://blog.csdn.net/GaussDB/article/details/141678136
版权归原作者 Gauss松鼠会 所有, 如有侵权,请联系我们删除。

“GaussDB 24.1.30 分布式3节点命令行方式部署”的评论:

还没有评论