执行gpexpand -f seghosts_add
What type of mirroring strategy would you like?
spread|grouped (default=grouped):
20191224:21:49:03:018043 gpexpand:master1:gpadmin-[ERROR]:-gpexpand failed: Expansion segment has no mirror but mirroring is enabled.
Exiting...
20191224:21:49:03:018043 gpexpand:master1:gpadmin-[INFO]:-Shutting down gpexpand...
查看gp_segment_configuration表:
发现mirror的hostname和address不一致。
在master节点上执行psql调整为相同:
set allow_system_table_mods='on';
update gp_segment_configuration set hostname='gp-node1' where hostname='xgz-szhglsjztxm-pre-greenplum-node1';
........
set allow_system_table_mods='off';
再次gpexpand -f seghosts_add成功,生成gpexpand_inputfile_20230215_194543
扩容了gp-node5和gp-node6
初始化Segment并且创建扩容schema
[gpadmin@master1 ~]$ gpexpand -i gpexpand_inputfile_20230215_194543
20230216:10:58:27:029351 gpexpand:master1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.21.0 build commit:d0087e3b24c54d203ca8bb315559205f13cd6393 Open Source'
20230216:10:58:27:029351 gpexpand:master1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.21.0 build commit:d0087e3b24c54d203ca8bb315559205f13cd6393 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 10 2022 01:57:17'
20230216:10:58:27:029351 gpexpand:master1:gpadmin-[INFO]:-Querying gpexpand schema for current expansion state
20230216:10:58:28:029351 gpexpand:master1:gpadmin-[INFO]:-Heap checksum setting consistent across cluster
20230216:10:58:28:029351 gpexpand:master1:gpadmin-[INFO]:-Syncing Greenplum Database extensions
20230216:10:58:29:029351 gpexpand:master1:gpadmin-[INFO]:-The packages on gp-node6 are consistent.
20230216:10:58:29:029351 gpexpand:master1:gpadmin-[INFO]:-The packages on gp-node5 are consistent.
20230216:10:58:30:029351 gpexpand:master1:gpadmin-[INFO]:-Locking catalog
20230216:10:58:30:029351 gpexpand:master1:gpadmin-[INFO]:-Locked catalog
20230216:10:58:30:029351 gpexpand:master1:gpadmin-[INFO]:-Creating segment template
20230216:11:00:49:029351 gpexpand:master1:gpadmin-[INFO]:-Copying postgresql.conf from existing segment into template
20230216:11:00:50:029351 gpexpand:master1:gpadmin-[INFO]:-Copying pg_hba.conf from existing segment into template
20230216:11:00:50:029351 gpexpand:master1:gpadmin-[INFO]:-Creating schema tar file
20230216:11:02:01:029351 gpexpand:master1:gpadmin-[INFO]:-Distributing template tar file to new hosts
20230216:11:04:44:029351 gpexpand:master1:gpadmin-[INFO]:-Configuring new segments (primary)
20230216:11:04:44:029351 gpexpand:master1:gpadmin-[INFO]:-{'gp-node6': '/data/greenplum-data/primary1/gpseg20:6000:true:false:39:20::-1:,/data/greenplum-data/primary2/gpseg21:6001:true:false:40:21::-1:,/data/greenplum-data/primary3/gpseg22:6002:true:false:41:22::-1:,/data/greenplum-data/primary4/gpseg23:6003:true:false:42:23::-1:', 'gp-node5': '/data/greenplum-data/primary1/gpseg16:6000:true:false:35:16::-1:,/data/greenplum-data/primary2/gpseg17:6001:true:false:36:17::-1:,/data/greenplum-data/primary3/gpseg18:6002:true:false:37:18::-1:,/data/greenplum-data/primary4/gpseg19:6003:true:false:38:19::-1:'}
20230216:11:07:01:029351 gpexpand:master1:gpadmin-[INFO]:-Cleaning up temporary template files
20230216:11:07:23:029351 gpexpand:master1:gpadmin-[INFO]:-Cleaning up databases in new segments.
20230216:11:07:33:029351 gpexpand:master1:gpadmin-[INFO]:-Unlocking catalog
20230216:11:07:33:029351 gpexpand:master1:gpadmin-[INFO]:-Unlocked catalog
20230216:11:07:33:029351 gpexpand:master1:gpadmin-[INFO]:-Creating expansion schema
20230216:11:07:34:029351 gpexpand:master1:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database template1
20230216:11:07:34:029351 gpexpand:master1:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database postgres
20230216:11:11:21:029351 gpexpand:master1:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database gpperfmon
20230216:11:11:22:029351 gpexpand:master1:gpadmin-[INFO]:-Starting new mirror segment synchronization
20230216:11:16:30:029351 gpexpand:master1:gpadmin-[INFO]:-************************************************
20230216:11:16:30:029351 gpexpand:master1:gpadmin-[INFO]:-Initialization of the system expansion complete.
20230216:11:16:30:029351 gpexpand:master1:gpadmin-[INFO]:-To begin table expansion onto the new segments
20230216:11:16:30:029351 gpexpand:master1:gpadmin-[INFO]:-rerun gpexpand
20230216:11:16:30:029351 gpexpand:master1:gpadmin-[INFO]:-************************************************
20230216:11:16:30:029351 gpexpand:master1:gpadmin-[INFO]:-Exiting...
然后做数据重分布
gpexpand -d 3:00:00