Configure MySQL¶

Specify the version¶

The default version is 8.0 (LTS).

To override the version, update the server’s Pillar file:

mysql:
  version: '8.0'

Add users, groups and databases¶

To configure the database for an application:

Add a user for the application, in a private Pillar file, replacing PASSWORD with a strong password (uncheck Symbols) and USERNAME with a recognizable username:
```
mysql:
  users:
    USERNAME:
      password: "PASSWORD"
      host: "192.0.2.1"
```
By default, host is set to localhost.
Create the database for the application and grant all privileges to the new user, in a public Pillar file, replacing DATABASE and USERNAME:
```
mysql:
  databases:
    DATABASE:
      user: USERNAME
      host: "192.0.2.1"
```
Add the Pillar files to the top file entry for the application.

Configure MySQL¶

Note

Even if you don’t need to configure MySQL, you must still set the following, in order for its SLS file to be automatically included:

mysql:
  configuration: False

Put your configuration file in the salt/mysql/files/conf directory.
Set mysql.configuration in the server’s Pillar file:
```
mysql:
  configuration: myconfig
```
Deploy the server

The configuration file will be in the /etc/mysql/conf.d directory on the server.

Set up backups¶

Create and configure an S3 backup bucket
Configure the AWS CLI
In the server’s Pillar file, set mysql.backup.location to a bucket and prefix, for example:
```
mysql:
  backup:
    location: ocp-coalition-backup/database
```
Deploy the server