Skip to content

Instantly share code, notes, and snippets.

@jburwell
Last active April 19, 2016 16:30
Show Gist options
  • Save jburwell/fb5e576810967cc1d2af to your computer and use it in GitHub Desktop.
Save jburwell/fb5e576810967cc1d2af to your computer and use it in GitHub Desktop.
#
# 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]
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
# Set the max connections consistent with the Blue Valley environment.
# 350 is the suggestion in the CloudStack installation documentation.
max_connections=350
# Per CloudStack documentation, we use the ROW binlog format
log-bin=mysql-bin
binlog-format = 'ROW'
# Expiring binlogs every 10 days will provide enough history to
# support backup operations ...
expire_logs_days=10
# Prevent logs from growing to more than 300 MB in size ...
max_binlog_size = 307200
# this is only for the mysqld standalone daemon
[mysqld]
# 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]
[mariadb-5.5]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment