Greenplum4330升級(jí)操作文檔20150403

Greenplum數(shù)據(jù)庫(kù)升級(jí)操作手冊(cè)第8頁(yè)目錄第一章 文檔概述 2第二章 安裝前準(zhǔn)備 32.1 檢查硬件健康狀態(tài) 32.2 檢查catalog健康狀態(tài) 32.3 檢查文件系統(tǒng)空間 32.4 查看數(shù)據(jù)庫(kù)狀態(tài) 32.5 整理數(shù)據(jù)庫(kù)空間 42.6 刪除日志文件 42.7 恢復(fù)segment實(shí)例 42.8 備份數(shù)據(jù)庫(kù) 4第三章 數(shù)據(jù)庫(kù)升級(jí)操作 53.1 安裝Greenplum4.3.3.0軟件(master節(jié)點(diǎn)) 53.2 安裝Greenplum4.3.3.0軟件(segment節(jié)點(diǎn)) 53.3 刪除standbymaster 53.4 停止數(shù)據(jù)庫(kù) 53.5 更新master節(jié)點(diǎn)的/usr/local/greenplum-db目錄 53.6 更新segment節(jié)點(diǎn)的/usr/local/greenplum-db目錄 53.7 檢查升級(jí) 63.8 升級(jí) 63.9 設(shè)置standbymaster 6第四章 操作檢查單 7文檔概述本文檔描述的是從4.2.*升級(jí)到4.3.3.0操作過程。如果低于4.2.6.0版本的Greenplum數(shù)據(jù)庫(kù)升級(jí)到4.3.3.0版本，需要首先升級(jí)到4.2.6.0版本，然后再升級(jí)到4.3.3.0。安裝前準(zhǔn)備檢查硬件健康狀態(tài)利用gpcheckperf工具檢查數(shù)據(jù)庫(kù)硬件的健康狀況網(wǎng)絡(luò)性能gpcheckperf-f/usr/local/greenplum-db/gpconfigs/all_hosts_single-rN-d/tmp>checknetwork.out硬盤性能gpcheckperf-f/usr/local/greenplum-db/gpconfigs/all_hosts_single-rds-D-d/data1/primary-d/data2/primary-d/data1/mirror-d/data2/mirror>checkio.out檢查磁盤IO的目標(biāo)目錄是數(shù)據(jù)庫(kù)的數(shù)據(jù)文件目錄，測(cè)試工具會(huì)寫入系統(tǒng)內(nèi)存的兩倍大小的數(shù)據(jù)量。檢查catalog健康狀態(tài)/usr/local/greenplum-db/bin/lib/gpcheckcat-p5432-Ugpadmin-Pgpadmin-g/data/config/gpcheckcat.sql如果出現(xiàn)錯(cuò)誤，需要運(yùn)行g(shù)pcheckcat.sql修復(fù)catalog，當(dāng)修復(fù)完成后重新運(yùn)行g(shù)pcheckcat檢查catalog。檢查文件系統(tǒng)空間檢查master和segment節(jié)點(diǎn)的文件系統(tǒng)至少2GB可用空間gpssh-f/data/config/allhosts-e'df-H'查看數(shù)據(jù)庫(kù)狀態(tài)通過gpstate檢查數(shù)據(jù)庫(kù)狀態(tài)是否正常gpstate整理數(shù)據(jù)庫(kù)空間vacuumdb-a刪除日志文件gpssh-fseg_host_file-e'rm/data/*/gp*/pg_log/gpdb-2015-04*.csv'恢復(fù)segment實(shí)例gprecoverseg備份數(shù)據(jù)庫(kù)在數(shù)據(jù)庫(kù)升級(jí)前請(qǐng)備份Greenplum數(shù)據(jù)庫(kù)gpcrondump-xedw-G-g-a-u/data/gpdump/數(shù)據(jù)庫(kù)升級(jí)操作安裝Greenplum4.3.3.0軟件(master節(jié)點(diǎn))bashgreenplum-db-4.3.3.0-build-1-RHEL5-x86_64.bin安裝Greenplum4.3.3.0軟件(segment節(jié)點(diǎn))gpseginstall-f/data/config/all_segs刪除standbymastergpinitstandby-r停止數(shù)據(jù)庫(kù)gpstop-a-Mfast更新master節(jié)點(diǎn)的/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-Rgpadmin/usr/local/greenplum-db更新segment節(jié)點(diǎn)的/usr/local/greenplum-db目錄#gpssh-fsegment_hosts_file=>rm-rf/usr/local/greenplum-db=>ln-s/usr/local/greenplum-db-4.3.3.0/usr/local/greenplum-db=>chown-Rgpadmin/usr/local/greenplum-db=>exit檢查升級(jí)gpmigrator_mirror--check-only/usr/local/greenplum-db-4.2.6.0/usr/local/greenplum-db-4.3.3.0升級(jí)gpmigrator_mirror/usr/local/greenplum-db-4.2.6.0/usr/local/greenplum-db-4.3.3.0設(shè)置standbymastergpinitstandby-sstandby_hostname操作檢查單Pre-UpgradePreparation(onyourcurrentsystem)*4.2.x.xsystemisupandavailableLogintoyourmasterhostasthegpadminuser(yourGreenplumsuperuser).(Optional)RunVACUUMonalldatabases(Optional)Removeoldserverlogfilesfrompg_loginyourmasterandsegmentdatadirectoriesCheckforandrecoveranyfailedsegments(gpstate,gprecoverseg)Copyorpreserveanyadditionalfoldersorfiles(suchasbackupfolders)InstalltheGreenplumDatabase4.3binariesonallGreenplumhostsInformalldatabaseusersoftheupgradeandlockouttimeframeUpgradeExecution*ThesystemwillbelockeddowntoalluseractivityduringtheupgradeprocessBackupyourcurrentdatabasesRemovethestandbymaster(gpinitstandby-r)Doacleanshutdownofyourcurrentsystem(gpstop)UpdateyourenvironmenttosourcethenewGreenplumDatabase4.3.3installation.Runtheupgradeutility(gpmigrator_mirrorifyouhavemirrors,gpmigratorifyoudonot)Aftertheupgradeprocessfinishessuccessfully,your4.3.3systemwillbeupandrunningPost-Upgrade(onyour4.3system)*The4.2.x.xsystemisupReinitializeyourstandbymasterhost(gpinitstandby).UpgradegpfdistonallofyourETLhostsRebuildanycustommodulesagainstyour4.3.3