root@dbclu01:/etc/mysql# find . -type f
./debian-start
./conf.d/tokudb.cnf
./conf.d/mariadb.cnf
./conf.d/mysqld_safe_syslog.cnf
./conf.d/cluster.cnf
./debian.cnf
./my.cnf
root@dbclu01:/etc/mysql# find . -type f |xargs cat
#!/bin/bash
#
- This script is executed by "/etc/init.d/mysql" on every (re)start.
#
- Changes to this file will be preserved when updating the Debian package.
#
source /usr/share/mysql/debian-start.inc.sh
MYSQL="/usr/bin/mysql --defaults-file=/etc/mysql/debian.cnf"
MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
MYUPGRADE="/usr/bin/mysql_upgrade --defaults-extra-file=/etc/mysql/debian.cnf"
MYCHECK="/usr/bin/mysqlcheck --defaults-file=/etc/mysql/debian.cnf"
MYCHECK_SUBJECT="WARNING: mysqlcheck has found corrupt tables"
MYCHECK_PARAMS="--all-databases --fast --silent"
MYCHECK_RCPT="root"
- The following commands should be run when the server is up but in background
- where they do not block the server start and in one shell instance so that
- they run sequentially. They are supposed not to echo anything to stdout.
- If you want to disable the check for crashed tables comment
- "check_for_crashed_tables" out.
- (There may be no output to stdout inside the background process!)
echo "Checking for corrupt, not cleanly closed and upgrade needing tables."
- Need to ignore SIGHUP, as otherwise a SIGHUP can sometimes abort the upgrade
- process in the middle.
trap "" SIGHUP
(
upgrade_system_tables_if_necessary;
check_root_accounts;
check_for_crashed_tables;
) >&2 &
exit 0
[mariadb]
- See https://mariadb.com/kb/en/how-to-enable-tokudb-in-mariadb/
- for instructions how to enable TokuDB
#
- See https://mariadb.com/kb/en/tokudb-differences/ for differences
- between TokuDB in MariaDB and TokuDB from http://www.tokutek.com/
#plugin-load-add=ha_tokudb.so
- MariaDB-specific config file.
- Read by /etc/mysql/my.cnf
[client]
- Default is Latin1, if you need UTF-8 set this (also in server section)
#default-character-set = utf8
[mysqld]
#
- * Character sets
#
- Default is Latin1, if you need UTF-8 set all this (also in client section)
#
#character-set-server = utf8
#collation-server = utf8_general_ci
#character_set_server = utf8
#collation_server = utf8_general_ci
[mysqld_safe]
syslog
[mysqld]
query_cache_size=0
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
query_cache_type=0
bind-address=0.0.0.0
- Galera Provider Configuration
wsrep_provider=/usr/lib/galera/libgalera_smm.so
#wsrep_provider_options="gcache.size=32G"
- Galera Cluster Configuration
wsrep_cluster_name="clu02"
wsrep_cluster_address="gcomm://10.0.52.11,10.0.52.12,10.0.52.13"
- Galera Synchronization Congifuration
wsrep_sst_method=rsync
#wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=admin:admin
- Galera Node Configuration
wsrep_node_address="10.0.52.11"
wsrep_node_name="dbclu01"
- Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = SUPASECRET
socket = /db/data/mysql.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = SUPASECRET
socket = /db/data/mysql.sock
basedir = /usr
- Generated by Percona Configuration Wizard (http://tools.percona.com/) version REL5-20120208
- Configuration name db03.soteha.inc generated for andrea.cervesato@soteha.it at 2014-05-19 11:14:43
[mysql]
- CLIENT #
port = 3306
socket = /db/data/mysql.sock
[mysqld]
ignore-db-dir = lost+found
- GENERAL #
user = mysql
default-storage-engine = InnoDB
socket = /db/data/mysql.sock
pid-file = /db/data/mysql.pid
- MyISAM #
key-buffer-size = 32M
myisam-recover = FORCE,BACKUP
- SAFETY #
max-allowed-packet = 16M
max-connect-errors = 1000000
skip-name-resolve
- DATA STORAGE #
datadir = /db/data/
- BINARY LOGGING #
log-bin = /db/data/mysql-bin
expire-logs-days = 14
sync-binlog = 1
- CACHES AND LIMITS #
tmpdir = /db/temp
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 500
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 10240
- INNODB #
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 256M
innodb-flush-log-at-trx-commit = 2
innodb-file-per-table = 1
innodb-buffer-pool-size = 12G
- LOGGING #
log-error = /db/log/mysql-error.log
log-queries-not-using-indexes = 1
slow-query-log = 1
slow-query-log-file = /db/log/mysql-slow.log
!includedir /etc/mysql/conf.d/
root@dbclu01:/etc/mysql#
Additional packages informations:
root@dbclu03:~# lsb_release -r
Release: 14.04
root@dbclu03:~# uname -a
Linux dbclu03 3.13.0-24-generic #47-Ubuntu SMP Fri May 2 23:30:00 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
root@dbclu03:~# dpkg -l |egrep 'maria|galera'
ii galera 25.3.5-wheezy amd64 Galera Replication Framework
ii libmariadbclient18 10.0.11+maria-1~trusty amd64 MariaDB database client library
ii libmysqlclient18 10.0.11+maria-1~trusty amd64 Virtual package to satisfy external depends
ii mariadb-client-10.0 10.0.11+maria-1~trusty amd64 MariaDB database client binaries
ii mariadb-client-core-10.0 10.0.11+maria-1~trusty amd64 MariaDB database core client binaries
ii mariadb-common 10.0.11+maria-1~trusty all MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii mariadb-galera-server 10.0.10+maria-1~trusty all MariaDB database server with Galera cluster (metapackage depending on the latest version)
ii mariadb-galera-server-10.0 10.0.10+maria-1~trusty amd64 MariaDB database server with Galera cluster binaries
ii mysql-common 10.0.11+maria-1~trusty all MariaDB database common files (e.g. /etc/mysql/my.cnf)