# MySQL Configuration


## MySQL

[MySQL](https://www.mysql.com/) is an open-source relational database management system.

The following settings are available via the Manifest file :

|Option|Applied on|Description|Clouds|
|--- |--- |--- |--- |
|`encoding`||Specify the encoding (AKA charset) for the database. Valid values can be found in the [MySQL charset docs](https://dev.mysql.com/doc/refman/8.0/en/charset-charsets/).|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](/:product/:version?/databases/attaching-multiple-databases) (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](/:product/:version?/build-and-config/advanced-cloud-configurations#using-iam-instance-profiles-with-your-servers) that should be used when provisioning this server.|AWS|
|`instance_service_account_name`||The name of the [GCE Service Account](/:product/:version?/build-and-config/advanced-cloud-configurations#using-gce-service-accounts-with-cloud-66) 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 |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](/:product/:version?/servers/tagging-components) 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 `8.0` or `8.4` NOTE: You can use [database groups](/:product/:version?/databases/attaching-multiple-databases) to run different versions of the same database in parallel with each other.|All|

### Example YAML for MySQL

```yaml
mysql:
  configuration:
    version: 8.0
    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](/:product/:version?/manifest/_database-groups).