Help Center > > User Guide> Working with RDS for MySQL> Instance Modifications> Scaling up Storage Space

Scaling up Storage Space

Updated at: Jul 02, 2021 GMT+08:00

Scenarios

If the original storage space is insufficient as your services grow, scale up storage space of your DB instance. The backup space increases with the DB instance scale-up.

If your storage space usage reaches 100%, the DB instance status becomes Storage full and data cannot be written to databases. In this case, scale up storage space to make the DB instance preserve at least 15% of its capacity to work properly.

You are advised to set alarm rules for the storage space usage by referring to Setting Alarm Rules.

For details about the causes and solutions of insufficient storage space, see What Should I Do If My Data Exceeds the Database Storage Space of an RDS DB Instance?

RDS allows you to scale up storage space of DB instances but you cannot change the storage type. During the scale-up period, services are not interrupted.

Constraints

  • The maximum allowed storage is 4,000 GB. There is no limit on the number of scale-ups.
  • The DB instance is in Scaling up state when its storage space is being scaled up and the backup services are not affected.
  • For primary/standby DB instances, scaling up the primary DB instance will cause the standby DB instance to also be scaled up accordingly.
  • Reboot is not required during DB instance scaling-up.
  • You cannot reboot or delete a DB instance that is being scaled up.
  • Storage space can only be scaled up, not down.
  • If you scale up a DB instance with disks encrypted, the expanded storage space will be encrypted using the original encryption key.

Scaling up a Primary DB Instance

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Database > Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, locate the target DB instance and choose More > Scale Storage Space in the Operation column.

    You can also perform the following operations to scale up storage space:

    • Click the target DB instance to enter the Basic Information page. In the Storage Space area, click Scale.
    • If the storage space is full, locate the target DB instance on the Instance Management page and click Scale in the Status column.

  5. On the displayed page, specify the new storage space and click Next.

    The minimum increment for each scaling is 10 GB.

  6. Confirm specifications.

    • If you need to modify your settings, click Previous.
    • If you select the Pay-per-use billing mode and do not need to modify your settings, click Submit. If you select the Yearly/Monthly billing mode and do not need to modify your settings, click Pay Now.

  7. View the scale-up result.

    Scaling up storage space takes 3-5 minutes. During the time period, the status of the DB instance on the Instance Management page will be Scaling up. Click the DB instance and view the utilization on the displayed Basic Information page to verify that the scale-up is successful.

    If the DB instance is running the MySQL DB engine, you can view the detailed progress and result of the task on the Task Center page. For details, see section Task Center.

Scaling up a Read Replica

Scaling up the storage space of a read replica does not affect that of the primary DB instance. Therefore, you can separately scale read replicas to meet service requirements. New storage space of read replicas after scaling up must be greater than or equal to that of the primary DB instance.

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Database > Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, locate the target DB instance and click in front of it. Locate a read replica to be scaled and choose More > Scale Storage Space in the Operation column.

    You can also perform the following operations to scale up storage space:

    • Click the target DB instance to enter the Basic Information page. In the Storage Space area, click Scale.
    • If the storage space is full, locate the target DB instance on the Instance Management page and click Scale in the Status column.

  5. On the displayed page, specify the new storage space and click Next.

    The minimum increment for each scaling is 10 GB.

  6. Confirm specifications.

    • If you need to modify your settings, click Previous.
    • If you select the Pay-per-use billing mode and do not need to modify your settings, click Submit.

  7. View the scale-up result.

    Scaling up storage space takes 3-5 minutes. During the time period, the status of the read replica on the Instance Management page will be Scaling up. Click the read replica and view the utilization on the displayed Basic Information page to verify that the scale-up is successful.

    If the read replica is running the MySQL DB engine, you can view the detailed progress and result of the task on the Task Center page. For details, see section Task Center.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel