Overview of Configuration

The configuration of a DB system is a collection of user, system, initialization, or service-specific variables that define the operation of a MySQL DB system.

A configuration has a default set of user and system variables assigned to them. You can edit the user variables while you cannot edit the system variables. The configuration is analogous to the my.ini or my.cnf files that you use in the local installation of the MySQL Server.

MySQL HeatWave Service supports two types of configuration, default and custom configuration. You can either select the default configuration or create a new custom configuration. The configuration is linked to the shape you select. Shapes define the resources available to the DB system. See Supported Shapes.

  • Default Configuration: Each default configuration is designed for a specific shape and contains a default set of configuration variables.
  • Custom Configuration: You can create a new custom configuration, or copy an existing configuration, edit it, and edit the DB system to use the new configuration.

    When you create a new custom configuration, you select a shape for the DB system. The selected shape has a default configuration associated it. This default configuration becomes your custom configuration, and the DB system inherits all variables of the default configuration. For example, if you create a custom configuration and select the MySQL.VM.Standard.E3.1.8GB shape, the configuration of your new custom configuration is MySQL.VM.Standard.E3.1.8GB.Standalone. See Creating a Custom Configuration.

    If you create a configuration by copying an existing configuration, the original configuration is the parent to the copy. The copy inherits all variables defined on the parent.