Pivotal ## Greenplum 6新特性: 在线扩容工具GPexpand剖析 杜佳伦 (jdu@pivotal.io) ## 大纲 • Greenplum 集群部署 • GPExpand简介与具体用法 • Greenplum 6中GPExpand的改进与实现 ## Greenplum 集群部署  

-342 规划新 Instance 的初始化..... - 343 规划 Mirror 策略..... - 344 为现有主机增加 Instance 数量..... - 344 关于 gpexpand 模式..... - 345 规划数据重分布..... - 346 管理大规模集群的数据重分布..... - 346 可用磁盘空间充足的系统..... - 347 可用磁盘空间不足的系统 初始化新 Instance..... - 358 扩容失败回退..... - 359 数据表的重分布..... - 359 调整表的重分布顺序..... - 360 使用 gpexpand 重分布数据..... - 361 监测数据重分布..... - 361 清除扩容用的模式..... - 362 第十七章：数据库的升级..... - 364 小版本升级... (gpointsystem) 启动(gpstart)或关闭GP集群(gpstop) 从集群中隔离故障的 Host 主机 (gpstop --host) 扩展 Instance 以及在新节点间重新分布 Table(gpexpand) ● 监控和恢复失败的 Instance(gpstate & gprecoverseg) 监控和恢复失败的 Master(gpstate & gpinitstandby)

input 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 Tables 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 Viewing 1978 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 Hostnames

input 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 Tables 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 Viewing 1912 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 Hostnames

input 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 113 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 Hostnames

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 Tables 1104 Ranking Tables for Redistribution 1105 Redistributing Tables Using gpexpand 1105 To redistribute tables with gpexpand 1105 Monitoring Table Redistribution 1105 Viewing Expansion Status 1106 **gpdeletesystem** 1974 Synopsis 1974 Description 1974 Options 1974 Examples 1975 See Also 1975 gpexpand 1975 Synopsis 1975 Prerequisites 1976 Description 1976 Options 1977 Specifying Hosts using

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 Ranking Tables for Redistribution 1137 Redistributing Tables Using gpexpand 1137 To redistribute tables with gpexpand 1137 Monitoring Table Redistribution 1137 Viewing Expansion Status 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 529 Expansion Input File Format 531 Running gpexpand to Initialize New Segments 532 To run gpexpand with an input file 532 Monitoring the Cluster Expansion State 532 Rolling Tables 0 Ranking Tables for Redistribution 533 Redistributing Tables Using gpexpand 534 To redistribute tables with gpexpand 534 Monitoring Table Redistribution 534 Viewing Expansion Status 534 gp_distribution_policy 0 gpexpand.expansion_progress 1598 gpexpand.expansion_progress 0 gpexpand.status 1598 gpexpand.status 0 gpexpand.status_detail 1599 gpexpand.status_detail 0 gp_fastsequence

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

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