- expire-logs-days sample

[packages/mysql.git] / mysqld.conf

diff --git a/mysqld.conf b/mysqld.conf
index 2b1ae5d6cbacc225193cc6e41616351b839de7a1..56e35c3af527a2f71624e28f8d88da185d61aa36 100644 (file)
--- a/mysqld.conf
+++ b/mysqld.conf
@@ -65,6 +65,10 @@ skip-networking
 ; binary logging is required for replication
 ;log-bin=mysql-bin
 
+; 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
+
 ; Normally, a slave does not log to its own binary log any updates that are
 ; received from a master server. This option tells the slave to log the updates
 ; performed by its SQL thread to its own binary log. For this option to have
@@ -77,6 +81,12 @@ skip-networking
 ; defaults to 1 if master-host is not set but will not function as a master if omitted
 ;server-id=2
 
+; To set up N master servers, set the variables like this:
+; Set auto_increment_increment to N on each master.
+; Set each of the N masters to have a different auto_increment_offset, using the values 1, 2, ..., N
+;auto-increment-offset=1
+;auto-increment-increment=2
+
 ; databases to be included in binlog
 ;binlog-do-db=db1
 ; or excluded