ansible-role-mysql
ansible-role-mysql copied to clipboard
geerlingguy
Ansible Role - MySQL
I wanted to save my mysql password in my ansible vault. Unfortunately the role fails here: `TASK [geerlingguy.mysql : Ensure MySQL users are present.] *********************************************************************************************************************************** fatal: [XXX]: FAILED! => {"censored":...
Allows to confgure `binlog_expire_logs_seconds`, `table_definition_cache`, `temptable_max_ram`. #462 is fixed.
I think that setting a default password of 'root' is dangerous. Instead, it might be worth considering: * aborting with an error if no password is defined * setting a...
There are a lot of deprecated variables in MySQL/InnoDB/MariaDB. Example: [MDEV-23397](https://jira.mariadb.org/browse/MDEV-23397). Filling ticket to compile a full list of deprecated variables but used by this role. Then I'll follow up...
Not sure if this something you want to fix in the your defaults, but this was quite surprising to us: Mysql 8 comes with a plugin called "mysql x" that...
See: [Testing Ansible Roles for Multiple Hosts or Clusters with Molecule](https://medium.com/swlh/testing-ansible-roles-for-multiple-hosts-or-clusters-with-molecule-e4e67a2d0d83). I would like to add a test scenario in Molecule that tests with at least a master/slave (primary/replica) setup,...
For replication, the playbook skips all tasks. Probably because of the following condition tasks/replications.yml: `(slave.Is_Slave is defined and not slave.Is_Slave) or (slave.Is_Slave is not defined and slave is failed)` The...
In tasks/replication.yml This errors occurs while I'm testing this role on vagrant guests. Problem 1 has a `delegate_to: "{{ mysql_replication_master }}` option which in my case needed a `remote_user` to...
Per https://galaxy.ansible.com/geerlingguy/mysql, I installed the role, ansible-galaxy install geerlingguy.mysql playbooks/install_database.yaml: ``` - hosts: database user: ubuntu become: yes vars_files: - ../vars/database.yaml roles: - role: geerlingguy.mysql ``` vars/database.yaml ``` mysql_databases: -...
I'm on 4.3.4 and just saw this warning: ``` […] TASK [geerlingguy.mysql : Ensure MySQL users are present.] ******************************************************************************************************************************************************************** ok: [myhost.example.com] => (item={'name': 'app', 'host': 'localhost', 'password': 'geheim', 'priv': {'app.*':...
