2006-04-24
How To Set Up A Load-Balanced MySQL Cluster
A very useful article on MySQL Clustering.
MySQL Cluster is essentially a 3 tier system with a management interface:
Keep in mind that MySQL Cluster Data Tables are IN MEMORY data tables only, so your storage capacity is limited by system RAM on all your nodes (lowest common denominator).
It does however produce extremely fast query performance, comparable to HEAP table performance, but with additional reliability.
Resources:
Article : How To Set Up A Load-Balanced MySQL Cluster
MySQL Home Page
MySQL Official Clustering Documentation (version 5.1)
MySQL Cluster is essentially a 3 tier system with a management interface:
Keep in mind that MySQL Cluster Data Tables are IN MEMORY data tables only, so your storage capacity is limited by system RAM on all your nodes (lowest common denominator).
It does however produce extremely fast query performance, comparable to HEAP table performance, but with additional reliability.
Resources:
Article : How To Set Up A Load-Balanced MySQL Cluster
MySQL Home Page
MySQL Official Clustering Documentation (version 5.1)
