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

Authentic ๐Ÿ“‹ Debian 13 (Trixie) 21 lines

Compatibility

Currently viewing:
Debian 13 (Trixie)
Also compatible:
Different versions:

File Info

Size
21 lines
MD5
655c85e18aeac0f013c8a87c6d182180
SHA256
5947436003b8eb0a65f1212817e55ca024954ac49cbfa429bc477a8af70f851a

Quick Commands

curl:
curl https://exampleconfig.com/api/v1/config/original/655c85e18aeac0f013c8a87c6d182180?hint=60-galera.cnf
wget:
wget -O 60-galera.cnf https://exampleconfig.com/api/v1/config/original/655c85e18aeac0f013c8a87c6d182180?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/mariadb
# 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 13 (Trixie). Safe baseline, but customize for your requirements.

How does this differ from other OS versions?

This config is from Debian 13 (Trixie). 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.