MariaDB 10.3 設定ファイル設計

Database関連

目次 †

概要 †

MariaDBにおける設定ファイル設計

設定ファイルの構成 †

設定はmy.cnfが参照する /etc/my.cnf.d 配下のファイルに行う方式。
用途別に設定ファイルが分かれるため、適切なファイルを編集する。

• /etc/my.cnf

  [client-server]
  
  !includedir /etc/my.cnf.d

デフォルト設定 †

mariadb-server-10.3.28 †

• auth_gssapi.cnf

  [mariadb]
  plugin-load-add=auth_gssapi.so

• client.cnf

  #
  # These two groups are read by the client library
  # Use it for options that affect all clients, but not the server
  #
  
  
  [client]
  
  # This group is not read by mysql client library,
  # If you use the same .cnf file for MySQL and MariaDB,
  # use it for MariaDB-only client options
  [client-mariadb]

• enable_encryption.preset

  #
  # !include this file into your my.cnf (or any of *.cnf files in /etc/my.cnf.d)
  # and it will enable data at rest encryption. This is a simple way to
  # ensure that everything that can be encrypted will be and your
  # data will not leak unencrypted.
  #
  # DO NOT EDIT THIS FILE! On MariaDB upgrades it might be replaced with a
  # newer version and your edits will be lost. Instead, add your edits
  # to the .cnf file after the !include directive.
  #
  # NOTE that you also need to install an encryption plugin for the encryption
  # to work. See https://mariadb.com/kb/en/mariadb/data-at-rest-encryption/#encryption-key-management
  # 
  [mariadb]
  aria-encrypt-tables
  encrypt-binlog
  encrypt-tmp-disk-tables
  encrypt-tmp-files
  loose-innodb-encrypt-log
  loose-innodb-encrypt-tables

• mariadb-server

  #
  # These groups are read by MariaDB server.
  # Use it for options that only the server (but not clients) should see
  #
  # See the examples of server my.cnf files in /usr/share/mysql/
  #
  
  # this is read by the standalone daemon and embedded servers
  [server]
  
  # this is only for the mysqld standalone daemon
  # Settings user and group are ignored when systemd is used.
  # If you need to run mysqld under a different user or group,
  # customize your systemd unit file for mysqld/mariadb according to the
  # instructions in http://fedoraproject.org/wiki/Systemd
  [mysqld]
  datadir=/var/lib/mysql
  socket=/var/lib/mysql/mysql.sock
  log-error=/var/log/mariadb/mariadb.log
  pid-file=/run/mariadb/mariadb.pid
  
  
  #
  # * Galera-related settings
  #
  [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 setting
  #wsrep_slave_threads=1
  #innodb_flush_log_at_trx_commit=0
  
  # this is only for embedded server
  [embedded]
  
  # This group is only read by MariaDB servers, not by MySQL.
  # If you use the same .cnf file for MySQL and MariaDB,
  # you can put MariaDB-only options here
  [mariadb]
  
  # This group is only read by MariaDB-10.3 servers.
  # If you use the same .cnf file for MariaDB of different versions,
  # use this group for options that older servers don't understand
  [mariadb-10.3]

• mysql-clients.cnf

  #
  # These groups are read by MariaDB command-line tools
  # Use it for options that affect only one utility
  # 
  
  [mysql]
  
  [mysql_upgrade]
  
  [mysqladmin]
  
  [mysqlbinlog]
  
  [mysqlcheck]
  
  [mysqldump]
  
  [mysqlimport]
  
  [mysqlshow]
  
  [mysqlslap]