mrlesmithjr / ansible-mysql

ansible-mysql

Ansible role to install/configure MySQL

Build Status

GitHub Actions

Travis CI

Requirements

For any required Ansible roles, review: requirements.yml

Role Variables

defaults/main.yml

Dependencies

Example Playbook

playbook.yml

License

MIT

Author Information

Larry Smith Jr.

• @mrlesmithjr
• [email protected]
• http://everythingshouldbevirtual.com

NOTE: Repo has been created/updated using https://github.com/mrlesmithjr/cookiecutter-ansible-role as a template.

ansible-mysql's Issues

item is undefined when managing databases

Full error with redacted path

fatal: [alpine-dns]: FAILED! => {"msg": "The task includes an option with an undefined variable. The error was: 'item' is undefined\n\nThe error appears to have been in '/home/jtl/<snip>/ansible-mysql/tasks/dbs.yml': line 2, column 3,

My playbook looks like this

---
- hosts: alpine-dns
  roles:
      - ansible-mysql
  vars:
      mysql_dbs:
          name: pdns
          state: present
      mysql_root_password: changme
      mysql_db_users:
          - name: pdns
            password: changeme
            state: present
            privs:
                - db: pdns
                  host: 127.0.0.1
                  table: "*"
                  priv: ALL

Cleanup Vars

Need to cleanup vars

collation_server and chatacter_set_client settings are ignored

changing these settings in user-consumed playbooks is ignored. potentially fix it by removing the comments from the mysql cnf file

#character_set_client = {{ mysql_settings['character_set_client'] }}
#collation_server = {{ mysql_settings['collation_server'] }}

Disable innodb_flush_log_at_timeout

Need to disable innodb_flush_log_at_timeout

Causes issues with many distro installs.