Scaling MySQL Cloud Service

Not Oracle Cloud Infrastructure This topic does not apply to Oracle Cloud Infrastructure.

If a database deployment on MySQL Cloud Service is performing poorly or is running out of storage, you can scale up the environment supporting the database deployment.

Usually, the need to scale arises as the result of analyzing database performance, as described in Tuning Database Performance on MySQL Cloud Service.

Occasionally, the need to scale arises from some change made to the database or backup configuration after it was created. For example, you might need to scale up the compute shape to one of the high-memory options, such as scaling from "OC4 - 2 OCPU, 15 GB RAM" to "OC2M - 2 OCPU, 30 GB RAM".

Scaling the Compute Shape for MySQL Cloud Service

Note:

When you scale the compute shape of a database deployment on MySQL Cloud Service, the deployment is put into Maintenance status during the operation and it is restarted. As a result of the restarting, any resources you’ve manually added using the Compute Cloud Service console become detached from the database deployment. For more information and for instructions on reattaching such resources, see About Stopping, Starting and Restarting a MySQL Server Deployment.

To scale the compute shape for a database deployment:

  1. Open the Instance Overview page for the service by clicking the service name on the console.

  2. Select the menu in the Resources section on the Instance Overview page.

  3. Select Scale Up/Down from the menu.

    The Scale Up/Down dialog is displayed.

  4. Choose the required shape and click Yes, Scale Up/Down VM to scale your instance.

    The service restarts.