# All files in this package is subject to the GPL v2 license
# More information is in the COPYING file in the top directory of this package.
# Copyright (C) 2009 severalnines.com

[MYSQLD]
user=mysql
basedir=/srv/mysql/
datadir=/srv/mysql/data
pid-file=mysqld.pid
socket=/srv/mysql/data/mysql.sock
port=3306
ndb_cluster_connection_pool=16
ndbcluster
default_storage_engine=NDBCLUSTER
ndb_connectstring="172.21.0.201:1186;172.21.0.202:1186"
ndb_force_send=1
ndb_use_exact_count=0
ndb_extra_logging=1
ndb_autoincrement_prefetch-sz=1024
engine_condition_pushdown=1
bind_address=0.0.0.0
skip_name_resolve
skip_innodb
safe_show_database
long_query_time = 3
#max_connections = 100000
max_connections = 3500
join_buffer_size = 4M
#REPLICATION SPECIFIC - GENERAL
server_id=11
#server-id=X
#REPLICATION SPECIFIC - MASTER
#log-bin=binlog
#LOGS
max_connect_errors = 100000
concurrent_insert = 2
table_lock_wait_timeout = 30
#log-err=error.log
log
log-slow-queries
server-id               = 21
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M

#OTHER THINGS, BUFFERS ETC
key_buffer_size=768M
max_allowed_packet = 128M
#sort_buffer_size = 24M
sort_buffer_size = 12M
#read_buffer_size = 4M
read_buffer_size = 2M
#read_rnd_buffer_size = 1024000
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 16M
#thread_cache_size=1024
thread_concurrency = 16
myisam_sort_buffer_size = 64M
#memlock
sysdate_is_now
thread_cache_size=16384
net_buffer_length=1048576
query_cache_type = 0
query_cache_limit=4M
query_prealloc_size=262144
query_alloc_block_size = 65536
query_cache_size = 512M
table_open_cache=64000
open_files_limit=65535
lower_case_table_names=1
wait_timeout=20
tmp_table_size = 8192M
max_heap_table_size = 8192M

[MYSQL]
socket=/srv/mysql/data/mysql.sock

[client]
socket=/srv/mysql/data/mysql.sock