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. On the DB systems list page, select the DB system that you want to work with. If you need help finding the list page or the DB system, see Listing DB Systems - Using the Console.

    The details page opens and displays information about the DB system.

  2. Select the Details tab.
  3. Select Edit in the Storage size or Automatic storage expansion field:
  4. In the Update storage size dialog box, enter the new data storage size in GB. You can only increase the storage size.
  5. (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.
  6. Select 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.