Author: jstephens
Date: 2010-09-10 11:04:21 +0200 (Fri, 10 Sep 2010)
New Revision: 22667
Log:
Documented fix for Cluster BUG#56691 (ref. BUG#34325)
--add-drop-trigger option for mysqldump (backport from 5.6)
Modified:
trunk/dynamic-docs/changelog/mysqld-2.xml
trunk/dynamic-docs/command-optvars/mysqldump.xml
trunk/refman-5.1/mysql-cluster-overview.xml
trunk/refman-5.1/programs-client-core.xml
Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml 2010-09-10 03:04:53 UTC (rev 22666)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml 2010-09-10 09:04:21 UTC (rev 22667)
Changed blocks: 1, Lines Added: 34, Lines Deleted: 0; 1155 bytes
@@ -6,6 +6,40 @@
]>
<changelog>
+ <logentry entrytype="feature">
+
+ <tags>
+ <highlight type="cluster"/>
+ <manual type="mysqldump"/>
+ <manual type="--add-drop-trigger"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="55691"/>
+ <seealsobug bugid="34325"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.47-ndb-6.3.38"/>
+ <version ver="5.1.47-ndb-7.0.19"/>
+ <version ver="5.1.47-ndb-7.1.8"/>
+ </versions>
+
+ <message>
+
+ <para>
+ <command>mysqldump</command> as supplied with MySQL Cluster now
+ has an <option role="mysqldump">--add-drop-trigger</option>
+ option which adds a
+ <literal role="stmt" condition="drop-trigger">DROP TRIGGER IF
+ EXISTS</literal> statement before each dumped trigger
+ definition.
+ </para>
+
+ </message>
+
+ </logentry>
+
<logentry entrytype="bug">
<tags>
Modified: trunk/dynamic-docs/command-optvars/mysqldump.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqldump.xml 2010-09-10 03:04:53 UTC (rev 22666)
+++ trunk/dynamic-docs/command-optvars/mysqldump.xml 2010-09-10 09:04:21 UTC (rev 22667)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 0; 570 bytes
@@ -145,6 +145,10 @@
</types>
<versions>
+ <manual version="5.1"/>
+ <introduced version="5.1.47-ndb-6.3.38"/>
+ <introduced version="5.1.47-ndb-7.0.19"/>
+ <introduced version="5.1.47-ndb-7.1.8"/>
<manual version="5.6"/>
</versions>
Modified: trunk/refman-5.1/mysql-cluster-overview.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster-overview.xml 2010-09-10 03:04:53 UTC (rev 22666)
+++ trunk/refman-5.1/mysql-cluster-overview.xml 2010-09-10 09:04:21 UTC (rev 22667)
Changed blocks: 8, Lines Added: 86, Lines Deleted: 31; 6779 bytes
@@ -1322,13 +1322,13 @@
<xref linkend="mysql-cluster-ndbinfo"/>.
</para>
</listitem>
-
+
<listitem>
<formalpara>
-
+
<title>New <literal role="stmt">CHANGE MASTER TO</literal> option for circular
replication</title>
-
+
<para>
Beginning with MySQL Cluster NDB 7.1.0, the
<literal role="stmt">CHANGE MASTER TO</literal> statement
@@ -1338,11 +1338,11 @@
to be ignored. (Log rotation and log deletion events are
preserved.)
</para>
-
+
</formalpara>
-
+
<para>
- See <xref linkend="change-master-to"/>, as well as
+ See <xref linkend="change-master-to"/>, as well as
<xref linkend="show-slave-status"/>, for more information.
</para>
</listitem>
@@ -1722,6 +1722,24 @@
</formalpara>
</listitem>
+ <listitem>
+ <formalpara>
+
+ <title><option role="mysqldump">--add-drop-trigger</option> option for
+ <command>mysqldump</command></title>
+
+ <para>
+ Beginning with MySQL Cluster NDB 7.1.8, this option can be
+ used to force all <literal role="stmt">CREATE
+ TRIGGER</literal> statements in
+ <command>mysqldump</command> output to be preceded by a
+ <literal role="stmt" condition="drop-trigger">DROP TRIGGER
+ IF EXISTS</literal> statement.
+ </para>
+
+ </formalpara>
+ </listitem>
+
</itemizedlist>
</section>
@@ -2286,9 +2304,9 @@
</para>
</formalpara>
-
+
<para>
- See <xref linkend="change-master-to"/>, as well as
+ See <xref linkend="change-master-to"/>, as well as
<xref linkend="show-slave-status"/>, for more information.
</para>
</listitem>
@@ -2558,6 +2576,24 @@
</formalpara>
</listitem>
+ <listitem>
+ <formalpara>
+
+ <title><option role="mysqldump">--add-drop-trigger</option> option for
+ <command>mysqldump</command></title>
+
+ <para>
+ Beginning with MySQL Cluster NDB 7.0.19, this option can
+ be used to force all <literal role="stmt">CREATE
+ TRIGGER</literal> statements in
+ <command>mysqldump</command> output to be preceded by a
+ <literal role="stmt" condition="drop-trigger">DROP TRIGGER
+ IF EXISTS</literal> statement.
+ </para>
+
+ </formalpara>
+ </listitem>
+
</itemizedlist>
</section>
@@ -3225,27 +3261,28 @@
</formalpara>
</listitem>
-
+
<listitem>
<formalpara>
-
+
<title>New <literal role="stmt">CHANGE MASTER TO</literal> option for circular
replication</title>
-
+
<para>
Beginning with MySQL Cluster NDB 6.3.31, the
- <literal role="stmt">CHANGE MASTER TO</literal> statement
- supports an <literal>IGNORE_SERVER_IDS</literal> option
- which takes a comma-separated list of server IDs and
- causes events originating from the corresponding servers
- to be ignored. (Log rotation and log deletion events are
+ <literal role="stmt">CHANGE MASTER TO</literal>
+ statement supports an
+ <literal>IGNORE_SERVER_IDS</literal> option which takes
+ a comma-separated list of server IDs and causes events
+ originating from the corresponding servers to be
+ ignored. (Log rotation and log deletion events are
preserved.)
</para>
-
+
</formalpara>
-
+
<para>
- See <xref linkend="change-master-to"/>, as well as
+ See <xref linkend="change-master-to"/>, as well as
<xref linkend="show-slave-status"/>, for more information.
</para>
</listitem>
@@ -3431,6 +3468,24 @@
</para>
</listitem>
+ <listitem>
+ <formalpara>
+
+ <title><option role="mysqldump">--add-drop-trigger</option> option for
+ <command>mysqldump</command></title>
+
+ <para>
+ Beginning with MySQL Cluster NDB 6.3.38, this option can
+ be used to force all <literal role="stmt">CREATE
+ TRIGGER</literal> statements in
+ <command>mysqldump</command> output to be preceded by a
+ <literal role="stmt" condition="drop-trigger">DROP
+ TRIGGER IF EXISTS</literal> statement.
+ </para>
+
+ </formalpara>
+ </listitem>
+
</itemizedlist>
</para>
@@ -3851,28 +3906,28 @@
added in MySQL Cluster NDB 6.2.19.
</para>
</listitem>
-
-
+
<listitem>
<formalpara>
-
+
<title>New <literal role="stmt">CHANGE MASTER TO</literal> option for circular
replication</title>
-
+
<para>
Beginning with MySQL Cluster NDB 6.2.19, the
- <literal role="stmt">CHANGE MASTER TO</literal> statement
- supports an <literal>IGNORE_SERVER_IDS</literal> option
- which takes a comma-separated list of server IDs and
- causes events originating from the corresponding servers
- to be ignored. (Log rotation and log deletion events are
+ <literal role="stmt">CHANGE MASTER TO</literal>
+ statement supports an
+ <literal>IGNORE_SERVER_IDS</literal> option which takes
+ a comma-separated list of server IDs and causes events
+ originating from the corresponding servers to be
+ ignored. (Log rotation and log deletion events are
preserved.)
</para>
-
+
</formalpara>
-
+
<para>
- See <xref linkend="change-master-to"/>, as well as
+ See <xref linkend="change-master-to"/>, as well as
<xref linkend="show-slave-status"/>, for more information.
</para>
</listitem>
Modified: trunk/refman-5.1/programs-client-core.xml
===================================================================
--- trunk/refman-5.1/programs-client-core.xml 2010-09-10 03:04:53 UTC (rev 22666)
+++ trunk/refman-5.1/programs-client-core.xml 2010-09-10 09:04:21 UTC (rev 22667)
Changed blocks: 1, Lines Added: 32, Lines Deleted: 0; 1535 bytes
@@ -5969,6 +5969,38 @@
</listitem>
<listitem>
+ <para id="option_mysqldump_add-drop-trigger">
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>add-drop-trigger option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>add-drop-trigger option</primary>
+ <secondary>mysqldump</secondary>
+ </indexterm>
+
+ <option role="mysqldump">--add-drop-trigger</option>
+ </para>
+
+ <para>
+ Add a <literal role="stmt">DROP TRIGGER</literal> statement
+ before each <literal role="stmt">CREATE TRIGGER</literal>
+ statement.
+ </para>
+
+ <note>
+ <para>
+ This option is supported only by
+ <command>mysqldump</command> as supplied with MySQL
+ Cluster NDB 6.3.38, MySQL Cluster NDB 7.0.19, MySQL
+ Cluster NDB 7.1.8, and later MySQL Cluster release. It is
+ not available when using MySQL ¤t-series;.
+ </para>
+ </note>
+ </listitem>
+
+ <listitem>
<para id="option_mysqldump_add-locks">
<indexterm>
<primary>mysqldump</primary>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r22667 - in trunk: dynamic-docs/changelog dynamic-docs/command-optvars refman-5.1 | jon.stephens | 10 Sep |
