GaussDB T 1.0.2 一主一备集群部署实战

sed -i 's/#PermitRootLogin yes/PermitRootLogin yes/g' /etc/ssh/sshd_configsed -i 's/#PasswordAuthentication yes/ PasswordAuthentication yes/g' /etc/ssh/sshd_config

/bin/systemctl restart sshd.service

systemctl stop firewalld.servicesystemctl disable firewalld.servicesed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

echo 'ulimit -c unlimited'>>/etc/profileecho 'kernel.core_pattern =/opt/gdb/corefile/core-%e-%p-%t'>>/etc/sysctl.conf

source /etc/profilesysctl -p

rpm -qa|grep ntp

yum install ntpwhich lsof

yum install lsof

groupadd dbgrpuseradd -g dbgrp -d /home/omm -m -s /bin/bash omm

passwd omm

mkdir -p /opt/software/gaussdb
[root@gauss1 gaussdb]# tar -zxvf GaussDB_T_1.0.2-CENTOS7.5-X86.tar.gz[root@gauss1 gaussdb]# tar -zxvf GaussDB_T_1.0.2-CLUSTER-CentOS-64bit.tar.gz
[root@gauss1 gaussdb]# chmod 755 /opt/software/[root@gauss1 gaussdb]# chmod -R 755 /opt/software/gaussdb/

[root@gauss1 ~]# vi /opt/software/gaussdb/clusterconfig.xml<?xml version="1.0" encoding="UTF-8"?><ROOT><!--  --> <CLUSTER>  <PARAM name="clusterName" value="GaussDB_100"/>  <PARAM name="nodeNames" value="gauss1,gauss2"/>  <PARAM name="gaussdbAppPath" value="/opt/gaussdb/app"/>  <PARAM name="gaussdbLogPath" value="/opt/gaussdb/log/"/>  <PARAM name="tmpMppdbPath" value="/opt/gaussdb/tmp/gaussdb_mppdb"/>  <PARAM name="gaussdbToolPath" value="/opt/gaussdb/huawei/wisequery"/>  <PARAM name="datanodeType" value="DN_ZENITH_HA"/>  <PARAM name="coordinatorType" value="CN_ZENITH_ZSHARDING"/>  <PARAM name="replicationCount" value="2"/>  <PARAM name="clusterType" value="mutil-AZ"/>
<!-- HA2 -->  <PARAM name="Ha2Node" value="true"/>  <PARAM name="GatewayIP" value="192.168.238.2"/>  <PARAM name="CMAgentPingTryTime" value="3"/>  <PARAM name="CMAgentPingInterval" value="5"/><!--floatip-->    <PARAM name="ServiceType" value="SingleService"/></CLUSTER><!-- --> <DEVICELIST>
  <!-- plat1 -->  <DEVICE sn="1000001">   <PARAM name="name" value="gauss1"/>   <PARAM name="azName" value="AZ1"/>   <PARAM name="azPriority" value="1"/>     <!-- IP -->   <PARAM name="backIp1" value="192.168.238.130"/>   <PARAM name="sshIp1" value="192.168.238.130"/>   <PARAM name="agentlsnPort" value="7020"/>   <!-- GTS -->    <!-- ETCD -->   <PARAM name="etcdNum" value="2"/>   <PARAM name="etcdListenPort" value="22100"/>   <PARAM name="etcdHaPort" value="22200"/>   <PARAM name="etcdListenIp1" value="192.168.238.130"/>   <PARAM name="etcdHaIp1" value="192.168.238.130"/>   <PARAM name="etcdDir1" value="/opt/gaussdb/data/data_etcd"/>   <PARAM name="etcdDir2" value="/opt/gaussdb/data/data_etcd1"/>   <!--cn-->   <!-- dn -->   <PARAM name="dataNum" value="1"/>   <PARAM name="dataPortBase" value="15402"/>   <PARAM name="dataNode1" value="/opt/gaussdb/data/data_dn1,gauss2,/opt/gaussdb/data/data_dn1"/>  </DEVICE>    <!-- plat2 -->  <DEVICE sn="1000002">   <PARAM name="name" value="gauss2"/>   <PARAM name="azName" value="AZ1"/>   <PARAM name="azPriority" value="1"/>     <!--IP -->   <PARAM name="backIp1" value="192.168.238.131"/>   <PARAM name="sshIp1" value="192.168.238.131"/>   <PARAM name="agentlsnPort" value="7020"/>    <!-- ETCD -->   <PARAM name="etcdNum" value="1"/>   <PARAM name="etcdListenPort" value="22100"/>   <PARAM name="etcdHaPort" value="22200"/>   <PARAM name="etcdListenIp1" value="192.168.238.131"/>   <PARAM name="etcdHaIp1" value="192.168.238.131"/>   <PARAM name="etcdDir1" value="/opt/gaussdb/data/data_etcd"/>   <!--cn-->   <!-- dn -->   <!-- cm -->   <PARAM name="cmsNum" value="1"/>   <PARAM name="cmServerPortBase" value="21900"/>   <PARAM name="cmServerListenIp1" value="192.168.238.131,192.168.238.130"/>   <PARAM name="cmServerHaIp1" value="192.168.238.131,192.168.238.130"/>   <PARAM name="cmServerlevel" value="1"/>   <PARAM name="cmServerRelation" value="gauss2,gauss1"/>  </DEVICE> </DEVICELIST></ROOT>

yum -y groupinstall "Development tools"yum -y install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gdbm-devel db4-devel libpcap-devel xz-develyum install libffi-devel -yyum install -y gcc

cd /rootwget https://www.python.org/ftp/python/3.7.0/Python-3.7.0.tar.xztar -xvJf  Python-3.7.0.tar.xz

mkdir /usr/local/python3 #创建编译安装目录cd Python-3.7.0./configure --prefix=/usr/local/python3make && make install

ln -s /usr/local/python3/bin/python3 /usr/local/bin/python3

python3 -Vpip3 –V

[root@gauss1 gaussdb]# cd /opt/software/gaussdb/script/[root@gauss1 script]# ./gs_preinstall -U omm -G dbgrp –X /opt/software/gaussdb/clusterconfig.xml

[root@gauss1 script]# ./gs_checkos -i B -h gauss1,gauss2 -X /opt/software/gaussdb/clusterconfig.xml

[root@gauss1 script]# su - omm[omm@gauss1 ~]$ gs_install -X /opt/software/gaussdb/clusterconfig.xml

[root@gauss1 script]# ./gs_preinstall -U omm -G dbgrp -X /opt/software/gaussdb/clusterconfig.xml[GAUSS-50204] : Failed to read cmServerRelation. The first item of cmServerRelation must be nodename.

[root@gauss1 script]# ./gs_preinstall -U omm -G dbgrp -X /opt/software/gaussdb/clusterconfig.xmlParsing the configuration file.Successfully parsed the configuration file.Installing the tools on the local node.Successfully installed the tools on the local node.Are you sure you want to create trust for root (yes/no)? yesPlease enter password for root.Password: Creating SSH trust for the root permission user.Successfully created SSH trust for the root permission user.All host RAM is consistentDistributing package.Successfully distributed package.Are you sure you want to create the user[omm] and create trust for it (yes/no)? yesInstalling the tools in the cluster.Successfully installed the tools in the cluster.Checking system resource.[FAILURE] gauss1:[GAUSS-53011] : Failed to check gatewayIP [192.168.238.10]. Please check gatewayIP config is vaild in your environment.[FAILURE] gauss2:[GAUSS-53011] : Failed to check gatewayIP [192.168.238.10]. Please check gatewayIP config is vaild in your environment.

[root@gauss1 script]# ./gs_checkos -i A12 -h gauss1,gauss2 -X /opt/software/gaussdb/clusterconfig.xml --detailRoot permission user has not SSH trust, create it when do checkos in remote node.Creating SSH trust for the root permission user.Please enter password for root.Password: Successfully creating SSH trust for the root permission user.Checking items    A12.[ Time consistency status ]                             : Warning            [gauss1]        The current system time = (2020-03-06 16:37:43")        [gauss2]        The current system time = (2020-03-06 16:37:45")
Total numbers:1. Abnormal numbers:0. Warning numbers:1.
Clean SSH trust for the root permission user.Successfully clean SSH trust for the root permission user.

[root@gauss1 ~]# cd /opt/software/gaussdb/script[root@gauss1 script]# ./gs_checkos -i C1 -h gauss1,gauss2 -X /opt/software/gaussdb/clusterconfig.xml
Root permission user has not SSH trust, create it when do checkos in remote node.Creating SSH trust for the root permission user.Please enter password for root.Password: Successfully creating SSH trust for the root permission user.
    C1. [ Set NTP Service ]                                     : NormalNOTICE: MTU value and some warning items can NOT be set. Please do it manually.Total numbers:1. Abnormal numbers:0. Warning numbers:0.
Clean SSH trust for the root permission user.Successfully clean SSH trust for the root permission user.

/opt/software/gaussdb/clusterconfig.xml
[omm@gauss1 ~]$ gs_uninstall --delete-data -X /opt/software/gaussdb/clusterconfig.xmlThe data will be deleted and cannot be recovered. Are you sure you want to uninstall the cluster(yes/no)?yesCheck preinstall on every node.Successfully checked preinstall on every node.Stop cluster.Check logfile path.Clean crontab.Clean crontab successfully.Kill process for components.Kill process for components successfully.Uninstall componentsUninstall components successfully.Modifying user's environmental variable.Successfully modified user's environmental variable.Clean tmp files and logs.Successfully clean cluster's tmp and logs.Successful uninstallation

[root@gauss1 script]# ./gs_postuninstall -U omm -X /opt/software/gaussdb/clusterconfig.xmlThe environment will be cleaned up and cannot be recovered.Are you sure you want to clean up the environment(yes/no)?yesParsing the configuration file.Successfully parsed the configuration file.Checking unpreinstallation.Success checking unpreinstallation.Deleting the instance paths.Deleting the instance paths successfully.Clean log and dependency.Clean up the user environment variablesClean up the user environment variable successfullyClean up the remote system tool environment variablesClean up the remote system tool environment variable successfullyClean up the local system tool environment variablesClean up the local system tool environment variable successfullyClean log and dependency successfully.Postuninstall successfully.Please close the terminal and login again, ensure that the environment variable takes effect.