huanghai
/
QingLong
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'main'
${ noResults }
QingLong/Doc/方法与技巧/GreenPlum7安装.txt

215 lines
4.7 KiB
Raw Permalink Normal View History Unescape

commit
2 years ago
<EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵<EFBFBD><EFBFBD><EFBFBD><EFBFBD>
10.10.14.211<EFBFBD><EFBFBD><EFBFBD><EFBFBD>gp-master
10.10.14.212<EFBFBD><EFBFBD><EFBFBD><EFBFBD>gp-segment1
10.10.14.213<EFBFBD><EFBFBD><EFBFBD><EFBFBD>gp-segment2
#<23><><EFBFBD><EFBFBD><EFBFBD>ڰ<EFBFBD>װrpm<70><6D>ʱ<EFBFBD>õ<EFBFBD><C3B5><EFBFBD>yum<75><6D><EFBFBD><EFBFBD><EFBFBD>Բ<EFBFBD><D4B2><EFBFBD><EFBFBD>Ȱ<EFBFBD>װ<EFBFBD><D7B0><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
#yum install -y apr-util bzip2 krb5-devel libyaml perl rsync zip net-tools libevent
#<23><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>VMWare<72><65><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ȱ<EFBFBD>װVMTools
yum install -y open-vm-tools
systemctl enable vmtoolsd
systemctl start vmtoolsd
#<23>رշ<D8B1><D5B7><EFBFBD>ǽ
systemctl disable firewalld.service
#<23>ر<EFBFBD>SELINUX
vi /etc/sysconfig/selinux
SELINUX=disabled
#<23><><EFBFBD>з<EFBFBD><D0B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼<EFBFBD><C2BC><EFBFBD><EFBFBD>Ż<EFBFBD>
#sysctl.conf <20>ļ<EFBFBD><C4BC>Ż<EFBFBD> 16G<36>ڴ<EFBFBD><DAB4><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
vi /etc/sysctl.conf
kernel.shmall = 2033239 #<23><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> echo $(expr $(getconf _PHYS_PAGES) / 2)
kernel.shmmax = 8328146944 #<23><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> 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
#<23>Ż<EFBFBD>limits.conf<6E>ļ<EFBFBD>
vi /etc/security/limits.conf
* soft nproc 131072
* hard nproc 131072
* soft nofile 524288
* hard nofile 524288
#<23>Ż<EFBFBD>20-nproc.conf<6E>ļ<EFBFBD><C4BC><EFBFBD>ע<EFBFBD><D7A2>CentOSϵͳ<CFB5><CDB3><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ļ<EFBFBD><C4BC><EFBFBD>openEulerϵͳû<CDB3><C3BB><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ļ<EFBFBD><C4BC><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ż<EFBFBD>
vi /etc/security/limits.d/20-nproc.conf
* soft nproc 131072
#<23>Ż<EFBFBD>SSH<53><48><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֵ
echo "
MaxStartups 10:30:200
MaxSessions 200
" >> /etc/ssh/sshd_config
--ÿ̨<C3BF><CCA8><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
vi /etc/hostname
<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>1<EFBFBD><EFBFBD>gp-master
<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>2<EFBFBD><EFBFBD>gp-segment1
<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>3<EFBFBD><EFBFBD>gp-segment2
--ÿ̨<C3BF><CCA8><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
vi /etc/hosts
10.10.14.211 <20><><EFBFBD><EFBFBD> gp-master
10.10.14.212 <20><><EFBFBD><EFBFBD> gp-segment1
10.10.14.213 <20><><EFBFBD><EFBFBD> gp-segment2
#<23><><EFBFBD><EFBFBD>һ<EFBFBD>·<EFBFBD><C2B7><EFBFBD><EFBFBD><EFBFBD>
#ע<><D7A2><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϵͳΪopenEuler 22.03 SP1<50><31><EFBFBD><EFBFBD>ִ<EFBFBD><D6B4><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EEA3AC><EFBFBD><EFBFBD><EFBFBD><EFBFBD>CentOS7.9<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ִ<EFBFBD><EFBFBD>
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
--ÿ̨<C3BF><CCA8><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
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
#<23><>rpm<70><6D><EFBFBD><EFBFBD>/usr/local<61><6C>
--ÿ̨<C3BF><CCA8><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
cd /usr/local && yum install -y open-source-greenplum-db-7.0.0-el8-x86_64.rpm
--master<65><72><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><D2AA>
mkdir -p /usr/local/gpadmin/conf
--master<65><72><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><D2AA>
vi /usr/local/gpadmin/conf/all_hosts
gp-master
gp-segment1
gp-segment2
--master<65><72><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><D2AA>
vi /usr/local/gpadmin/conf/seg_hosts
gp-segment1
gp-segment2
chown -R gpadmin /usr/local/gpadmin
--master<65><72><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><D2AA>
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<65><72><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><D2AA>
mkdir -p /usr/local/gpadmin/data/master
mkdir -p /usr/local/gpadmin/gpconfigs
--segment<6E><74><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><D2AA>
mkdir -p /usr/local/gpadmin/data/primary
mkdir -p /usr/local/gpadmin/data/mirror
chown -R gpadmin /usr/local/gpadmin
--master<65><72><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><D2AA>
cp $GPHOME/docs/cli_help/gpconfigs/gpinitsystem_config /usr/local/gpadmin/gpconfigs
--master<65><72><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><D2AA>
--<2D><>Ҫ<EFBFBD><D2AA><EFBFBD><EFBFBD>
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<65><72><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><D2AA>
gpinitsystem -c /usr/local/gpadmin/gpconfigs/gpinitsystem_config -h /usr/local/gpadmin/conf/seg_hosts -D
#<23><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>δ<EFBFBD><CEB4><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>-End Main<69><6E><EFBFBD>ǰ<EFBFBD>װ<EFBFBD><D7B0><EFBFBD><EFBFBD>
--<2D><><EFBFBD><EFBFBD><EFBFBD>û<EFBFBD>
psql -d postgres
CREATE USER postgres WITH PASSWORD 'DsideaL147258369';
ALTER ROLE root SUPERUSER;
--master<65><72><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><D2AA>
--<2D><><EFBFBD><EFBFBD>˭<EFBFBD><CBAD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
vi /usr/local/gpadmin/data/master/gpseg-1/pg_hba.conf
host all root 10.10.0.0/16 md5
--<2D><><EFBFBD>¼<EFBFBD><C2BC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ļ<EFBFBD>
gpstop -u
<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
vi gpStart.sh
#!/bin/sh
su - gpadmin -c "source /usr/local/greenplum-db/greenplum_path.sh && gpstart -a"
Ȼ<EFBFBD><EFBFBD><EFBFBD>ŵ<EFBFBD>/etc/rc.local<61><6C><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˸<EFBFBD>ִ<EFBFBD><D6B4> chmod +x /etc/rc.d/rc.local