| 1 | # |
|---|
| 2 | # These groups are read by MariaDB server. |
|---|
| 3 | # Use it for options that only the server (but not clients) should see |
|---|
| 4 | # |
|---|
| 5 | # See the examples of server my.cnf files in /usr/share/mysql/ |
|---|
| 6 | # |
|---|
| 7 | |
|---|
| 8 | # this is read by the standalone daemon and embedded servers |
|---|
| 9 | [server] |
|---|
| 10 | |
|---|
| 11 | # this is only for the mysqld standalone daemon |
|---|
| 12 | # Settings user and group are ignored when systemd is used. |
|---|
| 13 | # If you need to run mysqld under a different user or group, |
|---|
| 14 | # customize your systemd unit file for mysqld/mariadb according to the |
|---|
| 15 | # instructions in http://fedoraproject.org/wiki/Systemd |
|---|
| 16 | [mysqld] |
|---|
| 17 | #datadir=/var/lib/mysql |
|---|
| 18 | #datadir=/localdata/mysql |
|---|
| 19 | datadir=/svrdb/mariadb10.5/jkjarchiver-ap |
|---|
| 20 | socket=/var/lib/mysql/mysql.sock |
|---|
| 21 | log-error=/var/log/mariadb/mariadb.log |
|---|
| 22 | pid-file=/run/mariadb/mariadb.pid |
|---|
| 23 | |
|---|
| 24 | # Disabling symbolic-links is recommended to prevent assorted security risks |
|---|
| 25 | symbolic-links=0 |
|---|
| 26 | |
|---|
| 27 | # Use utf8 (3-bytes unicode) to avoid 767-bytes problem. |
|---|
| 28 | # Column size will exceed 767-bytes when the default charset, utf8mb4 (4-bytes unicode) is used. |
|---|
| 29 | character-set-server = utf8mb3 |
|---|
| 30 | collation-server = utf8_general_ci |
|---|
| 31 | |
|---|
| 32 | # |
|---|
| 33 | innodb_flush_log_at_trx_commit = 1 |
|---|
| 34 | |
|---|
| 35 | # |
|---|
| 36 | # * Galera-related settings |
|---|
| 37 | # |
|---|
| 38 | [galera] |
|---|
| 39 | # Mandatory settings |
|---|
| 40 | #wsrep_on=ON |
|---|
| 41 | #wsrep_provider= |
|---|
| 42 | #wsrep_cluster_address= |
|---|
| 43 | #binlog_format=row |
|---|
| 44 | #default_storage_engine=InnoDB |
|---|
| 45 | #innodb_autoinc_lock_mode=2 |
|---|
| 46 | # |
|---|
| 47 | # Allow server to accept connections on all interfaces. |
|---|
| 48 | # |
|---|
| 49 | #bind-address=0.0.0.0 |
|---|
| 50 | # |
|---|
| 51 | # Optional setting |
|---|
| 52 | #wsrep_slave_threads=1 |
|---|
| 53 | #innodb_flush_log_at_trx_commit=0 |
|---|
| 54 | |
|---|
| 55 | # this is only for embedded server |
|---|
| 56 | [embedded] |
|---|
| 57 | |
|---|
| 58 | # This group is only read by MariaDB servers, not by MySQL. |
|---|
| 59 | # If you use the same .cnf file for MySQL and MariaDB, |
|---|
| 60 | # you can put MariaDB-only options here |
|---|
| 61 | [mariadb] |
|---|
| 62 | |
|---|
| 63 | # This group is only read by MariaDB-10.5 servers. |
|---|
| 64 | # If you use the same .cnf file for MariaDB of different versions, |
|---|
| 65 | # use this group for options that older servers don't understand |
|---|
| 66 | [mariadb-10.5] |
|---|
| 67 | |
|---|
