前一篇文章Greenplum 6.12.1 安装部署及单独添加镜像在添加segment镜像的时候由于遇到了一个bug,导致添加mirror的流程不完整,只是把操作步骤记录下来,趁着个机会正好把greenplum做一下数据库升级。
greenplum 升级分两种:
- 大版本升级:跨越主版本的升级,比如 4.3 or 5 to 6
- 小版本升级:主版本内的升级,比如6.x to 6.newer
大版本升级
- Greenplum 开源版本是从5开始的,从5.28版本开始可以直接使用gpupgrade工具升级到6.9及以后的版本
- 对于GP4.3版本的数据库,如果升级到6,需要通过备份恢复的方式,可以使用gpbackup、gprestore或着gpcopy 工具来实现,这种方式同样适用于GP5 to GP6
对于大版本升级,相对小版本升级来说比较复杂,需要停止数据库集群的时间较长,通过逻辑备份恢复的方式来实现,这里暂时仅简单介绍升级流程,暂不做实操展示,以4.3 升级到 6 为例
- 对原集群做好备份,并保证备份可用,如果升级失败需要原集群继续提供服务
- 准备GP6集群,保证集群状态可用
- 确保有足够的磁盘空间可以保留备份文件,建议数据库的5倍大小
- 如果磁盘不够,使用gpcopy(4.3.26及以上版本 or 5.9及以上版本)命令,不建议使用–truncate-source-after参数,给自己留条后路
- 对于GP6不兼容的扩展模块,需要在备份之前或者在restore的时候需要排除相关的表
- GP6 的系统表、系统视图及函数变化比较大,留好操作日志,便于修复
小版本升级
这次将数据库从6.12.1 升级到 6.22,
下载安装
--下载安装包
wget https://github.com/greenplum-db/gpdb/releases/download/6.22.0/open-source-greenplum-db-6.22.0-rhel7-x86_64.rpm
--将新版本安装包copy 到所有master、standby 和 segment 节点服务器
[root@node1 software]# scp open-source-greenplum-db-6.22.0-rhel7-x86_64.rpm node2:/opt/software/
open-source-greenplum-db-6.22.0-rhel7-x86_64.rpm 100% 66MB 171.8MB/s 00:00
[root@node1 software]# scp open-source-greenplum-db-6.22.0-rhel7-x86_64.rpm node3:/opt/software/
open-source-greenplum-db-6.22.0-rhel7-x86_64.rpm 100% 66MB 163.0MB/s 00:00
[root@node1 software]#
升级前检查
-- 系统目录检查
这一步建议升级前几天操作,如果一旦发现问题,可以预留出时间来处理
[gpadmin@node1 ~]$ gpcheckcat
Truncated batch size to number of primaries: 5
Connected as user 'gpadmin' to database 'postgres', port '65432', gpdb version '6.12'
-------------------------------------------------------------------
Batch size: 5
Performing test 'unique_index_violation'
Total runtime for test 'unique_index_violation': 0:00:00.46
Performing test 'duplicate'
Total runtime for test 'duplicate': 0:00:00.84
Performing test 'missing_extraneous'
Total runtime for test 'missing_extraneous': 0:00:00.27
Performing test 'inconsistent'
Total runtime for test 'inconsistent': 0:00:01.17
Performing test 'foreign_key'
Total runtime for test 'foreign_key': 0:00:00.69
Performing test 'acl'
Total runtime for test 'acl': 0:00:00.05
Performing test 'pgclass'
Total runtime for test 'pgclass': 0:00:00.02
Performing test 'namespace'
Total runtime for test 'namespace': 0:00:00.00
Performing test 'distribution_policy'
Total runtime for test 'distribution_policy': 0:00:00.00
Performing test 'dependency'
Total runtime for test 'dependency': 0:00:00.07
Performing test 'owner'
Total runtime for test 'owner': 0:00:00.03
Performing test 'part_integrity'
Total runtime for test 'part_integrity': 0:00:00.02
Performing test 'part_constraint'
Total runtime for test 'part_constraint': 0:00:00.07
Performing test 'orphaned_toast_tables'
Total runtime for test 'orphaned_toast_tables': 0:00:00.03
Performing test 'aoseg_table'
Total runtime for test 'aoseg_table': 0:00:00.00
SUMMARY REPORT
===================================================================
Completed 15 test(s) on database 'postgres' at 2022-09-15 16:15:55 with elapsed time 0:00:03
Found no catalog issue
--检查集群状态
[gpadmin@node1 ~]$ gpstate
20220915:16:26:36:003311 gpstate:node1:gpadmin-[INFO]:-Starting gpstate with args:
20220915:16:26:36:003311 gpstate:node1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.12.1 build commit:7ec4678f29dd922d7d44501f5fc344b5d0d4d49f Open Source'
20220915:16:26:36:003311 gpstate:node1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.12.1 build commit:7ec4678f29dd922d7d44501f5fc344b5d0d4d49f Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Nov 20 2020 18:43:31'
20220915:16:26:36:003311 gpstate:node1:gpadmin-[INFO]:-Obtaining Segment details from master...
20220915:16:26:36:003311 gpstate:node1:gpadmin-[INFO]:-Gathering data from segments...
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:-Greenplum instance status summary
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:-----------------------------------------------------
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Master instance = Active
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Master standby = node2
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Standby master state = Standby host passive
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Total segment instance count from metadata = 4
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:-----------------------------------------------------
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Primary Segment Status
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:-----------------------------------------------------
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Total primary segments = 4
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Total primary segment valid (at master) = 4
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Total primary segment failures (at master) = 0
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Total number of postmaster.pid files missing = 0
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Total number of postmaster.pid files found = 4
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Total number of postmaster.pid PIDs missing = 0
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 4
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Total number of /tmp lock files missing = 0
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Total number of /tmp lock files found = 4
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Total number postmaster processes missing = 0
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Total number postmaster processes found = 4
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:-----------------------------------------------------
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Mirror Segment Status
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:-----------------------------------------------------
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:- Mirrors not configured on this array
20220915:16:26:37:003311 gpstate:node1:gpadmin-[INFO]:-----------------------------------------------------
集群升级
-- 停机群
[gpadmin@node1 ~]$ gpstop -a
20220915:16:36:16:006765 gpstop:node1:gpadmin-[INFO]:-Starting gpstop with args: -a
20220915:16:36:16:006765 gpstop:node1:gpadmin-[INFO]:-Gathering information and validating the environment...
20220915:16:36:16:006765 gpstop:node1:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20220915:16:36:16:006765 gpstop:node1:gpadmin-[INFO]:-Obtaining Segment details from master...
20220915:16:36:16:006765 gpstop:node1:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.12.1 build commit:7ec4678f29dd922d7d44501f5fc344b5d0d4d49f Open Source'
20220915:16:36:16:006765 gpstop:node1:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20220915:16:36:16:006765 gpstop:node1:gpadmin-[INFO]:-Master segment instance directory=/data/gpdata/gpmaster/gpseg-1
20220915:16:36:16:006765 gpstop:node1:gpadmin-[INFO]:-Stopping master segment and waiting for user connections to finish ...
server shutting down
20220915:16:36:17:006765 gpstop:node1:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20220915:16:36:17:006765 gpstop:node1:gpadmin-[INFO]:-Terminating processes for segment /data/gpdata/gpmaster/gpseg-1
20220915:16:36:17:006765 gpstop:node1:gpadmin-[INFO]:-Stopping master standby host node2 mode=fast
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-Successfully shutdown standby process on node2
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-Targeting dbid [2, 3, 4, 5] for shutdown
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-0.00% of jobs completed
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-100.00% of jobs completed
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-----------------------------------------------------
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:- Segments stopped successfully = 4
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:- Segments with errors during stop = 0
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-----------------------------------------------------
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-Successfully shutdown 4 of 4 segment instances
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-Cleaning up leftover gpmmon process
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-No leftover gpmmon process found
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts
20220915:16:36:18:006765 gpstop:node1:gpadmin-[INFO]:-Cleaning up leftover shared memory
--替换安装包
[root@node1 software]# rpm -U open-source-greenplum-db-6.22.0-rhel7-x86_64.rpm --prefix=/opt
error: Failed dependencies:
greenplum-db-6 conflicts with open-source-greenplum-db-6-6.22.0-1.el7.x86_64
--提示与原来的版本冲突,使用--nodeps 更新安装
[root@node1 software]# rpm -U open-source-greenplum-db-6.22.0-rhel7-x86_64.rpm --prefix=/opt --nodeps
[root@node1 software]# chown -R gpadmin: /opt/greenplum-db*
[root@node1 software]# ll /opt |grep -i green
lrwxrwxrwx. 1 gpadmin gpadmin 24 Sep 15 17:03 greenplum-db -> /opt/greenplum-db-6.22.0
drwxr-xr-x. 11 gpadmin gpadmin 238 Aug 28 15:34 greenplum-db-6.12.1
drwxr-xr-x. 11 gpadmin gpadmin 238 Sep 15 17:03 greenplum-db-6.22.0
--启动集群
[gpadmin@node1 ~]$ gpstart -a
20220915:17:15:55:020591 gpstart:node1:gpadmin-[INFO]:-Starting gpstart with args: -a
20220915:17:15:55:020591 gpstart:node1:gpadmin-[INFO]:-Gathering information and validating the environment...
20220915:17:15:55:020591 gpstart:node1:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source'
20220915:17:15:55:020591 gpstart:node1:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'
20220915:17:15:55:020591 gpstart:node1:gpadmin-[INFO]:-Starting Master instance in admin mode
20220915:17:15:55:020591 gpstart:node1:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20220915:17:15:55:020591 gpstart:node1:gpadmin-[INFO]:-Obtaining Segment details from master...
20220915:17:15:55:020591 gpstart:node1:gpadmin-[INFO]:-Setting new master era
20220915:17:15:55:020591 gpstart:node1:gpadmin-[INFO]:-Master Started...
20220915:17:15:56:020591 gpstart:node1:gpadmin-[INFO]:-Shutting down master
20220915:17:15:56:020591 gpstart:node1:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:-Process results...
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:-----------------------------------------------------
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:- Successful segment starts = 4
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:- Failed segment starts = 0
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:-----------------------------------------------------
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:-Successfully started 4 of 4 segment instances
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:-----------------------------------------------------
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:-Starting Master instance node1 directory /data/gpdata/gpmaster/gpseg-1
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:-Command pg_ctl reports Master node1 instance active
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:-Connecting to dbname='template1' connect_timeout=15
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:-Starting standby master
20220915:17:15:57:020591 gpstart:node1:gpadmin-[INFO]:-Checking if standby master is running on host: node2 in directory: /data/gpdata/gpmaster/gpseg-1
20220915:17:15:57:020591 gpstart:node1:gpadmin-[WARNING]:-Unable to cleanup previously started standby: 'Warning: the RSA host key for 'node2' differs from the key for the IP address '192.168.122.157'
Offending key for IP in /home/gpadmin/.ssh/known_hosts:1
Matching host key in /home/gpadmin/.ssh/known_hosts:5
'
20220915:17:15:58:020591 gpstart:node1:gpadmin-[INFO]:-Database successfully started
--检查集群版本信息
[gpadmin@node1 ~]$ gpstate -i
20220915:17:17:02:021151 gpstate:node1:gpadmin-[INFO]:-Starting gpstate with args: -i
20220915:17:17:02:021151 gpstate:node1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source'
20220915:17:17:02:021151 gpstate:node1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Sep 8 2022 22:41:44'
20220915:17:17:02:021151 gpstate:node1:gpadmin-[INFO]:-Obtaining Segment details from master...
20220915:17:17:02:021151 gpstate:node1:gpadmin-[INFO]:-Loading version information
20220915:17:17:03:021151 gpstate:node1:gpadmin-[INFO]:- Host Datadir Port Version
20220915:17:17:03:021151 gpstate:node1:gpadmin-[INFO]:- node1 /data/gpdata/gpmaster/gpseg-1 65432 PostgreSQL 9.4.26 (Greenplum Database 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Sep 8 2022 22:41:44
20220915:17:17:03:021151 gpstate:node1:gpadmin-[INFO]:- node2 /data/gpdata/gpmaster/gpseg-1 65432 PostgreSQL 9.4.26 (Greenplum Database 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Sep 8 2022 22:41:44
20220915:17:17:03:021151 gpstate:node1:gpadmin-[INFO]:- node2 /data/gpdata/seg1/primary/gpseg0 6000 PostgreSQL 9.4.26 (Greenplum Database 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Sep 8 2022 22:41:44
20220915:17:17:03:021151 gpstate:node1:gpadmin-[INFO]:- node2 /data/gpdata/seg2/primary/gpseg1 6001 PostgreSQL 9.4.26 (Greenplum Database 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Sep 8 2022 22:41:44
20220915:17:17:03:021151 gpstate:node1:gpadmin-[INFO]:- node3 /data/gpdata/seg1/primary/gpseg2 6000 PostgreSQL 9.4.26 (Greenplum Database 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Sep 8 2022 22:41:44
20220915:17:17:03:021151 gpstate:node1:gpadmin-[INFO]:- node3 /data/gpdata/seg2/primary/gpseg3 6001 PostgreSQL 9.4.26 (Greenplum Database 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Sep 8 2022 22:41:44
20220915:17:17:03:021151 gpstate:node1:gpadmin-[INFO]:-All segments are running the same software version
[gpadmin@node1 ~]$
到这里,我们的GP6的小版本已经升级完成了,我们来处理一下上一篇文章的小尾巴,即给segment的primary节点添加mirror
添加mirror
--创建目录
[gpadmin@node1 ~]$ gpssh -h node2 -h node3 -e "mkdir -p /data/gpdata/seg1/mirror"
[node3] mkdir -p /data/gpdata/seg1/mirror
[node2] mkdir -p /data/gpdata/seg1/mirror
[gpadmin@node1 ~]$ gpssh -h node2 -h node3 -e "mkdir -p /data/gpdata/seg2/mirror"
[node3] mkdir -p /data/gpdata/seg2/mirror
[node2] mkdir -p /data/gpdata/seg2/mirror
[gpadmin@node1 ~]$
--生成并编辑配置文件
[gpadmin@node1 ~]$ gpaddmirrors -o mirror_config
20220915:18:50:59:024057 gpaddmirrors:node1:gpadmin-[INFO]:-Starting gpaddmirrors with args: -o mirror_config
20220915:18:50:59:024057 gpaddmirrors:node1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source'
20220915:18:50:59:024057 gpaddmirrors:node1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Sep 8 2022 22:41:44'
20220915:18:50:59:024057 gpaddmirrors:node1:gpadmin-[INFO]:-Obtaining Segment details from master...
20220915:18:51:00:024057 gpaddmirrors:node1:gpadmin-[INFO]:-Heap checksum setting consistent across cluster
Enter mirror segment data directory location 1 of 2 >
/data/gpdata/seg1/mirror
Enter mirror segment data directory location 2 of 2 >
/data/gpdata/seg2/mirror
20220915:18:53:42:024057 gpaddmirrors:node1:gpadmin-[INFO]:-Configuration file output to mirror_config successfully.
--查看配置文件
[gpadmin@node1 ~]$ cat mirror_config
0|node3|8000|/data/gpdata/seg1/mirror/gpseg0
1|node3|8001|/data/gpdata/seg2/mirror/gpseg1
2|node2|8000|/data/gpdata/seg1/mirror/gpseg2
3|node2|8001|/data/gpdata/seg2/mirror/gpseg3
--添加镜像
[gpadmin@node1 ~]$ gpaddmirrors -i mirror_config
20220915:19:15:25:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Starting gpaddmirrors with args: -i mirror_config
20220915:19:15:25:032388 gpaddmirrors:node1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source'
20220915:19:15:25:032388 gpaddmirrors:node1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Sep 8 2022 22:41:44'
20220915:19:15:25:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Obtaining Segment details from master...
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Heap checksum setting consistent across cluster
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Greenplum Add Mirrors Parameters
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:---------------------------------------------
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Greenplum master data directory = /data/gpdata/gpmaster/gpseg-1
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Greenplum master port = 6543
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Batch size = 16
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Segment batch size = 64
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:---------------------------------------------
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:---------------------------------------------
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Mirror 1 of 4
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:---------------------------------------------
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance host = node2
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance address = node2
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance directory = /data/gpdata/seg1/primary/gpseg0
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance port = 7000
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance host = node3
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance address = node3
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance directory = /data/gpdata/seg1/mirror/gpseg0
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance port = 8000
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:---------------------------------------------
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Mirror 2 of 4
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:---------------------------------------------
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance host = node2
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance address = node2
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance directory = /data/gpdata/seg2/primary/gpseg1
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance port = 7001
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance host = node3
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance address = node3
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance directory = /data/gpdata/seg2/mirror/gpseg1
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance port = 8001
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:---------------------------------------------
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Mirror 3 of 4
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:---------------------------------------------
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance host = node3
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance address = node3
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance directory = /data/gpdata/seg1/primary/gpseg2
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance port = 7000
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance host = node2
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance address = node2
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance directory = /data/gpdata/seg1/mirror/gpseg2
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance port = 8000
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:---------------------------------------------
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Mirror 4 of 4
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:---------------------------------------------
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance host = node3
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance address = node3
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance directory = /data/gpdata/seg2/primary/gpseg3
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Primary instance port = 7001
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance host = node2
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance address = node2
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance directory = /data/gpdata/seg2/mirror/gpseg3
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:- Mirror instance port = 8001
20220915:19:15:26:032388 gpaddmirrors:node1:gpadmin-[INFO]:---------------------------------------------
Continue with add mirrors procedure Yy|Nn (default=N):
> y
20220915:19:15:29:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Starting to create new pg_hba.conf on primary segments
Warning: the RSA host key for 'node2' differs from the key for the IP address '192.168.122.157'
Offending key for IP in /home/gpadmin/.ssh/known_hosts:1
Matching host key in /home/gpadmin/.ssh/known_hosts:5
Warning: the RSA host key for 'node2' differs from the key for the IP address '192.168.122.157'
Offending key for IP in /home/gpadmin/.ssh/known_hosts:1
Matching host key in /home/gpadmin/.ssh/known_hosts:5
Warning: the RSA host key for 'node2' differs from the key for the IP address '192.168.122.157'
Offending key for IP in /home/gpadmin/.ssh/known_hosts:1
Matching host key in /home/gpadmin/.ssh/known_hosts:5
Warning: the RSA host key for 'node2' differs from the key for the IP address '192.168.122.157'
Offending key for IP in /home/gpadmin/.ssh/known_hosts:1
Matching host key in /home/gpadmin/.ssh/known_hosts:5
20220915:19:15:31:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Successfully modified pg_hba.conf on primary segments to allow replication connections
20220915:19:15:31:032388 gpaddmirrors:node1:gpadmin-[INFO]:-4 segment(s) to add
20220915:19:15:31:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Setting up the required segments for recovery
20220915:19:15:32:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Updating configuration for mirrors
20220915:19:15:32:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Initiating segment recovery. Upon completion, will start the successfully recovered segments
20220915:19:15:32:032388 gpaddmirrors:node1:gpadmin-[INFO]:-era is b4e16e773ff35286_220915184950
node3 (dbid 7): pg_basebackup: base backup completed
node3 (dbid 8): pg_basebackup: base backup completed
node2 (dbid 9): pg_basebackup: base backup completed
node2 (dbid 10): pg_basebackup: base backup completed
20220915:19:15:35:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Triggering FTS probe
20220915:19:15:35:032388 gpaddmirrors:node1:gpadmin-[INFO]:-******************************************************************
20220915:19:15:35:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Mirror segments have been added; data synchronization is in progress.
20220915:19:15:35:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Data synchronization will continue in the background.
20220915:19:15:35:032388 gpaddmirrors:node1:gpadmin-[INFO]:-Use gpstate -s to check the resynchronization progress.
20220915:19:15:35:032388 gpaddmirrors:node1:gpadmin-[INFO]:-******************************************************************
--查看镜像信息
[gpadmin@node1 ~]$ gpstate -m
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:-Starting gpstate with args: -m
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source'
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.22.0 build commit:4b6c079bc3aed35b2f161c377e208185f9310a69 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Sep 8 2022 22:41:44'
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:-Obtaining Segment details from master...
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:--------------------------------------------------------------
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:--Current GPDB mirror list and status
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:--Type = Group
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:--------------------------------------------------------------
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:- Mirror Datadir Port Status Data Status
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:- node3 /data/gpdata/seg1/mirror/gpseg0 8000 Passive Synchronized
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:- node3 /data/gpdata/seg2/mirror/gpseg1 8001 Passive Synchronized
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:- node2 /data/gpdata/seg1/mirror/gpseg2 8000 Passive Synchronized
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:- node2 /data/gpdata/seg2/mirror/gpseg3 8001 Passive Synchronized
20220915:19:17:05:000582 gpstate:node1:gpadmin-[INFO]:--------------------------------------------------------------
最后修改时间:2022-09-16 09:42:21
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。