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