From cb20bb988e5d08481e6d38ffb28607abe2fac27d Mon Sep 17 00:00:00 2001 From: Henk Kraal Date: Fri, 20 Feb 2015 13:32:57 +0100 Subject: [PATCH] Warn for STATEMENT based replication with MySQL and added links to modes-of-operation.md in settings.md --- docs/markdown/authoritative/backend-generic-mypgsql.md | 2 ++ docs/markdown/authoritative/settings.md | 4 ++-- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/docs/markdown/authoritative/backend-generic-mypgsql.md b/docs/markdown/authoritative/backend-generic-mypgsql.md index 1fa80eb477..be6842f527 100644 --- a/docs/markdown/authoritative/backend-generic-mypgsql.md +++ b/docs/markdown/authoritative/backend-generic-mypgsql.md @@ -28,6 +28,8 @@ There are in fact two backends, one for PostgreSQL and one for MySQL but they ac In practice, great results are achieved with the 'InnoDB' tables. PowerDNS will silently function with non-transaction aware MySQLs but at one point this is going to harm your database, for example when an incoming zone transfer fails. +**Warning**: For MySQL 5.1.11 and earlier, and for MySQL 5.1.29 and later the default binary logging format is STATEMENT which is nondeterministic and can cause differences in data between master and slave. See ["5.2.4.2, Setting The Binary Log Format"](http://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html) for more information. + The default setup conforms to the following schema: ``` diff --git a/docs/markdown/authoritative/settings.md b/docs/markdown/authoritative/settings.md index 929eee754e..d6e7e65326 100644 --- a/docs/markdown/authoritative/settings.md +++ b/docs/markdown/authoritative/settings.md @@ -382,7 +382,7 @@ stable, and is in fact likely to change. * Boolean * Default: yes -Turn on master support. +Turn on master support. See ["Modes of operation"](modes-of-operation.md#master-operation). ## `max-cache-entries` * Integer @@ -602,7 +602,7 @@ If set, change user id to this uid for more security. See * Boolean * Default: no -Turn on slave support. +Turn on slave support. See ["Modes of operation"](modes-of-operation.md#slave-operation). ## `slave-cycle-interval` * Integer -- 2.47.2