From: jon
Date: February 26 2008 1:35pm
Subject: svn commit - mysqldoc@docsrva: r10015 - in trunk: refman-5.0 refman-5.1 refman-6.0
List-Archive: http://lists.mysql.com/commits/42990
Message-Id: <200802261335.m1QDZ9Eg008538@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: jstephens
Date: 2008-02-26 14:35:09 +0100 (Tue, 26 Feb 2008)
New Revision: 10015
Log:
NO_DIR_IN_CREATE SQL mode is not replicated; however, it is preserved by
mysqlbinlog (Thanks, Sven!)
Modified:
trunk/refman-5.0/replication-notes.xml
trunk/refman-5.1/replication-notes.xml
trunk/refman-6.0/replication-notes.xml
Modified: trunk/refman-5.0/replication-notes.xml
===================================================================
--- trunk/refman-5.0/replication-notes.xml 2008-02-26 13:16:58 UTC (rev 10014)
+++ trunk/refman-5.0/replication-notes.xml 2008-02-26 13:35:09 UTC (rev 10015)
Changed blocks: 1, Lines Added: 19, Lines Deleted: 6; 1771 bytes
@@ -963,15 +963,28 @@
The FOREIGN_KEY_CHECKS,
- SQL_MODE, UNIQUE_CHECKS,
- and SQL_AUTO_IS_NULL variables are all
- replicated in MySQL ¤t-series;. The
- storage_engine system variable (also known as
- table_type) is not yet replicated, which is a
- good thing for replication between different storage engines.
+ UNIQUE_CHECKS, and
+ SQL_AUTO_IS_NULL variables are all
+ replicated.
+ SQL_MODE is also replicated except for the
+ NO_DIR_IN_CREATE mode. However, when
+ mysqlbinlog parses a SET @@SQL_MODE
+ = value statement, the full
+ value, including
+ NO_DIR_IN_CREATE, is passed to the receiving
+ server.
+
+
+
+ The storage_engine system variable is not
+ replicated, which is a good thing for replication between
+ different storage engines.
+
+
+
Starting from MySQL 5.0.3 (master and slave), replication works
even if the master and slave have different global character set
variables. Starting from MySQL 5.0.4 (master and slave),
Modified: trunk/refman-5.1/replication-notes.xml
===================================================================
--- trunk/refman-5.1/replication-notes.xml 2008-02-26 13:16:58 UTC (rev 10014)
+++ trunk/refman-5.1/replication-notes.xml 2008-02-26 13:35:09 UTC (rev 10015)
Changed blocks: 1, Lines Added: 19, Lines Deleted: 7; 1797 bytes
@@ -1664,16 +1664,28 @@
The FOREIGN_KEY_CHECKS,
- SQL_MODE, UNIQUE_CHECKS,
- and SQL_AUTO_IS_NULL variables are all
- replicated (this has been true since MySQL 5.0). The
- storage_engine system variable (also known as
- table_type) is not yet replicated in MySQL
- 5.1, which is a good thing for replication between different
- storage engines.
+ UNIQUE_CHECKS, and
+ SQL_AUTO_IS_NULL variables are all
+ replicated.
+ SQL_MODE is also replicated except for the
+ NO_DIR_IN_CREATE mode. However, when
+ mysqlbinlog parses a SET @@SQL_MODE
+ = value statement, the full
+ value, including
+ NO_DIR_IN_CREATE, is passed to the receiving
+ server.
+
+
+
+ The storage_engine system variable is not
+ replicated, which is a good thing for replication between
+ different storage engines.
+
+
+
Session variables are not replicated properly when used in
statements that update tables. For example, SET
MAX_JOIN_SIZE=1000 followed by INSERT INTO
Modified: trunk/refman-6.0/replication-notes.xml
===================================================================
--- trunk/refman-6.0/replication-notes.xml 2008-02-26 13:16:58 UTC (rev 10014)
+++ trunk/refman-6.0/replication-notes.xml 2008-02-26 13:35:09 UTC (rev 10015)
Changed blocks: 1, Lines Added: 19, Lines Deleted: 6; 1743 bytes
@@ -1633,15 +1633,28 @@
The FOREIGN_KEY_CHECKS,
- SQL_MODE, UNIQUE_CHECKS,
- and SQL_AUTO_IS_NULL variables are all
- replicated (this has been true since MySQL 5.0). The
- storage_engine system variable is not yet
- replicated in MySQL 5.1, which is a good thing for replication
- between different storage engines.
+ UNIQUE_CHECKS, and
+ SQL_AUTO_IS_NULL variables are all
+ replicated.
+ SQL_MODE is also replicated except for the
+ NO_DIR_IN_CREATE mode. However, when
+ mysqlbinlog parses a SET @@SQL_MODE
+ = value statement, the full
+ value, including
+ NO_DIR_IN_CREATE, is passed to the receiving
+ server.
+
+
+
+ The storage_engine system variable is not
+ replicated, which is a good thing for replication between
+ different storage engines.
+
+
+
Session variables are not replicated properly when used in
statements that update tables. For example, SET
MAX_JOIN_SIZE=1000 followed by INSERT INTO