Gaussdb T 分布式集群升級示例

Gaussdb T分布式集群可通過gs_upgradectl對數(shù)據(jù)庫進(jìn)行離線版本升級，本文演示將數(shù)據(jù)庫從GaussDB_100_1.0.0.B019 Release 0b7bb43升級至GaussDB_100_1.0.1.SPC2.B003 Release 3ae9d6c的整個(gè)過程。

1.gs_upgradectl命令幫助

[omm@gaussdb1?script]$?which?gs_upgradectl /gaussdb/gaussTools/wisequery/script/gs_upgradectl [omm@gaussdb1?script]$?gs_upgradectl??--help gs_upgradectl?is?a?utility?to?upgrade?a?cluster. Usage: ??gs_upgradectl?-??|?--help ??gs_upgradectl?-V?|?--version ??gs_upgradectl?-t?upgrade-type?-X?XMLFILE?[-l?LOGFILE] ??gs_upgradectl?-t?offline-upgrade?-X?XMLFILE?[-l?LOGFILE] ??gs_upgradectl?-t?offline-rollback?-X?XMLFILE?[-l?LOGFILE] General?options: ??-?,?--help??????????????????????Show?help?information?for?this?utility,?and?exit?the?command?line?mode. ??-V,?--version???????????????????Show?version?information. ??-t??????????????????????????????Subcommand?for?upgrade.?It?can?be?upgrade-type, ??????????????????????????????????offline-upgrade,?offline-rollback. ??-X??????????????????????????????Path?of?the?XML?configuration?file?of?the?later?version?cluster. ??-l??????????????????????????????Path?of?log?file. ???????? [omm@gaussdb1?script]$

參數(shù)解釋：

-X?集群配置文件 -l?日志文件 -t?升級類型，其中upgrade-type為判斷本次升級類型，systable-upgrade為離線小版本升級,binary-upgrade為離線二進(jìn)制升級。

2.升級前信息收集

[omm@gaussdb1?script]$?gs_om?-t?status Set?output?to?terminal. --------------------------------------------------------------------Cluster?Status-------------------------------------------------------------------- az_state?:??????single_az cluster_state?:?Normal balanced?:??????true ----------------------------------------------------------------------AZ?Status----------------------------------------------------------------------- AZ:AZ1????????????????ROLE:primary????????????STATUS:ONLINE?????? ---------------------------------------------------------------------Host?Status---------------------------------------------------------------------- HOST:gaussdb1?????????AZ:AZ1??????????????????STATUS:ONLINE???????IP:10.111.76.22 HOST:gaussdb2?????????AZ:AZ1??????????????????STATUS:ONLINE???????IP:10.111.76.23 HOST:gaussdb3?????????AZ:AZ1??????????????????STATUS:ONLINE???????IP:10.111.76.24 HOST:gaussdb4?????????AZ:AZ1??????????????????STATUS:ONLINE???????IP:10.111.76.25 ----------------------------------------------------------------Cluster?Manager?Status---------------------------------------------------------------- INSTANCE:CM1??????????ROLE:primary????????????STATUS:ONLINE???????HOST:gaussdb1?????????ID:601 INSTANCE:CM2??????????ROLE:slave??????????????STATUS:ONLINE???????HOST:gaussdb2?????????ID:602 ---------------------------------------------------------------------ETCD?Status---------------------------------------------------------------------- INSTANCE:ETCD1????????ROLE:follower???????????STATUS:ONLINE???????HOST:gaussdb1?????????ID:701??????PORT:2379?????????DataDir:/gaussdb/data/etcd/data_etcd1 INSTANCE:ETCD2????????ROLE:leader?????????????STATUS:ONLINE???????HOST:gaussdb2?????????ID:702??????PORT:2379?????????DataDir:/gaussdb/data/etcd/data_etcd1 INSTANCE:ETCD3????????ROLE:follower???????????STATUS:ONLINE???????HOST:gaussdb3?????????ID:703??????PORT:2379?????????DataDir:/gaussdb/data/etcd/data_etcd1 ----------------------------------------------------------------------CN?Status----------------------------------------------------------------------- INSTANCE:cn_401???????ROLE:no?role????????????STATUS:ONLINE???????HOST:gaussdb1?????????ID:401??????PORT:8000?????????DataDir:/gaussdb/data/cn INSTANCE:cn_402???????ROLE:no?role????????????STATUS:ONLINE???????HOST:gaussdb2?????????ID:402??????PORT:8000?????????DataDir:/gaussdb/data/cn INSTANCE:cn_403???????ROLE:no?role????????????STATUS:ONLINE???????HOST:gaussdb3?????????ID:403??????PORT:8000?????????DataDir:/gaussdb/data/cn INSTANCE:cn_404???????ROLE:no?role????????????STATUS:ONLINE???????HOST:gaussdb4?????????ID:404??????PORT:8000?????????DataDir:/gaussdb/data/cn ---------------------------------------------------------Instances?Status?in?Group?(group_1)---------------------------------------------------------- INSTANCE:DB1_1????????ROLE:primary????????????STATUS:ONLINE???????HOST:gaussdb1?????????ID:1????????PORT:4000?????????DataDir:/gaussdb/data/dn1 INSTANCE:DB1_2????????ROLE:standby????????????STATUS:ONLINE???????HOST:gaussdb2?????????ID:2????????PORT:4000?????????DataDir:/gaussdb/data/dn1 ---------------------------------------------------------Instances?Status?in?Group?(group_2)---------------------------------------------------------- INSTANCE:DB2_3????????ROLE:primary????????????STATUS:ONLINE???????HOST:gaussdb3?????????ID:3????????PORT:4000?????????DataDir:/gaussdb/data/dn3 INSTANCE:DB2_4????????ROLE:standby????????????STATUS:ONLINE???????HOST:gaussdb4?????????ID:4????????PORT:4000?????????DataDir:/gaussdb/data/dn3 --------------------------------------------------Manage?IP-------------------------------------------------- HOST:gaussdb1?????????IP:10.111.76.22 HOST:gaussdb2?????????IP:10.111.76.23 HOST:gaussdb3?????????IP:10.111.76.24 HOST:gaussdb4?????????IP:10.111.76.25 [omm@gaussdb1?script]$

SQL>?select?*?from?v$version; VERSION????????????????????????????????????????????????????????? ---------------------------------------------------------------- GaussDB_100_1.0.0.B019?Release?0b7bb43?????????????????????????? ZENGINE????????????????????????????????????????????????????????? 0b7bb43????????????????????????????????????????????????????????? 3?rows?fetched.

[omm@gaussdb1?script]$?zsql?/?as?sysdba?10.111.76.22:4000?-D?/gaussdb/data/dn1 Warning:?SSL?connection?to?server?without?CA?certificate?is?insecure.?Continue?anyway??(y/n):y connected. SQL>?SELECT?LOCAL_LFN,?PEER_LFN?FROM?DV_HA_SYNC_INFO;? LOCAL_LFN????????????PEER_LFN???????????? --------------------?-------------------- 1646?????????????????1646???????????????? 1?rows?fetched. SQL>? [omm@gaussdb3?~]$?zsql?/?as?sysdba?10.111.76.24:4000?-D?/gaussdb/data/dn3?-q connected. SQL>?SELECT?LOCAL_LFN,?PEER_LFN?FROM?DV_HA_SYNC_INFO;? LOCAL_LFN????????????PEER_LFN???????????? --------------------?-------------------- 1631?????????????????1631???????????????? 1?rows?fetched. SQL>

3.新版本介質(zhì)準(zhǔn)備

[root@gaussdb1?script]#?mkdir?-p?/opt/software/upgrade [root@gaussdb1?upgrade]#?tar?-zxvf?../1.0.1/GaussDB_100_1.0.1-CLUSTER-REDHAT7.5-64bit.tar.gz [root@gaussdb1?upgrade]#?ls?-lrt total?54476 drwx------?6?omm?dbgrp?????4096?Dec?14?11:40?script drwx------?7?omm?dbgrp??????196?Dec?14?11:40?lib -rwx------?1?omm?dbgrp??8038086?Dec?14?11:43?GaussDB_100_1.0.1-DATABASE-REDHAT-64bit.tar.gz -rwx------?1?omm?dbgrp???128240?Dec?14?11:46?GaussDB_100_1.0.1-ROACH-REDHAT-64bit.tar.gz -rwx------?1?omm?dbgrp?47604191?Dec?14?11:46?GaussDB_100_1.0.1-CM-REDHAT-64bit.tar.gz drwx------?5?omm?dbgrp???????49?Dec?14?11:46?shardingscript [root@gaussdb1?script]#?cp?/opt/soft/GaussDB_100-Upgrade-WhiteList.txt?/gaussdb/gaussTools/wisequery [root@gaussdb1?script]#

4.升級前檢查磁盤空間

Gaussdb T升級前會(huì)對數(shù)據(jù)庫進(jìn)行備份，請確?？臻e空間足夠。

[omm@gaussdb1?script]$??df?-lh?/gaussdb Filesystem???????????????????Size??Used?Avail?Use%?Mounted?on /dev/mapper/vg_data-lv_data??150G???42G??109G??28%?/gaussdb [omm@gaussdb1?script]$? [omm@gaussdb2?~]$??df?-lh?/gaussdb Filesystem???????????????????Size??Used?Avail?Use%?Mounted?on /dev/mapper/vg_data-lv_data??150G???42G??109G??28%?/gaussdb [omm@gaussdb2?~]$? [omm@gaussdb3?~]$??df?-lh?/gaussdb Filesystem???????????????????Size??Used?Avail?Use%?Mounted?on /dev/mapper/vg_data-lv_data??150G???42G??109G??28%?/gaussdb [omm@gaussdb3?~]$ [omm@gaussdb4?~]$?df?-lh?/gaussdb/ Filesystem???????????????????Size??Used?Avail?Use%?Mounted?on /dev/mapper/vg_data-lv_data??150G???42G??109G??28%?/gaussdb [omm@gaussdb4?~]$

5.升級前置檢查

cd?/opt/software/upgrade/script ./gs_preinstall?-U?omm?-G?dbgrp??-X?/opt/clusterconfig.xml??--alarm-type=1?--operation=upgrade

檢查日志

[root@gaussdb1?script]#?./gs_preinstall?-U?omm?-G?dbgrp??-X?/opt/clusterconfig.xml??--alarm-type=1?--operation=upgrade Parsing?the?configuration?file. Successfully?parsed?the?configuration?file. Do?preinstall?for?upgrade. Check?environment?for?upgrade?preinstall. Successfully?check?environment?for?upgrade?preinstall. Installing?the?tools?on?the?local?node. Successfully?installed?the?tools?on?the?local?node. Distributing?package. Successfully?distributed?package. Check?old?environment?on?all?nodes. Successfully?check?old?environment?on?all?nodes. Installing?the?tools?in?the?cluster. Successfully?installed?the?tools?in?the?cluster. Fixing?server?package?owner. Successfully?fixed?server?package?owner. Preinstallation?succeeded.

6.檢查升級類型

systable-upgrade為離線小版本升級,binary-upgrade為離線二進(jìn)制升級。本次升級為離線小版本升級。

[omm@gaussdb1?script]$?gs_upgradectl?-t?upgrade-type?-X?/opt/clusterconfig.xml Checking?upgrade?type. Successfully?checked?upgrade?type. Upgrade?type:?systable-upgrade. [omm@gaussdb1?script]$

7.正式升級

升級命令

gs_upgradectl?-t?offline-upgrade?-X?/opt/clusterconfig.xml

升級日志

[omm@gaussdb1?script]$?gs_upgradectl?-t?offline-upgrade?-X?/opt/clusterconfig.xml Performing?systable-upgrade. Checking?cluster?health. Successfully?checked?cluster?health. Checking?database?status. Successfully?checked?database?status. Checking?space?for?backup?files. Successfully?checked?space?for?backup?files. Change?the?primary?dn?and?cn?to?read?only?status. Successfully?changed?the?primary?dn?and?cn?to?read?only?status. Checking?database?read?only?status. Successfully?checked?database?read?only?status. Checking?sync?info?for?dns. Successfully?checking?sync?info?for?dns. Generating?upgrade?sql?file. Successfully?generated?upgrade?sql?file. Generating?combined?upgrade?sql?file. Successfully?generated?combined?upgrade?sql?file. Backing?up?current?application?and?configurations. Successfully?backed?up?current?application?and?configurations. Saving?system?tabls?path. Successfully?saved?system?tables?path. Saving?redo?log?file?path. Successfully?saved?redolog?file?path. Saving?undo?log?file?path. Successfully?saved?redolog?file?path. Stopping?the?cluster. Successfully?stopped?the?cluster. Stopping?the?etcd?and?agent. Successfully?stopped?the?etcd?and?agent. Starting?all?dns?to?open?status?for?backuping?system?cntl?and?redolog. Successfully?started?all?dns?to?open?status?for?backuping?system?cntl?and?redolog. Backing?up?current?system?tables. Successfully?backed?up?system?tables. Backing?up?current?cntl?files. Successfully?backed?up?cntl?files. Backing?up?current?redolog?files. Successfully?backed?up?redolog?files. Backing?up?current?undolog?files. Successfully?backed?up?undolog?files. Shutdowning?all?dns?for?backuping?system?cntl?and?redolog. Successfully?shutdown?all?dns?for?backuping?system?cntl?and?redolog. Upgrading?application. Successfully?upgraded?application. Starting?the?restrict?mode?cluster. Successfully?started?the?restrict?mode?cluster. Upgrading?the?system?table Successfully?upgraded?the?system?table Shutting?down?the?restrict?mode?cluster Successfully?shut?down?the?restrict?mode?cluster Starting?the?cns,?dns?to?open?status. Successfully?started?the?cns,?dns?to?open?status. Converting?the?cns,?primary?dns?to?read?write?status. Successfully?converted?the?cns,?primary?dns?to?read?write?status. Shutting?down?the?open?status?cns,?dns. Successfully?shutted?down?the?open?status?cns,?dns. Starting?the?etcd. Successfully?started?the?etcd. Loading?the?json. Successfully?loaded?the?json. Starting?cm?agent. Successfully?started?cm?agent. Starting?the?cluster. Successfully?started?the?cluster. Commit?systable-upgrade?succeeded. Time?for?"UpgradeCheck"?:?29.9917?seconds Time?for?"UpgradeBackup"?:?23.663?seconds Time?for?"UpgradeStopCluster"?:?25.9406?seconds Time?for?"UpgradeBackupSysCntlRedo"?:?1125.6257?seconds Time?for?"Upgrade"?:?9.7374?seconds Time?for?"KernelUpgrade"?:?135.4509?seconds Time?for?"ShutdownRestrict"?:?15.1444?seconds Time?for?"StartOpen"?:?20.6434?seconds Time?for?"ConvertReadWrite"?:?15.1271?seconds Time?for?"ShutdownOpen"?:?10.156?seconds Time?for?"SystemTable"?:?310.5378?seconds Time?for?"UpgradeStartCluster"?:?45.6341?seconds Time?for?"Total"?:?1614.5994?seconds [omm@gaussdb1?script]$

8.升級成功后驗(yàn)證

集群狀態(tài)

[omm@gaussdb1?script]$?gs_om?-t?status Set?output?to?terminal. --------------------------------------------------------------------Cluster?Status-------------------------------------------------------------------- az_state?:??????single_az cluster_state?:?Normal balanced?:??????true ----------------------------------------------------------------------AZ?Status----------------------------------------------------------------------- AZ:AZ1????????????????ROLE:primary????????????STATUS:ONLINE?????? ---------------------------------------------------------------------Host?Status---------------------------------------------------------------------- HOST:gaussdb1?????????AZ:AZ1??????????????????STATUS:ONLINE???????IP:10.111.76.22 HOST:gaussdb2?????????AZ:AZ1??????????????????STATUS:ONLINE???????IP:10.111.76.23 HOST:gaussdb3?????????AZ:AZ1??????????????????STATUS:ONLINE???????IP:10.111.76.24 HOST:gaussdb4?????????AZ:AZ1??????????????????STATUS:ONLINE???????IP:10.111.76.25 ----------------------------------------------------------------Cluster?Manager?Status---------------------------------------------------------------- INSTANCE:CM1??????????ROLE:primary????????????STATUS:ONLINE???????HOST:gaussdb1?????????ID:601 INSTANCE:CM2??????????ROLE:slave??????????????STATUS:ONLINE???????HOST:gaussdb2?????????ID:602 ---------------------------------------------------------------------ETCD?Status---------------------------------------------------------------------- INSTANCE:ETCD1????????ROLE:follower???????????STATUS:ONLINE???????HOST:gaussdb1?????????ID:701??????PORT:2379?????????DataDir:/gaussdb/data/etcd/data_etcd1 INSTANCE:ETCD2????????ROLE:leader?????????????STATUS:ONLINE???????HOST:gaussdb2?????????ID:702??????PORT:2379?????????DataDir:/gaussdb/data/etcd/data_etcd1 INSTANCE:ETCD3????????ROLE:follower???????????STATUS:ONLINE???????HOST:gaussdb3?????????ID:703??????PORT:2379?????????DataDir:/gaussdb/data/etcd/data_etcd1 ----------------------------------------------------------------------CN?Status----------------------------------------------------------------------- INSTANCE:cn_401???????ROLE:no?role????????????STATUS:ONLINE???????HOST:gaussdb1?????????ID:401??????PORT:8000?????????DataDir:/gaussdb/data/cn INSTANCE:cn_402???????ROLE:no?role????????????STATUS:ONLINE???????HOST:gaussdb2?????????ID:402??????PORT:8000?????????DataDir:/gaussdb/data/cn INSTANCE:cn_403???????ROLE:no?role????????????STATUS:ONLINE???????HOST:gaussdb3?????????ID:403??????PORT:8000?????????DataDir:/gaussdb/data/cn INSTANCE:cn_404???????ROLE:no?role????????????STATUS:ONLINE???????HOST:gaussdb4?????????ID:404??????PORT:8000?????????DataDir:/gaussdb/data/cn ---------------------------------------------------------Instances?Status?in?Group?(group_1)---------------------------------------------------------- INSTANCE:DB1_1????????ROLE:primary????????????STATUS:ONLINE???????HOST:gaussdb1?????????ID:1????????PORT:4000?????????DataDir:/gaussdb/data/dn1 INSTANCE:DB1_2????????ROLE:standby????????????STATUS:ONLINE???????HOST:gaussdb2?????????ID:2????????PORT:4000?????????DataDir:/gaussdb/data/dn1 ---------------------------------------------------------Instances?Status?in?Group?(group_2)---------------------------------------------------------- INSTANCE:DB2_3????????ROLE:primary????????????STATUS:ONLINE???????HOST:gaussdb3?????????ID:3????????PORT:4000?????????DataDir:/gaussdb/data/dn3 INSTANCE:DB2_4????????ROLE:standby????????????STATUS:ONLINE???????HOST:gaussdb4?????????ID:4????????PORT:4000?????????DataDir:/gaussdb/data/dn3 -----------------------------------------------------------------------Manage?IP---------------------------------------------------------------------- HOST:gaussdb1?????????IP:10.111.76.22 HOST:gaussdb2?????????IP:10.111.76.23 HOST:gaussdb3?????????IP:10.111.76.24 HOST:gaussdb4?????????IP:10.111.76.25 -------------------------------------------------------------------Query?Action?Info------------------------------------------------------------------ HOSTNAME:?gaussdb1?????TIME:?2020-02-06?12:04:50.821710 ------------------------------------------------------------------------Float?Ip------------------------------------------------------------------ HOST:gaussdb3????DB2_3:10.111.76.24????IP: HOST:gaussdb1????DB1_1:10.111.76.22????IP: [omm@gaussdb1?script]$

版本信息

SQL>?select?*?from?v$version; VERSION????????????????????????????????????????????????????????? ---------------------------------------------------------------- GaussDB_100_1.0.1.SPC2.B003?Release?3ae9d6c????????????????????? ZENGINE????????????????????????????????????????????????????????? 3ae9d6c????????????????????????????????????????????????????????? 3?rows?fetched. SQL>

至此，成功將Gaussdb T從1.0.0升級至1.0.1.

轉(zhuǎn)自墨天輪

數(shù)據(jù)庫 GaussDB

版權(quán)聲明：本文內(nèi)容由網(wǎng)絡(luò)用戶投稿，版權(quán)歸原作者所有，本站不擁有其著作權(quán)，亦不承擔(dān)相應(yīng)法律責(zé)任。如果您發(fā)現(xiàn)本站中有涉嫌抄襲或描述失實(shí)的內(nèi)容，請聯(lián)系我們jiasou666@gmail.com 處理，核實(shí)后本網(wǎng)站將在24小時(shí)內(nèi)刪除侵權(quán)內(nèi)容。

版權(quán)聲明：本文內(nèi)容由網(wǎng)絡(luò)用戶投稿，版權(quán)歸原作者所有，本站不擁有其著作權(quán)，亦不承擔(dān)相應(yīng)法律責(zé)任。如果您發(fā)現(xiàn)本站中有涉嫌抄襲或描述失實(shí)的內(nèi)容，請聯(lián)系我們jiasou666@gmail.com 處理，核實(shí)后本網(wǎng)站將在24小時(shí)內(nèi)刪除侵權(quán)內(nèi)容。