OpenGauss安裝手冊

1、OPENGAUSS數(shù)據(jù)庫安裝手冊安裝環(huán)境：服務器配置CPU：>=16核 2.0GHz內(nèi)存：>=32G硬盤:用于安裝openGauss的硬盤需最少滿足如下要求：至少1GB用于安裝openGauss的應用程序包。每個主機需大約300MB用于元數(shù)據(jù)存儲。預留70%以上的磁盤剩余空間用于數(shù)據(jù)存儲。建議系統(tǒng)盤配置為Raid1，數(shù)據(jù)盤配置為Raid5，且規(guī)劃4組Raid5數(shù)據(jù)盤用于安裝openGauss。openGauss支持使用SSD盤作為數(shù)據(jù)庫的主存儲設備，支持SAS接口和NVME協(xié)議的SSD盤，以RAID的方式部署使用。建議容量：>=1T網(wǎng)絡要求: 300兆以上以太網(wǎng), 建議網(wǎng)卡設

2、置為雙網(wǎng)卡冗余bond也可以根據(jù)自己的條件進行相關調(diào)整CENTOS 7.6 或OPENEULER1. CentOS 7.6：2. openEuler：/openEuler-20.03-LTS/ISO/aarch64/openEuler-20.03-LTS-aarch64-dvd.iso打開/zh/download.html 可以找到openGauss安裝包的下載鏈接閱讀參考openGauss官方網(wǎng)站：/zhopenGauss官方文檔：https:/opengauss

3、.org/zh/docs/1.0.0/docs/Quickstart/Quickstart.html安裝流程 設置主機名設置主機名，單機使用gaussdb，集群使用gaussdb1,2hostnamectl set-hostname 安裝其他軟件包有Internet網(wǎng)絡時，可以添加外部yum源沒有Internet網(wǎng)絡時，可以自己在虛擬機上最小化安裝一個Centos7.6的系統(tǒng)，注意一定要最小化安裝，需要安裝的只有Python3和一個bzip2制作本地yum源和掛載可以借鑒一下鏈接制作yum源：下面是需要下載的相關依賴包：yum -y install zlib-devel bzip2-devel

4、 openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gcc bzip2 make掛載：安裝PYTHON 31. CentOS 7.6安裝Python 3.6。建議使用3.6.8和3.6.10版本由于下載之后需要編譯說以下最主要的問題python 3 安裝 產(chǎn)生 libpython3.6m 等問題./configure -prefix=/usr/local/python3 -enable-shared CFLAGS=-fPIC make && make install 生成 （/usr/local/p

5、ython3） libpython3.6m.so和libpython3.6m.so.1.0這個文件很重要，如果缺失了在安裝的時候就會報錯 ./configure -prefix=/usr/local/python3 -enable-optimizations -with-ssl make && make install 生成 （/usr/local/python3） libpython3.6m.aln -s /usr/local/python3/bin/python3.6 /usr/bin/python3ln -s /usr/local/python3/bin/pip3 /us

6、r/bin/pip3如果 python3 -V 報錯 python3: error while loading shared libraries: libpython3.6m.so.1.0: cannot open shared object file: No such file or directory解決方案cp /usr/local/python3/lib/libpython3.6m.so.1.0 /usr/lib64/卸載python3rpm -qa|grep python3|xargs rpm -ev -allmatches -nodeps 卸載pyhton3whereis pyth

7、on3 |xargs rm -frv 刪除所有殘余文件成功卸載！whereis python 查看現(xiàn)有安裝的python2. openEuler 20.3安裝Python 3.7：openEuler 20.3自帶python3.7，輸入python3命令即可進入，默認python命令指向python2.7修改默認路徑就可以，不需要自己在安裝Python 3.7修改操作系統(tǒng)配置1.1關閉防火墻# systemctl stop firewalld1.2禁用SELINUX/etc/selinux/config文件中的“SELINUX”值設為“disabled”# vi /etc/selinux/co

8、nfigSELINUX=disabled重啟生效# reboot now1.3統(tǒng)一字符集例如：# vi /etc/profileexport LANG=en_US.UTF-81.4統(tǒng)一時區(qū)及時間# timedatectl set-timezone Asia/Shanghai有單獨的ntp服務器可以添加contab定期同步時間1.5關閉交換內(nèi)存# swapoff -a 或者將文件/etc/fstab交換分區(qū)那行刪除1.6設置網(wǎng)卡MTU推薦設置MTU為8192# vi /etc/sysconfig/network-scripts/ifcfg-enp0s3 增加如下內(nèi)容 MTU="8192

9、"# systemctl restart network1.7允許ROOT用戶遠程SSH# vi /etc/ssh/sshd_configPermitRootLogin yes# systemctl restart sshd安裝OPENGAUSS集群openGauss_1.0.0_PACKAGES_RELEASE_CentOS.tar.gz將安裝文件上傳至/opt/software/openGauss2.1創(chuàng)建XML配置文件根據(jù)你的IP修改地址# mkdir -p /opt/software/openGauss# chmod 755 -R /opt/software# vi /opt

10、/software/openGauss/clusterconfig.xml<?xml version="1.0" encoding="UTF-8"?> <ROOT> <CLUSTER> <PARAM name="clusterName" value="dbCluster" /> <PARAM name="nodeNames" value="opengauss,opengauss2" /> <PARAM name

11、="backIp1s" value=","/> <PARAM name="gaussdbAppPath" value="/opt/gaussdb/app" /> <PARAM name="gaussdbLogPath" value="/var/log/gaussdb" /> <PARAM name="gaussdbToolPath" value="/opt/huawe

12、i/wisequery" /> <PARAM name="corePath" value="/opt/opengauss/corefile"/> <PARAM name="clusterType" value="single-inst"/> </CLUSTER> <DEVICELIST> <DEVICE sn="1000001"> <PARAM name="name" value="o

13、pengauss"/> <PARAM name="azName" value="AZ1"/> <PARAM name="azPriority" value="1"/> <PARAM name="backIp1" value=""/> <PARAM name="sshIp1" value=""/> <PARAM name=&q

14、uot;dataNum" value="1"/> <PARAM name="dataPortBase" value="26000"/> <PARAM name="dataNode1" value="/gaussdb/data/db1,opengauss2,/gaussdb/data/db1"/> </DEVICE> <DEVICE sn="1000002"> <PARAM name="name&q

15、uot; value="opengauss2"/> <PARAM name="azName" value="AZ1"/> <PARAM name="azPriority" value="2"/> <PARAM name="backIp1" value=""/> <PARAM name="sshIp1" value=""/>

16、; </DEVICE> </DEVICELIST> </ROOT>2.2預安裝配置ROOT用戶SSH互信每個節(jié)點都執(zhí)行 # ssh-keygen -t rsa # ssh-copy-id -i .ssh/id_rsa.pub rootopengauss # ssh-copy-id -i .ssh/id_rsa.pub rootopengauss2配置OMM用戶SSH互信# su - omm $ ssh-keygen -t rsa $ ssh-copy-id -i .ssh/id_rsa.pub ommopengauss $ ssh-copy-id -i .s

17、sh/id_rsa.pub ommopengauss2# cd /opt/software/openGauss # tar -zxvf openGauss_1.0.0_PACKAGES_RELEASE_CentOS.tar.gz # tar -zxvf openGauss-1.0.0-CentOS-64bit.tar.gz# cd /opt/software/openGauss/script# ./gs_preinstall -U omm -G dbgrp -X /opt/software/openGauss/clusterconfig.xml -non-interactiveParsing

18、the configuration file.Successfully parsed the configuration file.Installing the tools on the local node.Successfully installed the tools on the local node.Setting pssh pathSuccessfully set core path.Distributing package.Begin to distribute package to tool path.Successfully distribute package to too

19、l path.Begin to distribute package to package path.Successfully distribute package to package path.Successfully distributed package.Preparing SSH service.Successfully prepared SSH service.Installing the tools in the cluster.Successfully installed the tools in the cluster.Checking hostname mapping.Su

20、ccessfully checked hostname mapping.Checking OS version.Successfully checked OS version.Creating cluster's path.Successfully created cluster's path.Setting SCTP service.Successfully set SCTP service.Set and check OS parameter.Setting OS parameters.Successfully set OS parameters.Warning: Inst

21、allation environment contains some warning messages.Please get more details by "/opt/software/openGauss/script/gs_checkos -i A -h opengauss,opengauss2".Set and check OS parameter completed.Preparing CRON service.Successfully prepared CRON service.Setting user environmental variables.Succes

22、sfully set user environmental variables.Setting the dynamic link library.Successfully set the dynamic link library.Setting Core fileSuccessfully set core path.Setting pssh pathSuccessfully set pssh path.Set ARM Optimization.Successfully set ARM Optimization.Preinstalling secbox.No need to install se

23、cbox.Setting finish flag.Successfully set finish flag.Preinstallation succeeded.2.3安裝# cd /opt/software/openGauss/script # chmod -R 755 /opt/software/openGauss/script # chown -R omm:dbgrp /opt/software/openGauss/script# su - omm # gs_install -X /opt/software/openGauss/clusterconfig.xml安裝時會讓你設置密碼，要求有

24、大寫字母和特殊符號切大于8位的密碼設置錯誤兩次會退出安裝Parsing the configuration file.Check preinstall on every node.Successfully checked preinstall on every node.Creating the backup directory.Successfully created the backup directory.begin deploy.Installing the cluster.begin prepare Install Cluster.Checking the installation

25、environment on all nodes.begin install Cluster.Installing applications on all nodes.Successfully installed APP.begin init Instance.encrypt ciper and rand files for database.Please enter password for database:Please repeat for database:begin to create CA cert filesThe sslcert will be generated in /opt/gaussdb/app/share/sslcert/omCluster installation is completed.Configuring.Deleting instances from all nodes.Successfully deleted instances from all nodes.Checking node configuration on all nodes.Initializing instances on all nodes.Updating instance configuration on all nodes.Check con