Name: ansible-mysql
Owner: EMBL-EBI Technology & Science Integration
Description: Ansible role to install and configure mysql database server
Created: 2017-07-10 11:04:41.0
Updated: 2017-07-10 15:09:59.0
Pushed: 2017-07-10 14:52:59.0
Size: 10
Language: Shell
GitHub Committers
User | Most Recent Commit | # Commits |
---|
Other Committers
User | Most Recent Commit | # Commits |
---|
Install and configure mysql database server.
This role adds the official mysql repository, but leaves it disabled. It also adds MySQL Python to use Ansible modules.
Select the version to install with mysql_version
. You should also change the root password, the default is mysql
.
The installation is secure following best practices found in the MySQL manual, ie removing anonymous users and the test database.
Multiple databases can be configured through mysql_databases
list. Databases, users and grants will be generated based on this list (see default/main.yml
for options).
A local backup cron job is installed under the mysqlbck
user. The template backup script is located in templates/backup_all.sh.j2
See meta/main.yml
.
See default/main.yml
.
None.
Example:
sts: servers
les:
- { role: mysql, mysql_version: 5.6, mysql_root_password: mypassword }
SELECT,RELOAD,FILE,SUPER,"LOCK TABLES","SHOW VIEW","SHOW DATABASES"
.Released under the MIT license.
Luis Gracia while at EMBL-EBI: