ansible-role-mysql
ansible-role-mysql copied to clipboard
geerlingguy
Ansible Role - MySQL
Our Ansible playbooks use this role and set the MySQL datadir like this: ``` mysql_datadir: /data/mysql ``` When this is set the plays fail with this error on every database...
https://www.drupal.org/project/drupal/issues/2833539#comment-12500749 Would like to discuss setting `transaction-isolation` to `READ-COMMITTED` by default as it solves a random, inconsistent flicker "SQLSTATE[40001]: Serialization failure: 1213 Deadlock" in some cases. The default is currently:...
should make a distinction between mariabdb and mysql as the two have some incompatibilities between them.
hello, it is possible to include support for rocky linux or rather enterprise linux family? thanks
Hello, we ran into the following issue: When we ran your mysql role, the replication didnt work on the slave on the first run. We had to do a second...
This allows it to be managed by the default logrotate configuration Fixes #540
The error messages in at least Ubuntu 20.04 for mysql get logged to syslog, so the mysql.err log is not handled by logrotate when this role is installed. looking at...
If the $ or % character is present in the root password, the password is not set correctly. If you escape with '/$' or '/%' the password is set correctly...
This PR addresses issue #535, to add the column_case_sensitive option to mysql_user to handle the case of the field names in the privileges.
I've changed the method for resetting the root user password in MySQL 8+ since `mysql_native_password` is no longer enabled by default. Link https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html Now, versions of MySQL 8.* are correctly...
