MariaDB config, CNF file

156 views
Skip to first unread message

Jørgen Staun Hansen

unread,
Jan 25, 2021, 4:33:40 AM1/25/21
to codership
Hi,


On my first setup of Galera and the tutorial video refer to the CNF file in /etc/my.cnf.d/server.cnf

I do not have this directory or file, instead I have these files : /etc/mysql/mariadb.conf.d

-rw-r--r-- 1 root root  577 Nov 10 13:14 50-client.cnf
-rw-r--r-- 1 root root  231 Nov 10 13:14 50-mysql-clients.cnf
-rw-r--r-- 1 root root  927 Nov 10 13:14 50-mysqld_safe.cnf
-rw-r--r-- 1 root root 3635 Nov 10 13:14 50-server.cnf
-rw-r--r-- 1 root root  494 Nov 10 13:14 60-galera.cnf
drwxr-xr-x 2 root root 4096 Jan 20 14:04 99-enable-encryption.cnf.preset


I am using Ubuntu 20.04 server and latest version of Galera MariaDB - has this changed or is it due to that I use Ubuntu and not CentOS?

and in my case should I use 50-server.cnf for the mysqld changes and the file 60-galera.cnf for the galera configurations that is mentioned in the video?

Jørgen Staun Hansen

unread,
Jan 25, 2021, 6:23:25 AM1/25/21
to codership
Might have solved it my self... I have the file 60-galera.cnf with the content mentionend in the video.

[galera]
# Mandatory settings
#wsrep_on = ON
#wsrep_provider =
#wsrep_cluster_address =
#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


So I will try to start editing this file.
Reply all
Reply to author
Forward
0 new messages