2013-11-11 MariaDB my.cnf

my.cnf

# cat /etc/my.cnf.d/server.cnf
#
# 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]
general_log_file=/var/log/mysql/mysqld.log
general_log=1
log_warning=2
log-error=/var/log/mysql/error.log
#log-bin=/var/log/mysql-bin.log
log-slow-queries=/var/log/mysql/mysql-slow-queries.log

# this is only for the mysqld standalone daemon
[mysqld]
datadir=/var/lib/mysql
port            = 3306
socket=/var/lib/mysql/mysql.sock
datadir=/var/lib/mysql
skip-external-locking
key_buffer      = 256M
max_allowed_packet      = 1M
table_cache     = 256
sort_buffer_size        =       2M
read_buffer_size        =       512k
#read_rnd_buffer_size   =       4M
#myisam_sort_buffer_size =      64M ##We dont use MyISAM, leave at default
thread_cache_size       =       80
query_cache_size        =       512M ##Upped from 256
query_cache_limit       =       10M
thread_concurrency      =       8
max_connections         =       400
#skip-federated
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 20M
innodb_flush_method = O_DIRECT  #added 8/3/2013 per tuning guide; potential for degradation on SAN... remove me first

innodb_log_file_size    = 1024M #Set to 25% of buffer pool size
innodb_log_buffer_size  = 8M
innodb_flush_log_at_trx_commit  = 2

innodb_file_per_table   =       1

user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

## This option should allow to change the passwords
#skip-grant-tables


[mysqldump]
quick
max_allowed_packet      = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer              = 64M
sort_buffer_size        = 64M
read_buffer             = 2M
write_buffer            = 2M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

# this is only for embedded server
[embedded]

# This group is only read by MariaDB-5.5 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mysqld-5.5]

# These two groups are 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]
wsrep_cluster_address=gcomm://mariadb-server-1.net,mariadb-server2.net
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
binlog_format=ROW
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
wsrep_cluster_name=corp-zabbix-server
wsrep_debug=on
wsrep_sst_auth=mariadb-user:cerner
wsrep_sst_method=mysqldump
wsrep_on=ON

[mariadb-5.5]