#collation-server=latin2_general_ci
#skip-character-set-client-handshake
-# Use passwords compatible with old 4.0 mysqld
-#old-passwords
+# This variable controls the password hashing method used by the PASSWORD()
+# function. It also influences password hashing performed by CREATE USER and
+# GRANT statements that specify a password using an IDENTIFIED BY clause.
+# http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_old_passwords
+# Value | Password Hashing Method | Associated Authentication Plugin
+# 0 | MySQL 4.1 native hashing | mysql_native_password
+# 1 | Pre-4.1 ("old") hashing | mysql_old_password
+# 2 | SHA-256 hashing | sha256_password
+# If you set old_passwords=2, follow the instructions for using the sha256_password plugin at
+# http://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html
+#old-passwords=0
# Don't use system locking
skip-external-locking
# 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
-# http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-storage-engine
+# http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_default-storage-engine
+# Default storage engine is InnoDB since 5.5.5
+# You may revert to previous behaviour by specifiying MyISAM here
#default-storage-engine=MyISAM
# Replication Master Server (default)
log-output = FILE
# mysqld error log (stderr)
-log-error = /var/log/mysql/mysqld.log
+log-error = /var/log/percona-server/mysqld.log
log-warnings = 2
# Log slow queries
slow-query-log
-slow-query-log-file = /var/log/mysql/slow.log
+slow-query-log-file = /var/log/percona-server/slow.log
# Log connections and queries. It slows down MySQL so it's disabled by default
#general-log
-#general-log-file = /var/log/mysql/query.log
+#general-log-file = /var/log/percona-server/query.log
# Log all updates.
-#log-update = /var/log/mysql/update
+#log-update = /var/log/percona-server/update
# Log some extra information to update log
#log-long-format
#delay-key-write-for-all-tables
# Repair automatically on open if the table wasn't closed properly.
-myisam-recover
+# http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_myisam-recover-options
+myisam-recover-options
#
#myisam_sort_buffer_size=4M
# these are actual defaults (as of 5.0.26)
innodb_data_home_dir = @clusterdir@/mysqldb/db
innodb_data_file_path = ibdata1:10M:autoextend
-innodb_mirrored_log_groups=1
innodb_log_group_home_dir = @clusterdir@/mysqldb/db
innodb_log_files_in_group=2
innodb_log_file_size=5M
#innodb_file_io_threads=4
#innodb_lock_wait_timeout=50
-# used for logs rotation
-[mysqladmin]
+# used for logs rotation or status check for replications
+[client]
user = mysql_sysadmin
password =
-
-# used by initscript to fetch slave status
-[mysql]
-user = mysql
-password =