Oracle Cloud Infrastructure Documentation

Managing a Configuration

You can edit a custom configuration, copy a configuration, update the configuration of a DB system, or compare two configurations.

Editing a Custom Configuration

You can edit the name, description, and tags of a custom configuration. You cannot edit a default configuration.

Using the Console

Use the Console to edit a custom configuration.

  1. Open the navigation menu and select Databases. Under MySQL HeatWave, click Configurations.
  2. Locate the custom configuration you want to edit and do one of the following:
    • Click the Actions menu and select Edit to open the Edit MySQL Configuration dialog box.
    • Click the name of the configuration to open the Configuration Details page and click Edit.
  3. In the Edit Configuration dialog box, edit the configuration name, description, and tags.
  4. Click Save Changes.

Copying a Configuration

You can copy either an existing custom configuration or a default configuration, and create a new custom configuration.

Using the Console

Use the Console to copy a configuration.

  1. Open the navigation menu and select Databases. Under MySQL HeatWave, click Configurations.
  2. Click the Actions menu on the same line as the configuration you want to copy, and select Copy Configuration.
  3. In the Copy Configuration panel, in the Configuration Information section, provide the following details:
    • Name: Specify a user-friendly display name for the configuration. The name does not need to be unique. An Oracle Cloud Identifier (OCID) uniquely identifies the configuration.
    • Description: (Optional) Specify a description of the configuration.
    • Configure placement and hardware:
      • Select a Compartment: (Optional) If you want to create the configuration in a different compartment, select the required compartment.
      • Select a Shape: You cannot change the shape associated with the configuration.
    • Show Advanced Options:
      • Tags: (Optional) Specify a Tag Namespace, Tag Key, and Tag Value.
  4. Click Next.
  5. In the Variables Information section, provide the following details:
    • Initialization Variables: (Optional) Enable Ignore case in table and schema names to disable case sensitivity. See Initialization Variables.
    • User Variables: (Optional) Select the variable you want to add in Variable Names drop down list, and specify the Variable Value. To add another variable to your configuration, click +Another Variable .

      Every configuration has a set of default user variables. If you do not select any variable, Oracle adds the default variables to your Configuration. See Configuration Variables. See User Variables.

    • System Variables: You cannot edit the system variables. See System Variables.
  6. Click Copy.

Updating the Configuration of a DB System

Update the configuration of a DB system to an already existing configuration or create a new configuration using the variables you require. Once you save the configuration, you can not edit the variables of the configuration.

When you update the configuration of a DB system from a custom configuration, which is not created recently, to the default configuration, it can result in restarting the MySQL Server. In such cases, plan the configuration update during a period when restart can be tolerated, or if you want to update the configuration immediately, copy the custom configuration, and add the configuration variables that are dynamic.

Using the Console

Use the Console to update the configuration of a DB system.

Do the following to update the configuration of a DB system:

  1. (Optional) Create a new configuration. See Creating a Custom Configuration.
  2. Edit the DB system to update the configuration. See Editing a DB System.
    Note

    You cannot update the configuration if there is an active channel connected to the DB system. Stop the channel to update the configuration.

Using the CLI

Use the command-line interface to update the configuration of a DB system.

This task requires the following:
  • A DB system Oracle Cloud Identifier (OCID).
  • A MySQL configuration OCID.
  • A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
  1. (Optional) Create a new configuration. See Creating a Custom Configuration.
  2. Open a command prompt and run the following command:
    oci mysql db-system update 
     --db-system-id <DBSystemOCID>
     --configuration-id <ConfigurationOCID>
    • db-system-id: Specify the OCID of the DB system you want to update.
    • configuration-id: Specify the OCID of the configuration with which you want to replace the existing configuration.
    This command stops the running the MySQL Server and restarts it with the new configuration values.

Comparing Configurations

Compare the shapes, initialization variables, and user variables of two configurations.

Using the Console

Use the Console to compare two configurations.

  1. Open the navigation menu and select Databases. Under MySQL HeatWave, click Configurations.
  2. Select the check box of the two configurations you want to compare, click the Actions button at the top of the page, and then click Compare.
  3. In the Compare configurations panel, click either of the following option buttons:
    • Show configuration differences: Displays the differences in the shapes, initialization variables, and user variables.
    • Show all configuration information: Displays all information related to shapes, initialization variables, and user variables of the two configurations.
  4. Click Close.