MySQL HeatWave on AWS  /  ...  /  Update MySQL Configuration

3.4.4 Update MySQL Configuration

Update the MySQL configuration for a DB System. This will change the user configurable system variables for the DB System to the values in the new configuration. See User-Configurable System Variables.

Note:

You cannot change the System Initialization Variables by updating the DB System's configuration. If you try to update your DB System with a MySQL configuration containing different system initialization variable values from those your DB System's, the update will fail.

During the update, the DB System will be in the UPDATING state until the update is finished. If the new configuration changes any system variables that are not dynamic, the MySQL database process, mysqld, will restart. If the DB System has an attached HeatWave Cluster, it will restart and reload data from the DB System.

If an update fails, the DB System will be rolled back to its original configuration. But if the rollback fails, the DB System will end up in the UPDATING_ERROR state.

To update the MySQL configuration for a DB System, make sure it is running, and follow these steps:

  1. In the MySQL HeatWave Console, select the MySQL tab.

  2. On the DB Systems tab, in the list of DB Systems, find the DB System to update, and do one of the following:

    • Click on the row of the DB System to highlight it, and choose Update MySQL Configuration from the Actions menu.

    • Click the name of the DB System to open the DB System Details page, and from the Actions menu choose Update MySQL Configuration.

  3. Click Change. The Select MySQL Configuration for shape … dialog box appears.

  4. Select the desired MySQL configuration from a list. Select a filter for the list:

    • Any: Show any configuration that can be applied to your DB System
    • Default: Show the default configuration for the MySQL shape of your DB System.
    • Custom: Show all custom configurations you have created by Creating a MySQL Configuration or Copying a MySQL Configuration that are applicable to your DB System.

    Refine the list by typing into the search bar part of the names of the configurations you are interested in.

    Note:

    Only configurations that support the DB System's shape are shown. Also, if a DB System has a HeatWave Cluster attached, only configurations that support HeatWave are shown; to change the configuration to one that does not support HeatWave, remove the DB System's HeatWave Cluster.

    Click Apply MySQL Configuration to confirm your choice.

  5. Click Update to actually apply the configuration to your DB System.

    If any problems occur updating the configuration, the DB System will roll back to its previous configuration.