Author: mcbrown
Date: 2007-08-09 19:33:52 +0200 (Thu, 09 Aug 2007)
New Revision: 7395
Log:
Documenting worklog:
WL#755 Write TABLE_TYPE, SQL_MODE etc to the binlog
Modified:
trunk/refman-5.0/dba-core.xml
trunk/refman-5.1/dba-core.xml
trunk/refman-5.1/replication-configuration.xml
Modified: trunk/refman-5.0/dba-core.xml
===================================================================
--- trunk/refman-5.0/dba-core.xml 2007-08-09 16:14:31 UTC (rev 7394)
+++ trunk/refman-5.0/dba-core.xml 2007-08-09 17:33:52 UTC (rev 7395)
Changed blocks: 1, Lines Added: 63, Lines Deleted: 0; 1967 bytes
@@ -28103,6 +28103,69 @@
be restarted from a fresh snapshot of the master's data.
</para>
+ <para>
+ For MySQL 5.0.46, the following session variables are written to
+ the binary log and honoured by the replication slave when
+ parsing the binary log:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_sql_mode"><literal>SQL_MODE</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>FOREIGN_KEY_CHECKS</literal>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>UNIQUE_CHECKS</literal>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_character_set_client"><literal>CHARACTER_SET_CLIENT</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_collation_connection"><literal>COLLATION_CONNECTION</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_collation_database"><literal>COLLATION_DATABASE</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_collation_server"><literal>COLLATION_SERVER</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>SQL_AUTO_IS_NULL</literal>
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
</section>
<section id="slow-query-log">
Modified: trunk/refman-5.1/dba-core.xml
===================================================================
--- trunk/refman-5.1/dba-core.xml 2007-08-09 16:14:31 UTC (rev 7394)
+++ trunk/refman-5.1/dba-core.xml 2007-08-09 17:33:52 UTC (rev 7395)
Changed blocks: 1, Lines Added: 64, Lines Deleted: 0; 2069 bytes
@@ -29554,6 +29554,70 @@
be restarted from a fresh snapshot of the master's data.
</para>
+ <para>
+ For MySQL 5.1.20 and later (and MySQL 5.0.46 for backwards
+ compatibility), the following session variables are written to
+ the binary log and honoured by the replication slave when
+ parsing the binary log:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_sql_mode"><literal>SQL_MODE</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>FOREIGN_KEY_CHECKS</literal>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>UNIQUE_CHECKS</literal>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_character_set_client"><literal>CHARACTER_SET_CLIENT</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_collation_connection"><literal>COLLATION_CONNECTION</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_collation_database"><literal>COLLATION_DATABASE</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_collation_server"><literal>COLLATION_SERVER</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>SQL_AUTO_IS_NULL</literal>
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
<section id="binary-log-formats">
<title>Binary Logging Formats</title>
Modified: trunk/refman-5.1/replication-configuration.xml
===================================================================
--- trunk/refman-5.1/replication-configuration.xml 2007-08-09 16:14:31 UTC (rev 7394)
+++ trunk/refman-5.1/replication-configuration.xml 2007-08-09 17:33:52 UTC (rev 7395)
Changed blocks: 2, Lines Added: 69, Lines Deleted: 5; 2709 bytes
@@ -1287,11 +1287,11 @@
</para>
<para>
- Starting with MySQL 5.1.20, the binary logging format used and
- supported is determined by the storage engine being used. For more
- information on mixed-based logging and the rules governing the
- support of different logging formatsion, see
- <xref linkend="binary-log-mixed"/>.
+ Starting with MySQL 5.1.20, the binary logging format used is
+ partially determined by the storage engine being used and the
+ statement being executed. For more information on mixed-based
+ logging and the rules governing the support of different logging
+ formatsion, see <xref linkend="binary-log-mixed"/>.
</para>
<para>
@@ -1323,6 +1323,70 @@
<option>--without-row-based-replication</option> option.
</para>
+ <para>
+ For MySQL 5.1.20 and later (and MySQL 5.0.46 for backwards
+ compatibility), the following session variables are written to the
+ binary log and honoured by the replication slave when parsing the
+ binary log:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_sql_mode"><literal>SQL_MODE</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>FOREIGN_KEY_CHECKS</literal>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>UNIQUE_CHECKS</literal>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_character_set_client"><literal>CHARACTER_SET_CLIENT</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_collation_connection"><literal>COLLATION_CONNECTION</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_collation_database"><literal>COLLATION_DATABASE</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="option_mysqld_collation_server"><literal>COLLATION_SERVER</literal></link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>SQL_AUTO_IS_NULL</literal>
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
<section id="replication-sbr-rbr">
<title>Comparison of Statement-Based Versus Row-Based Replication</title>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r7395 - in trunk: refman-5.0 refman-5.1 | mcbrown | 9 Aug |
