Skip to content

Instantly share code, notes, and snippets.

@alzabo
Created October 10, 2014 02:37
Show Gist options
  • Save alzabo/0d96e407850bf5244984 to your computer and use it in GitHub Desktop.
Save alzabo/0d96e407850bf5244984 to your computer and use it in GitHub Desktop.
Notice: /Stage[main]/Mysql::Server::Config/File[/etc/my.cnf]/content:
--- /etc/my.cnf 2014-10-09 19:24:17.000000000 -0700
+++ /tmp/puppet-file20141009-7211-nekr4i-0 2014-10-09 19:33:45.000000000 -0700
@@ -1,63 +1,66 @@
# FILE MANAGED BY PUPPET
[client]
-port=3306
-socket="/var/lib/mysql/mysql.sock"
+port = 3306
+socket = /var/lib/mysql/mysql.sock
[isamchk]
-key_buffer_size=16M
+key_buffer_size = 16M
[mysqld]
-slow-query-log=1
-long_query_time=1
-basedir="/usr"
-bind-address="*"
-connect_timeout=10
-datadir="/var/lib/mysql"
-default_storage_engine=MyISAM
-expire_logs_days=0
-general_log_file="/var/log/MySQLGenLog"
-innodb_buffer_pool_dump_at_shutdown=ON
-innodb_buffer_pool_load_at_startup=ON
-innodb_buffer_pool_size=28962MB
-innodb_flush_method=O_DIRECT
-innodb_log_file_size=5242880
-interactive_timeout=30
-key_buffer_size=768M
-log-error="/var/lib/mysql/biz123.inmotionhosting.com.err"
-long_query_time=3
-max_allowed_packet=268435456
-max_binlog_size=1073741824
-max_connections=500
-max_delayed_threads=0
-max_user_connections=30
-myisam_recover_options=DEFAULT
-open_files_limit=50000
-pid-file="/var/lib/mysql/biz123.inmotionhosting.com.pid"
-port=3306
-query_cache_limit=1M
-query_cache_size=512M
-read_buffer_size=256M
-read_rnd_buffer_size=16M
-secure-auth=OFF
+basedir = /usr
+bind-address = "*"
+connect_timeout = 10
+datadir = /var/lib/mysql
+default_storage_engine = MyISAM
+expire_logs_days = 0
+general_log_file = /var/log/MySQLGenLog
+innodb_buffer_pool_dump_at_shutdown = ON
+innodb_buffer_pool_load_at_startup = ON
+innodb_buffer_pool_size = 28962MB
+innodb_flush_method = O_DIRECT
+innodb_log_file_size = 5242880
+interactive_timeout = 30
+key_buffer_size = 768M
+log-error = /var/lib/mysql/biz123.inmotionhosting.com.err
+long_query_time = 3
+max_allowed_packet = 5M
+max_binlog_size = 1073741824
+max_connections = 500
+max_delayed_threads = 0
+max_user_connections = 30
+myisam_recover_options = DEFAULT
+open_files_limit = 50000
+pid-file = /var/lib/mysql/biz123.inmotionhosting.com.pid
+port = 3306
+query_cache_limit = 1M
+query_cache_size = 512M
+read_buffer_size = 256M
+read_rnd_buffer_size = 16M
+secure-auth = OFF
skip-external-locking
-socket="/var/lib/mysql/mysql.sock"
-sort_buffer_size=256M
-ssl=false
-table_open_cache=4096
-thread_cache_size=384
-thread_concurrency=24
-thread_stack=256K
-tmpdir="/tmp"
-user=mysql
-wait_timeout=30
+slow_query_log = 1
+slow_query_log_file = /var/log/slowqueries
+socket = /var/lib/mysql/mysql.sock
+sort_buffer_size = 256M
+ssl = false
+ssl-ca = ""
+ssl-cert = ""
+ssl-key = ""
+table_open_cache = 4096
+thread_cache_size = 384
+thread_concurrency = 24
+thread_stack = 256K
+tmpdir = /tmp
+user = mysql
+wait_timeout = 30
[mysqld_safe]
-log-error="/var/lib/mysql/biz123.inmotionhosting.com.err"
-nice=0
-socket="/var/lib/mysql/mysql.sock"
+log-error = /var/lib/mysql/biz123.inmotionhosting.com.err
+nice = 0
+socket = /var/lib/mysql/mysql.sock
[mysqldump]
-max_allowed_packet=5M
+max_allowed_packet = 5M
quick
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment