From: Date: April 24 2007 4:30am Subject: svn commit - mysqldoc@docsrva: r6099 - in trunk: refman-5.1 refman-5.1/images refman-common/cluster-graphics refman-common/images List-Archive: http://lists.mysql.com/commits/25213 Message-Id: <200704240230.l3O2Unok026322@docsrva.mysql.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Author: jstephens Date: 2007-04-24 04:30:24 +0200 (Tue, 24 Apr 2007) New Revision: 6099 Log: Documented fix for Cluster Bug #25688 Updated discussion of circular replication in mysql-cluster-replication-issues (Thanks, Tomas!) Added diagrams relating to this discussion (Dia and PNG format) Added: trunk/refman-5.1/images/cluster-circular-replication-1.png trunk/refman-5.1/images/cluster-circular-replication-2.png trunk/refman-common/cluster-graphics/cluster-circular-replication-1.dia trunk/refman-common/cluster-graphics/cluster-circular-replication-1.png trunk/refman-common/cluster-graphics/cluster-circular-replication-2.dia trunk/refman-common/cluster-graphics/cluster-circular-replication-2.png trunk/refman-common/images/cluster-circular-replication-1.png trunk/refman-common/images/cluster-circular-replication-2.png Modified: trunk/refman-5.1/Makefile.depends trunk/refman-5.1/mysql-cluster.xml trunk/refman-5.1/news-5.1.xml Property changes on: trunk/refman-5.1/images/cluster-circular-replication-1.png ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-5.1/images/cluster-circular-replication-2.png ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-common/cluster-graphics/cluster-circular-replication-1.dia ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-common/cluster-graphics/cluster-circular-replication-1.png ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-common/cluster-graphics/cluster-circular-replication-2.dia ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-common/cluster-graphics/cluster-circular-replication-2.png ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-common/images/cluster-circular-replication-1.png ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-common/images/cluster-circular-replication-2.png ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Modified: trunk/refman-5.1/Makefile.depends =================================================================== --- trunk/refman-5.1/Makefile.depends 2007-04-24 01:44:45 UTC (rev 6098) +++ trunk/refman-5.1/Makefile.depends 2007-04-24 02:30:24 UTC (rev 6099) Changed blocks: 4, Lines Added: 8, Lines Deleted: 0; 1521 bytes @@ -572,6 +572,8 @@ faqs.xml \ images/PSEArch.png \ images/blackhole-1.png \ + images/cluster-circular-replication-1.png \ + images/cluster-circular-replication-2.png \ images/cluster-components-1.png \ images/cluster-replication-binlog-injector.png \ images/cluster-replication-overview.png \ @@ -676,6 +678,8 @@ ../refman-common/replication-graphics/submaster-performance.png \ images/PSEArch.png \ images/blackhole-1.png \ + images/cluster-circular-replication-1.png \ + images/cluster-circular-replication-2.png \ images/cluster-components-1.png \ images/cluster-replication-binlog-injector.png \ images/cluster-replication-overview.png \ @@ -696,6 +700,8 @@ ../common/phrases.ent \ ../refman-common/urls.ent \ all-entities.ent \ + images/cluster-circular-replication-1.png \ + images/cluster-circular-replication-2.png \ images/cluster-components-1.png \ images/cluster-replication-binlog-injector.png \ images/cluster-replication-overview.png \ @@ -707,6 +713,8 @@ images/rolling-restarts.png \ versions.ent mysql_cluster_IMAGES = \ + images/cluster-circular-replication-1.png \ + images/cluster-circular-replication-2.png \ images/cluster-components-1.png \ images/cluster-replication-binlog-injector.png \ images/cluster-replication-overview.png \ Added: trunk/refman-5.1/images/cluster-circular-replication-1.png =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 347 bytes Added: trunk/refman-5.1/images/cluster-circular-replication-2.png =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 347 bytes Modified: trunk/refman-5.1/mysql-cluster.xml =================================================================== --- trunk/refman-5.1/mysql-cluster.xml 2007-04-24 01:44:45 UTC (rev 6098) +++ trunk/refman-5.1/mysql-cluster.xml 2007-04-24 02:30:24 UTC (rev 6099) Changed blocks: 1, Lines Added: 76, Lines Deleted: 15; 5242 bytes @@ -17227,24 +17227,85 @@ - Circular replication is not supported for Cluster - replication. This is because all log events created in a - particular MySQL Cluster are wrongly tagged with the server - id of the MySQL server used as master and not with the - server id of the originating server. + Circular replication: - + - Because of this misidentification, replicating between MySQL - servers A→B→A, - where B is any MySQL server connected - to a cluster A, causes the cluster - table changes (log entries) of A to - lose the originating server's identifier in - the log from B to - A. This causes the changes to be - reapplied on server A. + Prior to MySQL 5.1.18, circular replication was not + supported with MySQL Cluster replication, due to the fact + that all log events created in a particular MySQL Cluster + were wrongly tagged with the server ID of the MySQL server + used as master and not with the server ID of the originating + server. + + + Beginning with MySQL 5.1.18, this limitation is lifted, as + discussed in the next few paragraphs, in which we consider + the example of a replication setup involving three MySQL + Clusters numbered 1, 2, and 3, in which Cluster 1 acts as + the replication master for Cluster 2, Cluster 2 acts as the + master for Cluster 3, and Cluster 3 acts as the master for + Cluster 1. Each cluster has two SQL nodes, with SQL nodes A + and B belonging to Cluster 1, SQL nodes C and D belonging to + Cluster 2, and SQL nodes E and F belonging to Cluster 3. + + + + Circular replication using these clusters is supported as + long as: + + the SQL nodes on all masters and slaves are the + sameAll SQL nodes acting + as replication masters and slaves are started using the + option + This type of circular replication setup is shown in the following diagram: + + + + + + + Cluster circular replication scheme in + which all master SQL nodes are also slaves. + + + + In this scenario, SQL node A in Cluster 1 replicates to SQL + node C in Cluster 2; SQL node C replicates to SQL node E in + Cluster 3; SQL node E replicates to SQL node A. In other + words, the replication line (indicated by the red arrows in + the diagram) directly connects all SQL nodes used as + replication masters and slaves. + + + + It should also be possible to set up circular replication in which + not all master SQL nodes are also slaves, as shown here: + + + + + + + Cluster circular replication scheme in + which all master SQL nodes are not also necessarily slaves. + + + + + In this case, different SQL nodes in each cluster are used + as replication masters and slaves. However, you must + not start any of the SQL nodes using + (see the + description of this + option for more information). This type of circular + replication scheme for MySQL Cluster, in which the line of + replication (again indicated by the red arrows in the + diagram) is discontinuous, should be possible, but it should + be noted that it has not yet been thoroughly tested and + must therefore still be considered experimental. + Modified: trunk/refman-5.1/news-5.1.xml =================================================================== --- trunk/refman-5.1/news-5.1.xml 2007-04-24 01:44:45 UTC (rev 6098) +++ trunk/refman-5.1/news-5.1.xml 2007-04-24 02:30:24 UTC (rev 6099) Changed blocks: 1, Lines Added: 10, Lines Deleted: 0; 716 bytes @@ -156,6 +156,16 @@ . + + + + NDB Cluster (Replication): Some + circular replication setups are now supported for MySQL + Cluster. See + , for + detailed information. (Bug #25688) + + Added: trunk/refman-common/cluster-graphics/cluster-circular-replication-1.dia =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 373 bytes Added: trunk/refman-common/cluster-graphics/cluster-circular-replication-1.png =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 373 bytes Added: trunk/refman-common/cluster-graphics/cluster-circular-replication-2.dia =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 373 bytes Added: trunk/refman-common/cluster-graphics/cluster-circular-replication-2.png =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 373 bytes Added: trunk/refman-common/images/cluster-circular-replication-1.png =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 353 bytes Added: trunk/refman-common/images/cluster-circular-replication-2.png =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 353 bytes