ansible-role-mysql
ansible-role-mysql copied to clipboard
geerlingguy
Ansible Role - MySQL
Need the ability to set `binlog_expire_logs_seconds` instead. See: https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_binlog_expire_logs_seconds
Before running this role as root, I had a custom role setup official Mariadb 10.6 repo on AlmaLinux 8.6 since i didnt want to use the default streams provided by...
When MySQL is configured to use [sql_mode ANSI_QUOTES](https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_ansi_quotes), the query in tasks/secure-installation.yml fails: ``` TASK [geerlingguy.mysql : Get list of hosts for the anonymous user.] ************************************************************************************************************************************** fatal: [0.0.0.0]: FAILED! =>...
My OS is centOS 7.9, and the pid file is placed in directory "/var/run/mariadb" and after I reboot my machine, the directory is deleted, result in the failure of mysql...
If I'm not wrong, to check the replica status, we can't use the `mysql_replication_user` user, as it's only created on the primary MySQL instance (and here we're on the replica...
Mode name has changed. Here the patch to make this work again.
Disable Starting of MySQL Server on Debian based systems during install.
Instead of hard-coding an insecure default password for the `root` MySQL user, generate a random one as discussed in issue #223. This is more complicated than simply adding a random...
This role contains some removed variables that don't allow MySQL server to run/init: ``` query_cache_type query_cache_size query_cache_limit innodb_large_prefix innodb_file_format ``` Checking the `sudo cat /var/log/mysql/mysql.err` file: ``` ... 2022-04-03T17:41:40.978362Z 0...
