MySQL Cluster: High Availability for the Masses?!Category: MySQL
Reviewed by: redemption
Reviewed on: May 28 2004
» Discuss this topic (1 Posts)
If you're like me, you're pretty excited about the upcoming MySQL clustering technology that is slated for release later on in 2004. For most small use sites MySQL on a single server is no doubt enough, but if you're doing 200 queries a second or have gigabytes of data, you're no doubt faced with either using replication or else praying your Db holds up under pressure. MySQL Cluster is not out yet, they expect it to be in Alpha for the 4.1.2 release. Final Cluster will be a part of the 4.1 release branch since the 4.0 branch is only in maintenance mode now. So what makes MySQL Cluster COOL for high volume use?
- Load balancing
- No Single Point of Failure
- Hot swappable Auto Configuration Like Behaviour
- Crash Recovery
- Auto Detection of failed Nodes
- Multiple clusters across different geographies
Transparency & Load BalancingUnlike regular MySQL replication, Clustering will be completely transparent to your application. You don't need another layer in your application which will load balance the requests to MySQL, the MySQL Cluster itself will self manage incoming queries and requests through its Nodes. Ideally, most applications will be able to take advantage of Clustering with little actual coding changes, which makes this a very appealing upgrade for MANY organizations.
Not only is it transparent, its intelligent. The system will balance loads, allow paralelle processing, and also supposedly support all memory databases - a feature I am keen on trying myself.
MySQL says that performance is top knotch. While redundancy and failover protection are important features to many people, performance alone is something that might convince many high volume server admins to use MySQL Cluster. According to numbers published by MySQL AB, response times are sub 5ms and a simple 2 Node cluster of single CPU servers can handle 10K replicated transactions/sec.