16.1 Creating a MySQL Configuration

Use the HeatWave Console to create a new MySQL configuration.

Note:

It is not possible to change the values of any variables once a configuration has been created. However, you can create a custom configuration by copying and modifying an existing configuration. You can then update your DB system's configuration using your custom configuration.

Follow these steps to create your MySQL configuration:

1. In the HeatWave Console, select the HeatWave 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. On the General Information page of the Create MySQL Configuration dialog, provide the following information:

   • Basic information:

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

     • Description: Specify a simple description for the configuration.

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

4. Click Next. On the Configuration Variables page of the dialog, provide the following information:

   • Support HeatWave: Select this option to ensure that this MySQL Configuration supports HeatWave.

   • Initialization variables: Set preferred values for (and only for) initialization variables whose values you want to be different from the default setting.

     • 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. If no value is selected or entered, the value in the base configuration you are copying (shown in the value box) is used.

     • Click X to remove a variable you have selected by the steps above, if you change your mind and no longer want to set a value for it.

     • Click the information icon to show the default value of the variable you have selected. A Learn More link for more information on the selected variable also appears.

     • Click the setting icon to reset a selected variable to its default value, if it has been set to something else.

   • User variables: Set preferred values for (and only for) user variables whose values you want to be different from the default settings.

     • 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. If no value is selected or entered, the value in the base configuration you are copying (shown in the value box) is used. For any variables of the string data type, an empty value field means an empty string, except for nullable variables such as innodb_ft_server_stopword_table , for which an empty value field is taken as MYSQL NULL (i.e., a null value).

     • Click Add new variable to set more variables with the steps above, until you specified all the variables you want to.

     • Click X to remove a variable you have selected or added by the steps above, if you change your mind and no longer want to set a value for it.

     • Click the information icon to show the default value of the variable you have selected. A Learn More link for more information on the selected variable also appears.

     • Click the setting icon to reset a selected variable to its default value, if it has been set to something else.

5. Click Next. On the Review Configuration page of the dialog, review all the variable values you have selected in Step 4 above.

   Select a filter to show the variables and their values associated with the configuration:

   • All: Show all configuration variables (default)
   • Dynamic: Show all configuration variables that are dynamic and can be set at runtime.
   • Shape or feature specific: Show all configuration variables that have MySQL shape or feature-specific values.
   • Default: Show all configuration variables that have not been set by users.
   • User-defined: Show all configuration variables that have been set by users. User-defined variables are those that have ever been set in the dialog when the configuration was created. The actual value of the variable does not matter: for example, you could have selected a variable in the configuration dialog and then left its displayed value (which was the value from your base configuration) unchanged, but the variable would still be taken as "user-defined" and displayed by this filter.

   You can also refine the list by typing into the search bar part of the names of the variables you are interested in.

   Click Back to go back and edit any variable values if needed.

   Click X to remove a variable that you have added in the Step 4.

6. Click Create after you are happy with your configuration.

   HeatWave MySQL checks the values for each variable. If any values fail validation, the message Could not create MySQL Configuration appears together with the names of the failed variables. Correct any invalid values, and click Create again.

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

To review the default values for the MySQL global system variables and choose you preferred values, see the related links below. Notice that certain MySQL global system variables define whether a configuration can support HeatWave.