MySQL HeatWave on AWS  /  ...  /  Increasing DB System Storage

3.3.6 Increasing DB System Storage

You can increase the DB System storage by updating the data storage size of an active DB System, by backup and restore, or by export and import.

Increasing Storage by Updating the Data Storage Size of an Active DB System

Use the Console to increase the data storage size of an active DB System. If the DB System is active and healthy, updating the data storage size of the DB System does not restart the DB System, and you can continue to query it while the storage is being increased.

You can increase the data storage size once every six hours. It is recommended to create a backup of the DB System before updating the data storage size. See Creating a Backup.

  1. In the MySQL HeatWave Console, select the MySQL tab.
  2. On the DB Systems tab, in the list of DB Systems, find the DB System for which you want to update the data storage size, and do either of the following:
    • Click on the row of the DB System to highlight it, click Actions, and then click Update Data Storage Size.
    • Click the name of the DB system to open the DB System Details page. Click Actions, and then click Update Data Storage Size.
  3. In the Update Data Storage Size dialog, enter the required storage size in GiB. You can only increase the storage size, and the maximum storage size is 65536.
  4. Click Update.

Increasing Storage by Backup and Restore

  1. Create a backup of the DB System. See Creating a Backup.
  2. Create a new DB System from the backup, and define a larger storage in the new DB System. See Restoring a Backup to a New DB System.

Increasing Storage by Export and Import

  1. Export the data from your current DB System using MySQL Shell. See Exporting Data Using MySQL Shell.
  2. Use the MySQL HeatWave Console to create a new DB System with a larger storage size. See Creating a DB System.
  3. Import the data into the new DB System using MySQL Shell. See Importing Data.