Oracle Cloud Infrastructure Documentation

MySQL Server Upgrades

MySQL HeatWave Service supports automatic and manual upgrades.

  • Automatic upgrades:
    • If the MySQL Server version is running a deprecated version, MySQL HeatWave Service automatically upgrades the version during the maintenance window. For example, if the MySQL Server version is 8.0.33, which is deprecated, the service automatically upgrades to the latest patch release. If the MySQL Server version is 8.1.0, and if the version is deprecated, the service automatically upgrades to the latest innovation release.
    • Upgrade versions, such as 8.0.*-u1, are applied automatically during the maintenance window that you define on the DB system. The upgrade versions contain critical patches such as security and stability fixes.
  • Manual upgrades: You can manually upgrade the version using the Console or the CLI. See Manually Upgrading a MySQL Server.
    Note

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

Manually Upgrading a MySQL Server

Use the Console or CLI to manually upgrade a MySQL Server.

Using the Console

Use the Console to manually upgrade the MySQL Server of the DB system.

This task requires the following:
  • A running DB system with an available upgrade version.
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 MySQL Server:
  1. Open the navigation menu and select Databases. Under MySQL HeatWave, click 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:
    • Click the Actions menu present on the same line as your DB system, and then click Edit MySQL version. If this option is not enabled, your DB system is already using the latest version of the MySQL Server.
    • Click the name of the DB system to open the DB System Details page. Click Edit on the MySQL version field, or Edit MySQL version from the More Actions menu. If either option is not present, your DB system is already using the latest version of the MySQL Server.
    The dialog is displayed.
  4. In the Edit MySQL version dialog box, select the required MySQL version.
  5. Click Save Changes.
The DB system enters the UPDATING state while the MySQL Server is upgraded.

Using the CLI

Use the command-line interface to manually upgrade the MySQL Server of the DB system. You can upgrade to the same version of the MySQL Server (to get the latest service updates), but you cannot downgrade to an earlier version.

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 MySQL Server of 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 MySQL version of the DB system. See Retrieving the Version of a MySQL Server.
  3. Upgrade the MySQL 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 subequently the MySQL version changes to 8.0.33.