Oracle Cloud Infrastructure Documentation

DB System Upgrades

HeatWave Service supports automatic and manual upgrades.

  • Automatic upgrades:
    • Updates within the same version, such as 8.0.33-u1, are applied automatically during the maintenance window that you define on the DB system. The update versions contain critical patches such as security and stability fixes.
    • A deprecated version becomes unavailable about three months after the deprecation date. See MySQL Versions Deprecation and Removal Policy in HeatWave Service. Any DB system that is running an unavailable version will be upgraded automatically during its next maintenance window. It is upgraded to the lowest version currently available in the same series. For example, when version 8.0.31 becomes unavailable, it will be upgraded to 8.0.32 and when version 8.1.0 becomes unavailable, it is upgraded to 8.2.0.
    • For an Always Free DB system, the maintenance process will always upgrade the database version to the highest version available.
  • Manual upgrades: You can manually upgrade the version using the Console or the CLI. See Manually Upgrading a DB System.
    Note

    It is recommended to perform a full backup before upgrading the DB system.

Manually Upgrading a DB System

Use the Console or CLI to manually upgrade a DB system to a higher version. You can upgrade to the same version (to get the latest security and critical fixes), but you cannot downgrade to an earlier version.

Note

If you want to perform a major version upgrade such as MySQL 8.0 to MySQL 8.4, you should check the changes before upgrading. See Major Version Upgrade.

Using the Console

Use the Console to manually upgrade the DB system.

This task requires the following:
  • A running DB system.
Note

It is recommended to perform a full backup of the DB system before upgrading. See Creating a Manual Backup.
Do the following to upgrade the DB system:
  1. Open the navigation menu and select Databases. Under HeatWave MySQL, select DB systems.
  2. Choose your compartment from the List scope.
  3. In the list of DB systems, find the DB system you want to upgrade, and do one of the following:
    • Select the Actions menu present on the same line as your DB system, and then select Edit database version.
    • Select the name of the DB system to open the DB system details page. Select Edit on the Database version field, or Edit database version from the More actions menu.
    The dialog is displayed.
  4. In the Edit database version dialog box, select the required version.
    Note

    You can select the same version to get the latest service updates if the version is still available in the service.
  5. Select Save changes.
The DB system enters the UPDATING state while it is being upgraded.

Using the CLI

Use the command-line interface to manually upgrade the DB system.

This task requires the following:
Note

It is recommended to perform a full backup of the DB system before upgrading. See Creating a Manual Backup.
Do the following to upgrade the DB system:
  1. Use the version list command to retrieve the list of available versions:
    oci mysql version list --compartment-id <CompartmentOCID>
    You get a response similar to the following:
    {
  "data": [
    {
      "version-family": "8.0",
      "versions": [
        {
          "description": "8.0.32",
          "version": "8.0.32"
        },
        {
          "description": "8.0.33",
          "version": "8.0.33"
    }
  ]
}
  2. Confirm the version of the DB system. See Retrieving the Version of a MySQL Server.
  3. Upgrade the version from a lower version to a higher version such as 8.0.32 to 8.0.33, or to the same version, such as 8.0.33 to 8.0.33 to get the latest service updates:
    oci mysql db-system update 
             --db-system-id <DBSystemOCID> 
             --mysql-version <LatestMySQLVersion>
The status of the DB system changes to UPDATING and subsequently the version changes to 8.0.33.