鲲鹏论坛

主库：

192.168.6.201 ccf10

备库：

192.168.6.202 ccf11

级联备库：

192.168.6.203 ccf12

一、升级前准备及检查：

1.升级前尽可能保证数据库正常且主DN的数据完全同步到备DN。

可以通过gs_om -t status查询，查询结果的cluster_state为Normal代表数据库正常

[omm@ccf10 ~]$ gs_om -t status

-----------------------------------------------------------------------

cluster_state             : Normal

redistributing            : No

balanced                  : Yes

-----------------------------------------------------------------------

[omm@ccf10 ~]$ cm_ctl query -Cv

[ CMServer State   ]

node     instance state

-------------------------

1 ccf10 1        Primary

2 ccf11 2        Standby

3 ccf12 3        Standby

[   Cluster State   ]

cluster_state   : Normal

redistributing : No

balanced        : Yes

current_az      : AZ_ALL

[ Datanode State   ]

node     instance state            | node     instance state            | node     instance state

---------------------------------------------------------------------------------------------------------------

1 ccf10 6001     P Primary Normal | 2 ccf11 6002     S Standby Normal | 3 ccf12 6003     C Cascade Standby Normal

[omm@ccf11 ~]$ gs_ctl query

[2022-11-09 09:31:49.461][11846][][gs_ctl]: gs_ctl query ,datadir is /data/openGauss

HA state:

        local_role                     : Standby

        static_connections             : 2

        db_state                       : Normal

        detail_information             : Normal

Senders info:

        sender_pid                     : 3432

        local_role                     : Standby

        peer_role                      : Cascade Standby

        peer_state                     : Normal

        state                          : Streaming

        sender_sent_location           : 0/7011988

        sender_write_location          : 0/7011988

        sender_flush_location          : 0/7011988

        sender_replay_location         : 0/7011988

        receiver_received_location     : 0/7011988

        receiver_write_location        : 0/7011988

        receiver_flush_location        : 0/7011988

        receiver_replay_location       : 0/7011988

        sync_percent                   : 100%

        sync_state                     : Async

        sync_priority                  : 0

        sync_most_available            : Off

        channel                        : 192.168.6.202:15401-->192.168.6.203:35120

Receiver info:

        receiver_pid                   : 3203

        local_role                     : Standby

        peer_role                      : Primary

        peer_state                     : Normal

        state                          : Normal

        sender_sent_location           : 0/7011988

        sender_write_location          : 0/7011988

        sender_flush_location          : 0/7011988

        sender_replay_location         : 0/7011988

        receiver_received_location     : 0/7011988

        receiver_write_location        : 0/7011988

        receiver_flush_location        : 0/7011988

        receiver_replay_location       : 0/7011988

        sync_percent                   : 100%

        channel                        : 192.168.6.202:43524<--192.168.6.201:15401

[omm@ccf11 ~]$

2.升级前要保证操作系统处于健康状态，通过gs_checkos工具可以完成操作系统状态检查。

[root@ccf10 ~]# gs_checkos -i A

Checking items:

    A1. [ OS version status ]                                   : Normal

    A2. [ Kernel version status ]                               : Normal

    A3. [ Unicode status ]                                      : Normal

    A4. [ Time zone status ]                                    : Normal

    A5. [ Swap memory status ]                                  : Normal

    A6. [ System control parameters status ]                    : Normal

    A7. [ File system configuration status ]                    : Normal

    A8. [ Disk configuration status ]                           : Normal

    A9. [ Pre-read block size status ]                          : Normal

    A10.[ IO scheduler status ]                                 : Normal

BondMode Null

    A11.[ Network card configuration status ]                   : Warning

    A12.[ Time consistency status ]                             : Warning

    A13.[ Firewall service status ]                             : Normal

    A14.[ THP service status ]                                  : Normal

Total numbers:14. Abnormal numbers:0. Warning numbers:2.

[root@ccf10 ~]#

3.升级需要guc参数enable_stream_replication=on，该参数为off时不允许升级。

检查该参数

[omm@ccf11 ~]$ gs_guc check -N all -I all -c "enable_stream_replication"

设置该参数

[omm@ccf11 ~]$ gs_guc set -N all -I all -c "enable_stream_replication=on"

4.opengauss共享存储模式不支持版本升级。

5.升级前保证数据库互信正常

6.PL/Java升级约束

从3.0.0及其之前版本升级到3.1.0及其后续版本时，如果业务使用PL/Java功能且数据库实例所在机器上不存在java环境时，升级前check检查将失败。因此需提前确认是否使用到PL/Java功能和当前的JAVA版本。检查方法为：

1）在数据库中使用初始化用户执行“select count(1) from pg_proc where prolang = 15;”命令。

如果结果> 0，说明数据库使用了PL/Java，参考2进一步检查是否有Java环境。

如果结果= 0，说明数据库没有使用PL/Java。则结束本校验，执行其他校验流程。

2）在操作系统中使用root用户执行“java -version”命令。

java -version

如果Java存在，且版本等于或高于JDK1.8，则结束本校验，执行其他校验流程。

如果Java不存在或版本低于JDK1.8，则需要参考3进行JDK的下载及Java环境变量的配置。

3）JDK的下载及Java环境变量的配置。

可从官网下载或者使用此链接下载：https://www.hikunpeng.com/zh/developer/devkit/compiler/jdk，并通过以下方式配置环境变量：

export JAVA_HOME=/xxx/jdk1.xxx

export PATH=$JAVA_HOME/bin:$PATH

export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar

7.检查数据库节点磁盘使用率

建议数据库节点磁盘使用率低于80%时再执行升级操作

[omm@ccf10 ~]$ df -h

Filesystem Size Used Avail Use% Mounted on

devtmpfs 2.3G 0 2.3G 0% /dev

tmpfs 2.3G 12K 2.3G 1% /dev/shm

tmpfs 2.3G 9.2M 2.3G 1% /run

tmpfs 2.3G 0 2.3G 0% /sys/fs/cgroup

/dev/mapper/klas-root 46G 12G 34G 26% /

tmpfs 2.3G 12K 2.3G 1% /tmp

/dev/sda1 1014M 211M 804M 21% /boot

tmpfs 468M 0 468M 0% /run/user/1000

tmpfs 468M 0 468M 0% /run/user/993

tmpfs 468M 0 468M 0% /run/user/0

[omm@ccf10 ~]$

8.备份数据

gs_backup -t backup --backup-dir=/data/backup --all

可在升级前自己先建个表，验证升级后是不是正常。

mydb=# select * from chen01;

-----

111

(1 row)

9.获取升级包openGauss-3.1.0-openEuler-64bit-all.tar.gz

https://www.opengauss.org/zh/download/

10.检查gsql版本

[omm@ccf10 ~]$ gsql --version

gsql (openGauss 3.0.0 build 02c14696) compiled at 2022-04-01 18:12:19 commit 0 last mr

[omm@ccf10 ~]$

二、就地升级和灰度升级操作步骤

以root身份登录节点。

创建新包目录。

mkdir -p /opt/software/gaussdb_upgrade

将需要更新的新包上传至目录“/opt/software/gaussdb_upgrade”并解压。

cd /opt/software/gaussdb_upgrade

tar -zxvf openGauss-3.1.0-openEuler-64bit-all.tar.gz

tar -zxvf openGauss-3.1.0-openEuler-64bit-om.tar.gz

进入安装包解压出的script目录下:

cd /opt/software/gaussdb_upgrade/script

在就地升级或灰度升级前执行前置脚本gs_preinstall。

./gs_preinstall -U omm -G dbgrp -X /home/omm/cluster_config.xml

[root@ccf10 script]# ./gs_preinstall -U omm -G dbgrp -X /home/omm/cluster_config.xml

Warnging version of python doesnot meet the expection, maybe third-party libs need to be compiled by yourself

Warnging version of python doesnot meet the expection, maybe third-party libs need to be compiled by yourself

Parsing the configuration file.

Successfully parsed the configuration file.

Installing the tools on the local node.

Successfully installed the tools on the local node.

Are you sure you want to create trust for root (yes/no)?yes

Please enter password for root

Password:

Successfully created SSH trust for the root permission user.

Setting host ip env

Successfully set host ip env.

Distributing package.

Begin to distribute package to tool path.

Successfully distribute package to tool path.

Begin to distribute package to package path.

Successfully distribute package to package path.

Successfully distributed package.

Are you sure you want to create the user[omm] and create trust for it (yes/no)? yes

Preparing SSH service.

Successfully prepared SSH service.

Installing the tools in the cluster.

Successfully installed the tools in the cluster.

Checking hostname mapping.

Successfully checked hostname mapping.

Creating SSH trust for [omm] user.

Please enter password for current user[omm].

Password:

Checking network information.

All nodes in the network are Normal.

Successfully checked network information.

Creating SSH trust.

Creating the local key file.

Successfully created the local key files.

Appending local ID to authorized_keys.

Successfully appended local ID to authorized_keys.

Updating the known_hosts file.

Successfully updated the known_hosts file.

Appending authorized_key on the remote node.

Successfully appended authorized_key on all remote node.

Checking common authentication file content.

Successfully checked common authentication content.

Distributing SSH trust file to all node.

Distributing trust keys file to all node successfully.

Successfully distributed SSH trust file to all node.

Verifying SSH trust on all hosts.

Successfully verified SSH trust on all hosts.

Successfully created SSH trust.

Successfully created SSH trust for [omm] user.

Checking OS software.

Successfully check os software.

Checking OS version.

Successfully checked OS version.

Creating cluster's path.

Successfully created cluster's path.

Set and check OS parameter.

Setting OS parameters.

Successfully set OS parameters.

Warning: Installation environment contains some warning messages.

Please get more details by "/opt/software/gaussdb_upgrade/script/gs_checkos -i A -h ccf10,ccf11,ccf12 --detail".

Set and check OS parameter completed.

Preparing CRON service.

Successfully prepared CRON service.

Setting user environmental variables.

Successfully set user environmental variables.

Setting the dynamic link library.

Successfully set the dynamic link library.

Setting Core file

Successfully set core path.

Setting pssh path

Successfully set pssh path.

Setting Cgroup.

Successfully set Cgroup.

Set ARM Optimization.

No need to set ARM Optimization.

Fixing server package owner.

Setting finish flag.

Successfully set finish flag.

Preinstallation succeeded.

chmod -R 755 /opt/software/gaussdb_upgrade/

chown -R omm:dbgrp /opt/software/gaussdb_upgrade/

切换至omm用户。此时gs_om -V查看已变成3.1.0 gs_ssh -c "gsql -V"查看还未发生变化3.0.0

su - omm

数据库状态正常时，使用如下命令进行就地升级或者灰度升级。

示例一：使用gs_upgradectl脚本执行就地升级。

/opt/software/gaussdb_upgrade/script/gs_upgradectl -t auto-upgrade -X /home/omm/cluster_config.xml

示例二：使用gs_upgradectl脚本执行灰度升级。

/opt/software/gaussdb_upgrade/script/gs_upgradectl -t auto-upgrade -X /home/omm/cluster_config.xml --grey

[omm@ccf10 ~]$ /opt/software/gaussdb_upgrade/script/gs_upgradectl -t auto-upgrade -X /home/omm/cluster_config.xml --grey

Static configuration matched with old static configuration files.

Successfully set upgrade_mode to 0.

Checking upgrade environment.

Successfully checked upgrade environment.

Start to do health check.

Successfully checked cluster status.

Upgrade all nodes.

NOTICE: The directory /opt/openGauss/install/app_02c14696 will be deleted after commit-upgrade, please make sure there is no personal data.

Performing grey rollback.

No need to rollback.

The directory /opt/openGauss/install/app_02c14696 will be deleted after commit-upgrade, please make sure there is no personal data.

Installing new binary.

Wait for the cluster status normal or degrade.

copy certs from /opt/openGauss/install/app_02c14696 to /opt/openGauss/install/app_4e931f9a.

Successfully copy certs from /opt/openGauss/install/app_02c14696 to /opt/openGauss/install/app_4e931f9a.

Successfully backup hotpatch config file.

Sync cluster configuration.

Successfully synced cluster configuration.

Switch symbolic link to new binary directory.

Successfully switch symbolic link to new binary directory.

Switching all db processes.

Check cluster state.

Cluster state: [   Cluster State   ]

cluster_state   : Normal

redistributing : No

current_az      : AZ_ALL

[ Datanode State   ]

    node node_ip         port      instance     state

---------------------------------------------------------------------

1 ccf10 192.168.6.201   15400      6001       P Primary Normal

2 ccf11 192.168.6.202   15400      6002       S Standby Normal

3 ccf12 192.168.6.203   15400      6003       C Cascade Normal

Wait for the cluster status normal or degrade.

Wait for the cluster status normal or degrade.

Create checkpoint before switching.

Switching DN processes.

Ready to grey start cluster.

Grey start cluster successfully.

Wait for the cluster status normal or degrade.

Successfully switch all process version

The nodes ['ccf10', 'ccf11', 'ccf12'] have been successfully upgraded to new version. Then do health check.

Start to do health check.

Successfully checked cluster status.

Waiting for the cluster status to become normal.

.

The cluster status is normal.

Upgrade main process has been finished, user can do some check now.

Once the check done, please execute following command to commit upgrade:

    gs_upgradectl -t commit-upgrade -X /home/omm/cluster_config.xml

Successfully upgrade all nodes.

[omm@ccf10 ~]$

数据库状态正常时，使用如下命令进行滚动升级。

示例一：使用gs_upgradectl脚本执行指定单节点升级。

/opt/software/gaussdb_upgrade/script/gs_upgradectl -t auto-upgrade -X /home/omm/cluster_config.xml --grey -h ccf10

示例二：使用gs_upgradectl脚本执行指定多节点升级。

/opt/software/gaussdb_upgrade/script/gs_upgradectl -t auto-upgrade -X /home/omm/cluster_config.xml --grey -h ccf10,ccf11

数据库状态正常时，使用如下命令进行升级剩余节点。

/opt/software/gaussdb_upgrade/script/gs_upgradectl -t auto-upgrade -X /home/omm/cluster_config.xml --grey --continue

三、升级验证

版本查询

[omm@ccf10 ~]$ source .bashrc #所有节点

[omm@ccf10 ~]$ gs_ssh -c "gsql -V"

[omm@ccf10 ~]$ gs_ssh -c "gsql -V"

Successfully execute command on all nodes.

Output:

[SUCCESS] ccf10:

gsql (openGauss 3.1.0 build 4e931f9a) compiled at 2022-09-29 14:19:46 commit 0 last mr

[SUCCESS] ccf11:

gsql (openGauss 3.1.0 build 4e931f9a) compiled at 2022-09-29 14:19:46 commit 0 last mr

[SUCCESS] ccf12:

gsql (openGauss 3.1.0 build 4e931f9a) compiled at 2022-09-29 14:19:46 commit 0 last mr

[数据库状态查询

[omm@ccf10 ~]$ gs_om -t status --detail

-----------------------------------------------------------------------

cluster_state : Normal

redistributing : No

balanced : Yes

-----------------------------------------------------------------------

[omm@ccf10 ~]$ cm_ctl query -Cv

[ CMServer State ]

node instance state

-------------------------

1 ccf10 1 Standby

2 ccf11 2 Primary

3 ccf12 3 Standby

[ Cluster State ]

cluster_state : Normal

redistributing : No

balanced : Yes

current_az : AZ_ALL

[ Datanode State ]

node instance state | node instance state | node instance state

---------------------------------------------------------------------------------------------------------------

1 ccf10 6001 P Primary Normal | 2 ccf11 6002 S Standby Normal | 3 ccf12 6003 C Cascade Standby Normal

[omm@ccf10 ~]$

数据验证

[omm@ccf10 ~]$ gsql -d postgres -r

gsql ((openGauss 3.1.0 build 4e931f9a) compiled at 2022-09-29 14:19:46 commit 0 last mr )

Non-SSL connection (SSL connection is recommended when requiring high-security)

Type "help" for help.

openGauss=# \c mydb

Non-SSL connection (SSL connection is recommended when requiring high-security)

You are now connected to database "mydb" as user "omm".

mydb=# select * from chen01;

id

-----

111

(1 row)

mydb=#

四、提交升级

./gs_upgradectl -t commit-upgrade -X /home/omm/cluster_config.xml

[omm@ccf10 ~]$ /opt/software/gaussdb_upgrade/script/gs_upgradectl -t commit-upgrade -X /home/omm/cluster_config.xml

Start to do health check.

Successfully checked cluster status.

Wait for the cluster status normal or degrade.

Wait for the cluster status normal or degrade.

Successfully cleaned old install path.

Commit upgrade succeeded.

[omm@ccf10 ~]$

--回滚升级

/opt/software/gaussdb_upgrade/script/gs_upgradectl -t auto-rollback -X /home/omm/cluster_config.xml --force

关于鲲鹏

新闻与活动

交流与资讯

支持与服务

开源社区