Advanced Database Instance Management

In this section, we will describe some advanced Database Instance management functions.

Attach Configuration Group

A configuration group is used to apply database parameters. In this exercise, we are going to attach a configuration group to a database instance.

1. Navigate to the Project / Database / Configuration Groups page
2. Click the Create Configuration Group button to start the Create Configuration Group Dialog
3. Enter tutorial_mysql in Name field. Select your MySQL datastore version in the the Datastore drop down list.
4. Click the Create Configuration Group button.
5. Once the configuration group is created. Click the tutorial_mysql name.
6. In the configuration group details page, click the Add Parameter button.
7. Select auto_increment_increment in the ‘Name’ drop down list and enter 10 in the Value field.
8. Click the ‘Add Parameter’ button and you should see auto_increment_increment is listed in the Configuration Group Detail page.
9. Navigate to the Project / Database / Instances page. Click the Attach Configuration Group from the actions list of your tutorial instance.
10. In the Attach Configuration Group dialog, select tutorial_mysql from the Configuration Group drop down list. Note: it may be necessary to restart the database instance for this new configuration group to take effect.

Enable Database Root Access

By default, your database has no root access. In this exercise, we are going to enable root access.

1. Navigate to the Project / Database / Instances page and click Manage Root Access from the actions list of your tutorial instance.
2. Click the Enable Root button. A new root password will be generated.