greenplum(gp)增加mirror镜像配置

最新推荐文章于 2023-08-31 10:54:17 发布

王亭_666

最新推荐文章于 2023-08-31 10:54:17 发布

阅读量1.2k

点赞数

分类专栏：运维大数据 greenplum 文章标签：数据库 postgresql mysql

本文链接：https://blog.csdn.net/wt334502157/article/details/126742030

版权

大数据同时被 3 个专栏收录

85 篇文章 56 订阅

订阅专栏

运维

46 篇文章 5 订阅

订阅专栏

greenplum

6 篇文章 1 订阅

订阅专栏

greenplum(gp)增加mirror镜像配置

mirror备份工具gpaddmirrors介绍

gpaddmirrors工具为初始仅配置了主Segment实例的现有Greenplum数据库系统配置镜像Segment实例。该工具创建镜像实例并开始主Segment实例和镜像Segment实例之间的在线复制进程。一旦所有的镜像与其主Segment同步好，用户的Greenplum数据库系统就建立了完全的数据冗余。
【注意】:

在在线复制进程中，Greenplum数据库应处于静止状态，负载和其他查询不应该运行。
默认情况下，该工具将提示用户输入将创建镜像Segment数据目录的文件系统位置。如果用户不想被提示，可以使用-m选项传递包含文件系统位置的文件。
镜像位置和端口必须与用户的主Segment数据位置和端口不同。如果用户创建了额外的文件空间，则还将提示用户为每个文件空间提供镜像位置。

该工具使用预定义的命名习惯在指定位置中为每个镜像Segment实例创建唯一的数据目录。必须为镜像Segment 实例声明与主Segment实例相同数量的文件系统位置。如果用户希望在同一位置创建镜像数据目录，可以多次指定同样的目录名称，或者可以为每个镜像输入不同的数据位置。对于文件系统位置，请输入绝对路径。

部署实施

查看当前集群状态

[gpadmin@ypq-dmcp-prdgpmaster ~]$ gpstate
20220907:09:08:23:071057 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Starting gpstate with args: 
20220907:09:08:23:071057 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.19.0 build commit:c88801925e5d51e4be57f54ff2158ed74a264b8e Open Source'
20220907:09:08:23:071057 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.19.0 build commit:c88801925e5d51e4be57f54ff2158ed74a264b8e Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec  8 2021 23:08:44'
20220907:09:08:23:071057 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Obtaining Segment details from master...
...
...
20220907:09:08:25:071057 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-----------------------------------------------------
20220907:09:08:25:071057 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Mirror Segment Status
20220907:09:08:25:071057 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-----------------------------------------------------
20220907:09:08:25:071057 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Mirrors not configured on this array
20220907:09:08:25:071057 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-----------------------------------------------------

可以看到集群信息有显示：Mirrors not configured on this array.未在此集群上配置mirror镜像功能

数据库查看存储节点信息

[gpadmin@ypq-dmcp-prdgpmaster ~]$ psql
psql (9.4.26)
Type "help" for help.

testdb=# SELECT * from gp_segment_configuration;
 dbid | content | role | preferred_role | mode | status | port |       hostname        |        address        |            datadir            
------+---------+------+----------------+------+--------+------+-----------------------+-----------------------+-------------------------------
    1 |      -1 | p    | p              | n    | u      | 5432 | ypd-dmcp-prdgpmaster  | ypd-dmcp-prdgpmaster  | /data/gpdata/gpmaster/gpseg-1
   10 |       8 | p    | p              | n    | u      | 6000 | ypd-dmcp-prdsegment03 | ypd-dmcp-prdsegment03 | /data/gpdata/gpdatap1/gpseg8
   14 |      12 | p    | p              | n    | u      | 6000 | ypd-dmcp-prdsegment04 | ypd-dmcp-prdsegment04 | /data/gpdata/gpdatap1/gpseg12
   18 |      16 | p    | p              | n    | u      | 6000 | ypd-dmcp-prdsegment05 | ypd-dmcp-prdsegment05 | /data/gpdata/gpdatap1/gpseg16
    2 |       0 | p    | p              | n    | u      | 6000 | ypd-dmcp-prdsegment01 | ypd-dmcp-prdsegment01 | /data/gpdata/gpdatap1/gpseg0
    6 |       4 | p    | p              | n    | u      | 6000 | ypd-dmcp-prdsegment02 | ypd-dmcp-prdsegment02 | /data/gpdata/gpdatap1/gpseg4
   11 |       9 | p    | p              | n    | u      | 6001 | ypd-dmcp-prdsegment03 | ypd-dmcp-prdsegment03 | /data/gpdata/gpdatap2/gpseg9
   15 |      13 | p    | p              | n    | u      | 6001 | ypd-dmcp-prdsegment04 | ypd-dmcp-prdsegment04 | /data/gpdata/gpdatap2/gpseg13
   19 |      17 | p    | p              | n    | u      | 6001 | ypd-dmcp-prdsegment05 | ypd-dmcp-prdsegment05 | /data/gpdata/gpdatap2/gpseg17
    3 |       1 | p    | p              | n    | u      | 6001 | ypd-dmcp-prdsegment01 | ypd-dmcp-prdsegment01 | /data/gpdata/gpdatap2/gpseg1
    7 |       5 | p    | p              | n    | u      | 6001 | ypd-dmcp-prdsegment02 | ypd-dmcp-prdsegment02 | /data/gpdata/gpdatap2/gpseg5
   12 |      10 | p    | p              | n    | u      | 6002 | ypd-dmcp-prdsegment03 | ypd-dmcp-prdsegment03 | /data/gpdata/gpdatap3/gpseg10
   16 |      14 | p    | p              | n    | u      | 6002 | ypd-dmcp-prdsegment04 | ypd-dmcp-prdsegment04 | /data/gpdata/gpdatap3/gpseg14
   20 |      18 | p    | p              | n    | u      | 6002 | ypd-dmcp-prdsegment05 | ypd-dmcp-prdsegment05 | /data/gpdata/gpdatap3/gpseg18
    4 |       2 | p    | p              | n    | u      | 6002 | ypd-dmcp-prdsegment01 | ypd-dmcp-prdsegment01 | /data/gpdata/gpdatap3/gpseg2
    8 |       6 | p    | p              | n    | u      | 6002 | ypd-dmcp-prdsegment02 | ypd-dmcp-prdsegment02 | /data/gpdata/gpdatap3/gpseg6
   13 |      11 | p    | p              | n    | u      | 6003 | ypd-dmcp-prdsegment03 | ypd-dmcp-prdsegment03 | /data/gpdata/gpdatap4/gpseg11
   17 |      15 | p    | p              | n    | u      | 6003 | ypd-dmcp-prdsegment04 | ypd-dmcp-prdsegment04 | /data/gpdata/gpdatap4/gpseg15
   21 |      19 | p    | p              | n    | u      | 6003 | ypd-dmcp-prdsegment05 | ypd-dmcp-prdsegment05 | /data/gpdata/gpdatap4/gpseg19
    5 |       3 | p    | p              | n    | u      | 6003 | ypd-dmcp-prdsegment01 | ypd-dmcp-prdsegment01 | /data/gpdata/gpdatap4/gpseg3
    9 |       7 | p    | p              | n    | u      | 6003 | ypd-dmcp-prdsegment02 | ypd-dmcp-prdsegment02 | /data/gpdata/gpdatap4/gpseg7
   22 |      -1 | m    | m              | s    | u      | 5432 | ypd-dmcp-prdgpstandby | ypd-dmcp-prdgpstandby | /data/gpdata/gpmaster/gpseg-1
(22 rows)
testdb=# \q

可以看到2个管理存储，数据存储节点为20个，均为primary

创建节点清单文件

[gpadmin@ypq-dmcp-prdgpmaster ~]$ cd /data/
[root@ypq-dmcp-prdgpmaster data]# vim seg_host 
ypd-dmcp-prdgpmaster
ypd-dmcp-prdgpstandby
ypd-dmcp-prdsegment01
ypd-dmcp-prdsegment02
ypd-dmcp-prdsegment03
ypd-dmcp-prdsegment04
ypd-dmcp-prdsegment05

【注意】：这里的主机名清单根据自己的当前环境各hostname清单来编写，名称不同

各节点创建mirror存储目录

【注意】：

创建的目录数量和当前自己gp的环境设置的每个节点segment的节点数量相同，所以gpdatam的目录数可能是一个，可能是多个，根据情况规划。例如：gpdatap1-4，有4个，对应创建了4个mirror目录。
创建目录也可以不批量操作，而逐个登录集群节点手动创建目录。

[root@ypq-dmcp-prdgpmaster data]# gpssh -f hostlist
=>mkdir -p /data/gpdata/gpdatam{1,2,3,4}
=> hostname && ls /data/gpdata | grep gpdatam
[ ypd-dmcp-prdgpmaster] ypq-dmcp-prdgpmaster
[ ypd-dmcp-prdgpmaster] gpdatam1
[ ypd-dmcp-prdgpmaster] gpdatam2
[ ypd-dmcp-prdgpmaster] gpdatam3
[ ypd-dmcp-prdgpmaster] gpdatam4
[ypd-dmcp-prdsegment01] ypq-dmcp-prdsegment01
[ypd-dmcp-prdsegment01] gpdatam1
[ypd-dmcp-prdsegment01] gpdatam2
[ypd-dmcp-prdsegment01] gpdatam3
[ypd-dmcp-prdsegment01] gpdatam4
[ypd-dmcp-prdgpstandby] ypd-dmcp-prdgpstandby
[ypd-dmcp-prdgpstandby] gpdatam1
[ypd-dmcp-prdgpstandby] gpdatam2
[ypd-dmcp-prdgpstandby] gpdatam3
[ypd-dmcp-prdgpstandby] gpdatam4
[ypd-dmcp-prdsegment02] ypq-dmcp-prdsegment02
[ypd-dmcp-prdsegment02] gpdatam1
[ypd-dmcp-prdsegment02] gpdatam2
[ypd-dmcp-prdsegment02] gpdatam3
[ypd-dmcp-prdsegment02] gpdatam4
[ypd-dmcp-prdsegment04] ypd-dmcp-prdsegment04
[ypd-dmcp-prdsegment04] gpdatam1
[ypd-dmcp-prdsegment04] gpdatam2
[ypd-dmcp-prdsegment04] gpdatam3
[ypd-dmcp-prdsegment04] gpdatam4
[ypd-dmcp-prdsegment05] ypd-dmcp-prdsegment05
[ypd-dmcp-prdsegment05] gpdatam1
[ypd-dmcp-prdsegment05] gpdatam2
[ypd-dmcp-prdsegment05] gpdatam3
[ypd-dmcp-prdsegment05] gpdatam4
[ypd-dmcp-prdsegment03] ypd-dmcp-prdsegment03
[ypd-dmcp-prdsegment03] gpdatam1
[ypd-dmcp-prdsegment03] gpdatam2
[ypd-dmcp-prdsegment03] gpdatam3
[ypd-dmcp-prdsegment03] gpdatam4
=> exit

执行gpaddmirrors执行mirror添加

gpaddmirrors -o （output_sample_mirror_config）

用户使用这一选项运行 gpaddmirrors来生成一个基于主Segment配置的镜像配置文件示例。该工具将提示用户输入用户的镜像Segment数据目录位置（除非用户使用-m在一个文件中提供了这些位置）。然后用户可以编辑此文件根据需要将主机名更改为后补的镜像主机。

gpaddmirrors -i （mirror_config_file）

一个配置文件，每个要创建的镜像Segment对应一行。用户必须为系统中的每个主Segment都在该文件中列出一个镜像Segment

[gpadmin@ypq-dmcp-prdgpmaster data]$ gpaddmirrors -o ./addmirror
20220907:09:12:43:071171 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Starting gpaddmirrors with args: -o ./addmirror
20220907:09:12:43:071171 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.19.0 build commit:c88801925e5d51e4be57f54ff2158ed74a264b8e Open Source'
20220907:09:12:43:071171 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.19.0 build commit:c88801925e5d51e4be57f54ff2158ed74a264b8e Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec  8 2021 23:08:44'
20220907:09:12:43:071171 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Obtaining Segment details from master...
20220907:09:12:44:071171 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Heap checksum setting consistent across cluster
# 注意目录输入和之前创建的一一对应
Enter mirror segment data directory location 1 of 4 >
/data/gpdata/gpdatam1
Enter mirror segment data directory location 2 of 4 >
/data/gpdata/gpdatam2
Enter mirror segment data directory location 3 of 4 >
/data/gpdata/gpdatam3
Enter mirror segment data directory location 4 of 4 >
/data/gpdata/gpdatam4
20220907:09:13:58:071171 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Configuration file output to ./addmirror successfully.
# 查看生成的addmirror文件
[gpadmin@ypq-dmcp-prdgpmaster data]$ cat addmirror 
0|ypd-dmcp-prdsegment02|7000|/data/gpdata/gpdatam1/gpseg0
1|ypd-dmcp-prdsegment02|7001|/data/gpdata/gpdatam2/gpseg1
2|ypd-dmcp-prdsegment02|7002|/data/gpdata/gpdatam3/gpseg2
3|ypd-dmcp-prdsegment02|7003|/data/gpdata/gpdatam4/gpseg3
4|ypd-dmcp-prdsegment03|7000|/data/gpdata/gpdatam1/gpseg4
5|ypd-dmcp-prdsegment03|7001|/data/gpdata/gpdatam2/gpseg5
6|ypd-dmcp-prdsegment03|7002|/data/gpdata/gpdatam3/gpseg6
7|ypd-dmcp-prdsegment03|7003|/data/gpdata/gpdatam4/gpseg7
8|ypd-dmcp-prdsegment04|7000|/data/gpdata/gpdatam1/gpseg8
9|ypd-dmcp-prdsegment04|7001|/data/gpdata/gpdatam2/gpseg9
10|ypd-dmcp-prdsegment04|7002|/data/gpdata/gpdatam3/gpseg10
11|ypd-dmcp-prdsegment04|7003|/data/gpdata/gpdatam4/gpseg11
12|ypd-dmcp-prdsegment05|7000|/data/gpdata/gpdatam1/gpseg12
13|ypd-dmcp-prdsegment05|7001|/data/gpdata/gpdatam2/gpseg13
14|ypd-dmcp-prdsegment05|7002|/data/gpdata/gpdatam3/gpseg14
15|ypd-dmcp-prdsegment05|7003|/data/gpdata/gpdatam4/gpseg15
16|ypd-dmcp-prdsegment01|7000|/data/gpdata/gpdatam1/gpseg16
17|ypd-dmcp-prdsegment01|7001|/data/gpdata/gpdatam2/gpseg17
18|ypd-dmcp-prdsegment01|7002|/data/gpdata/gpdatam3/gpseg18
19|ypd-dmcp-prdsegment01|7003|/data/gpdata/gpdatam4/gpseg19

[gpadmin@ypq-dmcp-prdgpmaster data]$ gpaddmirrors -i addmirror 
20220907:09:14:51:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Starting gpaddmirrors with args: -i addmirror
20220907:09:14:51:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.19.0 build commit:c88801925e5d51e4be57f54ff2158ed74a264b8e Open Source'
20220907:09:14:51:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.19.0 build commit:c88801925e5d51e4be57f54ff2158ed74a264b8e Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec  8 2021 23:08:44'
20220907:09:14:51:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Obtaining Segment details from master...
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Heap checksum setting consistent across cluster
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Greenplum Add Mirrors Parameters
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:---------------------------------------------
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Greenplum master data directory         = /data/gpdata/gpmaster/gpseg-1
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Greenplum master port                   = 5432
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Batch size                              = 16
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Segment batch size                      = 64
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:---------------------------------------------
...
...
...
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:----------------------------------
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Mirror 20 of 20
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:---------------------------------------------
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Primary instance host        = ypd-dmcp-prdsegment05
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Primary instance address     = ypd-dmcp-prdsegment05
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Primary instance directory   = /data/gpdata/gpdatap4/gpseg19
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Primary instance port        = 6003
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Mirror instance host         = ypd-dmcp-prdsegment01
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Mirror instance address      = ypd-dmcp-prdsegment01
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Mirror instance directory    = /data/gpdata/gpdatam4/gpseg19
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Mirror instance port         = 7003
20220907:09:14:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:---------------------------------------------
Continue with add mirrors procedure Yy|Nn (default=N):
> y
20220907:09:15:00:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Starting to create new pg_hba.conf on primary segments
20220907:09:15:20:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Successfully modified pg_hba.conf on primary segments to allow replication connections
20220907:09:15:20:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-20 segment(s) to add
20220907:09:15:20:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Validating remote directories
20220907:09:15:20:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Configuring new segments
ypd-dmcp-prdsegment03 (dbid 27): pg_basebackup: base backup completed
ypd-dmcp-prdsegment03 (dbid 28): pg_basebackup: base backup completed
ypd-dmcp-prdsegment03 (dbid 29): pg_basebackup: base backup completed
ypd-dmcp-prdsegment03 (dbid 30): pg_basebackup: base backup completed
ypd-dmcp-prdsegment02 (dbid 23): pg_basebackup: base backup completed
ypd-dmcp-prdsegment02 (dbid 24): pg_basebackup: base backup completed
ypd-dmcp-prdsegment02 (dbid 25): pg_basebackup: base backup completed
ypd-dmcp-prdsegment02 (dbid 26): pg_basebackup: base backup completed
ypd-dmcp-prdsegment01 (dbid 39): pg_basebackup: base backup completed
ypd-dmcp-prdsegment01 (dbid 40): pg_basebackup: base backup completed
ypd-dmcp-prdsegment01 (dbid 41): pg_basebackup: base backup completed
ypd-dmcp-prdsegment01 (dbid 42): pg_basebackup: base backup completed
ypd-dmcp-prdsegment05 (dbid 35): pg_basebackup: base backup completed
ypd-dmcp-prdsegment05 (dbid 36): pg_basebackup: base backup completed
ypd-dmcp-prdsegment05 (dbid 37): pg_basebackup: base backup completed
ypd-dmcp-prdsegment05 (dbid 38): pg_basebackup: base backup completed
ypd-dmcp-prdsegment04 (dbid 31): pg_basebackup: base backup completed
ypd-dmcp-prdsegment04 (dbid 32): pg_basebackup: base backup completed
ypd-dmcp-prdsegment04 (dbid 33): pg_basebackup: base backup completed
ypd-dmcp-prdsegment04 (dbid 34): pg_basebackup: base backup completed
20220907:09:15:52:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Updating configuration with new mirrors
20220907:09:15:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Updating mirrors
20220907:09:15:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Starting mirrors
20220907:09:15:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-era is 4c498c938ed13004_220905113725
20220907:09:15:53:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
.
20220907:09:15:54:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Process results...
20220907:09:15:54:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-******************************************************************
20220907:09:15:54:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Mirror segments have been added; data synchronization is in progress.
20220907:09:15:54:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Data synchronization will continue in the background.
20220907:09:15:54:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Use  gpstate -s  to check the resynchronization progress.
20220907:09:15:54:071236 gpaddmirrors:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-******************************************************************

这样增加mirror的功能已经完成

验证mirror

再次查看gpstate可以看到已经有了mirror的信息展示

[gpadmin@ypq-dmcp-prdgpmaster data]$ gpstate
20220907:09:17:34:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Starting gpstate with args: 
20220907:09:17:34:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.19.0 build commit:c88801925e5d51e4be57f54ff2158ed74a264b8e Open Source'
20220907:09:17:34:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.19.0 build commit:c88801925e5d51e4be57f54ff2158ed74a264b8e Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec  8 2021 23:08:44'
20220907:09:17:34:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Obtaining Segment details from master...
20220907:09:17:34:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Gathering data from segments...
.
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-Greenplum instance status summary
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-----------------------------------------------------
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Master instance                                           = Active
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Master standby                                            = ypd-dmcp-prdgpstandby
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Standby master state                                      = Standby host passive
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total segment instance count from metadata                = 40
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-----------------------------------------------------
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Primary Segment Status
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-----------------------------------------------------
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total primary segments                                    = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total primary segment valid (at master)                   = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total primary segment failures (at master)                = 0
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number postmaster processes found                   = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-----------------------------------------------------
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Mirror Segment Status
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-----------------------------------------------------
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total mirror segments                                     = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total mirror segment valid (at master)                    = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total mirror segment failures (at master)                 = 0
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number postmaster processes found                   = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number mirror segments acting as primary segments   = 0
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-   Total number mirror segments acting as mirror segments    = 20
20220907:09:17:35:071495 gpstate:ypq-dmcp-prdgpmaster:gpadmin-[INFO]:-----------------------------------------------------

数据库种查询信息：（可以看到是20primary+20mirror）

[gpadmin@ypq-dmcp-prdgpmaster data]$ psql
psql (9.4.26)
Type "help" for help.

testdb=# SELECT * from gp_segment_configuration;
 dbid | content | role | preferred_role | mode | status | port |       hostname        |        address        |            datadir            
------+---------+------+----------------+------+--------+------+-----------------------+-----------------------+-------------------------------
    1 |      -1 | p    | p              | n    | u      | 5432 | ypd-dmcp-prdgpmaster  | ypd-dmcp-prdgpmaster  | /data/gpdata/gpmaster/gpseg-1
   22 |      -1 | m    | m              | s    | u      | 5432 | ypd-dmcp-prdgpstandby | ypd-dmcp-prdgpstandby | /data/gpdata/gpmaster/gpseg-1
    9 |       7 | p    | p              | s    | u      | 6003 | ypd-dmcp-prdsegment02 | ypd-dmcp-prdsegment02 | /data/gpdata/gpdatap4/gpseg7
   30 |       7 | m    | m              | s    | u      | 7003 | ypd-dmcp-prdsegment03 | ypd-dmcp-prdsegment03 | /data/gpdata/gpdatam4/gpseg7
    2 |       0 | p    | p              | s    | u      | 6000 | ypd-dmcp-prdsegment01 | ypd-dmcp-prdsegment01 | /data/gpdata/gpdatap1/gpseg0
   23 |       0 | m    | m              | s    | u      | 7000 | ypd-dmcp-prdsegment02 | ypd-dmcp-prdsegment02 | /data/gpdata/gpdatam1/gpseg0
    3 |       1 | p    | p              | s    | u      | 6001 | ypd-dmcp-prdsegment01 | ypd-dmcp-prdsegment01 | /data/gpdata/gpdatap2/gpseg1
   24 |       1 | m    | m              | s    | u      | 7001 | ypd-dmcp-prdsegment02 | ypd-dmcp-prdsegment02 | /data/gpdata/gpdatam2/gpseg1
    4 |       2 | p    | p              | s    | u      | 6002 | ypd-dmcp-prdsegment01 | ypd-dmcp-prdsegment01 | /data/gpdata/gpdatap3/gpseg2
   25 |       2 | m    | m              | s    | u      | 7002 | ypd-dmcp-prdsegment02 | ypd-dmcp-prdsegment02 | /data/gpdata/gpdatam3/gpseg2
    5 |       3 | p    | p              | s    | u      | 6003 | ypd-dmcp-prdsegment01 | ypd-dmcp-prdsegment01 | /data/gpdata/gpdatap4/gpseg3
   26 |       3 | m    | m              | s    | u      | 7003 | ypd-dmcp-prdsegment02 | ypd-dmcp-prdsegment02 | /data/gpdata/gpdatam4/gpseg3
    6 |       4 | p    | p              | s    | u      | 6000 | ypd-dmcp-prdsegment02 | ypd-dmcp-prdsegment02 | /data/gpdata/gpdatap1/gpseg4
   27 |       4 | m    | m              | s    | u      | 7000 | ypd-dmcp-prdsegment03 | ypd-dmcp-prdsegment03 | /data/gpdata/gpdatam1/gpseg4
    8 |       6 | p    | p              | s    | u      | 6002 | ypd-dmcp-prdsegment02 | ypd-dmcp-prdsegment02 | /data/gpdata/gpdatap3/gpseg6
   29 |       6 | m    | m              | s    | u      | 7002 | ypd-dmcp-prdsegment03 | ypd-dmcp-prdsegment03 | /data/gpdata/gpdatam3/gpseg6
   12 |      10 | p    | p              | s    | u      | 6002 | ypd-dmcp-prdsegment03 | ypd-dmcp-prdsegment03 | /data/gpdata/gpdatap3/gpseg10
   33 |      10 | m    | m              | s    | u      | 7002 | ypd-dmcp-prdsegment04 | ypd-dmcp-prdsegment04 | /data/gpdata/gpdatam3/gpseg10
   10 |       8 | p    | p              | s    | u      | 6000 | ypd-dmcp-prdsegment03 | ypd-dmcp-prdsegment03 | /data/gpdata/gpdatap1/gpseg8
   31 |       8 | m    | m              | s    | u      | 7000 | ypd-dmcp-prdsegment04 | ypd-dmcp-prdsegment04 | /data/gpdata/gpdatam1/gpseg8
   13 |      11 | p    | p              | s    | u      | 6003 | ypd-dmcp-prdsegment03 | ypd-dmcp-prdsegment03 | /data/gpdata/gpdatap4/gpseg11
   34 |      11 | m    | m              | s    | u      | 7003 | ypd-dmcp-prdsegment04 | ypd-dmcp-prdsegment04 | /data/gpdata/gpdatam4/gpseg11
    7 |       5 | p    | p              | s    | u      | 6001 | ypd-dmcp-prdsegment02 | ypd-dmcp-prdsegment02 | /data/gpdata/gpdatap2/gpseg5
   28 |       5 | m    | m              | s    | u      | 7001 | ypd-dmcp-prdsegment03 | ypd-dmcp-prdsegment03 | /data/gpdata/gpdatam2/gpseg5
   11 |       9 | p    | p              | s    | u      | 6001 | ypd-dmcp-prdsegment03 | ypd-dmcp-prdsegment03 | /data/gpdata/gpdatap2/gpseg9
   32 |       9 | m    | m              | s    | u      | 7001 | ypd-dmcp-prdsegment04 | ypd-dmcp-prdsegment04 | /data/gpdata/gpdatam2/gpseg9
   14 |      12 | p    | p              | s    | u      | 6000 | ypd-dmcp-prdsegment04 | ypd-dmcp-prdsegment04 | /data/gpdata/gpdatap1/gpseg12
   35 |      12 | m    | m              | s    | u      | 7000 | ypd-dmcp-prdsegment05 | ypd-dmcp-prdsegment05 | /data/gpdata/gpdatam1/gpseg12
   15 |      13 | p    | p              | s    | u      | 6001 | ypd-dmcp-prdsegment04 | ypd-dmcp-prdsegment04 | /data/gpdata/gpdatap2/gpseg13
   36 |      13 | m    | m              | s    | u      | 7001 | ypd-dmcp-prdsegment05 | ypd-dmcp-prdsegment05 | /data/gpdata/gpdatam2/gpseg13
   16 |      14 | p    | p              | s    | u      | 6002 | ypd-dmcp-prdsegment04 | ypd-dmcp-prdsegment04 | /data/gpdata/gpdatap3/gpseg14
   37 |      14 | m    | m              | s    | u      | 7002 | ypd-dmcp-prdsegment05 | ypd-dmcp-prdsegment05 | /data/gpdata/gpdatam3/gpseg14
   17 |      15 | p    | p              | s    | u      | 6003 | ypd-dmcp-prdsegment04 | ypd-dmcp-prdsegment04 | /data/gpdata/gpdatap4/gpseg15
   38 |      15 | m    | m              | s    | u      | 7003 | ypd-dmcp-prdsegment05 | ypd-dmcp-prdsegment05 | /data/gpdata/gpdatam4/gpseg15
   18 |      16 | p    | p              | s    | u      | 6000 | ypd-dmcp-prdsegment05 | ypd-dmcp-prdsegment05 | /data/gpdata/gpdatap1/gpseg16
   39 |      16 | m    | m              | s    | u      | 7000 | ypd-dmcp-prdsegment01 | ypd-dmcp-prdsegment01 | /data/gpdata/gpdatam1/gpseg16
   19 |      17 | p    | p              | s    | u      | 6001 | ypd-dmcp-prdsegment05 | ypd-dmcp-prdsegment05 | /data/gpdata/gpdatap2/gpseg17
   40 |      17 | m    | m              | s    | u      | 7001 | ypd-dmcp-prdsegment01 | ypd-dmcp-prdsegment01 | /data/gpdata/gpdatam2/gpseg17
   20 |      18 | p    | p              | s    | u      | 6002 | ypd-dmcp-prdsegment05 | ypd-dmcp-prdsegment05 | /data/gpdata/gpdatap3/gpseg18
   41 |      18 | m    | m              | s    | u      | 7002 | ypd-dmcp-prdsegment01 | ypd-dmcp-prdsegment01 | /data/gpdata/gpdatam3/gpseg18
   21 |      19 | p    | p              | s    | u      | 6003 | ypd-dmcp-prdsegment05 | ypd-dmcp-prdsegment05 | /data/gpdata/gpdatap4/gpseg19
   42 |      19 | m    | m              | s    | u      | 7003 | ypd-dmcp-prdsegment01 | ypd-dmcp-prdsegment01 | /data/gpdata/gpdatam4/gpseg19
(42 rows)
testdb=# \q

查看目录大小:

[gpadmin@ypq-dmcp-prdgpmaster data]$ gpssh -f seg_host      
=> hostname && du -sh /data/gpdata/*
[ ypd-dmcp-prdgpmaster] ypq-dmcp-prdgpmaster
[ ypd-dmcp-prdgpmaster] 0       /data/gpdata/gpdatam1
[ ypd-dmcp-prdgpmaster] 0       /data/gpdata/gpdatam2
[ ypd-dmcp-prdgpmaster] 0       /data/gpdata/gpdatam3
[ ypd-dmcp-prdgpmaster] 0       /data/gpdata/gpdatam4
[ ypd-dmcp-prdgpmaster] 0       /data/gpdata/gpdatap1
[ ypd-dmcp-prdgpmaster] 0       /data/gpdata/gpdatap2
[ ypd-dmcp-prdgpmaster] 0       /data/gpdata/gpdatap3
[ ypd-dmcp-prdgpmaster] 0       /data/gpdata/gpdatap4
[ ypd-dmcp-prdgpmaster] 292M    /data/gpdata/gpmaster
[ypd-dmcp-prdsegment03] ypd-dmcp-prdsegment03
[ypd-dmcp-prdsegment03] 224M    /data/gpdata/gpdatam1
[ypd-dmcp-prdsegment03] 224M    /data/gpdata/gpdatam2
[ypd-dmcp-prdsegment03] 224M    /data/gpdata/gpdatam3
[ypd-dmcp-prdsegment03] 224M    /data/gpdata/gpdatam4
[ypd-dmcp-prdsegment03] 1.6G    /data/gpdata/gpdatap1
[ypd-dmcp-prdsegment03] 1.6G    /data/gpdata/gpdatap2
[ypd-dmcp-prdsegment03] 1.6G    /data/gpdata/gpdatap3
[ypd-dmcp-prdsegment03] 1.6G    /data/gpdata/gpdatap4
[ypd-dmcp-prdsegment03] 0       /data/gpdata/gpmaster
[ypd-dmcp-prdgpstandby] ypd-dmcp-prdgpstandby
[ypd-dmcp-prdgpstandby] 0       /data/gpdata/gpdatam1
[ypd-dmcp-prdgpstandby] 0       /data/gpdata/gpdatam2
[ypd-dmcp-prdgpstandby] 0       /data/gpdata/gpdatam3
[ypd-dmcp-prdgpstandby] 0       /data/gpdata/gpdatam4
[ypd-dmcp-prdgpstandby] 0       /data/gpdata/gpdatap1
[ypd-dmcp-prdgpstandby] 0       /data/gpdata/gpdatap2
[ypd-dmcp-prdgpstandby] 0       /data/gpdata/gpdatap3
[ypd-dmcp-prdgpstandby] 0       /data/gpdata/gpdatap4
[ypd-dmcp-prdgpstandby] 224M    /data/gpdata/gpmaster
[ypd-dmcp-prdsegment02] ypq-dmcp-prdsegment02
[ypd-dmcp-prdsegment02] 224M    /data/gpdata/gpdatam1
[ypd-dmcp-prdsegment02] 224M    /data/gpdata/gpdatam2
[ypd-dmcp-prdsegment02] 224M    /data/gpdata/gpdatam3
[ypd-dmcp-prdsegment02] 224M    /data/gpdata/gpdatam4
[ypd-dmcp-prdsegment02] 1.6G    /data/gpdata/gpdatap1
[ypd-dmcp-prdsegment02] 1.6G    /data/gpdata/gpdatap2
[ypd-dmcp-prdsegment02] 1.5G    /data/gpdata/gpdatap3
[ypd-dmcp-prdsegment02] 1.6G    /data/gpdata/gpdatap4
[ypd-dmcp-prdsegment02] 0       /data/gpdata/gpmaster
[ypd-dmcp-prdsegment01] ypq-dmcp-prdsegment01
[ypd-dmcp-prdsegment01] 224M    /data/gpdata/gpdatam1
[ypd-dmcp-prdsegment01] 224M    /data/gpdata/gpdatam2
[ypd-dmcp-prdsegment01] 224M    /data/gpdata/gpdatam3
[ypd-dmcp-prdsegment01] 224M    /data/gpdata/gpdatam4
[ypd-dmcp-prdsegment01] 1.5G    /data/gpdata/gpdatap1
[ypd-dmcp-prdsegment01] 1.5G    /data/gpdata/gpdatap2
[ypd-dmcp-prdsegment01] 1.6G    /data/gpdata/gpdatap3
[ypd-dmcp-prdsegment01] 1.5G    /data/gpdata/gpdatap4
[ypd-dmcp-prdsegment01] 0       /data/gpdata/gpmaster
[ypd-dmcp-prdsegment05] ypd-dmcp-prdsegment05
[ypd-dmcp-prdsegment05] 224M    /data/gpdata/gpdatam1
[ypd-dmcp-prdsegment05] 224M    /data/gpdata/gpdatam2
[ypd-dmcp-prdsegment05] 224M    /data/gpdata/gpdatam3
[ypd-dmcp-prdsegment05] 224M    /data/gpdata/gpdatam4
[ypd-dmcp-prdsegment05] 1.6G    /data/gpdata/gpdatap1
[ypd-dmcp-prdsegment05] 1.5G    /data/gpdata/gpdatap2
[ypd-dmcp-prdsegment05] 1.5G    /data/gpdata/gpdatap3
[ypd-dmcp-prdsegment05] 1.6G    /data/gpdata/gpdatap4
[ypd-dmcp-prdsegment05] 0       /data/gpdata/gpmaster
[ypd-dmcp-prdsegment04] ypd-dmcp-prdsegment04
[ypd-dmcp-prdsegment04] 224M    /data/gpdata/gpdatam1
[ypd-dmcp-prdsegment04] 224M    /data/gpdata/gpdatam2
[ypd-dmcp-prdsegment04] 224M    /data/gpdata/gpdatam3
[ypd-dmcp-prdsegment04] 224M    /data/gpdata/gpdatam4
[ypd-dmcp-prdsegment04] 1.6G    /data/gpdata/gpdatap1
[ypd-dmcp-prdsegment04] 1.6G    /data/gpdata/gpdatap2
[ypd-dmcp-prdsegment04] 1.5G    /data/gpdata/gpdatap3
[ypd-dmcp-prdsegment04] 1.6G    /data/gpdata/gpdatap4
[ypd-dmcp-prdsegment04] 0       /data/gpdata/gpmaster

可以看到目前mirror中已经存储了已有数据的备份

王亭_666

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
打赏
0
评论
greenplum(gp)增加mirror镜像配置

gpaddmirrors工具为初始仅配置了主Segment实例的现有Greenplum数据库系统配置镜像 Segment实例。该工具创建镜像实例并开始主Segment实例和镜像Segment实例之间的在线复制进程。一旦所有的镜像与其主Segment同步好，用户的Greenplum数据库系统就建立了完全的数据冗余。Important: 在在线复制进程中，Greenplum数据库应处于静止状态，负载和其他查询不应该运行。
复制链接

扫一扫