my.cnf.erb

# DEPLOYED BY CHEF
# MariaDB database server configuration file.
#
# You can copy this file to one of:
# - "<%= @mycnf_file %>" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...

<% if node['platform_family'] == 'debian' -%>
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
<% end -%>

[client]
port   = <%= @client_port %>
socket = <%= @client_socket %>
<% unless @client_host.nil? -%>
host   = <%= @client_host %>
<% end -%>
<% @client_options.each do |key, value| -%>
<%= key %> = <%= value %>
<% end -%>

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = <%= @mysqld_safe_socket %>
nice   = 0
<% @mysqld_safe_options.each do |key, value| -%>
<%= key %> = <%= value %>
<% end -%>

[mysqld]
user            = <%= @mysqld_user %>
<% unless @mysqld_pid_file.nil? -%>
pid-file        = <%= @mysqld_pid_file %>
<% end -%>
socket          = <%= @mysqld_socket %>
port            = <%= @mysqld_port %>
basedir         = <%= @mysqld_basedir %>
datadir         = <%= @mysqld_datadir %>
tmpdir          = <%= @mysqld_tmpdir %>
lc_messages_dir = <%= @mysqld_lc_messages_dir %>
lc_messages     = <%= @mysqld_lc_messages %>
<% if @mysqld_skip_external_locking -%>
skip-external-locking
<% end -%>
<% if @mysqld_skip_log_bin -%>
skip-log-bin
<% end -%>
<% if @mysqld_skip_name_resolve -%>
skip-name-resolve
<% end -%>
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
<% unless @mysqld_bind_address.nil? or @mysqld_bind_address.empty? -%>
bind-address    = <%= @mysqld_bind_address %>
<% end -%>

#
# * Fine Tuning
#
max_connections         = <%= @mysqld_max_connections %>
<% unless @mysqld_max_statement_time.nil? -%>
max_statement_time      = <%= @mysqld_max_statement_time %>
<% end -%>
connect_timeout         = <%= @mysqld_connect_timeout %>
wait_timeout            = <%= @mysqld_wait_timeout %>
max_allowed_packet      = <%= @mysqld_max_allowed_packet %>
thread_cache_size       = <%= @mysqld_thread_cache_size %>
sort_buffer_size        = <%= @mysqld_sort_buffer_size %>
bulk_insert_buffer_size = <%= @mysqld_bulk_insert_buffer_size %>
tmp_table_size          = <%= @mysqld_tmp_table_size %>
max_heap_table_size     = <%= @mysqld_max_heap_table_size %>

#
# * MyISAM
#
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched. On error, make copy and try a repair.
myisam_recover_options  = <%= @mysqld_myisam_recover_options %>
key_buffer_size         = <%= @mysqld_key_buffer_size %>
<% unless @mysqld_open_files_limit.nil? -%>
open-files-limit        = <%= @mysqld_open_files_limit %>
<% end -%>
table_open_cache        = <%= @mysqld_table_open_cache %>
myisam_sort_buffer_size = <%= @mysqld_myisam_sort_buffer_size %>
concurrent_insert       = <%= @mysqld_concurrent_insert %>
read_buffer_size        = <%= @mysqld_read_buffer_size %>
read_rnd_buffer_size    = <%= @mysqld_read_rnd_buffer_size %>

#
# * Query Cache Configuration
#
# Cache only tiny result sets, so we can fit more in the query cache.
query_cache_limit = <%= @mysqld_query_cache_limit %>
query_cache_size  = <%= @mysqld_query_cache_size %>
# for more write intensive setups, set to DEMAND or OFF
<% if @mysqld_query_cache_type.nil? -%>
#query_cache_type = DEMAND
<% else -%>
query_cache_type  = <%= @mysqld_query_cache_type %>
<% end -%>

#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
general_log_file    = <%= @mysqld_general_log_file %>
general_log         = <%= @mysqld_general_log %>
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# we do want to know about network errors and such
log_warnings        = <%= @mysqld_log_warnings %>
#
# Enable the slow query log to see queries with especially long duration
#slow_query_log[={0|1}]
slow_query_log      = <%= @mysqld_slow_query_log %>
slow_query_log_file = <%= @mysqld_slow_query_log_file %>
long_query_time     = <%= @mysqld_long_query_time %>
log_slow_rate_limit = <%= @mysqld_log_slow_rate_limit %>
log_slow_verbosity  = <%= @mysqld_log_slow_verbosity %>
# Logging output type
log_output          = <%= @mysqld_log_output %>

#log-queries-not-using-indexes
#log_slow_admin_statements
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#report_host              = master1
#auto_increment_increment = 2
#auto_increment_offset    = 1
# not fab for performance, but safer
#sync_binlog = 1
# slaves
#relay_log           = /var/log/mysql/relay-bin
#relay_log_index     = /var/log/mysql/relay-bin.index
#relay_log_info_file = /var/log/mysql/relay-bin.info
#log_slave_updates
#read_only
#
# If applications support it, this stricter sql_mode prevents some
# mistakes like inserting invalid dates etc.
#sql_mode = NO_ENGINE_SUBSTITUTION,TRADITIONAL

default_storage_engine = <%= @mysqld_default_storage_engine %>

#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

<% @mysqld_options.each do |key, value| -%>
<%= key %> = <%= value %>
<% end -%>

[mysqldump]
<% if @mysqldump_quick -%>
quick
<% end -%>
<% if @mysqldump_quote_names -%>
quote-names
<% end -%>
max_allowed_packet = <%= @mysqldump_max_allowed_packet %>

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = <%= @isamchk_key_buffer %>

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir <%= @extra_configuration_directory %>/