MySQL Cluster: Difference between revisions

Revision as of 05:16, 20 May 2007

Revision as of 18:08, 30 May 2007

Line 1:

'''MySQL Cluster''' is a technology which provides [[Shared nothing architecture|shared-nothing]] clustering capabilities for the [[MySQL]] [[database management system]]. It was first included in the production release of MySQL 4.1 in November 2004. It is designed to provide very high availability and high performance, while allowing for nearly linear scalability. MySQL Cluster is implemented through an additional storage engine available within [[MySQL]] called NDB or NDBCLUSTER ("NDB" stands for for '''N'''etwork '''D'''ata'''b'''ase).

==Architecture==

Line 5:

===Replication===

MySQL Cluster uses [[synchronous replication]] through a [[two-phase commit]] mechanism in order to guarantee that data is written to multiple nodes upon committing the data. (This is in contrast to what as what is usually referred to as "[[http://dev.mysql.com/doc/en/replication.html MySQL Replication]]", which is asynchronous.) Two copies (known as ''replicas'') of the data are required to guarantee availability; however, the cluster can be configured to store one to four copies at any single time.

===Horizontal Data Partitioning===

Line 52:

* [http://www.neckermann.de/ Neckermann.de] GmbH - uses MySQL cluster to store the customer profiles and session data of their online web shop

* [http://www.vodafone.co.uk/ Vodafone UK] - uses MySQL cluster for a range of IN Applictions

* [http://www.alcatel.com/ Alcatel]- uses MySQL Cluster for HSS and [[Home_Location_Register|Home Location Register]] (HLR) applications

== External links==

Line 61:

*[http://dev.mysql.com/doc/ndbapi/en/index.html MySQL NDB API Developers' Guide]

*[http://dev.mysql.com/tech-resources/articles/mysql-cluster-for-two-servers.html MySQL Cluster tutorial]

[[Category:Open source database management systems]]