Greenplum 6新特性: 在线扩容工具GPexpand剖析 杜佳伦 (jdu@pivotal.io) 大纲 • Greenplum 集群部署 • GPExpand简介与具体用法 • Greenplum 6中GPExpand的改进与实现 Greenplum 集群部署 Greenplum 集群部署 • gp_segment_configuration 字段名 描述 dbid 分布列的操作类 GPExpand简介与具体用法 • GPExpand是Greenplum的扩容工具，可以为集群增加新的节 点来支持更大容量的存储和更高的计算能力。 • 随着Greenplum一起安装发布，在$GPHOME/bin下面，和其 他辅助工具，如gpstart,gpstop,gpactivatestandby一样，是一个 用python写的命令行脚本。 GPExpand简介与具体用法 • GPExpand工作流程 – 建立并添加新节点 – 数据重分布 GPExpand简介与具体用法 • 增加新节点 – gpexpand –i 配置文件 • 数据重分布 – gpexpand • 清理 – gpexpand -c GPExpand简介与具体用法 • 增加新节点 – gpexpand –i 配置文件（gpexpand生成或手动编辑） sdw:sdw:2543

Instance 数量 ......................................................................... - 344 - 关于 gpexpand 模式............................................................................................. ................................................................................... - 360 - 使用 gpexpand 重分布数据 ................................................................................. - 361 - 18616691889) 编写：陈淼 - 20 -  从集群中隔离故障的 Host 主机(gpstop --host)  扩展 Instance 以及在新节点间重新分布 Table(gpexpand)  监控和恢复失败的 Instance(gpstate & gprecoverseg)  监控和恢复失败的 Master(gpstate & gpinitstandby)

file in interactive mode 1133 Expansion Input File Format 1134 Running gpexpand to Initialize New Segments 1135 To run gpexpand with an input file 1135 Monitoring the Cluster Expansion State 1135 Rolling 1136 Ranking Tables for Redistribution 1137 Redistributing Tables Using gpexpand 1137 To redistribute tables with gpexpand 1137 Monitoring Table Redistribution 1137 Viewing Expansion Status 1138 gpdeletesystem 2015 Synopsis 2015 Description 2016 Options 2016 Examples 2016 See Also 2017 gpexpand 2017 Synopsis 2017 Prerequisites 2017 Description 2018 Options 2019 Specifying Hosts using

file in interactive mode 1101 Expansion Input File Format 1102 Running gpexpand to Initialize New Segments 1103 To run gpexpand with an input file 1103 Monitoring the Cluster Expansion State 1103 Rolling Redistribution 1105 Redistributing Tables Using gpexpand 1105 VMware Greenplum 6 Documentation VMware, Inc. 51 To redistribute tables with gpexpand 1105 Monitoring Table Redistribution 1105 Viewing VMware Greenplum 6 Documentation VMware, Inc. 117 Options 1974 Examples 1975 See Also 1975 gpexpand 1975 Synopsis 1975 Prerequisites 1976 Description 1976 Options 1977 Specifying Hosts using

file in interactive mode 1116 Expansion Input File Format 1118 Running gpexpand to Initialize New Segments 1119 To run gpexpand with an input file 1119 Monitoring the Cluster Expansion State 1119 Rolling 1120 Ranking Tables for Redistribution 1120 Redistributing Tables Using gpexpand 1121 To redistribute tables with gpexpand 1121 Monitoring Table Redistribution 1121 Viewing Expansion Status 1121 Options 1979 Examples 1979 See Also 1979 VMware Greenplum 6 Documentation VMware, Inc 112 gpexpand 1979 Synopsis 1979 Prerequisites 1980 Description 1981 Options 1982 Specifying Hosts using

file in interactive mode 1083 Expansion Input File Format 1084 Running gpexpand to Initialize New Segments 1085 To run gpexpand with an input file 1085 Monitoring the Cluster Expansion State 1086 Rolling 1086 Ranking Tables for Redistribution 1087 Redistributing Tables Using gpexpand 1087 To redistribute tables with gpexpand 1087 Monitoring Table Redistribution 1087 Viewing Expansion Status 1088 gpdeletesystem 1912 Synopsis 1913 Description 1913 Options 1913 Examples 1914 See Also 1914 gpexpand 1914 Synopsis 1914 Prerequisites 1914 Description 1915 Options 1916 Specifying Hosts using

file in interactive mode 1078 Expansion Input File Format 1080 Running gpexpand to Initialize New Segments 1080 To run gpexpand with an input file 1080 Monitoring the Cluster Expansion State 1081 Rolling Redistribution 1082 Redistributing Tables Using gpexpand 1082 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 49 To redistribute tables with gpexpand 1082 Monitoring Table Redistribution 1083 Viewing gpdeletesystem 1905 Synopsis 1905 Description 1905 Options 1906 Examples 1906 See Also 1906 gpexpand 1906 Synopsis 1906 Prerequisites 1907 Description 1907 Options 1908 Specifying Hosts using

input file in interactive mode 944 Expansion Input File Format 945 Running gpexpand to Initialize New Segments 946 To run gpexpand with an input file 946 Monitoring the Cluster Expansion State 947 Rolling Tables 947 Ranking Tables for Redistribution 947 Redistributing Tables Using gpexpand 948 To redistribute tables with gpexpand 948 Monitoring Table Redistribution 948 Viewing Expansion Status 948 Viewing gpdeletesystem 1683 Synopsis 1683 Description 1683 Options 1683 Examples 1684 See Also 1684 gpexpand 1684 Synopsis 1684 Prerequisites 1684 Description 1685 Options 1686 Specifying Hosts using

input file in interactive mode 606 Expansion Input File Format 608 Running gpexpand to Initialize New Segments 609 To run gpexpand with an input file 609 Monitoring the Cluster Expansion State 609 Rolling Tables 0 Ranking Tables for Redistribution 610 Redistributing Tables Using gpexpand 611 To redistribute tables with gpexpand 611 Monitoring Table Redistribution 611 Viewing Expansion Status 611 Viewing 1674 gp_distribution_policy 0 gpexpand.expansion_progress 1675 gpexpand.expansion_progress 0 gpexpand.status 1675 gpexpand.status 0 gpexpand.status_detail 1676 gpexpand.status_detail 0 VMware Greenplum

input file in interactive mode 597 Expansion Input File Format 599 Running gpexpand to Initialize New Segments 600 To run gpexpand with an input file 600 Monitoring the Cluster Expansion State 600 Rolling Tables 0 Ranking Tables for Redistribution 601 Redistributing Tables Using gpexpand 602 To redistribute tables with gpexpand 602 Monitoring Table Redistribution 602 Viewing Expansion Status 602 Viewing 1663 gp_distribution_policy 0 gpexpand.expansion_progress 1664 gpexpand.expansion_progress 0 gpexpand.status 1664 gpexpand.status 0 gpexpand.status_detail 1665 gpexpand.status_detail 0 gp_fastsequence