原 GreenPlum适配国产化操作系统的情况
Tags: 原创GreenPlum国产操作系统欧拉银河麒麟统信UOS国产化
欧拉系统:可行
EulerOS 在2019年开源后更名为openEuler。
在openEuler 22.03和EulerOS 22.03上,在X86_64系统上通过rpm包和源码编译安装都可以,不过需要安装一些额外的包,
请参考:https://www.xmmup.com/greenplum-6-jiyuopeneuler22-03bianyianzhuangbuzhichi.html
麒麟系统
银河麒麟:可行
1、在“Kylin Linux Advanced Server V10”的SP1、SP2和SP3上,在X86_64系统上使用rpm包安装没有问题,需要提前安装如下包:
1 2 3 4 5 6 7 | dnf install -y libnsl hostname ln -s /usr/lib64/libreadline.so.7.0 /usr/lib64/libreadline.so.6 -- 安装包:RHEL8推荐 open-source-greenplum-db-6.25.1-rhel8-x86_64.rpm -- 或 open-source-greenplum-db-6.25.1-rhel7-x86_64.rpm |
2、在“Kylin Linux Advanced Server V10”的SP1、SP2和SP3上,在X86_64系统上使用编译安装没有问题
二进制安装
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 | docker rm -f kylingpdb docker run -itd --name kylingpdb -h kylingpdb \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/kylinos:v10_sp3_2.0 \ init docker exec -it kylingpdb bash dnf install -y libnsl hostname ln -s /usr/lib64/libreadline.so.7.0 /usr/lib64/libreadline.so.6 sed -i s/SELINUX=enforcing/SELINUX=disabled/g /etc/selinux/config setenforce 0 cat >> /etc/security/limits.conf <<"EOF" * soft nofile 655350 * hard nofile 655350 * soft nproc 655350 * hard nproc 655350 EOF cat >> /etc/sysctl.conf <<"EOF" kernel.shmmax = 4398046511104 kernel.shmmni = 4096 kernel.shmall = 4000000000 kernel.sem = 32000 1024000000 500 32000 vm.overcommit_memory=1 vm.overcommit_ratio=95 EOF sysctl -p groupadd -g 530 gpadmin useradd -g 530 -u 530 -m -d /home/gpadmin -s /bin/bash gpadmin chown -R gpadmin:gpadmin /home/gpadmin echo "gpadmin:lhr" | chpasswd -- rpm -ivh /soft/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm chown -R gpadmin:gpadmin /usr/local/greenplum-db echo ". /usr/local/greenplum-db/greenplum_path.sh" >> /home/gpadmin/.bashrc echo "export MASTER_DATA_DIRECTORY=/opt/greenplum/data/master/gpseg-1" >> /home/gpadmin/.bashrc echo "export PGDATABASE=postgres" >> /home/gpadmin/.bashrc echo "export PGPORT=5432" >> /home/gpadmin/.bashrc ./sshUserSetup.sh -user root -hosts "mdw mdw" -advanced exverify –confirm ./sshUserSetup.sh -user gpadmin -hosts "mdw mdw" -advanced exverify –confirm chmod 600 /home/gpadmin/.ssh/config mkdir -p /opt/greenplum/data/master mkdir -p /opt/greenplum/data/primary mkdir -p /opt/greenplum/data/mirror mkdir -p /opt/greenplum/data/master_standby mkdir -p /opt/greenplum/data/ chown -R gpadmin:gpadmin /opt/greenplum su - gpadmin mkdir -p /home/gpadmin/conf/ cat > /home/gpadmin/conf/all_hosts <<"EOF" kylingpdb EOF cat > /home/gpadmin/conf/seg_hosts <<"EOF" kylingpdb EOF ssh-keygen -t rsa ssh-keygen -t dsa cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys ssh kylingpdb date su - gpadmin cat > /home/gpadmin/conf/initgp_config <<"EOF" declare -a DATA_DIRECTORY=(/opt/greenplum/data/primary /opt/greenplum/data/primary) declare -a MIRROR_DATA_DIRECTORY=(/opt/greenplum/data/mirror /opt/greenplum/data/mirror) ARRAY_NAME="lhrgp" SEG_PREFIX=gpseg PORT_BASE=6000 MIRROR_PORT_BASE=7000 MASTER_PORT=5432 MASTER_HOSTNAME=kylingpdb MASTER_DIRECTORY=/opt/greenplum/data/master DATABASE_NAME=lhrgpdb MACHINE_LIST_FILE=/home/gpadmin/conf/seg_hosts EOF gpinitsystem -c /home/gpadmin/conf/initgp_config -e=lhr -s kylingpdb -P 5433 -S /opt/greenplum/data/master_standby/gpseg-1 |