Welcome to docs.opsview.com

Differences

This shows you the differences between two versions of the page.

opsview4.6:mysql [2015/09/16 15:32]
tvoon
opsview4.6:mysql [2015/11/03 14:05] (current)
dferguson Note on binlog_Format = MIXED
Line 139: Line 139:
  * innodb_autoinc_lock_mode=0 # Required for replication with MySQL 5.1 or later   * innodb_autoinc_lock_mode=0 # Required for replication with MySQL 5.1 or later
  * max_allowed_packet = 16M   * max_allowed_packet = 16M
-  * binlog_format = 'STATEMENT' # when using binary logs in replication+  * binlog_format = 'MIXED' # when using binary logs in replication NOTE: use 'STATEMENT' for MySQL 5.4 or earlier.
You can see the current values with ''mysqladmin variables''. You can see the current values with ''mysqladmin variables''.
Navigation
Print/export
Toolbox