List:Commits« Previous MessageNext Message »
From:jon.stephens Date:February 1 2009 7:02pm
Subject:svn commit - mysqldoc@docsrva: r13504 - in trunk: dynamic-docs/changelog mysql-monitor-2.0 refman-5.1 refman-5.1-maria refman-6.0
View as plain text  
Author: jstephens
Date: 2009-02-01 20:02:13 +0100 (Sun, 01 Feb 2009)
New Revision: 13504

Log:

Documented Replication bugfixes:

  Bug #25998, Bug #34541, Bug #34654,
  Bug #35546, Bug #36929, Bug #40459

New IGNORE_SERVER_IDS option for CHANGE MASTER TO

Changes in SLAVE SLAVE STATUS output, content of master.info

Rebuilt dependencies



Modified:
   trunk/dynamic-docs/changelog/mysqld-1.xml
   trunk/mysql-monitor-2.0/Makefile.depends
   trunk/refman-5.1-maria/Makefile.depends
   trunk/refman-5.1/Makefile.depends
   trunk/refman-5.1/sql-syntax-server-administration.xml
   trunk/refman-6.0/Makefile.depends
   trunk/refman-6.0/replication-implementation.xml
   trunk/refman-6.0/sql-syntax-replication.xml
   trunk/refman-6.0/sql-syntax-server-administration.xml


Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml	2009-02-01 00:33:17 UTC (rev 13503)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml	2009-02-01 19:02:13 UTC (rev 13504)
Changed blocks: 1, Lines Added: 186, Lines Deleted: 0; 4532 bytes

@@ -9,6 +9,192 @@
   <logentry entrytype="bug">
 
     <tags>
+      <highlight type="replication"/>
+      <manual type="mysqlbinlog"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="35546"/>
+      <seealsobug bugid="35543"/>
+    </bugs>
+
+    <versions>
+      <version ver="6.0.10"/>
+    </versions>
+
+    <message>
+
+      <para>
+        <command>mysqlbinlog</command> sometimes failed when trying to
+        create temporary files; this was because it ignored the
+        <option>--tmpdir</option> option and tried to use the system
+        <filename>/tmp</filename> directory instead.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="feature">
+
+    <tags>
+      <highlight type="replication"/>
+      <highlight type="importantchange"/>
+      <manual type="RESET"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="34654"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.1.32"/>
+      <version ver="6.0.10"/>
+    </versions>
+
+    <message>
+
+      <para>
+        <literal role="stmt">RESET MASTER</literal> and
+        <literal role="stmt">RESET SLAVE</literal> now reset the values
+        shown for <literal>Last_IO_Error</literal>,
+        <literal>Last_IO_Errno</literal>,
+        <literal>Last_SQL_Error</literal>, and
+        <literal>Last_SQL_Errno</literal> in the output of
+        <literal role="stmt">SHOW SLAVE STATUS</literal>.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="feature">
+
+    <tags>
+      <highlight type="replication"/>
+      <manual type="CHANGE MASTER TO"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="25998"/>
+      <seealsobug bugid="27808"/>
+    </bugs>
+
+    <versions>
+      <version ver="6.0.10"/>
+    </versions>
+
+    <message>
+
+      <para>
+        In circular replication, it was sometimes possible for an event
+        to propagate such that it would be reapplied on all servers.
+        This could occur when the originating server was removed from
+        the replication circle and so could no longer act as the
+        terminator of its own events, as normally happens in circular
+        replication.
+      </para>
+
+      <para>
+        In order to prevent this from occurring, a new
+        <literal>IGNORE_SERVER_IDS</literal> option is introduced for
+        the <literal>CHANGE MASTER TO</literal> statement. This option
+        takes a list of replication server IDs; events having a server
+        ID which appears in this list are ignored and not applied. For
+        more information, see <xref linkend="change-master-to"/>.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <highlight type="replication"/>
+      <manual type="--with-libevent"/>
+      <manual type="--thread-handling"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="36929"/>
+    </bugs>
+
+    <versions>
+      <version ver="6.0.10"/>
+    </versions>
+
+    <message>
+
+      <para>
+        A slave compiled using <option>--with-libevent</option> and run
+        with <option>--thread-handling=pool-of-threads</option> could
+        sometimes crash.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <highlight type="replication"/>
+      <manual type="mysqlbinlog"/>
+      <manual type="AUTOCOMMIT"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="34541"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.1.32"/>
+      <version ver="6.0.10"/>
+    </versions>
+
+    <message>
+
+      <para>
+        In statement mode, <command>mysqlbinlog</command> failed to
+        issue a <literal>SET @@autommit</literal> statement when the
+        autocommit mode was changed.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <highlight type="replication"/>
+      <manual type="CHANGE MASTER TO"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="40459"/>
+    </bugs>
+
+    <versions>
+      <version ver="6.0.10"/>
+    </versions>
+
+    <message>
+
+      <para>
+        When <literal role="stmt" condition="change-master-to">CHANGE
+        MASTER TO ... SET MASTER_HEARTBEAT_PERIOD ...</literal> failed,
+        no error code was set.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
       <highlight type="cluster"/>
       <manual type="SHOW STATUS"/>
     </tags>


Modified: trunk/mysql-monitor-2.0/Makefile.depends
===================================================================
--- trunk/mysql-monitor-2.0/Makefile.depends	2009-02-01 00:33:17 UTC (rev 13503)
+++ trunk/mysql-monitor-2.0/Makefile.depends	2009-02-01 19:02:13 UTC (rev 13504)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 0; 776 bytes

@@ -276,6 +276,8 @@
 dynxml_local_monitor_faq_IMAGES =
 dynxml_local_monitor_faq_SOURCES = dynxml-local-monitor-faq.xml $(dynxml_local_monitor_faq_INCLUDES)
 dynxml_local_monitor_faq_IDMAPS = \
+	../mysql-monitor-2.0/metadata/dashboard-query-analysis.idmap \
+	../mysql-monitor-2.0/metadata/deployment.idmap \
 	../mysql-monitor-2.0/metadata/monitor-faq-core.idmap
 dynxml-local-monitor-faq.validpure: $(dynxml_local_monitor_faq_SOURCES)
 dynxml-local-monitor-faq.titles: $(dynxml_local_monitor_faq_SOURCES)


Modified: trunk/refman-5.1/Makefile.depends
===================================================================
--- trunk/refman-5.1/Makefile.depends	2009-02-01 00:33:17 UTC (rev 13503)
+++ trunk/refman-5.1/Makefile.depends	2009-02-01 19:02:13 UTC (rev 13504)
Changed blocks: 7, Lines Added: 7, Lines Deleted: 0; 2303 bytes

@@ -1337,6 +1337,7 @@
 dynxml_local_se_archive_INCLUDES = \
 	../common/fixedchars.ent \
 	../common/phrases.ent \
+	../dynamic-docs/storage-engines/engines.xml \
 	../refman-common/urls.ent \
 	all-entities.ent \
 	se-archive-core.xml \

@@ -1361,6 +1362,7 @@
 	../common/phrases.ent \
 	../dynamic-docs/command-optvars/mysqld.xml \
 	../dynamic-docs/metadata-titles.en.xml \
+	../dynamic-docs/storage-engines/engines.xml \
 	../refman-common/urls.ent \
 	all-entities.ent \
 	se-innodb-core.xml \

@@ -1390,6 +1392,7 @@
 dynxml_local_se_memory_INCLUDES = \
 	../common/fixedchars.ent \
 	../common/phrases.ent \
+	../dynamic-docs/storage-engines/engines.xml \
 	../refman-common/urls.ent \
 	all-entities.ent \
 	se-memory-core.xml \

@@ -1414,6 +1417,7 @@
 	../common/phrases.ent \
 	../dynamic-docs/command-optvars/mysqld.xml \
 	../dynamic-docs/metadata-titles.en.xml \
+	../dynamic-docs/storage-engines/engines.xml \
 	../refman-common/urls.ent \
 	all-entities.ent \
 	se-myisam-core.xml \

@@ -1446,6 +1450,7 @@
 	../common/phrases.ent \
 	../dynamic-docs/command-optvars/mysqld.xml \
 	../dynamic-docs/metadata-titles.en.xml \
+	../dynamic-docs/storage-engines/engines.xml \
 	../refman-common/images/published/PSEArch.png \
 	../refman-common/images/published/blackhole-1.png \
 	../refman-common/images/published/se-federated-structure.png \

@@ -1973,6 +1978,7 @@
 	../dynamic-docs/reserved-words/mysql-5.1.6-alpha \
 	../dynamic-docs/reserved-words/mysql-5.1.7-beta \
 	../dynamic-docs/reserved-words/mysql-5.1.9-beta \
+	../dynamic-docs/storage-engines/engines.xml \
 	../mysql-monitor-2.0/../common/fixedchars.ent \
 	../mysql-monitor-2.0/../common/phrases.ent \
 	../mysql-monitor-2.0/../dynamic-docs/faq/monitor.xml \

@@ -2721,6 +2727,7 @@
 	../dynamic-docs/reserved-words/mysql-5.1.6-alpha \
 	../dynamic-docs/reserved-words/mysql-5.1.7-beta \
 	../dynamic-docs/reserved-words/mysql-5.1.9-beta \
+	../dynamic-docs/storage-engines/engines.xml \
 	../dynamic-docs/topic-quickref/quickrefs.xml \
 	../mysql-monitor-2.0/../common/fixedchars.ent \
 	../mysql-monitor-2.0/../common/phrases.ent \


Modified: trunk/refman-5.1/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-5.1/sql-syntax-server-administration.xml	2009-02-01 00:33:17 UTC (rev 13503)
+++ trunk/refman-5.1/sql-syntax-server-administration.xml	2009-02-01 19:02:13 UTC (rev 13504)
Changed blocks: 3, Lines Added: 21, Lines Deleted: 0; 1675 bytes

@@ -8302,6 +8302,13 @@
             also appears as a message in the slave's error log.
           </para>
 
+          <para>
+            Beginning with MySQL 5.1.32, issuing
+            <literal role="stmt">RESET MASTER</literal> or
+            <literal role="stmt">RESET SLAVE</literal> resets the values
+            shown in these columns.
+          </para>
+
           <note>
             <para>
               When the slave SQL thread receives an error, it reports

@@ -8565,6 +8572,13 @@
             also appears as a message in the slave's error log. These
             columns were added in MySQL 5.1.20.
           </para>
+
+          <para>
+            Beginning with MySQL 5.1.32, issuing
+            <literal role="stmt">RESET MASTER</literal> or
+            <literal role="stmt">RESET SLAVE</literal> resets the values
+            shown in these columns.
+          </para>
         </listitem>
 
         <listitem>

@@ -8599,6 +8613,13 @@
             example, if you forget to copy the table to the slave when
             setting up replication.)
           </para>
+
+          <para>
+            Beginning with MySQL 5.1.32, issuing
+            <literal role="stmt">RESET MASTER</literal> or
+            <literal role="stmt">RESET SLAVE</literal> resets the values
+            shown in these columns.
+          </para>
         </listitem>
 
       </itemizedlist>


Modified: trunk/refman-5.1-maria/Makefile.depends
===================================================================
--- trunk/refman-5.1-maria/Makefile.depends	2009-02-01 00:33:17 UTC (rev 13503)
+++ trunk/refman-5.1-maria/Makefile.depends	2009-02-01 19:02:13 UTC (rev 13504)
Changed blocks: 2, Lines Added: 2, Lines Deleted: 0; 1160 bytes

@@ -438,6 +438,7 @@
 	../refman-5.1/../dynamic-docs/reserved-words/mysql-5.1.6-alpha \
 	../refman-5.1/../dynamic-docs/reserved-words/mysql-5.1.7-beta \
 	../refman-5.1/../dynamic-docs/reserved-words/mysql-5.1.9-beta \
+	../refman-5.1/../dynamic-docs/storage-engines/engines.xml \
 	../refman-5.1/../refman-common/../common/fixedchars.ent \
 	../refman-5.1/../refman-common/../common/phrases.ent \
 	../refman-5.1/../refman-common/../refman-common/apis-php-mysql.xml \

@@ -1010,6 +1011,7 @@
 	../refman-5.1/../common/phrases.ent \
 	../refman-5.1/../dynamic-docs/command-optvars/mysqld.xml \
 	../refman-5.1/../dynamic-docs/metadata-titles.en.xml \
+	../refman-5.1/../dynamic-docs/storage-engines/engines.xml \
 	../refman-5.1/../refman-common/images/published/blackhole-1.png \
 	../refman-5.1/../refman-common/images/published/se-federated-structure.png \
 	../refman-5.1/../refman-common/urls.ent \


Modified: trunk/refman-6.0/Makefile.depends
===================================================================
--- trunk/refman-6.0/Makefile.depends	2009-02-01 00:33:17 UTC (rev 13503)
+++ trunk/refman-6.0/Makefile.depends	2009-02-01 19:02:13 UTC (rev 13504)
Changed blocks: 9, Lines Added: 9, Lines Deleted: 0; 2927 bytes

@@ -1133,6 +1133,7 @@
 dynxml_local_se_archive_INCLUDES = \
 	../common/fixedchars.ent \
 	../common/phrases.ent \
+	../dynamic-docs/storage-engines/engines.xml \
 	../refman-common/urls.ent \
 	all-entities.ent \
 	se-archive-core.xml \

@@ -1157,6 +1158,7 @@
 	../common/phrases.ent \
 	../dynamic-docs/command-optvars/mysqld.xml \
 	../dynamic-docs/metadata-titles.en.xml \
+	../dynamic-docs/storage-engines/engines.xml \
 	../refman-common/urls.ent \
 	all-entities.ent \
 	se-falcon-core.xml \

@@ -1182,6 +1184,7 @@
 	../common/phrases.ent \
 	../dynamic-docs/command-optvars/mysqld.xml \
 	../dynamic-docs/metadata-titles.en.xml \
+	../dynamic-docs/storage-engines/engines.xml \
 	../refman-common/urls.ent \
 	all-entities.ent \
 	se-innodb-core.xml \

@@ -1236,6 +1239,7 @@
 dynxml_local_se_memory_INCLUDES = \
 	../common/fixedchars.ent \
 	../common/phrases.ent \
+	../dynamic-docs/storage-engines/engines.xml \
 	../refman-common/urls.ent \
 	all-entities.ent \
 	se-memory-core.xml \

@@ -1260,6 +1264,7 @@
 	../common/phrases.ent \
 	../dynamic-docs/command-optvars/mysqld.xml \
 	../dynamic-docs/metadata-titles.en.xml \
+	../dynamic-docs/storage-engines/engines.xml \
 	../refman-common/urls.ent \
 	all-entities.ent \
 	se-myisam-core.xml \

@@ -1293,6 +1298,7 @@
 	../dynamic-docs/command-optvars/mysqld.xml \
 	../dynamic-docs/faq/se-maria.xml \
 	../dynamic-docs/metadata-titles.en.xml \
+	../dynamic-docs/storage-engines/engines.xml \
 	../refman-common/images/published/PSEArch.png \
 	../refman-common/images/published/blackhole-1.png \
 	../refman-common/images/published/se-federated-structure.png \

@@ -1738,6 +1744,7 @@
 	../dynamic-docs/faq/se-maria.xml \
 	../dynamic-docs/metadata-titles.en.xml \
 	../dynamic-docs/opsfunctions/opfunctions.xml \
+	../dynamic-docs/storage-engines/engines.xml \
 	../mysql-monitor-2.0/../common/fixedchars.ent \
 	../mysql-monitor-2.0/../common/phrases.ent \
 	../mysql-monitor-2.0/../dynamic-docs/faq/monitor.xml \

@@ -2348,6 +2355,7 @@
 	../dynamic-docs/faq/se-maria.xml \
 	../dynamic-docs/metadata-titles.en.xml \
 	../dynamic-docs/opsfunctions/opfunctions.xml \
+	../dynamic-docs/storage-engines/engines.xml \
 	../dynamic-docs/topic-quickref/quickrefs.xml \
 	../mysql-monitor-2.0/../common/fixedchars.ent \
 	../mysql-monitor-2.0/../common/phrases.ent \

@@ -3988,6 +3996,7 @@
 	../refman-6.0/metadata/dba-user-management-core.idmap \
 	../refman-6.0/metadata/functions-core.idmap \
 	../refman-6.0/metadata/replication-configuration.idmap \
+	../refman-6.0/metadata/replication-implementation.idmap \
 	../refman-6.0/metadata/replication-options-core.idmap \
 	../refman-6.0/metadata/sql-syntax-replication.idmap \
 	../refman-6.0/metadata/sql-syntax-server-administration.idmap


Modified: trunk/refman-6.0/replication-implementation.xml
===================================================================
--- trunk/refman-6.0/replication-implementation.xml	2009-02-01 00:33:17 UTC (rev 13503)
+++ trunk/refman-6.0/replication-implementation.xml	2009-02-01 19:02:13 UTC (rev 13504)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 0; 834 bytes

@@ -559,6 +559,12 @@
               <entry><literal>Master_SSL_Verify_Server_Cert</literal></entry>
               <entry>Whether to verify the server certificate.</entry>
             </row>
+            <row>
+              <entry>17</entry>
+              <entry><literal>Replicate_Ignore_Server_Ids</literal></entry>
+              <entry>The number of server IDs to be ignored, followed by the actual server
+                IDs. Added in MySQL 6.0.10.</entry>
+            </row>
           </tbody>
         </tgroup>
       </informaltable>


Modified: trunk/refman-6.0/sql-syntax-replication.xml
===================================================================
--- trunk/refman-6.0/sql-syntax-replication.xml	2009-02-01 00:33:17 UTC (rev 13503)
+++ trunk/refman-6.0/sql-syntax-replication.xml	2009-02-01 19:02:13 UTC (rev 13504)
Changed blocks: 3, Lines Added: 55, Lines Deleted: 1; 3567 bytes

@@ -433,7 +433,7 @@
       <remark role="help-topic" condition="CHANGE MASTER TO"/>
 
       <remark role="help-keywords">
-        CHANGE MASTER TO
+        CHANGE MASTER TO IGNORE_SERVER_IDS
 
 <!--MASTER_BIND-->
 

@@ -471,6 +471,10 @@
   | MASTER_SSL_KEY = '<replaceable>key_file_name</replaceable>'
   | MASTER_SSL_CIPHER = '<replaceable>cipher_list</replaceable>'
   | MASTER_SSL_VERIFY_SERVER_CERT = {0|1}
+  | IGNORE_SERVER_IDS = (<replaceable>server_id_list</replaceable>)
+
+<replaceable>server_id_list</replaceable>:
+    [<replaceable>server_id_1</replaceable>[, <replaceable>server_id_2</replaceable>[ ... ]]]
 </programlisting>
 
       <remark role="help-description-begin"/>

@@ -628,6 +632,56 @@
       </para>
 
       <para>
+        <literal>IGNORE_SERVER_IDS</literal> was added in MySQL 6.0.10.
+        This option takes a comma-separated list of 0 or more server
+        IDs; events from the corresponding servers are ignored, with the
+        exception of log rotation and deletion events, which are still
+        recorded in the relay log.
+      </para>
+
+      <para>
+        In circular replication, the originating server normally acts as
+        the terminator of its own events, so that they are not applied
+        more than once. Thus, this option is useful in circular
+        replication when one of the servers in the circle is removed.
+        For example, suppose that you have a circular replication setup
+        with 4 servers, having server IDs 1, 2, 3, and 4, and server 3
+        fails. When bridging the gap by starting replication from server
+        2 to server 4, you can include <literal>IGNORE_SERVER_IDS =
+        (3)</literal> in the <literal>CHANGE MASTER TO</literal>
+        statement that you issue on server 4 to tell it to use server 2
+        as its master instead of server 3. Doing so causes it to ignore
+        and not to propagate any statements that originated with the
+        server that is no longer in use.
+      </para>
+
+      <para>
+        If a <literal>CHANGE MASTER TO</literal> statement is issued
+        without any <literal>IGNORE_SERVER_IDS</literal> option, any
+        existing list is preserved; <literal role="stmt">RESET
+        SLAVE</literal> also has no effect on the server ID list. To
+        clear the list of servers that are ignored, it is necessary to
+        use the option with an empty list (that is, as
+        <literal>IGNORE_SERVER_IDS = ()</literal>).
+      </para>
+
+      <para>
+        If <literal>IGNORE_SERVER_IDS</literal> contains the
+        server&apos;s own ID and the server was started with the
+        <option>--replicate-same-server-id</option> option enabled, an
+        error results.
+      </para>
+
+      <para>
+        Also beginning with MySQL 6.0.10, the
+        <filename>master.info</filename> file and the output of
+        <literal>SHOW SLAVE STATUS</literal> are extended to provide the
+        list of servers that are currently ignored. For more
+        information, see <xref linkend="slave-logs-status"/>, and
+        <xref linkend="show-slave-status"/>.
+      </para>
+
+      <para>
         <literal role="stmt">CHANGE MASTER TO</literal>
         <emphasis>deletes all relay log files</emphasis> and starts a
         new one, unless you specify <literal>RELAY_LOG_FILE</literal> or


Modified: trunk/refman-6.0/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-6.0/sql-syntax-server-administration.xml	2009-02-01 00:33:17 UTC (rev 13503)
+++ trunk/refman-6.0/sql-syntax-server-administration.xml	2009-02-01 19:02:13 UTC (rev 13504)
Changed blocks: 4, Lines Added: 54, Lines Deleted: 0; 3235 bytes

@@ -7871,6 +7871,7 @@
                 Last_IO_Error:
                Last_SQL_Errno: 0
                Last_SQL_Error:
+  Replicate_Ignore_Server_Ids: 0                  
 </programlisting>
 
       <remark role="help-description-end"/>

@@ -8073,6 +8074,13 @@
             <literal>Last_SQL_Error</literal>.
           </para>
 
+          <para>
+            Beginning with MySQL 6.0.10, issuing
+            <literal role="stmt">RESET MASTER</literal> or
+            <literal role="stmt">RESET SLAVE</literal> resets the values
+            shown in these columns.
+          </para>
+
           <note>
             <para>
               When the slave SQL thread receives an error, it reports

@@ -8332,6 +8340,13 @@
             the <literal>Last_IO_Error</literal> value is not empty, it
             also appears as a message in the slave's error log.
           </para>
+
+          <para>
+            Beginning with MySQL 6.0.10, issuing
+            <literal role="stmt">RESET MASTER</literal> or
+            <literal role="stmt">RESET SLAVE</literal> resets the values
+            shown in these columns.
+          </para>
         </listitem>
 
         <listitem>

@@ -8365,8 +8380,47 @@
             example, if you forget to copy the table to the slave when
             setting up replication.)
           </para>
+
+          <para>
+            Beginning with MySQL 6.0.10, issuing
+            <literal role="stmt">RESET MASTER</literal> or
+            <literal role="stmt">RESET SLAVE</literal> resets the values
+            shown in these columns.
+          </para>
         </listitem>
 
+        <listitem>
+          <para>
+            <literal>Replicate_Ignore_Server_Ids</literal>
+          </para>
+
+          <para>
+            Beginning with MySQL 6.0.10, you can tell a slave to ignore
+            events from 0 or more masters using the
+            <literal>IGNORE_SERVER_IDS</literal> option in a
+            <literal role="stmt">CHANGE MASTER TO</literal> statement.
+            This is normally of interest only when using a circular or
+            other multi-master replication setup.
+          </para>
+
+          <para>
+            The message shown for
+            <literal>Replicate_Ignore_Server_Ids</literal> consists of a
+            space-delimited list of 1 or more numbers, the first number
+            indicating the number of servers to be ignored; if not 0
+            (the default), then this number is followed by the actual
+            server IDs. For example, if a slave has been told to ignore
+            masters having the server IDs 2, 6, and 9 (using a
+            <literal role="stmt">CHANGE MASTER TO</literal> statement
+            containing the option <literal>IGNORE_SERVER_IDS =
+            (2,6,9)</literal>), then this row appears as shown here:
+          </para>
+
+<programlisting>
+  Replicate_Ignore_Server_Ids: 3 2 6 9
+</programlisting>
+        </listitem>
+
       </itemizedlist>
 
     </section>


Thread
svn commit - mysqldoc@docsrva: r13504 - in trunk: dynamic-docs/changelog mysql-monitor-2.0 refman-5.1 refman-5.1-maria refman-6.0jon.stephens1 Feb