Greenplum4.3.3.0升级操作文档_20150907.docx

文档概述升级前注意事项：1.本文档描述的是从4.2.*升级到4.3.3.0操作过程。2.如果低于4.2.6.0版本的Greenplum数据库升级到4.3.3.0版本，需要首先升级到4.2.6.0版本，然后再升级到4.3.3.0。安装前准备检查硬件健康状态利用gpcheckperf工具检查数据库硬件的健康状况网络性能gpcheckperf -f /usr/local/greenplum-db/gpconfigs/all_hosts_single -r N -d /tmp checknetwork.out硬盘性能gpcheckperf -f /usr/local/greenplum-db/gpconfigs/all_hosts_single -r ds -D -d /data1/primary -d /data2/primary -d /data1/mirror -d /data2/mirror checkio.out检查磁盘IO的目标目录是数据库的数据文件目录，测试工具会写入系统内存的两倍大小的数据量。检查catalog健康状态/usr/local/greenplum-db/bin/lib/gpcheckcat -p 5432 -U gpadmin -P gpadmin -g /data/config/gpcheckcat.sql如果出现错误，需要运行gpcheckcat.sql修复catalog，当修复完成后重新运行gpcheckcat检查catalog。检查文件系统空间检查master和segment节点的文件系统至少2GB可用空间gpssh -f /data/config/allhosts -e df -H 查看数据库状态通过gpstate检查数据库状态是否正常gpstate整理数据库空间vacuumdb -a删除日志文件gpssh -f seg_host_file -e rm /data/*/gp*/pg_log/gpdb-2015-04*.csv恢复segment实例gprecoverseg备份数据库在数据库升级前请备份Greenplum数据库gpcrondump -x edw -G -g -a -u /data/gpdump/数据库升级操作安装Greenplum4.3.3.0软件(master节点)bash greenplum-db-4.3.3.0-build-1-RHEL5-x86_64.bin安装Greenplum4.3.3.0软件(segment节点)gpseginstall -f /data/config/all_segs删除standby mastergpinitstandby -r停止数据库gpstop -a -M fast更新master节点的/usr/local/greenplum-db目录# rm –f /usr/local/greenplum-db# ln -s /usr/local/greenplum-db-4.3.3.0 /usr/local/greenplum-db# chown -R gpadmin /usr/local/greenplum-db更新segment节点的/usr/local/greenplum-db目录# gpssh -f segment_hosts_file=rm -rf /usr/local/greenplum-db=ln -s /usr/local/greenplum-db-4.3.3.0 /usr/local/greenplum-db=chown -R gpadmin /usr/local/greenplum-db=exit检查升级gpmigrator_mirror --check-only /usr/local/greenplum-db-4.2.6.0 /usr/local/greenplum-db-4.3.3.0升级gpmigrator_mirror /usr/local/greenplum-db-4.2.6.0 /usr/local/greenplum-db-4.3.3.0设置standby mastergpinitstandby -s standby_hostname操作检查单Pre-Upgrade Preparation (on your current system)* 4.2.x.x system is up and availableLog in to your master host as the gpadmin user (your Greenplumsuperuser).(Optional) Run VACUUM on all databases(Optional) Remove old server log files from pg_