Mogdb数据库非OM工具非omm用户的异构操作系统集群安装

一、主节点安装

关闭防火墙，selinux

systemctl disable firewalld.service
systemctl stop firewalld.service
setenforce=0
sed -i '/^SELINUX=/c'SELINUX=disabled /etc/selinux/config

安装依赖包

yum install libaio-devel -y

创建相关目录，用户，组

groupadd mogdbgrp -g 20001
useradd mog -g 20001 -u 20001
echo "Enmo@123" | passwd --stdin mog
mkdir -p  /mogdb_tang/software
chown -R mog:mogdbgrp /mogdb_tang/

上传并解压解压二进制文件

wget https://cdn-mogdb.enmotech.com/mogdb-media/2.0.1/MogDB-2.0.1-Kylin-all-arm_64.tar

tar -xf MogDB-2.0.1-Kylin-all-arm_64.tar
tar -xvf  MogDB-2.0.1-openEuler-64bit-Libpq.tar.gz

修改环境变量

echo "export GAUSSHOME=/mogdb_tang/software"  >> /home/mog/.bashrc && \
echo "export PATH=\$GAUSSHOME/bin:\$PATH " >> /home/mog/.bashrc && \
echo "export LD_LIBRARY_PATH=\$GAUSSHOME/lib:\$LD_LIBRARY_PATH" >> /home/mog/.bashrc
source /home/mog/.bashrc

以mog用户初始化数据库

bin/gs_initdb --pgdata=/mogdb_tang/data --nodename=primary --pwpasswd=Enmo@123 --encoding=UTF-8 --locale=en_US.UTF-8

修改初始化参数

echo "port=29000" >> /mogdb_tang/data/postgresql.conf
echo "listen_addresses = '0.0.0.0'" >> /mogdb_tang/data/postgresql.conf
echo "password_encryption_type = 0" >> /mogdb_tang/data/postgresql.conf
echo "log_directory = 'pg_log'" >> /mogdb_tang/data/postgresql.conf
echo "remote_read_mode=non_authentication" >> /mogdb_tang/data/postgresql.conf
echo "host all all 0.0.0.0/0 md5" >> /mogdb_tang/data/pg_hba.conf

配置连接通道

echo "replconninfo1='localhost=172.16.0.127 localport=29003 localheartbeatport=29006 localservice=29007 remotehost=172.16.0.176 remoteport=29003 remoteheartbeatport=29006 remoteservice=29007'" >> /mogdb_tang/data/postgresql.conf
localhost为主库IP,remotehost为备库IP

以primary方式启动数据库

gs_ctl start -D /mogdb_tang/data/ -M primary

二、备库操作

关闭防火墙，selinux

systemctl disable firewalld.service
systemctl stop firewalld.service
setenforce=0
sed -i '/^SELINUX=/c'SELINUX=disabled /etc/selinux/config

安装依赖包

yum install libaio-devel -y

创建相关目录，用户，组

groupadd mogdbgrp -g 20001
useradd mog -g 20001 -u 20001
echo "Enmo@123" | passwd --stdin mog
mkdir -p  /mogdb_tang/software
chown -R mog:mogdbgrp /mogdb_tang/

上传并解压二进制文件

wget https://cdn-mogdb.enmotech.com/mogdb-media/2.0.1/MogDB-2.0.1-CentOS-all-x86_64.tar
tar -xvf MogDB-2.0.1-CentOS-all-x86_64.tar
tar -xvf MogDB-2.0.1-CentOS-64bit.tar.bz2

修改环境变量

echo "export GAUSSHOME=/mogdb_tang/software"  >> /home/mog/.bashrc && \
echo "export PATH=\$GAUSSHOME/bin:\$PATH " >> /home/mog/.bashrc && \
echo "export LD_LIBRARY_PATH=\$GAUSSHOME/lib:\$LD_LIBRARY_PATH" >> /home/mog/.bashrc
source /home/mog/.bashrc

以mog用户初始化数据库

bin/gs_initdb --pgdata=/mogdb_tang/data --nodename=standby --pwpasswd=Enmo@123 --encoding=UTF-8 --locale=en_US.UTF-8

将主库的配置文件传到备库

scp /mogdb_tang/data/pg_hba.conf /mogdb_tang/data/postgresql.conf 172.16.0.176:/mogdb_tang/data/

配置连接通道,将localhost和remotehost对调

sed -i "/^replconninfo1/creplconninfo1='localhost=172.16.0.176 localport=29003 localheartbeatport=29006 localservice=29007 remotehost=172.16.0.127 remoteport=29003 remoteheartbeatport=29006 remoteservice=29007'" /mogdb_tang/data/postgresql.conf

localhost为备库IP,remotehost为主库IP

构建主备关系

gs_ctl build -D /mogdb_tang/data/ -b full -M standby

查询主备状态

gs_ctl query -D /mogdb_tang/data/