# Options specific to server applications, see
# https://mariadb.com/kb/en/configuring-mariadb-with-option-files/
# server-option-groups

# Options specific to all server programs
[server]

# Options specific to MariaDB server programs
[server-mariadb]

#
# Options for specific server tools
#

[mysqld]
user                            = mysql
# port                          = 3306 # inherited from /usr/local/etc/mysql/my.cnf
# socket                        = /var/run/mysql/mysql.sock # inherited from /usr/local/etc/mysql/my.cnf
bind-address                    = 0.0.0.0
basedir                         = /usr/local
net_retry_count                 = 16384
log_error                       = /var/log/mysql/mysqld.err
datadir                         = /var/db/mysql/data
log_error                       = /var/db/mysql/log/error.log
innodb_log_group_home_dir       = /var/db/mysql/log
#audit_log_file                 = /var/db/mysql/log/audit.log
general_log_file                = /var/db/mysql/log/general.log
log_bin                         = /var/db/mysql/log/mysql-bin
relay_log                       = /var/db/mysql/log/relay.log
slow_query_log_file             = /var/db/mysql/log/slow.log
aria_log_dir_path               = /var/db/mysql/log
innodb_data_home_dir            = /var/db/mysql/data
innodb_doublewrite              = 0
innodb_use_atomic_writes        = 0
innodb_use_native_aio           = 0
innodb_flush_neighbors          = 0
innodb_log_write_ahead_size     = 16384
#innodb_flush_method            = O_DSYNC
innodb_flush_method             = fsync
sync_binlog                     = 1
innodb_buffer_pool_size         = 2G
innodb_flush_log_at_trx_commit  = 1

# Options read by `mariadb_safe`
# Renamed from [mysqld_safe] starting with MariaDB 10.4.6.
[mariadb-safe]

# Options read my `mariabackup`
[mariabackup]

# Options read by `mysql_upgrade`
# Renamed from [mysql_upgrade] starting with MariaDB 10.4.6.
[mariadb-upgrade]

# Specific options read by the mariabackup SST method
[sst]

# Options read by `mysqlbinlog`
# Renamed from [mysqlbinlog] starting with MariaDB 10.4.6.
[mariadb-binlog]

# Options read by `mysqladmin`
# Renamed from [mysqladmin] starting with MariaDB 10.4.6.
[mariadb-admin]