MySQL role
Deploy MySQL database container.
Usage
Configure the role.
# https://hub.docker.com/_/mysql
mysql_image: mysql:8
mysql_hostname: mysql01
mysql_description: database for moodle # default: MySQL
mysql_volume_name: mysql_data01 # default: "{{ mysql_hostname }}"
mysql_data_dir: /usr/share/mysql # default: "/usr/share/{{ mysql_hostname }}"
mysql_root_password: # default: "{{ vault_mysql_root_password }}"
mysql_database: example
mysql_user: example
mysql_password: # default: "{{ vault_mysql_password }}"
mysql_memory_limit: 4294967296 # default: 2147483648 (2 GB)
mysql_backup_set: # See restic_backup_set var in role restic
And include it in your playbook.
- hosts: mysql
roles:
- role: mysql
The following tags are available:
- mysql
- mysql_backup
Docs
Execute sql query in container
Enter the mysql cli with docker exec -it mysql01 sh -c 'mysql -u root -p"$MYSQL_ROOT_PASSWORD"'
and run the query:
show global variables like 'log_bin';