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:

1. 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"
   

2. Create the database for the application and grant all privileges to the new user. Replace DATABASE and USERNAME:

   mysql:
     users:
       USERNAME:
         password: "PASSWORD"
     databases:
       DATABASE:
         user: USERNAME
   

3. Add the private Pillar file 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

1. Put your configuration file in the salt/mysql/files/conf directory.

2. Set mysql.configuration in the server’s Pillar file:

   mysql:
     configuration: myconfig
   

3. Deploy the server

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

Set up backups

1. Create and configure an S3 backup bucket

2. Configure the AWS CLI

3. In the server’s Pillar file, set mysql.backup.location to a bucket and prefix, for example:

   mysql:
     backup:
       location: ocp-coalition-backup/database
   

4. Deploy the server