# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
+# Default storage engine is InnoDB since 5.5.5
+# You may revert to previous behaviour by specifiying MyISAM here
+#default-storage-engine=InnoDB
+
# Don't listen on a TCP/IP port at all. This is a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets.
# Emergency option. Use only if you really need this.
#skip-grant-tables
-# skip startup of slave
-#skip-slave-start
-
-# slave setup
-#relay-log=slave-relay-bin
-#master-host=master
-#master-user=replica
-#master-port=3306
-#master-password=replica
-#report-host=db-slave.example.org
-
-# master does not ignore them, but we do
-#replicate-ignore-db=mysql
-#replicate-ignore-db=test
-
-#replicate-rewrite-db=delfi->delfi_ro
+# http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-storage-engine
+#default-storage-engine=MyISAM
# Replication Master Server (default)
# binary logging is required for replication
#log-bin=mysql-bin
+# max size of master binlog files
+#max_binlog_size=256M
+
# If non-zero, binary logs will be purged after expire_logs_days days; possible
# purges happen at startup and at binary log rotation.
#expire-logs-days=30
#binlog-ignore-db=mysql
#binlog-ignore-db=test
+# slave setup
+#relay-log=slave-relay-bin
+#report-host=db-slave.example.org
+
+# skip startup of slave
+#skip-slave-start
+
+# master does not ignore them, but we do
+#replicate-ignore-db=mysql
+#replicate-ignore-db=test
+#replicate-ignore-table=db1.tbl1
+#replicate-ignore-table=db2.tbl2
+
+#replicate-rewrite-db=delfi->delfi_ro
+
+# replication local log
+#max_relay_log_size=256M
+
# global option where logs be written
log-output = FILE
#query_cache_size=8M
#query_cache_limit=1M
-# replication local log
-#max_relay_log_size=256M
-# max size of master binlog files
-#max_binlog_size=256M
-
# Fulltext search options
#ft_min_word_len=2
#myisam_sort_buffer_size=4M
+# To completely disable InnoDB, use this option
+# this makes all innodb options being unknown options (including skip-innodb)
+# @deprecated
+#ignore-builtin-innodb
#
# InnoDB tables options (see MySQL manual)
#
#skip-innodb
+# http://stackoverflow.com/questions/2646373/mysql-data-file-wont-shrink
+# http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablespaces.html
+#innodb_file_per_table
+
# these are actual defaults (as of 5.0.26)
innodb_data_home_dir = @clusterdir@/mysqldb/db
innodb_data_file_path = ibdata1:10M:autoextend
[mysqladmin]
user = mysql_sysadmin
password =
+
+# used by initscript to fetch slave status
+[mysql]
+user = mysql
+password =