MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:jon Date:October 9 2008 3:30pm
Subject:svn commit - mysqldoc@docsrva: r12024 - trunk/refman-5.1
View as plain text  
Author: jstephens
Date: 2008-10-09 17:30:36 +0200 (Thu, 09 Oct 2008)
New Revision: 12024

Log:

Starting writeup for WL#1504 (Cluster:Online add/drop nodegroup)



Added:
   trunk/refman-5.1/mysql-cluster-online-add-drop-nodegroup.xml


Added: trunk/refman-5.1/mysql-cluster-online-add-drop-nodegroup.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster-online-add-drop-nodegroup.xml	                        (rev 0)
+++ trunk/refman-5.1/mysql-cluster-online-add-drop-nodegroup.xml	2008-10-09 15:30:36 UTC (rev 12024)
Changed blocks: 1, Lines Added: 187, Lines Deleted: 0; 5334 bytes

@@ -0,0 +1,187 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE section PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN" "http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd" [
+<!ENTITY % all.entities SYSTEM "all-entities.ent">
+%all.entities;
+]>
+<section id="mysql-cluster-online-add-drop-nodegroups">
+
+  <title>Online Adding and Dropping of MySQL Cluster Node Groups</title>
+
+  <para>
+    This section describes how to add and drop MySQL Cluster nodegroups
+    <quote>online</quote> &mdash; that is, without needing to shut down
+    the cluster completely and restarting it as part of the process.
+    This capability is available in MySQL Cluster NDB 6.4.0.
+  </para>
+
+  <para>
+    Currently, it is not possible to add new data nodes to an existing
+    node group online. You must add the data nodes as part of a new node
+    group. In addition, it is not possible to change the number of
+    replicas online.
+  </para>
+
+  <section id="mysql-cluster-online-add-nodegroup">
+
+    <title>Adding a Node Group Online</title>
+
+    <para>
+      This section provides an example procedure for adding a node group
+      to a MySQL Cluster online.
+    </para>
+
+    <formalpara>
+
+      <title>Basic Steps</title>
+
+      <para>
+        Assuming that you already have a running MySQL Cluster, adding
+        data nodes online requires the following steps:
+
+        <orderedlist>
+
+          <listitem>
+            <para>
+              Edit the cluster configuration
+              <filename>config.ini</filename> file, adding new
+              <literal>[ndbd]</literal> sections corresponding to the
+              nodes to be added.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              Restart the MySQL Cluster management server.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              Execute one or more <literal>CREATE NODEGROUP</literal>
+              commands in the MySQL Cluster management client to create
+              the new nodegroup or nodegroups to which the new data
+              nodes will belong.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              Perform a rolling restart of all existing MySQL Cluster
+              data nodes.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              Perform an initial start of the new data nodes.
+            </para>
+
+            <note>
+              <para>
+                The new data nodes may be started concurrently.
+              </para>
+            </note>
+          </listitem>
+
+          <listitem>
+            <para>
+              Perform a rolling restart of any SQL or API nodes
+              connected to the MySQL Cluster.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              Restribute the cluster&apos;s data among all data nodes
+              (including the new ones) by issuing an <literal>ALTER
+              ONLINE TABLE ... ADD PARTITION ...</literal> statement in
+              the <command>mysql</command> client for each
+              <literal>NDBCLUSTER</literal> table.
+            </para>
+
+            <note>
+              <para>
+                This needs to be done only for tables already existing
+                at the time the new node group is added; data in tables
+                created after the new node group is added will be
+                distributed automatically.
+              </para>
+            </note>
+          </listitem>
+
+          <listitem>
+            <para>
+              Reclaim the space freed on the <quote>old</quote> nodes by
+              issuing, for each <literal>NDBCLUSTER</literal> table, an
+              <literal>OPTIMIZE TABLE</literal> statement in the
+              <command>mysql</command> client.
+            </para>
+          </listitem>
+
+        </orderedlist>
+      </para>
+
+    </formalpara>
+
+    <formalpara>
+
+      <title>Example</title>
+
+      <para>
+        In this example, we start with a MySQL Cluster having 2 data
+        nodes in a single node group and conclude with one having 4 data
+        nodes in 2 node groups.
+      </para>
+
+    </formalpara>
+
+    <formalpara>
+
+      <title>Starting configuration</title>
+
+      <para>
+        For purposes of illustration, we assume a minimal configuration,
+        and that the cluster uses a <filename>config.ini</filename> file
+        containing only the following information:
+
+<programlisting>
+[ndbd default]
+DataMemory = 100M
+IndexMemory = 100M
+NoOfReplicas = 2
+DataDir = /home/jon/data
+
+[ndbd]
+Id = 1
+
+[ndbd]
+Id = 2
+
+[mgm]
+HostName = localhost
+Id = 10
+
+[api]
+Id=20
+
+[api]
+Id=21
+</programlisting>
+      </para>
+
+    </formalpara>
+
+  </section>
+
+  <section id="mysql-cluster-online-drop-nodegroup">
+
+    <title>Dropping A Node Group Online</title>
+
+    <para>
+      This section provides an example procedure for removing a node
+      group from a MySQL Cluster online.
+    </para>
+
+  </section>
+
+</section>


Thread
svn commit - mysqldoc@docsrva: r12024 - trunk/refman-5.1jon9 Oct