|
|
环境说明：
|
|
|
10.10.14.211 gp-master
|
|
|
10.10.14.212 gp-segment1
|
|
|
10.10.14.213 gp-segment2
|
|
|
|
|
|
|
|
|
|
|
|
#由于在安装rpm包时用的是yum，所以不用先安装依赖包
|
|
|
#yum install -y apr-util bzip2 krb5-devel libyaml perl rsync zip net-tools libevent
|
|
|
|
|
|
|
|
|
|
|
|
#如果是VMWare虚拟机可以先安装VMTools
|
|
|
yum install -y open-vm-tools
|
|
|
systemctl enable vmtoolsd
|
|
|
systemctl start vmtoolsd
|
|
|
|
|
|
|
|
|
|
|
|
#关闭防火墙
|
|
|
systemctl disable firewalld.service
|
|
|
|
|
|
|
|
|
|
|
|
#关闭SELINUX
|
|
|
vi /etc/sysconfig/selinux
|
|
|
SELINUX=disabled
|
|
|
|
|
|
|
|
|
|
|
|
#所有服务器都进行如下几项优化
|
|
|
|
|
|
#sysctl.conf 文件优化 16G内存用如下配置
|
|
|
vi /etc/sysctl.conf
|
|
|
kernel.shmall = 2033239 #用以下命令计算 echo $(expr $(getconf _PHYS_PAGES) / 2)
|
|
|
kernel.shmmax = 8328146944 #用以下命令计算 echo $(expr $(getconf _PHYS_PAGES) / 2 \* $(getconf PAGE_SIZE))
|
|
|
kernel.shmmni = 4096
|
|
|
vm.overcommit_memory = 2
|
|
|
vm.overcommit_ratio = 95
|
|
|
|
|
|
kernel.sem = 500 2048000 200 4096
|
|
|
kernel.sysrq = 1
|
|
|
kernel.core_uses_pid = 1
|
|
|
kernel.msgmnb = 65536
|
|
|
kernel.msgmax = 65536
|
|
|
kernel.msgmni = 2048
|
|
|
net.ipv4.tcp_syncookies = 1
|
|
|
net.ipv4.conf.default.accept_source_route = 0
|
|
|
net.ipv4.tcp_max_syn_backlog = 4096
|
|
|
net.ipv4.conf.all.arp_filter = 1
|
|
|
net.core.netdev_max_backlog = 10000
|
|
|
net.core.rmem_max = 2097152
|
|
|
net.core.wmem_max = 2097152
|
|
|
vm.swappiness = 10
|
|
|
vm.zone_reclaim_mode = 0
|
|
|
vm.dirty_expire_centisecs = 500
|
|
|
vm.dirty_writeback_centisecs = 100
|
|
|
vm.dirty_background_ratio = 3
|
|
|
vm.dirty_ratio = 10
|
|
|
|
|
|
|
|
|
|
|
|
#优化limits.conf文件
|
|
|
vi /etc/security/limits.conf
|
|
|
|
|
|
* soft nproc 131072
|
|
|
* hard nproc 131072
|
|
|
* soft nofile 524288
|
|
|
* hard nofile 524288
|
|
|
|
|
|
|
|
|
#优化20-nproc.conf文件，注意CentOS系统有这个文件，openEuler系统没有这个文件不用优化
|
|
|
vi /etc/security/limits.d/20-nproc.conf
|
|
|
* soft nproc 131072
|
|
|
|
|
|
|
|
|
|
|
|
#优化SSH连接阈值
|
|
|
echo "
|
|
|
MaxStartups 10:30:200
|
|
|
MaxSessions 200
|
|
|
" >> /etc/ssh/sshd_config
|
|
|
|
|
|
|
|
|
|
|
|
--每台服务器进行修名
|
|
|
vi /etc/hostname
|
|
|
服务器1：gp-master
|
|
|
服务器2：gp-segment1
|
|
|
服务器3：gp-segment2
|
|
|
|
|
|
|
|
|
|
|
|
--每台服务器都做
|
|
|
vi /etc/hosts
|
|
|
10.10.14.211 gp-master
|
|
|
10.10.14.212 gp-segment1
|
|
|
10.10.14.213 gp-segment2
|
|
|
|
|
|
#重启一下服务器
|
|
|
|
|
|
|
|
|
|
|
|
#注：如果系统为openEuler 22.03 SP1，需执行如下命令，如果是CentOS7.9不用执行
|
|
|
ln -s /usr/lib64/libldap.so.2.0.200 /usr/lib64/libldap-2.4.so.2
|
|
|
ln -s /usr/lib64/libldap.so.2.0.200 /usr/lib64/libldap_r-2.4.so.2
|
|
|
ln -s /usr/lib64/libreadline.so.8.1 /usr/lib64/libreadline.so.6
|
|
|
ln -s /usr/lib64/libreadline.so.8.1 /usr/lib64/libreadline.so.7
|
|
|
|
|
|
|
|
|
--每台服务器都做
|
|
|
groupadd -g 530 gpadmin
|
|
|
useradd -g 530 -u 530 -m -d /usr/local/gpadmin -s /bin/bash gpadmin
|
|
|
chown -R gpadmin:gpadmin /usr/local/gpadmin
|
|
|
echo Dsideal4r5t6y7u | passwd --stdin gpadmin
|
|
|
|
|
|
|
|
|
#将rpm包到/usr/local下
|
|
|
|
|
|
--每台服务器都做
|
|
|
cd /usr/local && yum install -y open-source-greenplum-db-7.0.0-el8-x86_64.rpm
|
|
|
|
|
|
|
|
|
--master主机需要做
|
|
|
mkdir -p /usr/local/gpadmin/conf
|
|
|
|
|
|
|
|
|
--master主机需要做
|
|
|
vi /usr/local/gpadmin/conf/all_hosts
|
|
|
gp-master
|
|
|
gp-segment1
|
|
|
gp-segment2
|
|
|
|
|
|
|
|
|
--master主机需要做
|
|
|
vi /usr/local/gpadmin/conf/seg_hosts
|
|
|
gp-segment1
|
|
|
gp-segment2
|
|
|
|
|
|
chown -R gpadmin /usr/local/gpadmin
|
|
|
|
|
|
|
|
|
--master主机需要做
|
|
|
su - gpadmin
|
|
|
source /usr/local/greenplum-db/greenplum_path.sh
|
|
|
ssh-keygen
|
|
|
ssh-copy-id gp-segment1
|
|
|
ssh-copy-id gp-segment2
|
|
|
gpssh-exkeys -f /usr/local/gpadmin/conf/all_hosts
|
|
|
|
|
|
|
|
|
--master主机需要做
|
|
|
mkdir -p /usr/local/gpadmin/data/master
|
|
|
mkdir -p /usr/local/gpadmin/gpconfigs
|
|
|
|
|
|
|
|
|
--segment主机需要做
|
|
|
mkdir -p /usr/local/gpadmin/data/primary
|
|
|
mkdir -p /usr/local/gpadmin/data/mirror
|
|
|
chown -R gpadmin /usr/local/gpadmin
|
|
|
|
|
|
|
|
|
--master主机需要做
|
|
|
cp $GPHOME/docs/cli_help/gpconfigs/gpinitsystem_config /usr/local/gpadmin/gpconfigs
|
|
|
|
|
|
|
|
|
--master主机需要做
|
|
|
--主要配置
|
|
|
vi /usr/local/gpadmin/gpconfigs/gpinitsystem_config
|
|
|
|
|
|
declare -a DATA_DIRECTORY=(/usr/local/gpadmin/data/primary /usr/local/gpadmin/data/primary)
|
|
|
MASTER_HOSTNAME=gp-master
|
|
|
MASTER_DIRECTORY=/usr/local/gpadmin/data/master
|
|
|
MIRROR_PORT_BASE=7000
|
|
|
declare -a MIRROR_DATA_DIRECTORY=(/usr/local/gpadmin/data/mirror /usr/local/gpadmin/data/mirror)
|
|
|
|
|
|
|
|
|
vi /usr/local/gpadmin/.bashrc
|
|
|
MASTER_DATA_DIRECTORY=/usr/local/gpadmin/data/master/gpseg-1
|
|
|
export MASTER_DATA_DIRECTORY
|
|
|
|
|
|
source /usr/local/gpadmin/.bashrc
|
|
|
|
|
|
|
|
|
--master主机需要做
|
|
|
gpinitsystem -c /usr/local/gpadmin/gpconfigs/gpinitsystem_config -h /usr/local/gpadmin/conf/seg_hosts -D
|
|
|
|
|
|
#过程中未出错，出现-End Main就是安装完成
|
|
|
|
|
|
|
|
|
--增加用户
|
|
|
psql -d postgres
|
|
|
|
|
|
CREATE USER postgres WITH PASSWORD 'DsideaL147258369';
|
|
|
ALTER ROLE root SUPERUSER;
|
|
|
|
|
|
|
|
|
--master主机需要做
|
|
|
--配置谁可以连接
|
|
|
vi /usr/local/gpadmin/data/master/gpseg-1/pg_hba.conf
|
|
|
|
|
|
host all root 10.10.0.0/16 md5
|
|
|
|
|
|
--重新加载配置文件
|
|
|
gpstop -u
|
|
|
|
|
|
|
|
|
开机自启
|
|
|
|
|
|
vi gpStart.sh
|
|
|
|
|
|
#!/bin/sh
|
|
|
|
|
|
su - gpadmin -c "source /usr/local/greenplum-db/greenplum_path.sh && gpstart -a"
|
|
|
然后放到/etc/rc.local，别忘了给执行 chmod +x /etc/rc.d/rc.local |
