15.2 Copying a MySQL Configuration

While it is not possible to change the values of any variables once a configuration has been created, 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 copy a MySQL configuration and create a custom configuration out of it:

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

2. On the Configurations page, select a base configuration you want to copy and then click Copy MySQL Configuration to open the Copy MySQL Configuration dialog.

3. On the General Information page of the Copy 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.

   • Source MySQL Configuration shape: The MySQL shape of the configuration you are copying is displayed (it cannot be changed).

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) any initialization variables whose values you want to be different from the base configuration you are copying:

     • 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.

   • User variables: Set preferred values for (and only for) any user variables whose values you want to be different from the base configuration you are copying.

     • 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.

     Note:

     User variables in the base configuration you are copying are pre-selected here and pre-populated with their values in the base configuration. They are not removable by the X button, and will remain as user variables in the new custom configuration you are creating.

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-specific 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 a configuration dialog when the configuration or its base 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 Copy 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 Copy 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.