添加mirror也分两种情况，在现有的GP集群节点中添加，或者新加的主机中添加。
如果在新加的主机中添加mirror，那么首先需要做的是对应主机的初始化（包括OS的配置，SSH KEY的交换，GP BIN的安装等等）
对应新加主机的部分，可以参考 Greenplum 扩展 segment个数 中的方法来添加新的主机。这里不多说。
http://yq.aliyun.com/articles/177
接下来的就是可以复用的内容。
在所有需要添加mirror的主机，创建存放mirror的数据目录
$ mkdir /disk1/digoal/gpdata_mirror
产生配置文件
$ gpaddmirrors -o ./addmirror
需要输入每个primary segment对应的mirror的目录
Enter mirror segment data directory location 1 of 23 >
/disk1/digoal/gpdata_mirror
Enter mirror segment data directory location 2 of 23 >
/disk1/digoal/gpdata_mirror
Enter mirror segment data directory location 3 of 23 >
......
Enter mirror segment data directory location 23 of 23 >
/disk1/digoal/gpdata_mirror
20151217:17:58:15:070582 gpaddmirrors:digoal:digoal-[INFO]:-Configuration file output to ./addmirror successfully.
查看配置文件
$ cat addmirror
filespaceOrder=
mirror0=0:digoal.sqa.zmf:41000:42000:43000:/disk1/digoal/gpdata_mirror/gpseg0
mirror1=1:digoal.sqa.zmf:41001:42001:43001:/disk1/digoal/gpdata_mirror/gpseg1
mirror2=2:digoal.sqa.zmf:41002:42002:43002:/disk1/digoal/gpdata_mirror/gpseg2
mirror3=3:digoal.sqa.zmf:41003:42003:43003:/disk1/digoal/gpdata_mirror/gpseg3
mirror4=4:digoal.sqa.zmf:41004:42004:43004:/disk1/digoal/gpdata_mirror/gpseg4
mirror5=5:digoal.sqa.zmf:41005:42005:43005:/disk1/digoal/gpdata_mirror/gpseg5
mirror6=6:digoal.sqa.zmf:41006:42006:43006:/disk1/digoal/gpdata_mirror/gpseg6
mirror7=7:digoal.sqa.zmf:41007:42007:43007:/disk1/digoal/gpdata_mirror/gpseg7
mirror8=8:digoal.sqa.zmf:41008:42008:43008:/disk1/digoal/gpdata_mirror/gpseg8
mirror9=9:digoal.sqa.zmf:41009:42009:43009:/disk1/digoal/gpdata_mirror/gpseg9
mirror10=10:digoal.sqa.zmf:41010:42010:43010:/disk1/digoal/gpdata_mirror/gpseg10
mirror11=11:digoal.sqa.zmf:41011:42011:43011:/disk1/digoal/gpdata_mirror/gpseg11
mirror12=12:digoal.sqa.zmf:41012:42012:43012:/disk1/digoal/gpdata_mirror/gpseg12
mirror13=13:digoal.sqa.zmf:41013:42013:43013:/disk1/digoal/gpdata_mirror/gpseg13
mirror14=14:digoal.sqa.zmf:41014:42014:43014:/disk1/digoal/gpdata_mirror/gpseg14
mirror15=15:digoal.sqa.zmf:41015:42015:43015:/disk1/digoal/gpdata_mirror/gpseg15
mirror16=16:digoal.sqa.zmf:41016:42016:43016:/disk1/digoal/gpdata_mirror/gpseg16
mirror17=17:digoal.sqa.zmf:41017:42017:43017:/disk1/digoal/gpdata_mirror/gpseg17
mirror18=18:digoal.sqa.zmf:41018:42018:43018:/disk1/digoal/gpdata_mirror/gpseg18
mirror19=19:digoal.sqa.zmf:41019:42019:43019:/disk1/digoal/gpdata_mirror/gpseg19
mirror20=20:digoal.sqa.zmf:41020:42020:43020:/disk1/digoal/gpdata_mirror/gpseg20
mirror21=21:digoal.sqa.zmf:41021:42021:43021:/disk1/digoal/gpdata_mirror/gpseg21
mirror22=22:digoal.sqa.zmf:41022:42022:43022:/disk1/digoal/gpdata_mirror/gpseg22
如果你不满意，可以自行修改以上配置文件。
解释一下配置文件的含义。可以查看 gp_segment_configuration, pg_filespace, pg_filespace_entry 获得内容。
postgres=# select * from gp_segment_configuration order by role,content;
1 | -1 | p | p | s | u | 1921 | digoal.sqa.zmf | digoal.sqa.zmf | |
2 | 0 | p | p | s | u | 40000 | digoal.sqa.zmf | digoal.sqa.zmf | 43000 |
3 | 1 | p | p | s | u | 40001 | digoal.sqa.zmf | digoal.sqa.zmf | 43001 |
4 | 2 | p | p | s | u | 40002 | digoal.sqa.zmf | digoal.sqa.zmf | 43002 |
5 | 3 | p | p | s | u | 40003 | digoal.sqa.zmf | digoal.sqa.zmf | 43003 |
6 | 4 | p | p | s | u | 40004 | digoal.sqa.zmf | digoal.sqa.zmf | 43004 |
7 | 5 | p | p | s | u | 40005 | digoal.sqa.zmf | digoal.sqa.zmf | 43005 |
8 | 6 | p | p | s | u | 40006 | digoal.sqa.zmf | digoal.sqa.zmf | 43006 |
9 | 7 | p | p | s | u | 40007 | digoal.sqa.zmf | digoal.sqa.zmf | 43007 |
10 | 8 | p | p | s | u | 40008 | digoal.sqa.zmf | digoal.sqa.zmf | 43008 |
11 | 9 | p | p | s | u | 40009 | digoal.sqa.zmf | digoal.sqa.zmf | 43009 |
12 | 10 | p | p | s | u | 40010 | digoal.sqa.zmf | digoal.sqa.zmf | 43010 |
13 | 11 | p | p | s | u | 40011 | digoal.sqa.zmf | digoal.sqa.zmf | 43011 |
14 | 12 | p | p | s | u | 40012 | digoal.sqa.zmf | digoal.sqa.zmf | 43012 |
15 | 13 | p | p | s | u | 40013 | digoal.sqa.zmf | digoal.sqa.zmf | 43013 |
16 | 14 | p | p | s | u | 40014 | digoal.sqa.zmf | digoal.sqa.zmf | 43014 |
17 | 15 | p | p | s | u | 40015 | digoal.sqa.zmf | digoal.sqa.zmf | 43015 |
18 | 16 | p | p | s | u | 40016 | digoal.sqa.zmf | digoal.sqa.zmf | 43016 |
19 | 17 | p | p | s | u | 40017 | digoal.sqa.zmf | digoal.sqa.zmf | 43017 |
20 | 18 | p | p | s | u | 40018 | digoal.sqa.zmf | digoal.sqa.zmf | 43018 |
21 | 19 | p | p | s | u | 40019 | digoal.sqa.zmf | digoal.sqa.zmf | 43019 |
22 | 20 | p | p | s | u | 40020 | digoal.sqa.zmf | digoal.sqa.zmf | 43020 |
23 | 21 | p | p | s | u | 40021 | digoal.sqa.zmf | digoal.sqa.zmf | 43021 |
24 | 22 | p | p | s | u | 50011 | digoal.sqa.zmf | digoal.sqa.zmf | 43022 |
postgres=# select * from pg_filespace;
fsname | fsowner
-----------+---------
pg_system | 10
(1 row)
postgres=# select * from pg_filespace_entry ;
fsefsoid | fsedbid | fselocation
----------+---------+---------------------------------------
3052 | 1 | /disk1/digoal/gpdata/gpseg-1
3052 | 2 | /disk1/digoal/gpdata/gpseg0
3052 | 3 | /disk1/digoal/gpdata/gpseg1
3052 | 4 | /disk1/digoal/gpdata/gpseg2
3052 | 5 | /disk1/digoal/gpdata/gpseg3
3052 | 6 | /disk1/digoal/gpdata/gpseg4
3052 | 7 | /disk1/digoal/gpdata/gpseg5
3052 | 8 | /disk1/digoal/gpdata/gpseg6
3052 | 9 | /disk1/digoal/gpdata/gpseg7
3052 | 10 | /disk1/digoal/gpdata/gpseg8
3052 | 11 | /disk1/digoal/gpdata/gpseg9
3052 | 12 | /disk1/digoal/gpdata/gpseg10
3052 | 13 | /disk1/digoal/gpdata/gpseg11
3052 | 14 | /disk1/digoal/gpdata/gpseg12
3052 | 15 | /disk1/digoal/gpdata/gpseg13
3052 | 16 | /disk1/digoal/gpdata/gpseg14
3052 | 17 | /disk1/digoal/gpdata/gpseg15
3052 | 18 | /disk1/digoal/gpdata/gpseg16
3052 | 19 | /disk1/digoal/gpdata/gpseg17
3052 | 20 | /disk1/digoal/gpdata/gpseg18
3052 | 21 | /disk1/digoal/gpdata/gpseg19
3052 | 22 | /disk1/digoal/gpdata/gpseg20
3052 | 23 | /disk1/digoal/gpdata/gpseg21
3052 | 24 | /disk1/digoal/gpdata/gpseg22
3052 | 25 | /disk1/digoal/gpdata_mirror/gpseg0
3052 | 26 | /disk1/digoal/gpdata_mirror/gpseg1
3052 | 27 | /disk1/digoal/gpdata_mirror/gpseg2
3052 | 28 | /disk1/digoal/gpdata_mirror/gpseg3
3052 | 29 | /disk1/digoal/gpdata_mirror/gpseg4
3052 | 30 | /disk1/digoal/gpdata_mirror/gpseg5
3052 | 31 | /disk1/digoal/gpdata_mirror/gpseg6
3052 | 32 | /disk1/digoal/gpdata_mirror/gpseg7
3052 | 33 | /disk1/digoal/gpdata_mirror/gpseg8
3052 | 34 | /disk1/digoal/gpdata_mirror/gpseg9
3052 | 35 | /disk1/digoal/gpdata_mirror/gpseg10
3052 | 36 | /disk1/digoal/gpdata_mirror/gpseg11
3052 | 37 | /disk1/digoal/gpdata_mirror/gpseg12
3052 | 38 | /disk1/digoal/gpdata_mirror/gpseg13
3052 | 39 | /disk1/digoal/gpdata_mirror/gpseg14
3052 | 40 | /disk1/digoal/gpdata_mirror/gpseg15
3052 | 41 | /disk1/digoal/gpdata_mirror/gpseg16
3052 | 42 | /disk1/digoal/gpdata_mirror/gpseg17
3052 | 43 | /disk1/digoal/gpdata_mirror/gpseg18
3052 | 44 | /disk1/digoal/gpdata_mirror/gpseg19
3052 | 45 | /disk1/digoal/gpdata_mirror/gpseg20
3052 | 46 | /disk1/digoal/gpdata_mirror/gpseg21
3052 | 47 | /disk1/digoal/gpdata_mirror/gpseg22
(47 rows)
配置文件格式：
-i <mirror_config_file>
A configuration file containing one line for each mirror segment
you want to create. You must have one mirror segment listed for
each primary segment in the system. The format of this file is as
follows (as per attributes in the gp_segment_configuration,
pg_filespace, and pg_filespace_entry catalog tables):
filespaceOrder=[<filespace1_fsname>[:<filespace2_fsname>:...]
mirror<content>=<content>:<address>:<port>:<mir_replication_port>:<pri_replication_port>:<fselocation>[:<fselocation>:...]
Note that you only need to specify a name for filespaceOrder if
your system has multiple filespaces configured. If your system does
not have additional filespaces configured besides the default pg_system
filespace, this file will only have one location per segment (for
the default data directory filespace, pg_system). pg_system does
not need to be listed in the filespaceOrder line. It will always be
the first <fselocation> listed after <replication_port>.
根据这个格式，以及系统信息，可以定制那个mirror跑在哪台主机上，以及目录信息都可以配置。
正式添加mirror
gpaddmirrors -i ./addmirror -v -B 1
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=content id delimiter='=' value=None
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=contentId delimiter=':' value=0
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=address delimiter=':' value=digoal.sqa.zmf
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=port delimiter=':' value=41000
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=replicationPort delimiter=':' value=42000
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=primarySegmentReplicationPort delimiter=':' value=43000
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=dataDirectory delimiter=':' value=/disk1/digoal/gpdata_mirror/gpseg0
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:-./addmirror:3
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=content id delimiter='=' value=None
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=contentId delimiter=':' value=1
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=address delimiter=':' value=digoal.sqa.zmf
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=port delimiter=':' value=41001
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=replicationPort delimiter=':' value=42001
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=primarySegmentReplicationPort delimiter=':' value=43001
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[DEBUG]:- name=dataDirectory delimiter=':' value=/disk1/digoal/gpdata_mirror/gpseg1
......
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:-Greenplum Add Mirrors Parameters
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:----------------------------------------------------------
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:-Greenplum master data directory = /disk1/digoal/gpdata/gpseg-1
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:-Greenplum master port = 1921
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:-Parallel batch limit = 1
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:----------------------------------------------------------
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:-Mirror 1 of 23
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:----------------------------------------------------------
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:- Primary instance host = digoal.sqa.zmf
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:- Primary instance address = digoal.sqa.zmf
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:- Primary instance directory = /disk1/digoal/gpdata/gpseg0
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:- Primary instance port = 40000
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:- Primary instance replication port = 43000
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:- Mirror instance host = digoal.sqa.zmf
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:- Mirror instance address = digoal.sqa.zmf
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:- Mirror instance directory = /disk1/digoal/gpdata_mirror/gpseg0
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:- Mirror instance port = 41000
20151217:17:59:13:071643 gpaddmirrors:digoal:digoal-[INFO]:- Mirror instance replication port = 42000
......
Continue with add mirrors procedure Yy|Nn (default=N):
> y
......
20151217:17:59:36:071643 gpaddmirrors:digoal:digoal-[INFO]:-Process results...
20151217:17:59:36:071643 gpaddmirrors:digoal:digoal-[INFO]:-Done updating primaries
20151217:17:59:36:071643 gpaddmirrors:digoal:digoal-[INFO]:-******************************************************************
20151217:17:59:36:071643 gpaddmirrors:digoal:digoal-[INFO]:-Mirror segments have been added; data synchronization is in progress.
20151217:17:59:36:071643 gpaddmirrors:digoal:digoal-[INFO]:-Data synchronization will continue in the background.
20151217:17:59:36:071643 gpaddmirrors:digoal:digoal-[INFO]:-
20151217:17:59:36:071643 gpaddmirrors:digoal:digoal-[INFO]:-Use gpstate -s to check the resynchronization progress.
20151217:17:59:36:071643 gpaddmirrors:digoal:digoal-[INFO]:-******************************************************************
20151217:17:59:36:071643 gpaddmirrors:digoal:digoal-[DEBUG]:-WorkerPool haltWork()
20151217:17:59:36:071643 gpaddmirrors:digoal:digoal-[DEBUG]:-[worker0] haltWork
查看mirror同步状态
$ gpstate -s
Resynchronizing表示还在同步
Synchronized表示同步完成。
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Segment Info
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Hostname = digoal.sqa.zmf
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Address = digoal.sqa.zmf
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Datadir = /disk1/digoal/gpdata/gpseg0
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Port = 40000
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Mirroring Info
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Current role = Primary
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Preferred role = Primary
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Mirror status = Resynchronizing
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Change Tracking Info
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Change tracking data size = 8.25 MB
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Resynchronization Info
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Resynchronization mode = Full
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Data synchronized = 119 MB
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Estimated total data to synchronize = 121 MB
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Estimated resync progress with mirror = 98.91%
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Total resync objects = 1030
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Objects to resync = 0
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Estimated resync end time = 2015-12-17 17:59:53
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Status
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- PID = 68982
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Configuration reports status as = Up
20151217:17:59:58:074049 gpstate:digoal:digoal-[INFO]:- Database status = Suspended
或者
gpstate -m
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:-Starting gpstate with args: -m
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.3.6.1 build 2'
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.3.6.1 build 2) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 1 2015 15:14:22'
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:-Obtaining Segment details from master...
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:--------------------------------------------------------------
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:--Current GPDB mirror list and status
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:--Type = Group
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:--------------------------------------------------------------
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- Mirror Datadir Port Status Data Status
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg0 41000 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg1 41001 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg2 41002 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg3 41003 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg4 41004 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg5 41005 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg6 41006 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg7 41007 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg8 41008 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg9 41009 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg10 41010 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg11 41011 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg12 41012 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg13 41013 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg14 41014 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg15 41015 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg16 41016 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg17 41017 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg18 41018 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg19 41019 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg20 41020 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg21 41021 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:- digoal.sqa.zmf /disk1/digoal/gpdata_mirror/gpseg22 41022 Passive Synchronized
20151217:19:37:04:124869 gpstate:digoal:digoal-[INFO]:--------------------------------------------------------------
addmirror时，输出的端口信息解释
- name=port delimiter=':' value=41013 对应mirror的postmaster监听端口
- name=replicationPort delimiter=':' value=42013 对应mirror的receiver ack process监听端口
- name=primarySegmentReplicationPort delimiter=':' value=43013 对应primary的receiver process监听端口
也对应了使用gpinitsystem初始化数据库时指定的几个配置。
MIRROR_PORT_BASE
Optional. This specifies the base number by which mirror segment
port numbers are calculated. The first mirror segment port on a
host is set as MIRROR_PORT_BASE, and then incremented by one
for each additional mirror segment on that host. Valid values
range from 1 through 65535 and cannot conflict with the ports
calculated by PORT_BASE.
REPLICATION_PORT_BASE
Optional. This specifies the base number by which the port numbers
for the primary file replication process are calculated. The
first replication port on a host is set as REPLICATION_PORT_BASE,
and then incremented by one for each additional primary segment
on that host. Valid values range from 1 through 65535 and cannot
conflict with the ports calculated by PORT_BASE or MIRROR_PORT_BASE.
MIRROR_REPLICATION_PORT_BASE
Optional. This specifies the base number by which the port numbers
for the mirror file replication process are calculated. The first
mirror replication port on a host is set as MIRROR_REPLICATION_PORT_BASE,
and then incremented by one for each additional mirror segment on
that host. Valid values range from 1 through 65535 and cannot conflict
with the ports calculated by PORT_BASE, MIRROR_PORT_BASE,
or REPLICATION_PORT_BASE.
primary
digoal 73315 68987 0 17:59 ? 00:00:00 postgres: port 40013, primary process
digoal 73376 73315 0 17:59 ? 00:00:00 postgres: port 40013, primary receiver ack process
digoal 73381 73315 0 17:59 ? 00:00:05 postgres: port 40013, primary sender process
digoal 73387 73315 0 17:59 ? 00:00:00 postgres: port 40013, primary consumer ack process
digoal 73393 73315 0 17:59 ? 00:00:03 postgres: port 40013, primary recovery process
digoal 73400 73315 0 17:59 ? 00:00:00 postgres: port 40013, primary verification process
mirror
digoal 72906 72703 0 17:59 ? 00:00:00 postgres: port 41013, mirror process
digoal 72932 72906 0 17:59 ? 00:00:10 postgres: port 41013, mirror receiver process
digoal 72934 72906 0 17:59 ? 00:00:14 postgres: port 41013, mirror consumer process
digoal 72936 72906 0 17:59 ? 00:00:01 postgres: port 41013, mirror consumer writer process
digoal 72938 72906 0 17:59 ? 00:00:00 postgres: port 41013, mirror consumer append only process
digoal 72939 72906 0 17:59 ? 00:00:00 postgres: port 41013, mirror sender ack process
digoal 72940 72906 0 17:59 ? 00:00:00 postgres: port 41013, mirror verification process
连接是这样的。
primary sender -> mirror receiver
mirror sender ack -> primary receiver ack
查看segment的元数据信息。
postgres=# select * from gp_segment_configuration order by dbid;
dbid | content | role | preferred_role | mode | status | port | hostname | address | replication_port | san_mounts
------+---------+------+----------------+------+--------+-------+-------------------+-------------------+------------------+------------
1 | -1 | p | p | s | u | 1921 | digoal.sqa.zmf | digoal.sqa.zmf | |
2 | 0 | p | p | s | u | 40000 | digoal.sqa.zmf | digoal.sqa.zmf | 43000 |
3 | 1 | p | p | s | u | 40001 | digoal.sqa.zmf | digoal.sqa.zmf | 43001 |
4 | 2 | p | p | s | u | 40002 | digoal.sqa.zmf | digoal.sqa.zmf | 43002 |
5 | 3 | p | p | s | u | 40003 | digoal.sqa.zmf | digoal.sqa.zmf | 43003 |
6 | 4 | p | p | s | u | 40004 | digoal.sqa.zmf | digoal.sqa.zmf | 43004 |
7 | 5 | p | p | s | u | 40005 | digoal.sqa.zmf | digoal.sqa.zmf | 43005 |
8 | 6 | p | p | s | u | 40006 | digoal.sqa.zmf | digoal.sqa.zmf | 43006 |
9 | 7 | p | p | s | u | 40007 | digoal.sqa.zmf | digoal.sqa.zmf | 43007 |
10 | 8 | p | p | s | u | 40008 | digoal.sqa.zmf | digoal.sqa.zmf | 43008 |
11 | 9 | p | p | s | u | 40009 | digoal.sqa.zmf | digoal.sqa.zmf | 43009 |
12 | 10 | p | p | s | u | 40010 | digoal.sqa.zmf | digoal.sqa.zmf | 43010 |
13 | 11 | p | p | s | u | 40011 | digoal.sqa.zmf | digoal.sqa.zmf | 43011 |
14 | 12 | p | p | s | u | 40012 | digoal.sqa.zmf | digoal.sqa.zmf | 43012 |
15 | 13 | p | p | s | u | 40013 | digoal.sqa.zmf | digoal.sqa.zmf | 43013 |
16 | 14 | p | p | s | u | 40014 | digoal.sqa.zmf | digoal.sqa.zmf | 43014 |
17 | 15 | p | p | s | u | 40015 | digoal.sqa.zmf | digoal.sqa.zmf | 43015 |
18 | 16 | p | p | s | u | 40016 | digoal.sqa.zmf | digoal.sqa.zmf | 43016 |
19 | 17 | p | p | s | u | 40017 | digoal.sqa.zmf | digoal.sqa.zmf | 43017 |
20 | 18 | p | p | s | u | 40018 | digoal.sqa.zmf | digoal.sqa.zmf | 43018 |
21 | 19 | p | p | s | u | 40019 | digoal.sqa.zmf | digoal.sqa.zmf | 43019 |
22 | 20 | p | p | s | u | 40020 | digoal.sqa.zmf | digoal.sqa.zmf | 43020 |
23 | 21 | p | p | s | u | 40021 | digoal.sqa.zmf | digoal.sqa.zmf | 43021 |
24 | 22 | p | p | s | u | 50011 | digoal.sqa.zmf | digoal.sqa.zmf | 43022 |
25 | 0 | m | m | s | u | 41000 | digoal.sqa.zmf | digoal.sqa.zmf | 42000 |
26 | 1 | m | m | s | u | 41001 | digoal.sqa.zmf | digoal.sqa.zmf | 42001 |
27 | 2 | m | m | s | u | 41002 | digoal.sqa.zmf | digoal.sqa.zmf | 42002 |
28 | 3 | m | m | s | u | 41003 | digoal.sqa.zmf | digoal.sqa.zmf | 42003 |
29 | 4 | m | m | s | u | 41004 | digoal.sqa.zmf | digoal.sqa.zmf | 42004 |
30 | 5 | m | m | s | u | 41005 | digoal.sqa.zmf | digoal.sqa.zmf | 42005 |
31 | 6 | m | m | s | u | 41006 | digoal.sqa.zmf | digoal.sqa.zmf | 42006 |
32 | 7 | m | m | s | u | 41007 | digoal.sqa.zmf | digoal.sqa.zmf | 42007 |
33 | 8 | m | m | s | u | 41008 | digoal.sqa.zmf | digoal.sqa.zmf | 42008 |
34 | 9 | m | m | s | u | 41009 | digoal.sqa.zmf | digoal.sqa.zmf | 42009 |
35 | 10 | m | m | s | u | 41010 | digoal.sqa.zmf | digoal.sqa.zmf | 42010 |
36 | 11 | m | m | s | u | 41011 | digoal.sqa.zmf | digoal.sqa.zmf | 42011 |
37 | 12 | m | m | s | u | 41012 | digoal.sqa.zmf | digoal.sqa.zmf | 42012 |
38 | 13 | m | m | s | u | 41013 | digoal.sqa.zmf | digoal.sqa.zmf | 42013 |
39 | 14 | m | m | s | u | 41014 | digoal.sqa.zmf | digoal.sqa.zmf | 42014 |
40 | 15 | m | m | s | u | 41015 | digoal.sqa.zmf | digoal.sqa.zmf | 42015 |
41 | 16 | m | m | s | u | 41016 | digoal.sqa.zmf | digoal.sqa.zmf | 42016 |
42 | 17 | m | m | s | u | 41017 | digoal.sqa.zmf | digoal.sqa.zmf | 42017 |
43 | 18 | m | m | s | u | 41018 | digoal.sqa.zmf | digoal.sqa.zmf | 42018 |
44 | 19 | m | m | s | u | 41019 | digoal.sqa.zmf | digoal.sqa.zmf | 42019 |
45 | 20 | m | m | s | u | 41020 | digoal.sqa.zmf | digoal.sqa.zmf | 42020 |
46 | 21 | m | m | s | u | 41021 | digoal.sqa.zmf | digoal.sqa.zmf | 42021 |
47 | 22 | m | m | s | u | 41022 | digoal.sqa.zmf | digoal.sqa.zmf | 42022 |
(47 rows)
Greenplum 添加segment mirror节点
2015-12-17
8334
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《
阿里云开发者社区用户服务协议》和
《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写
侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：
目录
相关文章
|
运维
容灾
关系型数据库
|
SQL
Oracle
关系型数据库
xDB Replication Server - PostgreSQL, Oracle, SQL Server, PPAS 全量、增量(redo log based, or trigger based)同步（支持single-master, mult-master同步, 支持DDL）
xDB Replication Server - PostgreSQL, Oracle, SQL Server, PPAS 全量、增量(redo log based, or trigger based)同步（支持single-master, mult-master同步, 支持DDL）
931
0
0
|
SQL
网络安全
调度
Greenplum 扩展 segment个数
13769
2
10
|
关系型数据库
Greenplum 如何直连segment节点
11798
2
7
Greenplum 激活standby master
6260
2
5
Greenplum 添加或删除standby master节点
11436
2
4
|
关系型数据库
数据库
C语言
Deepgreen & Greenplum 高可用（一） - Segment节点故障转移
尚书中云：惟事事，乃其有备，有备无患。这教导我们做事一定要有准备，做事尚且如此，在企事业单位发展中处于基础地位的数据仓库软件在运行过程中，何尝不需要有备无患呢？
今天别的不表，主要来谈谈企业级数据仓库软件Deepgreen和Greenplum的高可用特性之一：计算节点镜像。
8293
0
1
Greenplum failed segment的恢复方法
7135
2
2
|
关系型数据库
PostgreSQL
SQL
GreenPlum Primary/Mirror 同步机制
5734
0
1