From: jon Date: October 24 2008 8:13pm Subject: svn commit - mysqldoc@docsrva: r12149 - in trunk: common refman-5.1 topic-guides/topics-5.1 topic-guides/topics-6.0 List-Archive: http://lists.mysql.com/commits/57041 Message-Id: <200810242013.m9OKDSZk023963@docsrva.mysql.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Author: jstephens Date: 2008-10-24 22:13:27 +0200 (Fri, 24 Oct 2008) New Revision: 12149 Log: Updated Cluster RPM info in installing-core (Thanks, Elena!) Updated Cluster installation instructions Re-published Cluster RPM instructions (now that we have them again) Split up entity refs for Cluster releases Updated dependencies Modified: trunk/common/phrases.ent trunk/refman-5.1/Makefile.depends trunk/refman-5.1/installing-core.xml trunk/refman-5.1/mysql-cluster-multi-computer.xml trunk/topic-guides/topics-5.1/Makefile.depends trunk/topic-guides/topics-6.0/Makefile.depends Modified: trunk/common/phrases.ent =================================================================== --- trunk/common/phrases.ent 2008-10-24 19:47:30 UTC (rev 12148) +++ trunk/common/phrases.ent 2008-10-24 20:13:27 UTC (rev 12149) Changed blocks: 1, Lines Added: 4, Lines Deleted: 2; 1764 bytes @@ -14,8 +14,10 @@ - - + + + + MySQL ClusterThe information in this section applies to users of MySQL Cluster only. For more information, see .'> MySQL ClusterThe following information applies to users of MySQL Cluster only. For more information, see .'> The following information applies to all MySQL users.'> \ No newline at end of file Modified: trunk/refman-5.1/Makefile.depends =================================================================== --- trunk/refman-5.1/Makefile.depends 2008-10-24 19:47:30 UTC (rev 12148) +++ trunk/refman-5.1/Makefile.depends 2008-10-24 20:13:27 UTC (rev 12149) Changed blocks: 2, Lines Added: 3, Lines Deleted: 1; 1261 bytes @@ -591,6 +591,7 @@ ../refman-5.1/metadata/internationalization.idmap \ ../refman-5.1/metadata/language-structure-core.idmap \ ../refman-5.1/metadata/mysql-cluster-configuration.idmap \ + ../refman-5.1/metadata/mysql-cluster-multi-computer.idmap \ ../refman-5.1/metadata/mysql-cluster-utilities.idmap \ ../refman-5.1/metadata/news-5.1-core.idmap \ ../refman-5.1/metadata/news.idmap \ @@ -2094,7 +2095,8 @@ ../refman-5.1/metadata/mysql-cluster-multi-computer.idmap \ ../refman-5.1/metadata/mysql-cluster-process-management.idmap \ ../refman-5.1/metadata/mysql-cluster-security.idmap \ - ../refman-5.1/metadata/mysql-cluster-upgrade-downgrade.idmap + ../refman-5.1/metadata/mysql-cluster-upgrade-downgrade.idmap \ + ../refman-5.1/metadata/mysql-cluster-utilities.idmap mysql-cluster-multi-computer.validpure: $(mysql_cluster_multi_computer_SOURCES) mysql-cluster-multi-computer.titles: $(mysql_cluster_multi_computer_SOURCES) mysql-cluster-multi-computer.useless: $(mysql_cluster_multi_computer_SOURCES) Modified: trunk/refman-5.1/installing-core.xml =================================================================== --- trunk/refman-5.1/installing-core.xml 2008-10-24 19:47:30 UTC (rev 12148) +++ trunk/refman-5.1/installing-core.xml 2008-10-24 20:13:27 UTC (rev 12149) Changed blocks: 1, Lines Added: 28, Lines Deleted: 0; 1493 bytes @@ -5759,6 +5759,34 @@ installation. + + + RPMs for MySQL Cluster + + + Beginning with MySQL 5.1.24, standard MySQL server RPMs built by + MySQL no longer provide support for the + NDBCLUSTER storage engine. MySQL Cluster + users wanting to upgrade MySQL 5.1.23 or earlier installations + from RPMs built by MySQL should upgrade to MySQL Cluster NDB 6.2 + or MySQL Cluster NDB 6.3; RPMs that should work with most Linux + distributions are available for both of these release series. + + + + When upgrading a MySQL Cluster RPM installation, you must + upgrade all installed RPMs, including + the Server and Client + RPMs. + + + + For more information about installing MySQL Cluster from RPMs, + see . + + + + For upgrades, if your installation was originally produced by installing multiple RPM packages, it is best to upgrade all the Modified: trunk/refman-5.1/mysql-cluster-multi-computer.xml =================================================================== --- trunk/refman-5.1/mysql-cluster-multi-computer.xml 2008-10-24 19:47:30 UTC (rev 12148) +++ trunk/refman-5.1/mysql-cluster-multi-computer.xml 2008-10-24 20:13:27 UTC (rev 12149) Changed blocks: 28, Lines Added: 142, Lines Deleted: 88; 19429 bytes @@ -85,7 +85,7 @@ IP Address - Management (MGM) node + Management (MGMD) node 192.168.0.10 @@ -383,7 +383,7 @@
- Multi-Computer Installation + Installation of MySQL Cluster installing MySQL Cluster @@ -416,20 +416,24 @@ - MySQL AB provides precompiled binaries that support Cluster, and - there is generally no need to compile these yourself. However, we - also include information relating to installing a MySQL Cluster - after building MySQL from source. For setting up a cluster using - MySQL's binaries, the first step in the installation process - for each cluster host is to download the file - mysql-&mysql-cluster-current-6.2;-linux-i686-glibc23.tar.gz - from the MySQL downloads - area. We assume that you have placed it in each machine's - /var/tmp directory. (If you do require a - custom binary, see .) + MySQL AB provides precompiled binaries that support Cluster. + However, we also include information relating to installing a + MySQL Cluster after building MySQL from source. For setting up a + cluster using MySQL's binaries, the first step in the + installation process for each cluster host is to download the + latest MySQL Cluster NDB 6.2 or MySQL Cluster NDB 6.3 binary + archive + (mysql-cluster-gpl-&ndb-engine-current-6.2;-linux-i686-glibc23.tar.gz + or + mysql-cluster-gpl-&ndb-engine-current-6.3;-linux-i686-glibc23.tar.gz, + respectively) from the + MySQL Cluster downloads + area. We assume that you have placed this file in each + machine's /var/tmp directory. (If you do + require a custom binary, see + .) - @@ -560,14 +585,14 @@ file, unpack the archive, and create a symlink to the mysql directory named mysql. Note that the actual file and - directory names will vary according to the MySQL version - number. + directory names will vary according to the MySQL Cluster + version number. shell> cd /var/tmp -shell> tar -C /usr/local -xzvf mysql-&mysql-cluster-current-6.2;-linux-i686-glibc23.tar.gz -shell> ln -s /usr/local/mysql-&mysql-cluster-current-6.2;-linux-i686-glibc23.tar.gz /usr/local/mysql +shell> tar -C /usr/local -xzvf mysql-cluster-gpl-&ndb-engine-current-6.3;-linux-i686-glibc23.tar.gz +shell> ln -s /usr/local/mysql-cluster-gpl-&ndb-engine-current-6.3;-linux-i686-glibc23.tar.gz /usr/local/mysql @@ -636,26 +661,25 @@ - Remember that the preceding steps must be performed separately - on each machine where an SQL node is to reside. + Remember that the preceding steps must be repeated on each + machine where an SQL node is to reside. - @@ -702,7 +739,6 @@ - @@ -754,12 +789,13 @@ Installation of the management node does not require the - mysqld binary. Only the binary for the - management server is required, which can be found in the - downloaded archive. You most likely want to install the - management client as well; this can also be found in the - .tar.gz archive. Again, we assume that you - have placed this archive in /var/tmp. + mysqld binary. Only the MySQL Cluster + management server (ndb_mgmd) is required; you + most likely want to install the management client + (ndb_mgm) as well. Both of these binaries + also be found in the .tar.gz archive. + Again, we assume that you have placed this archive in + /var/tmp. @@ -784,8 +820,8 @@ shell> cd /var/tmp -shell> tar -zxvf mysql-&mysql-cluster-current-6.2;-linux-i686-glibc23.tar.gz -shell> cd mysql-&mysql-cluster-current-6.2;-linux-i686-glibc23 +shell> tar -zxvf mysql-&mysql-cluster-current-6.3;-linux-i686-glibc23.tar.gz +shell> cd mysql-&mysql-cluster-current-6.3;-linux-i686-glibc23 shell> cp /bin/ndb_mgm* /usr/local/bin @@ -813,7 +849,6 @@ - @@ -882,7 +932,8 @@ In , we create - configuration files for all of the nodes in our example Cluster. + configuration files for all of the nodes in our example MySQL + Cluster.
@@ -917,9 +968,10 @@ Each data node or SQL node requires a my.cnf file that provides two pieces of information: a connectstring that tells - the node where to find the MGM node, and a line telling the - MySQL server on this host (the machine hosting the data node) - to run in NDB mode. + the node where to find the management node, and a line telling + the MySQL server on this host (the machine hosting the data + node) to enable the NDBCLUSTER storage + engine. @@ -956,10 +1008,12 @@ shell> vi /etc/my.cnf - - We show vi being used here to create the file, - but any text editor should work just as well. - + + + We show vi being used here to create the + file, but any text editor should work just as well. + + For each data node and SQL node in our example setup, @@ -1002,9 +1056,9 @@ Configuring the management node - The first step in configuring the MGM node is to create the - directory in which the configuration file can be found and then - to create the file itself. For example (running as + The first step in configuring the management node is to create + the directory in which the configuration file can be found and + then to create the file itself. For example (running as root): @@ -1041,8 +1095,8 @@ # Management process options: [ndb_mgmd] -hostname=192.168.0.10 # Hostname or IP address of MGM node -datadir=/var/lib/mysql-cluster # Directory for MGM node log files +hostname=192.168.0.10 # Hostname or IP address of management node +datadir=/var/lib/mysql-cluster # Directory for management node log files # Options for data node "A": [ndbd] @@ -1208,7 +1262,7 @@ The SQL node is referenced here as [mysqld(API)]. This is perfectly normal, and reflects the fact that the mysqld process is - acting as a cluster API node. + acting as a MySQL Cluster API node. @@ -1247,9 +1301,8 @@ For a table to be replicated in the cluster, it must use the NDBCLUSTER storage engine. To specify this, - use the or - table option. You can add - this option when creating the table: + use the ENGINE=NDBCLUSTER or + ENGINE=NDB option when creating the table: @@ -1269,10 +1322,11 @@ - Each NDB table must - have a primary key. If no primary key is defined by the user - when a table is created, the NDBCLUSTER - storage engine automatically generates a hidden one. + Each NDBCLUSTER table + must have a primary key. If no primary + key is defined by the user when a table is created, the + NDBCLUSTER storage engine automatically + generates a hidden one. @@ -1327,13 +1381,13 @@ - You need to make sure that MySQL uses the NDB - storage engine for this table. There are two ways that this can be - accomplished. One of these is to modify the table definition - before importing it into the Cluster - database. Using the City table as an example, - modify the ENGINE option of the definition as - follows: + You need to make sure that MySQL uses the + NDBCLUSTER storage engine for this table. There + are two ways that this can be accomplished. One of these is to + modify the table definition before importing + it into the Cluster database. Using the City + table as an example, modify the ENGINE option + of the definition as follows: Modified: trunk/topic-guides/topics-5.1/Makefile.depends =================================================================== --- trunk/topic-guides/topics-5.1/Makefile.depends 2008-10-24 19:47:30 UTC (rev 12148) +++ trunk/topic-guides/topics-5.1/Makefile.depends 2008-10-24 20:13:27 UTC (rev 12149) Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 730 bytes @@ -290,6 +290,7 @@ ../../refman-5.1/metadata/installing-core.idmap \ ../../refman-5.1/metadata/internationalization.idmap \ ../../refman-5.1/metadata/mysql-cluster-configuration.idmap \ + ../../refman-5.1/metadata/mysql-cluster-multi-computer.idmap \ ../../refman-5.1/metadata/mysql-cluster-utilities.idmap \ ../../refman-5.1/metadata/programs-admin-util-core.idmap \ ../../refman-5.1/metadata/programs-server-core.idmap \ Modified: trunk/topic-guides/topics-6.0/Makefile.depends =================================================================== --- trunk/topic-guides/topics-6.0/Makefile.depends 2008-10-24 19:47:30 UTC (rev 12148) +++ trunk/topic-guides/topics-6.0/Makefile.depends 2008-10-24 20:13:27 UTC (rev 12149) Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 720 bytes @@ -192,6 +192,7 @@ ../../refman-6.0/metadata/programs-using.idmap \ ../../refman-6.0/metadata/se-innodb-core.idmap \ ../../refman-5.1/metadata/mysql-cluster-configuration.idmap \ + ../../refman-5.1/metadata/mysql-cluster-multi-computer.idmap \ ../../refman-5.1/metadata/mysql-cluster-utilities.idmap \ ../../refman-common/metadata/bug-reports.idmap mysql-linuxunix-excerpt.validpure: $(mysql_linuxunix_excerpt_SOURCES)