You can provision a MySQL® Shared Resources database as an application add-on using the dashboard, CLI or Terraform Provider.

Provisioning

Using the Dashboard

1. From your web browser, open your dashboard
2. Click on the application to which you want to add the database
3. Click on the Resources tab
4. Locate the Addons block and click on the Add an addon button
5. Select MySQL® in the databases block and confirm your choice
6. Select the plan you want to provision and confirm your selection
7. Review the addon configuration, then click the Provision addon button to confirm it and start provisioning
8. Wait a few seconds for the database to be provisioned

Using the Command Line

1. Make sure you have correctly setup the Scalingo command line tool
2. From the command line, list the plans available for mysql:

   scalingo addons-plans mysql
   

   The output should look like this:

   +-----------------------+---------------+
   |          ID           |     NAME      |
   +-----------------------+---------------+
   | mysql-starter-512     | Starter 512M  |
   | mysql-starter-1024    | Starter 1G    |
   ...
   

3. Locate the ID corresponding to the plan you want to deploy (for example mysql-starter-512)
4. Provision the addon:

   scalingo --app my-app addons-add mysql <plan_ID>
   

   The output should look like this:

   -----> Addon mysql has been provisionned
          ID: my_app_wxyz
          Message from addon provider: Database is being provisioned
   

5. Wait a few seconds for the addon to be provisioned and enjoy!

Using the Terraform Provider

1. Place the following resource block in your Terraform file to create the addon and attach it to your app:

   resource "scalingo_addon" "my-db" {
     provider_id = "mysql"
     plan = "mysql-starter-512"
     app = "${scalingo_app.my-app.id}"
   }
   

   In this example, we create a MySQL® Starter 512 addon named my-db and attach it to an app named my-app (which must exist). We could have done the same with another plan.

2. Run terraform plan and check if the result looks good
3. If so, run terraform apply
4. After a few seconds, your database is ready to use. Enjoy!

Accessing the Scalingo for MySQL® Dashboard

Every MySQL® addon comes with its dedicated dashboard, generally referred to as database dashboard, which is the central place for administrative tasks such as:

• Monitoring the database through logs, metrics and statistics
• Upgrading the database engine version
• Managing database users
• Using multiple databases
• Managing backups

You can access the database dashboard via the application dashboard:

1. From your web browser, open your dashboard
2. Open the Project containing the application to which your database is linked
3. Click on the application name
4. Click on the Overview tab
5. Locate the Addons block and click on the Dashboard button next to the database you want to manage.