3.3 Creating a MySQL Configuration

Use the MySQL HeatWave Console to create a new MySQL configuration. It is not possible to change the values of any variables once a configuration has been created.

Review the default values for the MySQL global system variables, and choose preferred values. See Section 13.1, “System Initialization Variables”, and Section 13.2, “User Configurable System Variables”

Certain MySQL global system variables define whether a configuration can support HeatWave. See: Section 13.3, “User Configurable Shape Dependent System Variables”.

1. In the MySQL HeatWave Console, select the MySQL tab, and then click Configurations to open the Configurations page.

2. On the Configurations page, click Create MySQL Configuration to open the Create MySQL Configuration dialog.

3. Basic information: Provide a name and description for the configuration:

   • Display Name: Specify a display name for the configuration or use the generated default name.

   • Description: Specify a user friendly description for the configuration.

4. Select MySQL shape: Select a shape to create a configuration for.

5. Click Next.

6. Support HeatWave: Select this option to ensure that the configuration supports HeatWave.

7. Initialization variables: Set preferred values for initialization variables.

   • Click Select a variable name, and select the variable from the drop-down list.

   • Click Select a value, and select the value from the drop-down list, or enter the preferred value.

8. User variables: Set preferred values for user variables.

   • Click Select a variable name, and select the variable from the drop-down list.

   • Click Select a value, and select the value from the drop-down list, or enter the preferred value.

   • Click Add new variable, and repeat these steps to create the full configuration.

9. Review all the variables, and their values. Edit the values, or if any are incorrect, click X to remove the variable.

10. Click Create.

    The MySQL HeatWave Console checks the values for each variable. If any fail validation Could not create MySQL Configuration appears, with the name of the failed variable. Edit the value, and click Create.

    The MySQL HeatWave Console returns to the Configurations page, and shows the new configuration at the top of the page.

11. Click on the configuration to view the Details page. This shows the variables and their values associated with the configuration.

    Click the Associated DB Systems tab to see all the DB Systems that use the configuration.

    Click Delete if no DB System uses the configuration, and it is not required.