If a database deployment on MySQL Cloud Service is running out of storage, you can extend the existing storage volumes.
The following storage volumes can be extended:
Usable Database Storage— storage available to the MySQL database. This storage volume can be extended up to 1024 GB.
Backup Storage—storage available for backups stored on the compute node. This storage volume can be extended up to 2000 GB. This option is available only if backup was defined when the service was created.
Redolog Storage—storage available for MySQL redo logging. This storage volume can be extended up to 1024 GB.
Extending a storage volume sets the storage volume to the defined value. It does not add the new value to the existing value, but sets the storage volume to the defined value. For example, if your current storage volume is 50GB and you define the new value as 100GB, the storage volume is extended to 100GB, not 150GB.
Each MySQL Cloud Service instance has 10 storage volumes assigned. Six of those are used, out-of-the-box, leaving 4 possible extensions.
Note:
It is not possible to shrink a storage volume.Adding Storage
To extend a storage volume, do the following:
Open the Instance Overview page for the service by clicking the service name on the console.
Select the menu in the Resources section on the Instance Overview page.
Select Add Storage from the menu.
The Add Storage dialog is displayed.
Define the required values and click Yes, Add Storage to extend your storage volumes to the defined value.
The service restarts.
Note:
If you define a value which is larger than the defined limits, or lower than the current value, the field is highlighted in red and a tooltip is displayed explaining the error.