MariaDB conf for Frappe

More about mariadb config from ansible playbook -

Latest Config here: https://github.com/frappe/bench/blob/develop/bench/playbooks/roles/mariadb/files/mariadb_config.cnf

Create a file /etc/my.cnf.d/frappe.cnf or /etc/mysql/mariadb.conf.d/frappe.cnf and add

For MariaDB <= 10.2

[mysqld]
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
default-character-set = utf8mb4

For MariaDB >= 10.3

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
default-character-set = utf8mb4

For MariaDB >= 10.6

https://discuss.erpnext.com/t/table-tabdefaultvalue-missing-error-when-creating-new-site/78019/10

Restart MariaDB