MYSQL

Ansible role for mysql. It's designed for my development environment but might reach sometimes production ready state.

Supported distributions:

• Debian
• Ubuntu

Supported MySQL distributions:

• MariaDB
• MySQL

Requirements

This role requires ansible >= 2.4.

Dictionaries are used for configuration. Partially overriding defaults needs

  hash_behaviour = merge

set in your ansible.cfg or

  ANSIBLE_HASH_BEHAVIOUR=merge

for your environment.

Role Variables

  mysql:
    packages:
      - mariadb-server
      - mariadb-client
      # or just use mysql
      #- mysql-server
      #- mysql-client
      - python-mysqldb
    charset: utf8mb4
    port: 3306
    socket: /var/run/mysqld/mysqld.sock
    datadir: /var/lib/mysql
    log_error: /var/log/mysql/error.log
    pid_file: /var/run/mysqld/mysqld.pid
    config_path: /etc/mysql/conf.d
    root_password: root
    users:
      - { name: dbuser, password: 123, privileges: '*.*:ALL' }

Dependencies

None.

Example Playbook

- hosts: servers
- include_role:
    name: injectedMonkey.php-fpm
  vars:
    mysql:
      packages:
        - mariadb-server
        - mariadb-client
        # or just use mysql
        #- mysql-server
        #- mysql-client
        - python-mysqldb
      charset: utf8mb4
      port: 3306
      socket: /var/run/mysqld/mysqld.sock
      datadir: /var/lib/mysql
      log_error: /var/log/mysql/error.log
      pid_file: /var/run/mysqld/mysqld.pid
      config_path: /etc/mysql/conf.d
      root_password: root
      users:
        - { name: dbuser, password: 123, privileges: '*.*:ALL' }

License

BSD

Author Information

injectedMonkey.wtf