gaussdb 200 安装及配置

CN端口号：25308
datanode端口号：40000

安装

1、操作系统要求：32G内存、centos6.4/6.5/6.6/6.7/6.8/6.9/7.0/7.1/7.2/7.3
2、修改/etc/sysctl.conf

# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Disable netfilter on bridges.
net.bridge.bridge-nf-call-ip6tables = 0
net.bridge.bridge-nf-call-iptables = 0
net.bridge.bridge-nf-call-arptables = 0

# Controls the default maxmimum size of a mesage queue
kernel.msgmnb = 65536

# Controls the maximum size of a message, in bytes
kernel.msgmax = 65536

# Controls the maximum shared segment size, in bytes

# Controls the maximum number of shared memory segments, in pages
net.core.rmem_default = 21299200
net.sctp.sctp_mem = 94500000 915000000 927000000
net.core.wmem_default = 21299200
kernel.shmall = 1152921504606846720
net.core.rmem_max = 21299200
net.core.somaxconn = 65535
vm.min_free_kbytes = 1644199
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_max_tw_buckets = 10000
net.sctp.sctp_rmem = 8192 250000 16777216
net.sctp.sctp_wmem = 8192 250000 16777216
net.ipv4.tcp_keepalive_intvl = 30
net.ipv4.tcp_tw_recycle = 1
kernel.sem = 250 6400000 1000 25600
kernel.shmmax = 18446744073709551615
net.ipv4.tcp_keepalive_time = 30
net.ipv4.tcp_max_syn_backlog = 65535
net.ipv4.tcp_rmem = 8192 250000 16777216
net.ipv4.tcp_retries2 = 80
net.ipv4.tcp_wmem = 8192 250000 16777216
net.core.wmem_max = 21299200
net.core.netdev_max_backlog = 65535
net.ipv4.tcp_keepalive_probes = 9
net.ipv4.tcp_retries1 = 5
net.ipv4.tcp_syn_retries = 5
net.ipv4.tcp_synack_retries = 5
net.sctp.path_max_retrans = 10
net.sctp.max_init_retransmits = 10
net.sctp.association_max_retrans = 10
net.sctp.hb_interval = 30000
vm.overcommit_memory = 0
net.sctp.sndbuf_policy = 0
net.sctp.rcvbuf_policy = 0
net.ipv4.tcp_syncookies = 1
net.sctp.addip_enable = 0
net.ipv4.tcp_fin_timeout = 60
net.ipv4.tcp_sack = 1
net.ipv4.tcp_timestamps = 1
vm.extfrag_threshold = 500
vm.overcommit_ratio = 90
SctpChecksumErrors = 0 --这条可能会报错，如果报错就删除

sysctl -p

2、关闭防火墙 service iptables stop
3、修改文件句柄
echo “* soft nofile 1000000” >>/etc/security/limits.conf
echo “* hard nofile 1000000” >>/etc/security/limits.conf
4、关闭selinux
vim /etc/selinux/config
修改SELINUX=disabled
5、允许root远程登录
vim /etc/ssh/sshd_config
修改PermitRootLogin yes

service sshd restart

6、重启操作系统
7、上传安装包及clusterconfig.xml
（1）上传安装包：
Gauss200_V100R008C10_PACKAGES.tar.gz
Gauss200-V100R008C10-REDHAT-64bit.bin
Gauss200-V100R008C10-REDHAT-64bit.sha256
（2）clusterconfig.xml文件内容

<?xml version="1.0" encoding="UTF-8"?>
<ROOT>
<!-- 集群级整体信息 -->
<CLUSTER>
<PARAM name="clusterName" value="localhost.localdomain"/>
<PARAM name="nodeNames" value="localhost.localdomain"/>
<PARAM name="gaussdbAppPath" value="/opt/gaussdb/app"/>
<PARAM name="gaussdbLogPath" value="/opt/gaussdb/log/gaussdb" />
<PARAM name="tmpMppdbPath" value="/opt/gaussdb/tmp/gaussdba_mppdb"/>
<PARAM name="gaussdbToolPath" value="/opt/gaussdb/huawei/wisequery"/>
<PARAM name="clusterType" value="single"/>
<PARAM name="networkType" value="0"/>
</CLUSTER>
<!-- 每台服务器上的实例部署信息 -->
<DEVICELIST>
<!-- plat上的实例部署信息 -->
<DEVICE sn="1000001">
<PARAM name="name" value="localhost.localdomain"/>
<!-- 如果服务器只有一个网卡可用，将backIP1和sshIP1配置成同一个IP -->
<PARAM name="backIp1" value="192.168.224.13"/>
<PARAM name="sshIp1" value="192.168.224.13"/>
<!-- gtm -->
<PARAM name="gtmNum" value="1"/>
<PARAM name="gtmDir1" value="/opt/gaussdb/data/data_gtm"/>
<PARAM name="gtmPortBase"  value="6000"/>
<PARAM name="gtmListenIp1" value="192.168.224.13"/>
<!-- cm -->
<PARAM name="cmsNum" value="1"/>
<PARAM name="cmServerlevel" value="1"/>
<PARAM name="cmAgentConnectIp1" value="192.168.224.13"/>
<PARAM name="cmServerPortBase" value="5000"/>
<PARAM name="cmDir" value="/opt/gaussdb/data/data_cm"/>
<PARAM name="cmServerListenIp1" value="192.168.224.13"/>
<!-- cn -->
<PARAM name="cooNum" value="1"/>
<PARAM name="cooPortBase" value="25308"/>
<PARAM name="cooDir1" value="/opt/gaussdb/data/data_cn"/>
<PARAM name="cooServerListenIp1" value="192.168.224.13"/>
<!-- dn -->
<PARAM name="dataNum" value="2"/>
<PARAM name="dataPortBase" value="40000"/>
<!-- <PARAM name="dataListenIp1" value="192.168.224.13"/>      -->
<PARAM name="dataNode1" value="/opt/gaussdb/data/data_dn1"/>
<PARAM name="dataNode2" value="/opt/gaussdb/data/data_dn2"/>
</DEVICE>
</DEVICELIST>
</ROOT>

（3）解压
tar -zxvf Gauss200_V100R008C10_PACKAGES.tar.gz
tar -zxvf Gauss200-V100R008C10-SUSE11-64bit.tar.gz
8、运行gs_checkos查看操作系统是否符合要求，没有abnormal就可以执行安装了
gs_checkos -i A --detail

9、root用户执行gs_preinstall
cd /opt/package/script
./gs_preinstall -U omm -G wheel -X /opt/package/clusterconfig.xml --alarm-type=1

10、操作系统omm用户
cd /opt/package/script
gs_install -X /opt/package/clusterconfig.xml

11、初始化数据库
gs_initdb /opt/gaussdb/data/data_n1 --nodename localhost.localdomain
//localhost.localdomain 为clusterconfig.xml 配置的nodename
gsql -d postgres -p 25308
gsql -d template1 -p 25308

配置远程登录

1、使用如下命令查看CN目前的listen_addresses配置
gs_guc check -Z coordinator -I all -c “listen_addresses”
查询结果如下：

expected guc information: localhost.localdomain: listen_addresses=NULL: [/opt/gaussdb/data/data_cn/postgresql.conf]
gs_guc check: localhost.localdomain: listen_addresses='*': [/opt/gaussdb/data/data_cn/postgresql.conf]

Total GUC values: 1. Failed GUC values: 0.
The value of parameter listen_addresses is same on all instances.
    listen_addresses='*'

（1）如果 listen_addresses的值为安装数据库IP需要修改CN配置文件postgres.conf，路径/opt/gaussdb/data/data_cn
或
（2）使用如下命令把要添加的IP追加到listen_addresses后面，多个配置项之间用英文逗号分隔。例如，追加IP地址10.11.12.13。

gs_guc set -I all -Z coordinator -c "listen_addresses='localhost,192.168.0.100,10.11.12.13'"

下面示例中配置允许IP地址为10.10.0.30的客户端访问本机

gs_guc set -Z coordinator -N all -I all -h "host all jack 10.10.0.30/32 sha256"

– 使用“jack”用户前，请先使用本地连接数据库，并在数据库中使用如下语句建立
“jack”用户。
postgres=# CREATE USER jack PASSWORD 'Gaussdba@Mpp';
– -Z coordinator表示实例类型为coordinator。
– -N all表示集群的所有主机。
– -I all表示主机中的所有实例。
– -h表示指定需要在“pg_hba.conf”增加的语句。
– all表示允许客户端连接到任意的数据库。
– jack表示数据库中已存在的用户。
– 10.10.0.30/32表示只允许IP地址为10.10.0.30的主机连接。在使用过程中，请根据用户的
网络进行配置修改。
– sha256表示连接时jack用户的密码使用sha256算法加密。

2、执行如下命令重启集群

gs_om -t stop && gs_om -t start

参考链接https://www.modb.pro/db/9231

命令

• 查询集群各实例情况 gs_om -t status --detail