openGauss数据库从3.0.0升级到3.1.0操作实践

[omm@pekphisprb70593 ~]$ gsql --version

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

[omm@pekphisprb70593 ~]$ df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/vda3        35G  7.0G   26G  22% /
devtmpfs        3.9G     0  3.9G   0% /dev
tmpfs           3.9G   12K  3.9G   1% /dev/shm
tmpfs           3.9G   49M  3.8G   2% /run
tmpfs           3.9G     0  3.9G   0% /sys/fs/cgroup
/dev/vda1       976M  117M  793M  13% /boot
tmpfs           783M     0  783M   0% /run/user/0

[omm@pekphisprb70593 ~]$ gs_om -t status

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

cluster_name    : opengSingle

cluster_state   : Normal

redistributing  : No

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

gs_checkos -i A

mkdir -p /opt/software/gaussdb_upgrade

[root@pekphisprb70593 software]# chown -R omm:dbgrp gaussdb_upgrade/

cd /opt/software/gaussdb_upgrade/script
./gs_preinstall -U omm -G dbgrp -X /opt/software/gaussdb_upgrade/cluster_config.xml

./configure --prefix=/usr/local/python3 --enable-shared CFLAGS=-fPIC
make
make install

[root@pekphisprb70593 script]# ./gs_preinstall -U omm -G dbgrp -X  /opt/software/gaussdb_upgrade/cluster_config.xml

Parsing the configuration file.

Successfully parsed the configuration file.

Installing the tools on the local node.

Successfully installed the tools on the local node.

Setting host ip env

Successfully set host ip env.

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

Preparing SSH service.

Successfully prepared SSH service.

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 pekphisprb70593 --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.

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

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

Static configuration matched with old static configuration files.

The authenticity of host 'pekphisprb70593 (fe80::f816:3eff:fee3:12fb%eth0)' can't be established.

ECDSA key fingerprint is SHA256:yOyJOqmNfoKjxATR/5n3JNeEQDqH2BVAKz/Sxr27clA.

ECDSA key fingerprint is MD5:42:8f:e9:f1:88:6e:18:c0:d0:68:6a:97:30:0b:d0:77.

Are you sure you want to continue connecting (yes/no)? yes

omm@pekphisprb70593's password:

omm@pekphisprb70593's password:

Successfully set upgrade_mode to 0.

Checking upgrade environment.

Successfully checked upgrade environment.

Start to do health check.

Successfully checked cluster status.

Upgrade one node 'pekphisprb70593'.

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

Performing grey rollback.

omm@pekphisprb70593's password:

omm@pekphisprb70593's password:

No need to rollback.

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

Installing new binary.

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

Successfully copy certs from /opt/huawei/install/app_02c14696 to /opt/huawei/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 pekphisprb70593 10.x.x.218 15400 6001 P Primary Normal

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 ['pekphisprb70593'] 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 /opt/software/gaussdb_upgrade/cluster_config.xml

Successfully upgrade all nodes.

[omm@pekphisprb70593 script]$ gsql --version

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

[omm@pekphisprb70593 script]$ gs_om -t status

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

cluster_name    : opengSingle

cluster_state   : Normal

redistributing  : No

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

opengauss_db=# select * from test1;

id

----

1

(1 row)

gs_upgradectl -t commit-upgrade  -X /opt/software/gaussdb_upgrade/cluster_config.xml