From: jon.stephens
Date: June 28 2011 10:41am
Subject: svn commit - mysqldoc@oter02: r26633 - trunk/refman-5.1
List-Archive: http://lists.mysql.com/commits/139956
Message-Id: <20110628104130.C02EE7806F@oter02.norway.sun.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: js221926
Date: 2011-06-28 12:41:30 +0200 (Tue, 28 Jun 2011)
New Revision: 26633
Log:
Master and slave mysqlds must come from Cluster distribution, not 5.1. (BUG#61552)
Modified:
trunk/refman-5.1/mysql-cluster-replication-core.xml
Modified: trunk/refman-5.1/mysql-cluster-replication-core.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster-replication-core.xml 2011-06-28 08:41:34 UTC (rev 26632)
+++ trunk/refman-5.1/mysql-cluster-replication-core.xml 2011-06-28 10:41:30 UTC (rev 26633)
Changed blocks: 4, Lines Added: 45, Lines Deleted: 18; 4762 bytes
@@ -56,13 +56,14 @@
conceptually very similar but can be more complex in practice, as it
may be extended to cover a number of different configurations
including replicating between two complete clusters. Although a
- MySQL Cluster itself depends on the
- NDBCLUSTER storage engine for
- clustering functionality, it is not necessary to use the Cluster
- storage engine on the slave. However, for maximum availability, it
- is possible to replicate from one MySQL Cluster to another, and it
- is this type of configuration that we discuss, as shown in the
- following figure:
+ MySQL Cluster itself depends on the NDB
+ storage engine for clustering functionality, it is not necessary to
+ use NDB as the storage engine for the
+ slave's copies of the replicated tables (see
+ ). However,
+ for maximum availability, it is possible (and preferable) to
+ replicate from one MySQL Cluster to another, and it is this scenario
+ that we discuss, as shown in the following figure:
@@ -96,6 +97,27 @@
.
+
+
+ Replication from NDB to non-NDB
+ tables
+
+
+ It is possible to replicate NDB
+ tables from a MySQL Cluster acting as the master to tables using
+ other MySQL storage engines such as
+ InnoDB or
+ MyISAM on a slave
+ mysqld. However, because of differences between
+ the version of mysqld provided with MySQL
+ Cluster and that included with MySQL Server ¤t-series;, the
+ slave server must also use a mysqld binary from
+ the MySQL Cluster distribution. See
+ .
+
+
+
+
MySQL Cluster Replication: Abbreviations and Symbols
@@ -182,7 +204,7 @@
- MySQL Cluster Replication: Assumptions and General Requirements
+ General Requirements for MySQL Cluster ReplicationMySQL Cluster replication
@@ -245,19 +267,24 @@
option,
where id is a unique integer. Although
it is not strictly necessary, we will assume for purposes of this
- discussion that all MySQL installations are the same version.
+ discussion that all MySQL Cluster binaries are of the same release
+ version.
- In any event, both MySQL servers involved in replication must be
- compatible with one another with respect to both the version of
- the replication protocol used and the SQL feature sets which they
- support; the simplest and easiest way to assure that this is the
- case is to use the same MySQL version for all servers involved.
- Note that in many cases it is not possible to replicate to a slave
- running a version of MySQL with a lower version number than that
- of the master (see ,
- for details).
+ It is generally true in MySQL Replication that both MySQL servers
+ (mysqld processes) involved must be compatible
+ with one another with respect to both the version of the
+ replication protocol used and the SQL feature sets which they
+ support (see ). It is
+ due to such differences between the binaries in the MySQL Cluster
+ and MySQL Server ¤t-series; distributions that MySQL Cluster
+ Replication has the additional requirement that both
+ mysqld binaries come from a MySQL Cluster
+ distribution. The simplest and easiest way to assure that the
+ mysqld servers are compatible is to use the
+ same MySQL Cluster distribution for all master and slave
+ mysqld binaries.