3.4.5 Update MySQL Shape

Users can reduce the shape of a DB System to save cost or expand the shape to enhance the function or performance. Decisions on shape changes are aided by the Autopilot Shape Advisor, which uses the system workload to access the suitability of a shape and make recommendations on shape changes.

Changing the shape will bring the DB System offline temporarily.

To update the MySQL shape or configuration for a DB System, make sure the DB System is in either the ACTIVE or INACTIVE state, and follow these steps:

1. In the HeatWave Console, select the Resources 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 from the Actions menu choose Update MySQL Shape .

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

3. On the Update MySQL Shape panel, provide the following information:
   • Hardware configuration
     • Shape: Select the shape you want to update your DB System to. See Supported Shapes.

       Note:

       If you do not choose a shape other than you current shape, you will not be able to proceed to the following steps.
   • MySQL Configuration: If you were previously using a default configuration, the corresponding default configuration for the new shape is displayed as the Selected MySQL Configuration. If you were previously using a custom configuration, you will need to select a new custom configuration or default configuration compatible with the new shape. To select or to change a configuration:
     • Click the Change button. The Select MySQL Configuration panel for shape … panel appears.

     • Select the desired MySQL configuration from a list. Select a filter:

       • Any: Show any configuration that can be applied to your DB System for the selected shape
       • Default: Show the default configuration for the selected 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 for the selected shape.

       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 selected shape are shown. Also, if your 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 Use MySQL Configuration to confirm your choice.

4. Click Update to actually apply the selected shape and configuration to your DB System.

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

Related Topics

• System Initialization Variables
• User-Configurable System Variables
• User-Configurable Shape-Dependent System Variables
• Creating a MySQL Configuration
• Copying a MySQL Configuration
• View MySQL Configuration Details

Parent topic: Managing a DB System