GaussDB Inside 2.23.01.280 集中式一主一备安装

GaussDB Inside 2.23.01.280 集中式一主一备安装文档一、环境规划节点主机名IP角色节点 1node110.10.9.211主库节点 2node210.10.9.212备库以下“系统准备”步骤需在两台机器上执行除非特别注明。二、修改主机名和 hostsnode1 执行hostnamectl set-hostname node1execbashnode2 执行hostnamectl set-hostname node2execbash两台机器均写入/etc/hostscat/etc/hostsEOF 10.10.9.211 node1 10.10.9.212 node2 EOF验证hostnamegetent hosts node1 getent hosts node2ping-c1node2三、系统基础配置1. SELinuxsed-is/^SELINUX.*/SELINUXdisabled//etc/selinux/config setenforce0getenforcegetenforce应返回Disabled修改/etc/selinux/config后建议重启服务器使配置彻底生效。2. 防火墙和 iptablessystemctl stop firewalld systemctl disable firewalld iptables-F3. 文件句柄、进程数和资源限制不要覆盖/etc/security/limits.conf创建独立配置cat/etc/security/limits.d/99-gaussdb-omm.confEOF omm soft nofile 1000000 omm hard nofile 1000000 omm soft nproc 1000000 omm hard nproc 1000000 omm soft stack 32768 omm hard stack 32768 omm soft memlock unlimited omm hard memlock unlimited omm soft core unlimited omm hard core unlimited EOF配置系统参数cat/etc/sysctl.d/99-gaussdb.confEOF kernel.core_pattern /opt/gaussdb/corefile/core-%e-%p-%t fs.file-max 2097152 fs.nr_open 1048576 kernel.pid_max 4194304 EOFsysctl--system创建 core 文件目录mkdir-p/opt/gaussdb/corefilechmod750/opt/gaussdb/corefile设置当前及后续登录 shell 的 core 限制cat/etc/profileEOF # GaussDB core dump ulimit -c unlimited EOFsource/etc/profile验证sysctlfs.file-max fs.nr_open kernel.pid_max kernel.core_pattern四、准备安装目录和安装介质node1执行即可mkdir-p/opt/software/Gaussdbmkdir-p/opt/gaussdb将安装总包上传到/opt/software/Gaussdb/例如GaussDB_X86_Kylinv10_Centralized_2.23.01.280_20240826073625.tar.gz解压总安装包cd/opt/software/Gaussdbtar-xfGaussDB_X86_Kylinv10_Centralized_2.23.01.280_20240826073625.tar.gz确认总包解压后包含gauss目录ls-l进入gauss目录并将 OM、Server 安装组件解压到当前安装介质根目录cd/opt/software/Gaussdb/gausstar-xfGaussDB-Kernel_503.1.0.SPC2700.B015_Om_X86_Centralized.tar.gztar-xfGaussDB-Kernel_503.1.0.SPC2700.B015_Server_X86_Centralized.tar.gz确认脚本和依赖文件存在ls-lscript/gs_preinstallls-lscript/gs_installls-ldependency/lib/libstdc.so.6为避免路径混乱统一将实际安装介质目录固定为/opt/software/Gaussdb如果解压后脚本位于/opt/software/Gaussdb/gauss/om/script则将 OM 内容同步至安装目录rsync-aH/opt/software/Gaussdb/gauss/om/ /opt/software/Gaussdb/复制 Kylin Server 二进制安装包至安装目录根路径cp-a\/opt/software/Gaussdb/gauss/server/kylin/GaussDB-Kernel_503.1.0.SPC2700_Kylin_64bit.bin\/opt/software/Gaussdb/最终确认ls-lh/opt/software/Gaussdb/GaussDB-Kernel_503.1.0.SPC2700_Kylin_64bit.binls-lh/opt/software/Gaussdb/dependency/lib/libstdc.so.6ls-lh/opt/software/Gaussdb/script/gs_preinstall五、创建 XML 配置文件在 node1 创建cd/opt/software/Gaussdb/scriptcatcluster_config.xmlEOF ?xml version1.0 encodingUTF-8? ROOT CLUSTER PARAM nameclusterName valuedbCluster / PARAM namenodeNames valuenode1,node2 / PARAM namegaussdbAppPath value/opt/gaussdb/install/app / PARAM namegaussdbLogPath value/opt/gaussdb/log/omm / PARAM nametmpMppdbPath value/opt/gaussdb/tmp / PARAM namegaussdbToolPath value/opt/gaussdb/tool / PARAM namecorePath value/opt/gaussdb/corefile / PARAM namebackIp1s value10.10.9.211,10.10.9.212 / PARAM nameclusterType valuesingle-inst / /CLUSTER DEVICELIST DEVICE snnode1 PARAM namename valuenode1 / PARAM nameazName valueAZ1 / PARAM nameazPriority value1 / PARAM namebackIp1 value10.10.9.211 / PARAM namesshIp1 value10.10.9.211 / PARAM namecmDir value/opt/gaussdb/install/cm / PARAM namecmsNum value1 / PARAM namecmServerPortBase value5000 / PARAM namecmServerlevel value1 / PARAM namecmServerListenIp1 value10.10.9.211,10.10.9.212 / PARAM namecmServerRelation valuenode1,node2 / PARAM namecmAgentConnectIp value10.10.9.211 / PARAM nameetcdNum value1 / PARAM nameetcdListenPort value2379 / PARAM nameetcdHaPort value2380 / PARAM nameetcdDir1 value/opt/gaussdb/install/etcd / PARAM nameetcdListenIp1 value10.10.9.211 / PARAM nameetcdHaIp1 value10.10.9.211 / PARAM namedataNum value1 / PARAM namedataPortBase value15400 / PARAM namedataListenIp value(10.10.9.211),(10.10.9.212) / PARAM namedataNode1 value/opt/gaussdb/install/data/dn,node2,/opt/gaussdb/install/data/dn / PARAM namedataNode1_syncNum value1 / /DEVICE DEVICE snnode2 PARAM namename valuenode2 / PARAM nameazName valueAZ1 / PARAM nameazPriority value1 / PARAM namebackIp1 value10.10.9.212 / PARAM namesshIp1 value10.10.9.212 / PARAM namecmDir value/opt/gaussdb/install/cm / PARAM nameetcdNum value1 / PARAM nameetcdListenPort value2379 / PARAM nameetcdHaPort value2380 / PARAM nameetcdDir1 value/opt/gaussdb/install/etcd / PARAM nameetcdListenIp1 value10.10.9.212 / PARAM nameetcdHaIp1 value10.10.9.212 / /DEVICE /DEVICELIST /ROOT EOF六、预安装在 node1 的 root 用户下执行cd/opt/software/Gaussdb/script ./gs_preinstall\-Uomm\-Gdbgrp\-X/opt/software/Gaussdb/script/cluster_config.xml\--alarm-type5执行期间会询问是否创建 root 用户 SSH 互信是否创建omm用户和 SSH 互信。均输入yes预安装成功标志Preinstallation succeeded.预安装完成后检查 OS 告警/opt/software/Gaussdb/script/gs_checkos-iA-hnode1,node2After the pre-installation is completed, execute the following commands on both machines:chown-Romm:dbgrp /opt/software/Gaussdbchown-Romm:dbgrp /opt/gaussdb确认ls-ld/opt/software/Gaussdb /opt/gaussdb七、授权安装目录预安装完成后两台机器均执行chown-Romm:dbgrp /opt/software/Gaussdbchown-Romm:dbgrp /opt/gaussdb确认ls-ld/opt/software/Gaussdb /opt/gaussdb八、正式安装仅在 node1 执行su- omm使用环境变量中的gs_installwhichgs_install执行安装gs_install-X/opt/software/Gaussdb/script/cluster_config.xml不要使用./gs_install-Uomm-Gdbgrp...因为正式安装阶段的gs_install不接受-U、-G和--alarm-type参数。安装成功时应看到类似Successfully started cluster. cluster_state : Normal Datanode State primary : 1 standby : 1 Successfully installed application.九、连接数据库在 node1以omm用户执行gsql-h127.0.0.1-p15400-dpostgres也可以指定主库 IPgsql-h10.10.9.211-p15400-dpostgres默认gsql -d postgres会连接默认 socket 和5432端口不适用于本配置。首次登录后修改密码ALTERROLEommPASSWORD请替换为强密码;查看内核版本selectversion();确认当前实例是否为主库selectpg_is_in_recovery();返回f表示当前实例为主库可读写。返回t表示当前实例为备库通常只读。退出数据库\q十、查看集群状态以omm用户执行gs_om-tstatus--detail简要状态gs_om-tstatus正常状态应包含cluster_state : Normal Datanode State primary : 1 standby : 1十一、常用端口服务端口GaussDB 主库连接端口15400CM Server5000etcd Client2379etcd Peer2380检查端口netstat-lntp|egrep15400|5000|2379|2380