Oracle Cloud Infrastructure Documentation

Increasing the Storage of a DB System

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.

Note

You cannot increase the storage size of an Always Free DB system.
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:

  • For an ACTIVE DB system:
    • Use the Update storage size console action. See Using the Console.
    • Using the REST API, run the UpdateDbSystem operation with the dataStorageSizeInGBs attribute.
    Note

    There is no downtime while increasing the storage of a DB system.
  • For an ACTIVE or INACTIVE DB system:

Using the Console

You can increase storage using the Update storage size console action of an ACTIVE DB system.

This task requires the following:

Do the following to increase the storage of an ACTIVE DB system:

  1. Open the navigation menu, and select Databases, and under HeatWave MySQL, 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 new data storage size in GB. You can only increase the storage size.
  4. (Optional) You can also enable or disable the automatic storage expansion. If you enable automatic storage expansion, you must specify a maximum storage size in GB.
  5. Click Update.

By Backup and Restore Action

Use the Console or CLI to increase the storage of an ACTIVE or INACTIVE DB system 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 DB system in ACTIVE or INACTIVE state.
Do the following to increase the storage of an ACTIVE or INACTIVE 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.