search

geerlingguy / ansible-role-mysql

Ansible Role - MySQL
https://galaxy.ansible.com/geerlingguy/mysql/
MIT License
1.05k stars 861 forks source link

Do not delete `ib_logfile0` on MariaDB 10.8.1 or higher #546

Open pfrenssen opened 2 months ago

pfrenssen commented 2 months ago

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

geerlingguy commented 2 months ago

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

pfrenssen commented 2 months ago

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.