Oracle Cloud Infrastructure Documentation

Increasing the Storage of a DB System

MySQL HeatWave Service tracks storage space utilization for a DB system and can warn you if there is a shortage of space on the disk. If you see these warnings, or know your storage needs will soon increase, take action to increase the storage space.

The initial storage size specified during the DB system creation determines the maximum size the storage can be increased to.
Note

The number of volume remains the same when the storage size is increased. If you create a DB system with a small initial storage size and increase the storage size multiple times larger later, the storage performance could be limited by the less than optimal number of volumes. See DB System Storage. You can overcome this by creating a new DB system with a larger initial storage size based on the required storage size and use MySQL Shell to export and import the data. See Overview of Exporting and Importing.

You can increase the amount of storage available to the DB system by using these methods:

  • Use the Update storage size console action. See Using the Console.
    Note

    There is no downtime while increasing the storage of a DB system.
  • Back up the DB system and restore it to a new DB system that has a larger storage size. See By Backup and Restore Action.

Using the Console

You can increase storage using the Update storage size console action for the DB system.

This task requires the following:
  • A running DB system that is running MySQL Server 8.0.27-u3-cloud or a higher version. For earlier versions, see By Backup and Restore Action.

Do the following to increase the storage of a DB system:

  1. Open the navigation menu, and select Databases, and under MySQL HeatWave select DB systems.
  2. Do one of the following:
    • Click the Actions menu present on the same line as your DB system, and click Update storage size.
    • Click the name of the DB system to open the DB system details page.Click More actions present at the top of the page, and click Update storage size.
    • Click the name of the DB system to open the DB system details page. Click Edit present adjacent to Storage size under DB system configuration field.
  3. In the Update storage size dialog box, enter the required storage. You can only increase the storage size.
  4. Click Update.

By Backup and Restore Action

Use the Console or CLI to increase the storage of a DB system of any MySQL Server version by creating a backup of the DB system, and restoring the backup to a new DB system with a larger storage size.

This task requires the following:
  • A running DB system.
Do the following to increase the storage of a DB system:
  1. Create a backup of the DB system. See Creating a Manual Backup.
  2. Restore the backup to a new DB system that has a larger storage size. See Restoring From a Backup.