At Scalingo, Dedicated Resources plan names identify:

1. a database type : mysql-dr
2. a class : either starter, business or enterprise (learn more about service classes)
3. a size : specifying the amount of RAM available with the plan, in MB.

You can change your Scalingo for MySQL® Dedicated Resources Database plan whenever you want. The operation is launched instantly, no manual input is required.

Service class changes are supported in both directions (scale-out or scale-in) for a given size. However, size/resources changes are supported only in a scale-up direction: moving to a smaller size is not supported.

The impact on your application and the downtime vary depending on several factors such as the current plan being used and the one you wish to change for (see below for further information).

Understanding the Plan Change Process

Plan changes can combine two dimensions:

• Topology:
  • Single-node (Starter)
  • Multi-node cluster (Business and Enterprise)
• Size (RAM per node)

Single-node to Single-node (Scale-up)

This covers Starter to Starter when increasing size. The platform reboots the existing instance with the new size. No new VM is created.

Single-node to Multi-node Cluster (Scale-out)

This covers moves from Starter to Business or Enterprise. The platform creates additional node(s) and configures replication/failover.

Multi-node Cluster to Multi-node Cluster

This covers Business <-> Enterprise, as well as size increases within the same class. Moving from Business to Enterprise starts additional infrastructure and takes longer than increasing size within the same class.

Multi-node Cluster to Single-node (Scale-in)

This covers moves from Business or Enterprise to Starter.

Using the Dashboard

1. From your web browser, open your dashboard
2. Click on the Settings tab
3. Locate the Database plan block and click on the Change plan button
4. Select the new plan
5. Click the Finish button
6. Validate by clicking the Confirm plan change button

Using the Command Line (Preview)

Because Dedicated Resources databases are not yet generally available, you must first enable preview features to use the related CLI commands:

export SCALINGO_PREVIEW_FEATURES=true

1. Make sure you have correctly setup the Scalingo command line tool
2. From the command line, list your databases:

   scalingo databases
   

3. Locate the ID of the database you want to scale (for example my-dedicated-database).
4. From the command line, list the plans available for mysql-dr:

   scalingo database-list-plans mysql-dr
   

   The output should look like this:

   +-----------------------+------------+
   | ID                    | NAME       |
   +-----------------------+------------+
   | mysql-dr-starter-8192 | Starter 8G |
   ...
   

5. Locate the ID corresponding to the plan you want to scale to
6. Change plan with:

   scalingo database-upgrade <database_ID> <plan_ID>
   

   Example:

   scalingo database-upgrade 699d6312565f770d0a6cdab3 <plan_ID>
   

   The output should look like this:

   -----> Your mysql-dr database 699d6312565f770d0a6cdab3 ('my-dedicated-database') is being upgraded…
   

Optionally you can use --wait in order to make the command synchronous.

scalingo database-upgrade --database 699d6312565f770d0a6cdab3 --wait <plan_ID>

Using the Terraform Provider

1. Update the plan property of the corresponding Resource block in your Terraform file to scale the database:

   resource "scalingo_database" "my-dedicated-database" {
     name       = "my-dedicated-database"
     technology = "mysql-dr"
     plan       = "<plan_ID>"
   }
   

   In this example, we switch the my-dedicated-database resource to a selected Dedicated Resources plan.

2. Run terraform plan and check if the result looks good
3. If so, run terraform apply