MySQL

Provision a MySQL server. This role will optionally configure SSL, an admin account, unique server-id, log to syslog, daily backups and a mail alias. Configuration templates can be placed inside templates/mysql/conf.d/ either inside the role or relative to the playbook. Other configuration is out of scope for this role and are left to user using the configuration templates.

Requirements

See meta/main.yml and assertions at the top of tasks/main.yml.

Role Variables

See defaults/main.yml.

Dependencies

See meta/main.yml.

Example Playbook

See tests/playbook.yml.

Testing

Testing requires Python 2.7, Tox, Vagrant and Virtualbox. To test simply run tox. Pre-commit is also setup for this project.

License

This software is licensed under the MIT license (see the LICENSE.txt file).

Author Information

Nimrod Adar, contact me or visit my website. Patches are welcome via git send-email. The repository is located at: https://www.shore.co.il/git/.

TODO

• More thorough, applicative tests.
• A backup script that saves each database in its own file but in a single transaction without locking.