3.4.6 Increasing DB System Storage

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

Increasing Storage by Updating the Data Storage Size of a DB System

Use the Console to increase the data storage size of a DB System that is in the ACTIVE, STARTING_ERROR, or RESTARTING_ERROR state. If the DB System is operating normally, resizing the storage will not restart the DB System, and you can continue to query it while the storage is being increased. Otherwise, resizing the storage may restart the DB System in order to return it to a normal operating state.

It is recommended that you create a backup of the DB System before updating the data storage size. See Creating a Backup.

Caution:

You can only increase the data storage size once every 6 hours. It is recommended that you increase your storage by an amount large enough to support your storage requirement in the next 6 hours.

Follow these steps to update the data sotrage size of a DB system:

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.

Parent topic: Managing a DB System