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.

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

  • For a DB system that is running MySQL Server 8.0.27-u3-cloud or a higher version, use the Update storage size console action. You can increase the storage size of DB systems with initial storage of 400 GB or less to 32 TB, and DB systems with initial storage greater than 400 GB to 64 TB. See Using the Console.
  • For any MySQL Server version, back up the DB system and move it to a new DB system that has a larger storage size. See By Backup and Restore Action.

There is no downtime while increasing the storage of the DB system.

Related Topics

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.