GreenPlum 安装实战

1、
cat /dev/null > /etc/sysctl.conf
sudo bash -c 'cat >> /etc/sysctl.conf <<-EOF
kernel.shmmax = 500000000
kernel.shmmni = 4096
kernel.shmall = 4000000000
kernel.sem = 500 1024000 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.ip_forward = 0
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_max_syn_backlog = 4096
net.ipv4.conf.all.arp_filter = 1
net.ipv4.ip_local_port_range = 1025 65535
net.core.netdev_max_backlog = 10000
net.core.rmem_max = 2097152
net.core.wmem_max = 2097152
vm.overcommit_memory = 2

EOF'

2、
cat /dev/null > /etc/security/limits.conf
sudo bash -c 'cat >> /etc/security/limits.conf <<-EOF

  • soft nofile 65536
  • hard nofile 65536
  • soft nproc 131072
  • hard nproc 131072

EOF'

3、
sudo bash -c 'cat >> /etc/ld.so.conf <<-EOF
/usr/local/lib

EOF'

4、
sudo yum install -y epel-release
sudo yum install -y \
apr-devel \
bison \
bzip2-devel \
cmake3 \
flex \
gcc \
gcc-c++ \
krb5-devel \
libcurl-devel \
libevent-devel \
libkadm5 \
libyaml-devel \
libxml2-devel \
libzstd-devel \
openssl-devel \
perl-ExtUtils-Embed \
python-devel \
python-pip \
readline-devel \
xerces-c-devel \
zlib-devel

pip install --upgrade setuptools
pip install --upgrade pip
pip install setuptools==40.6.3
sudo pip install conan
sudo pip install -r python-dependencies.txt
sudo pip install -r python-developer-dependencies.txt

5、
hostnamectl --static set-hostname mdw
hostnamectl --static set-hostname sdw1
hostnamectl --static set-hostname sdw2

wget https://codeload.github.com/greenplum-db/gporca/zip/v3.42.0 -O gporca-3.42.0.zip
unzip gporca-3.42.0.zip
cd gporca-3.42.0
source /etc/profile && cmake -GNinja -H. -Bbuild && ninja install -C build
ldconfig

cd /home/gpadmin
git clone https://github.com/greenplum-db/gpdb.git && cd gpdb

./configure --prefix=/data/app/gpdb --enable-orca \
--enable-gpperfmon \
--with-perl --with-python --with-libxml \
--enable-mapreduce \
--with-includes=/usr/local/include/ \
--with-libraries=/usr/local/lib \
--enable-thread-safety-force

make -j 32 && make install

source /data/app/gpdb/greenplum_path.sh

cd /data/gpdata && mkdir segmentdata1 masterdata segmentmirror1 segmentmirror

chown -R gpadmin:gpadmin /data /home/gpadmin

2019/5/24 源自  GreenPlum

GreenPlum 使用

使用 gpadmin 权限登录

psql -d GP -U gpadmin -h 127.0.0.1 -p 2345
阅读原文   2019/5/23 源自  GreenPlum