一 、测试环境概述
1. 机器配置
-
配置截图
-
两台华为云ECS，kc1.xlarge.4，规格4c/16g，openEuler 20.03系统。
二、安装openGauss
详情请见openGauss官网： https://opengauss.org/zh/
三 、修改内网地址
1. 修改ECS IP
-
修改IP前要解绑NAT，关闭服务器。
-
修改IP
-
另一台同样操作
2. 开机
3. 恢复NAT
四、数据库端操作
1. 直接启动数据库
-
发现报错
[omm@ecs-0001 ~]$ gs_om -t startStarting cluster.========================================= [GAUSS-51400] : Failed to execute the command: scp ecs-0002:/appdata/app/opengauss_f892ccb7/bin/cluster_dynamic_config /appdata/app/opengauss_f892ccb7/bin/cluster_dynamic_config_ecs-0002. Error:ssh: connect to host ecs-0002 port 22: No route to host
2. 修改配置文件
-
postgresql.conf
-
pg_hba.conf
-
clusterconfig.xml （用于生成static configuration）
-
/etc/hosts
[root@ecs-0001 ~]# sed -i 's/192.168.0.10/192.168.0.30/g' /appdata/data/postgresql.conf /appdata/data/pg_hba.conf /opt/software/opengauss/clusterconfig.xml /etc/hosts[root@ecs-0001 ~]# sed -i 's/192.168.0.20/192.168.0.40/g' /appdata/data/postgresql.conf /appdata/data/pg_hba.conf /opt/software/opengauss/clusterconfig.xml /etc/hosts[root@ecs-0002 ~]# sed -i 's/192.168.0.10/192.168.0.30/g' /appdata/data/postgresql.conf /appdata/data/pg_hba.conf /opt/software/opengauss/clusterconfig.xml /etc/hosts[root@ecs-0002 ~]# sed -i 's/192.168.0.20/192.168.0.40/g' /appdata/data/postgresql.conf /appdata/data/pg_hba.conf /opt/software/opengauss/clusterconfig.xml /etc/hosts
3. 生成集群文件并发送到备库
-
自动发送到备库
[omm@ecs-0001 ~]$ gs_om -t generateconf -X /opt/software/opengauss/clusterconfig.xml --distributeGenerating static configuration files for all nodes.Creating temp directory to store static configuration files.Successfully created the temp directory.Generating static configuration files.Successfully generated static configuration files.Static configuration files for all nodes are saved in /appdata/app/tools/script/static_config_files.Distributing static configuration files to all nodes.Successfully distributed static configuration files.
4. 启动数据库验证
-
主库启动
[omm@ecs-0001 ~]$ gs_om -t startStarting cluster.=========================================[SUCCESS] ecs-00012022-01-20 12:45:15.721 [unknown] [unknown] localhost 281457640472592 0 0 [BACKEND] WARNING: Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (16 Mbytes) or shared memory (8004 Mbytes) is larger.[SUCCESS] ecs-00022022-01-20 12:45:18.071 [unknown] [unknown] localhost 281465901482000 0 0 [BACKEND] WARNING: Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (16 Mbytes) or shared memory (8004 Mbytes) is larger.=========================================Successfully started.
-
备库查看状态
[omm@ecs-0002 ~]$ gs_om -t status --all-----------------------------------------------------------------------
cluster_state : Normalredistributing : No
-----------------------------------------------------------------------
node : 1node_name : ecs-0001instance_id : 6001node_ip : 192.168.0.30data_path : /appdata/datatype : Datanodeinstance_state : Normalaz_name : AZ1static_connections : 1HA_state : Normalinstance_role : Primary
-----------------------------------------------------------------------
node : 2node_name : ecs-0002instance_id : 6002node_ip : 192.168.0.40data_path : /appdata/datatype : Datanodeinstance_state : Normalaz_name : AZ1instance_role : StandbyHA_state : Streamingsender_sent_location : 0/452D3E8sender_write_location : 0/452D3E8sender_flush_location : 0/452D3E8sender_replay_location : 0/452D3E8receiver_received_location: 0/452D3E8receiver_write_location : 0/452D3E8receiver_flush_location : 0/452D3E8receiver_replay_location : 0/452D3E8sync_percent : 100%sync_state : Sync
-----------------------------------------------------------------------
欢迎访问openGauss官方网站
openGauss开源社区官方网站：
https://opengauss.org
openGauss组织仓库：
https://gitee.com/opengauss
openGauss镜像仓库：
https://github.com/opengauss-mirror
扫码关注我们
微信公众号｜openGauss
微信社群小助手｜openGauss-bot
本文分享自微信公众号 - openGauss（openGauss）。
如有侵权，请联系 support@oschina.cn 删除。
本文参与“ OSC源创计划 ”，欢迎正在阅读的你也加入，一起分享。
