MariaDB /etc/mysql/mariadb.conf.d/60-galera.cnf

Authentic ๐Ÿ“‹ Debian 12 (Bookworm) 21 lines

Compatibility

Currently viewing:
Debian 12 (Bookworm)
Also compatible:
Debian 11 (Bullseye) Ubuntu 22.04 LTS (Jammy Jellyfish) Ubuntu 24.04 LTS (Noble Numbat)
Different versions:

File Info

Size
21 lines
MD5
e2f4b79114ba923199ead4b7e94eee70
SHA256
fd9c188f54cfc21080ee06109869f0c658d8010e6a595a8ac9eee195ac97d44b

Quick Commands

curl:
curl https://exampleconfig.com/api/v1/config/original/e2f4b79114ba923199ead4b7e94eee70?hint=60-galera.cnf
wget:
wget -O 60-galera.cnf https://exampleconfig.com/api/v1/config/original/e2f4b79114ba923199ead4b7e94eee70?hint=60-galera.cnf
/etc/mysql/mariadb.conf.d/60-galera.cnf
#
# * Galera-related settings
#
# See the examples of server wsrep.cnf files in /usr/share/mysql
# and read more at https://mariadb.com/kb/en/galera-cluster/

[galera]
# Mandatory settings
#wsrep_on                 = ON
#wsrep_cluster_name       = "MariaDB Galera Cluster"
#wsrep_cluster_address    = gcomm://
#binlog_format            = row
#default_storage_engine   = InnoDB
#innodb_autoinc_lock_mode = 2

# Allow server to accept connections on all interfaces.
#bind-address = 0.0.0.0

# Optional settings
#wsrep_slave_threads = 1
#innodb_flush_log_at_trx_commit = 0

How to Install MariaDB

Alpine Linux

sudo apk add mariadb

Debian

sudo apt update && sudo apt install mariadb-server

Red Hat Enterprise Linux

sudo yum install mariadb-server

Ubuntu

sudo apt update && sudo apt install mariadb-server

Configuration File Location

File Path
/etc/mysql/mariadb.conf.d/60-galera.cnf
Directory
/etc/mysql/mariadb.conf.d/
Significance
System-wide configuration directory
Description
Files in /etc/ contain system-wide configuration settings that affect all users.

Quick Answers

When should I use this 60-galera.cnf?

Use this file to restore MariaDB defaults after misconfiguration, for fresh installations, or as a customization baseline.

How do I restore MariaDB defaults?

Download this file, backup your current config, then replace /etc/mysql/mariadb.conf.d/60-galera.cnf. Restart MariaDB service.

Is 60-galera.cnf safe for production?

Factory default from MariaDB on Debian 12 (Bookworm). Safe baseline, but customize for your requirements.

How does this differ from other OS versions?

This config is from Debian 12 (Bookworm). Other OS versions may have different defaults. Check compatibility section.

Can I use this for MariaDB troubleshooting?

Yes, compare this original config with your current settings to identify problematic modifications.