MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:jon Date:July 15 2008 7:28am
Subject:svn commit - mysqldoc@docsrva: r11247 - in trunk: refman-4.1 refman-5.0
View as plain text  
Author: jstephens
Date: 2008-07-15 09:28:07 +0200 (Tue, 15 Jul 2008)
New Revision: 11247

Log:

In 4.1, multiple-table updates are not replicated unless every table
referenced in the update has a matching do-rule

Fixes Docs Bug #37881



Modified:
   trunk/refman-4.1/replication.xml
   trunk/refman-5.0/replication-implementation.xml


Modified: trunk/refman-4.1/replication.xml
===================================================================
--- trunk/refman-4.1/replication.xml	2008-07-15 07:22:33 UTC (rev 11246)
+++ trunk/refman-4.1/replication.xml	2008-07-15 07:28:07 UTC (rev 11247)
Changed blocks: 1, Lines Added: 12, Lines Deleted: 6; 1457 bytes

@@ -3816,13 +3816,19 @@
               to the options. For example, if the statement is
               <literal>INSERT INTO sales SELECT * FROM prices</literal>,
               only <literal>sales</literal> is compared to the options).
-              If several tables are to be updated (multiple-table
-              statement), the first table that matches <quote>do</quote>
-              or <quote>ignore</quote> wins. That is, the server checks
-              the first table against the options. If no decision could
-              be made, it checks the second table against the options,
-              and so on.
             </para>
+
+            <important>
+              <para>
+                If several tables are to be updated (multiple-table
+                statement), <emphasis>every</emphasis> table referenced
+                in the statement must have a matching
+                <option>--replicate-do-table</option> rule. If any table
+                to be updated does not have a matching
+                <option>--replicate-do-table</option> rule, then the
+                update is not replicated.
+              </para>
+            </important>
           </listitem>
 
         </itemizedlist>


Modified: trunk/refman-5.0/replication-implementation.xml
===================================================================
--- trunk/refman-5.0/replication-implementation.xml	2008-07-15 07:22:33 UTC (rev 11246)
+++ trunk/refman-5.0/replication-implementation.xml	2008-07-15 07:28:07 UTC (rev 11247)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 0; 858 bytes

@@ -634,6 +634,16 @@
               be made, it checks the second table against the options,
               and so on.
             </para>
+
+            <note>
+              <para>
+                In MySQL 4.1, a multiple-table update was not replicated
+                if each table referenced by the updating statement did
+                not have a matching
+                <option>--replicate-do-table</option> rule. In MySQL
+                5.0, this is no longer true.
+              </para>
+            </note>
           </listitem>
 
         </itemizedlist>


Thread
svn commit - mysqldoc@docsrva: r11247 - in trunk: refman-4.1 refman-5.0jon15 Jul