MySQL Cluster: Difference between revisions

Revision as of 10:48, 19 August 2005

Revision as of 15:34, 24 August 2005

Line 4:

MySQL Cluster has a few important concepts behind its design, which give both benefits and disadvantages.

===Replication===

NDB uses synchronous replication through a two-phase commit mechanism in order to guarantee that data isare written to multiple nodes upon committing the data. Normally there isare two copies of the data in the cluster, however it can be configured to allow 1-4one to four copies at any single time.

===Horizontal Data Partitioning===

Data within NDB tables are automatically partitioned across all of the data nodes in the system. This is done based on a hashing algorithm based on the PRIMARY KEY on the table. This is totally transparent to the end application.