This topic describes how to upgrade OceanBase Database by using OceanBase Deployer (obd).
Introduction
There are two solutions for upgrading OceanBase Database using obd, and you can choose the appropriate one based on your actual situation:
Solution 1: If your server can access the Internet or you have configured an image repository that has the RPM package for upgrading OceanBase Database, you can use this solution for the upgrade. For more information, see Solution 1: upgrade OceanBase Database online.
Solution 2: If your server cannot access the Internet and the configured image repository does not contain an RPM package for upgrading OceanBase Database, you can run the
obd mirror clonecommand to add the RPM package for upgrading OceanBase Database to the local image repository, or download and install the OceanBase all-in-one installation package of the corresponding version, and then upgrade OceanBase Database. For more information, see Solution 2: upgrade OceanBase Database offline.
Procedure
Note
If a tenant in the cluster to be upgraded has a standby tenant, you must first upgrade the cluster where the standby tenant is located or perform a switchover to switch between the primary and standby tenants.
Run the following command to connect to the remote image repository:
obd mirror enable remoteOptional. Run the following command to upgrade obd to the latest version:
obd updateRun the following command to query the version of OceanBase Database in the remote mirror repository:
obd mirror list oceanbase.community.stable | grep oceanbase-ceIn the following sample output, the strings displayed in the rightmost column are the hash values of the corresponding versions of OceanBase Database Community Edition.
| oceanbase-ce | 3.1.0 | 1.el7 | x86_64 | 9decc4788a7fc6cc2082ac1668f287f60f4a3b8d05a58da094605aa2f19d18fc | | oceanbase-ce | 3.1.0 | 2.el7 | x86_64 | 642cceea884f64860f231701351efb9a1156c46664b49a65f82806f9dab704a2 | | oceanbase-ce | 3.1.0 | 3.el7 | x86_64 | 9a21232c8ee420f6a5dad043ee12aed2efe9796478780ea04077622300b6bac8 | | oceanbase-ce | 3.1.1 | 1.el7 | x86_64 | 37be8ed5ea3a263a5a509f0ee553a208a3d4b63887a8c81a2efda7256e4838e9 | | oceanbase-ce | 3.1.1 | 4.el7 | x86_64 | d94d9856ec521fe0a54f21bb2a33739c20367e8388da937fd0fcd2e54364ae96 | | oceanbase-ce | 3.1.2 | 10000392021123010.el7 | x86_64 | f38723204d49057d3e062ffad778edc1552a7c114622bf2a86fea769fbd202ea | | oceanbase-ce | 3.1.3 | 10000292022032916.el7 | x86_64 | bb5dcd5d56e84a30bfecd4173455c84952819db7c37619c1cedbb375054f1acb | | oceanbase-ce | 3.1.3 | 10100032022041510.el7 | x86_64 | 589c4f8ed2662835148a95d5c1b46a07e36c2d346804791364a757aef4f7b60d | | oceanbase-ce | 3.1.4 | 100000112022102717.el7 | x86_64 | 25b25df19e27d0844fd3d0632da010b7ac33ac454144107ca8b10d337e2f4f68 | | oceanbase-ce | 3.1.4 | 10000092022071511.el7 | x86_64 | 30a7241f8781d306dc4d008f266e9321876b1e6448bbc4aaf15ab6631b5d2715 | | oceanbase-ce | 3.1.4 | 102000012022120715.el7 | x86_64 | 033f86169a145d76499eb2730dbd49c4e657ffbacd7bd7a860522d7981a68d6d | | oceanbase-ce | 3.1.4 | 103000102023020719.el7 | x86_64 | 6980507073d6e7b91fceb9549c0e68a767f47194d961112d73106e2f26952077 | | oceanbase-ce | 3.1.5 | 100000252023041721.el7 | x86_64 | d3629804ab753a7248a9ba80fb111f6594411820000aa7b3f958cda3f8b12dd4 | | oceanbase-ce | 4.0.0.0 | 100000272022110114.el7 | x86_64 | 759074414c7b7b723013855353f62a7ba0aae0f493216ef2511825850ce77b51 | | oceanbase-ce | 4.0.0.0 | 100000282022112511.el7 | x86_64 | debb18ab3c0b3d16f145c41cd21c30686863580b721d45ddaa068e6309e03b64 | | oceanbase-ce | 4.0.0.0 | 102000032022120718.el7 | x86_64 | c63bb73384b17d74299b34fe3aceb0ae310fd319d2ccdb1acd39f31ba6673198 | | oceanbase-ce | 4.0.0.0 | 103000022023011215.el7 | x86_64 | ca467ed00a5e717f40d360ba9d08252595f4ce9de87c81e6006858fbae5755fa | | oceanbase-ce | 4.1.0.0 | 100000192023032010.el7 | x86_64 | a4a092156b5cfe6708a25813633145e0bbd75170e01e30b5c4b88fb230e10903 | | oceanbase-ce | 4.1.0.0 | 100000202023040520.el7 | x86_64 | b56ec3d6e75fd01da65abe0ebb8f8b6455d6a8563c77491ee3d19b33abc40e53 | # Subsequent outputs omittedOptional. View the primary zone configuration of tenants in the cluster.
Note
This step is required only when you upgrade OceanBase Database to V4.0.x, V4.1.x, or V4.2.0 BETA.
Log on to the sys tenant of the database as the root user and run the following command:
obclient [oceanbase]> select * from __all_tenant;Output:
+----------------------------+----------------------------+-----------+-------------+-----------+--------------+--------+----------------+---------------+---------------+-------------------+-----------------------+--------------------+------------------+--------+---------------+----------------------------+ | gmt_create | gmt_modified | tenant_id | tenant_name | zone_list | primary_zone | locked | collation_type | info | locality | previous_locality | default_tablegroup_id | compatibility_mode | drop_tenant_time | status | in_recyclebin | arbitration_service_status | +----------------------------+----------------------------+-----------+-------------+-----------+--------------+--------+----------------+---------------+---------------+-------------------+-----------------------+--------------------+------------------+--------+---------------+----------------------------+ | 2023-04-28 16:39:24.019437 | 2023-04-28 16:39:24.019437 | 1 | sys | zone1 | RANDOM | 0 | 0 | system tenant | FULL{1}@zone1 | | -1 | 0 | -1 | NORMAL | 0 | DISABLED | | 2023-04-28 16:39:35.803601 | 2023-04-28 16:39:48.801686 | 1001 | META$1002 | zone1 | RANDOM | 0 | 0 | | FULL{1}@zone1 | | -1 | 0 | -1 | NORMAL | 0 | DISABLED | | 2023-04-28 16:39:35.812822 | 2023-04-28 16:39:48.823722 | 1002 | ocp | zone1 | RANDOM | 0 | 0 | | FULL{1}@zone1 | | -1 | 0 | -1 | NORMAL | 0 | DISABLED | +----------------------------+----------------------------+-----------+-------------+-----------+--------------+--------+----------------+---------------+---------------+-------------------+-----------------------+--------------------+------------------+--------+---------------+----------------------------+Check whether the value of the
primary_zonecolumn for tenants other than thesystenant in the output isRANDOM. If yes, run the following command to configure different priorities for the zones in the tenant:obclient [oceanbase]> ALTER TENANT ocp primary_zone='zone1';For more information about the ALTER TENANT statement, see ALTER TENANT.
Perform a major compaction of OceanBase Database.
Log on to the sys tenant as the root user and run the following command to perform a major compaction:
obclient [oceanbase]> ALTER SYSTEM MAJOR FREEZE;Run the following command to check whether the major compaction is completed:
obclient [oceanbase]> select name,value from oceanbase.__all_zone where name='frozen_version' or name='last_merged_version'; #or obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_MAJOR_COMPACTION\GFor more information about the
oceanbase.CDB_OB_MAJOR_COMPACTIONview, see oceanbase.CDB_OB_MAJOR_COMPACTION.Run the following command to upgrade OceanBase Database:
obd cluster upgrade obtest -c oceanbase-ce -V 4.1.0.0 --usable=b56ec3d6e75fd01da65abe0ebb8f8b6455d6a8563c77491ee3d19b33abc40e53For more information about the commands used in this step, see Cluster commands.
Verify the upgrade
Log on to the sys tenant of OceanBase Database as the root user and execute the following statement to view the database version:
obclient [oceanbase]> SELECT version();
Configure the RPM package.
You can run the
obd mirror clonecommand to add the RPM package for upgrading OceanBase Database to the local image repository, or download and install the all-in-one installation package of the corresponding version.Method 1: Download the RPM packages of OceanBase Database and the required dependency library from the Releases page on GitHub or OceanBase Download Center, copy the packages to the server where obd is installed, and run the following command in the directory where the packages are located to add the packages to the local image repository:
obd mirror clone oceanbase-ce-*.rpmMethod 2: Download the all-in-one installation package of the required version from OceanBase Download Center, copy the installation package to the server where obd is installed, and run the following command to decompress and install the package:
Notice
You must install the all-in-one installation package with the same account that you use to install OceanBase Database.
[admin@test001 ~]$ tar -xzf oceanbase-all-in-one-*.tar.gz [admin@test001 ~]$ cd oceanbase-all-in-one/bin/ [admin@test001 bin]$ ./install.sh [admin@test001 bin]$ source ~/.oceanbase-all-in-one/bin/env.sh
Run the following command to disconnect from the remote image repository:
obd mirror disable remoteRun the following command to query the version of OceanBase Database in the local image repository:
obd mirror list local | grep oceanbase-ceIn the following sample output, the strings displayed in the rightmost column are the hash values of the corresponding versions of OceanBase Database Community Edition.
| oceanbase-ce | 4.1.0.0 | 100000192023032010.el7 | x86_64 | 8439ecf8db5e0649bd49671b41ea9e8c85756b63 | | oceanbase-ce | 4.1.0.0 | 100000202023040520.el7 | x86_64 | d598937b1cfb1df85e2c2231acf024e4994db533 | | oceanbase-ce-libs | 4.1.0.0 | 100000192023032010.el7 | x86_64 | a83b1dd1cab44d3f610d439931322be7a08555f2 | | oceanbase-ce-libs | 4.1.0.0 | 100000202023040520.el7 | x86_64 | 5d24535db655b4dce6fc62aedc4d0e867225792a |Optional. View the primary zone configuration of tenants in the cluster.
Note
This step is required only when you upgrade OceanBase Database to V4.0.x, V4.1.x, or V4.2.0 BETA.
Log on to the sys tenant of the database as the root user and run the following command:
obclient [oceanbase]> select * from __all_tenant;Output:
+----------------------------+----------------------------+-----------+-------------+-----------+--------------+--------+----------------+---------------+---------------+-------------------+-----------------------+--------------------+------------------+--------+---------------+----------------------------+ | gmt_create | gmt_modified | tenant_id | tenant_name | zone_list | primary_zone | locked | collation_type | info | locality | previous_locality | default_tablegroup_id | compatibility_mode | drop_tenant_time | status | in_recyclebin | arbitration_service_status | +----------------------------+----------------------------+-----------+-------------+-----------+--------------+--------+----------------+---------------+---------------+-------------------+-----------------------+--------------------+------------------+--------+---------------+----------------------------+ | 2023-04-28 16:39:24.019437 | 2023-04-28 16:39:24.019437 | 1 | sys | zone1 | RANDOM | 0 | 0 | system tenant | FULL{1}@zone1 | | -1 | 0 | -1 | NORMAL | 0 | DISABLED | | 2023-04-28 16:39:35.803601 | 2023-04-28 16:39:48.801686 | 1001 | META$1002 | zone1 | RANDOM | 0 | 0 | | FULL{1}@zone1 | | -1 | 0 | -1 | NORMAL | 0 | DISABLED | | 2023-04-28 16:39:35.812822 | 2023-04-28 16:39:48.823722 | 1002 | ocp | zone1 | RANDOM | 0 | 0 | | FULL{1}@zone1 | | -1 | 0 | -1 | NORMAL | 0 | DISABLED | +----------------------------+----------------------------+-----------+-------------+-----------+--------------+--------+----------------+---------------+---------------+-------------------+-----------------------+--------------------+------------------+--------+---------------+----------------------------+Check whether the value of the
primary_zonecolumn for tenants other than thesystenant in the output isRANDOM. If yes, run the following command to configure different priorities for the zones in the tenant:obclient [oceanbase]> ALTER TENANT ocp primary_zone='zone1';For more information about the ALTER TENANT statement, see ALTER TENANT.
Perform a major compaction of OceanBase Database
Log on to the sys tenant as the root user and run the following command to perform a major compaction:
obclient [oceanbase]> ALTER SYSTEM MAJOR FREEZE;Run the following command to check whether the major compaction is completed:
obclient [oceanbase]> select name,value from oceanbase.__all_zone where name='frozen_version' or name='last_merged_version'; #or obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_MAJOR_COMPACTION\GFor more information about the
oceanbase.CDB_OB_MAJOR_COMPACTIONview, see oceanbase.CDB_OB_MAJOR_COMPACTION.Run the following command to upgrade OceanBase Database:
obd cluster upgrade obtest -c oceanbase-ce -V 4.1.0.0 --usable=d598937b1cfb1df85e2c2231acf024e4994db533For more information about the commands used in this step, see Cluster commands.
Verify the upgrade
Log on to the sys tenant of OceanBase Database as the root user and execute the following statement to view the database version:
obclient [oceanbase]> SELECT version();