MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:jon.stephens Date:July 30 2009 6:42am
Subject:svn commit - mysqldoc@docsrva: r15858 - in trunk: dynamic-docs/changelog dynamic-docs/command-optvars refman-5.1
View as plain text  
Author: jstephens
Date: 2009-07-30 08:42:39 +0200 (Thu, 30 Jul 2009)
New Revision: 15858

Log:

Documented new Arbitration parameter (WL#4914)



Modified:
   trunk/dynamic-docs/changelog/mysqld-1.xml
   trunk/dynamic-docs/command-optvars/ndb-config-params.xml
   trunk/refman-5.1/mysql-cluster-configuration.xml
   trunk/refman-5.1/mysql-cluster-roadmap.xml


Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml	2009-07-29 23:15:31 UTC (rev 15857)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml	2009-07-30 06:42:39 UTC (rev 15858)
Changed blocks: 1, Lines Added: 50, Lines Deleted: 0; 1996 bytes

@@ -6,6 +6,56 @@
 ]>
 <changelog>
 
+  <logentry entrytype="feature">
+
+    <tags>
+      <highlight type="cluster"/>
+      <manual type="arbitration"/>
+    </tags>
+
+    <versions>
+      <version ver="5.1.35-ndb-7.0.7"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Previously, it was possible to disable arbitration only by
+        setting <literal>ArbitrationRank</literal> to 0 on all
+        management and API nodes. A new data node configuration
+        parameter <literal>Arbitration</literal> simplifies this task;
+        to disable arbitration, you can now use <literal>Arbitration =
+        Disabled</literal> in the <literal>[ndbd default]</literal>
+        section of the <filename>config.ini</filename> file.
+      </para>
+
+      <para>
+        It is now also possible to configure arbitration in such a way
+        that the cluster waits until the time determined by
+        <literal>ArbitrationTimeout</literal> passes for an external
+        manager to perform arbitration instead of handling it
+        internally. This can be done by setting <literal>Arbitration =
+        WaitExternal</literal> in the <literal>[ndbd default]</literal>
+        section of the <filename>config.ini</filename> file.
+      </para>
+
+      <para>
+        The default value for the Arbitration parameter is
+        <literal>Default</literal>, which allows arbitration to proceed
+        normally, as determined by the
+        <literal>ArbitrationRank</literal> settings for the management
+        and API nodes.
+      </para>
+
+      <para>
+        For more information, see
+        <xref linkend="mysql-cluster-ndbd-definition"/>.
+      </para>
+
+    </message>
+
+  </logentry>
+
   <logentry entrytype="bug">
 
     <tags>


Modified: trunk/dynamic-docs/command-optvars/ndb-config-params.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/ndb-config-params.xml	2009-07-29 23:15:31 UTC (rev 15857)
+++ trunk/dynamic-docs/command-optvars/ndb-config-params.xml	2009-07-30 06:42:39 UTC (rev 15858)
Changed blocks: 1, Lines Added: 24, Lines Deleted: 0; 1108 bytes

@@ -71,6 +71,30 @@
 
   </mysqloption>
 
+  <mysqloption id="arbitration-ndbd" section="cluster" subsection="ndbd">
+
+    <name>Arbitration</name>
+
+    <shortdescription lang="en">
+      How arbitration should be performed to avoid split-brain issues in
+      the event of node failure.
+    </shortdescription>
+
+    <values vartype="enumeration" platform="all" inversion="5.1.35-ndb-7.0.7">
+      <choice value="Disabled"/>
+      <value default="Default"/>
+      <choice value="WaitExternal"/>
+    </values>
+
+    <versions>
+      <introduced version="5.1.35-ndb-7.0.7"/>
+      <manual version="5.1"/>
+    </versions>
+
+    <restart type="node" initial="no"/>
+
+  </mysqloption>
+
   <mysqloption id="arbitrationdelay-api" section="cluster" subsection="api">
 
     <name>ArbitrationDelay</name>


Modified: trunk/refman-5.1/mysql-cluster-configuration.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster-configuration.xml	2009-07-29 23:15:31 UTC (rev 15857)
+++ trunk/refman-5.1/mysql-cluster-configuration.xml	2009-07-30 06:42:39 UTC (rev 15858)
Changed blocks: 3, Lines Added: 104, Lines Deleted: 2; 5181 bytes

@@ -4389,8 +4389,8 @@
           <para>
             Prior to MySQL Cluster NDB versions 6.2.18, 6.3.24, and
             7.0.5, the effective minimum for this parameter was 100
-            milliseconds. (Bug#44099) Beginning with these versions,
-            the actual minimum is 50 milliseconds.
+            milliseconds. (Bug#44099) Beginning with these versions, the
+            actual minimum is 50 milliseconds.
           </para>
         </listitem>
 

@@ -4664,6 +4664,98 @@
           </para>
         </listitem>
 
+        <listitem>
+          <indexterm>
+            <primary>Arbitration</primary>
+          </indexterm>
+
+          <para id="mysql-cluster-param-ndbd-definition-arbitration">
+            <literal>Arbitration</literal>
+          </para>
+
+          <para>
+            The <literal>Arbitration</literal> parameter, added in MySQL
+            Cluster NDB 7.0.7, allows a choice of arbitration schemes,
+            corresponding to one of 3 possible values for this
+            parameter:
+          </para>
+
+          <itemizedlist>
+
+            <listitem>
+              <formalpara>
+
+                <title><literal>Default</literal></title>
+
+                <para>
+                  This allows arbitration to proceed normally, as
+                  determined by the <literal>ArbitrationRank</literal>
+                  settings for the management and API nodes. This is the
+                  default value.
+                </para>
+
+              </formalpara>
+            </listitem>
+
+            <listitem>
+              <formalpara>
+
+                <title><literal>Disabled</literal></title>
+
+                <para>
+                  Previously, it was possible to disable arbitration
+                  only by setting <literal>ArbitrationRank</literal> to
+                  0 on all management and API nodes. Now, you can now
+                  use <literal>Arbitration = Disabled</literal> in the
+                  <literal>[ndbd default]</literal> section of the
+                  <filename>config.ini</filename> file to accomplish
+                  this task. In this case, any
+                  <literal>ArbitrationRank</literal> settings are
+                  ignored.
+                </para>
+
+              </formalpara>
+            </listitem>
+
+            <listitem>
+              <formalpara>
+
+                <title><literal>WaitExternal</literal></title>
+
+                <para>
+                  The <literal>Arbitration</literal> parameter also
+                  makes it possible to configure arbitration in such a
+                  way that the cluster waits until after the time
+                  determined by <literal>ArbitrationTimeout</literal>
+                  has passed for an external cluster manager application
+                  to perform arbitration instead of handling arbitration
+                  internally. This can be done by setting
+                  <literal>Arbitration = WaitExternal</literal> in the
+                  <literal>[ndbd default]</literal> section of the
+                  <filename>config.ini</filename> file. For best results
+                  with the <literal>WaitExternal</literal> setting, it
+                  is recommended that
+                  <literal>ArbitrationTimeout</literal> be 2 times as
+                  long as the interval required by the external cluster
+                  manager to perform arbitration.
+                </para>
+
+              </formalpara>
+            </listitem>
+
+          </itemizedlist>
+
+          <important>
+            <para>
+              This parameter should be used only in the <literal>[ndbd
+              default]</literal> section of the cluster configuration
+              file. The behavior of the cluster is unspecified when
+              <literal>Arbitration</literal> is set to different values
+              for individual data nodes.
+            </para>
+          </important>
+        </listitem>
+
       </itemizedlist>
 
       <formalpara>

@@ -7454,6 +7546,16 @@
               <entry><emphasis role="bold">Restart Type</emphasis></entry>
             </row>
             <row>
+              <entry><literal><link linkend="mysql-cluster-param-ndbd-definition-arbitration">Arbitration</link></literal>
+                (<emphasis>added in MySQL Cluster NDB 7.0.7</emphasis>)</entry>
+              <entry>string (one of: <literal>Default</literal>, <literal>Disabled</literal>,
+                <literal>WaitExternal</literal>)</entry>
+              <entry><literal>Default</literal></entry>
+              <entry>&mdash;</entry>
+              <entry>&mdash;</entry>
+              <entry>N</entry>
+            </row>
+            <row>
               <entry><literal><link linkend="mysql-cluster-param-ndbd-definition-arbitrationtimeout">ArbitrationTimeout</link></literal></entry>
               <entry>milliseconds</entry>
               <entry>3000</entry>


Modified: trunk/refman-5.1/mysql-cluster-roadmap.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster-roadmap.xml	2009-07-29 23:15:31 UTC (rev 15857)
+++ trunk/refman-5.1/mysql-cluster-roadmap.xml	2009-07-30 06:42:39 UTC (rev 15858)
Changed blocks: 1, Lines Added: 28, Lines Deleted: 1; 1428 bytes

@@ -246,12 +246,39 @@
           <entry>Dynamic buffering for NDB transporters</entry>
         </row>
         <row>
-          <entry><literal>NDB$INFO</literal> meta-information database (in development)</entry>
+          <entry>Increased flexibility in determining arbitration handling, via a new
+            <literal>Arbitration</literal> data node configuration
+            parameter</entry>
         </row>
       </tbody>
     </tgroup>
   </informaltable>
 
+  <remark role="TODO">
+    [js] Uncomment link in next table heading after "Features Added in
+    NDB 7.1" section is added.
+  </remark>
+
+  <informaltable>
+    <tgroup cols="1">
+      <colspec colwidth="50*"/>
+      <thead>
+        <row>
+          <entry><!--<link linkend="mysql-cluster-changes-5-1-ndb-7-1">-->
+
+            MySQL Cluster NDB 7.1
+
+<!--</link>--></entry>
+        </row>
+      </thead>
+      <tbody>
+        <row>
+          <entry><literal>NdbInfo</literal> meta-information database (in development)</entry>
+        </row>
+      </tbody>
+    </tgroup>
+  </informaltable>
+
   <section id="mysql-cluster-changes-5-1">
 
     <title>Features Added in MySQL 5.1 Cluster</title>


Thread
svn commit - mysqldoc@docsrva: r15858 - in trunk: dynamic-docs/changelog dynamic-docs/command-optvars refman-5.1jon.stephens30 Jul