MySQL Configuration

MySQL

MySQL is an open-source relational database management system.

The following settings are available via the Manifest file :

Option	Description	Clouds
`encoding`	Specify the encoding (AKA charset) for the database. Valid values can be found in the MySQL charset docs.	All
`engine`	Specify the MySQL engine you want to install. Valid values are `mysql` and `percona`	All
`groups`	Used to define multiple separate database groups (of the same type), each with their own configuration. The name of each group in your Manifest must match the names in your Dashboard.	All
`iam_instance_profile_name`	The name of the IAM instance profile that should be used when provisioning this server.	AWS
`instance_service_account_name`	The name of the GCE Service Account that should be used when provisioning this server.	GCE
`operating_system`	The version of Ubuntu to install on the server that hosts MySQL. Accepted values ubuntu2204orubuntu2404	All
`root_disk_size`	Default size of root disk (in GB) for servers used by MySQL. Default value is `50`.	AWS, Azure, GCE
`root_disk_type`	Disk type for servers used by MySQL, accepted values being `ssd` and `magnetic`. Default value is `ssd`.	AWS, GCE
`tags`	Append the listed tags to any servers created for this component. See our tagging guide for more info on tag syntax and support.	AWS, Azure, DigitalOcean, Hetzner
`tamper_with_yml`	Determines whether Cloud 66 can automatically update your database configuration (username, password and server address). Default is `yes`.	All
`version`	Specify the version of MySQL you want to install. Valid values are `5.7` or `8.0` NOTE: You can use database groups to run different versions of the same database in parallel with each other.	All

Example YAML for MySQL

mysql:
  configuration:
    version: 5.7
    root_disk_size: 100
    root_disk_type: ssd
    engine: percona
    encoding: koi8u
    iam_instance_profile_name: mysql-perms

If you need help specifying multiple databases of the same type via your Manifest, please read our guide on Database Groups.