ansible-role-mysql icon indicating copy to clipboard operation
ansible-role-mysql copied to clipboard

Do not delete `ib_logfile0` on MariaDB 10.8.1 or higher

Open pfrenssen opened this issue 1 year ago • 2 comments

Starting with MariaDB 10.8.1 the ib_logfile0 is required and should not be deleted (ref. MDEV-27199: Require ib_logfile0 to exist.

pfrenssen avatar Jul 02 '24 22:07 pfrenssen

https://github.com/geerlingguy/ansible-role-mysql/blob/d769e8b35567594c7ca607bf6955ef5ff8e8abfb/tasks/setup-Debian.yml#L33-L42 - what about logfile1?

geerlingguy avatar Jul 02 '24 22:07 geerlingguy

logfile1 is seemingly already obsolete in MariaDB since 10.5.0. In that version they switched to using 1 single log file. I found the ticket: MDEV-20907: Set innodb_log_files_in_group=1 by default.

pfrenssen avatar Jul 02 '24 22:07 pfrenssen

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

Please read this blog post to see the reasons why I mark issues as stale.

github-actions[bot] avatar Nov 02 '24 20:11 github-actions[bot]

This issue has been closed due to inactivity. If you feel this is in error, please reopen the issue or file a new issue with the relevant details.

github-actions[bot] avatar Jan 04 '25 20:01 github-actions[bot]