Skip navigation links

MySQL Forums :: Cluster :: Cluster / Sharding / Reporting


Advanced Search

Re: Cluster / Sharding / Reporting
Posted by: Mat Keep ()
Date: February 04, 2012 01:12AM

Hi Leon
there have been some significant enhancements to MySQL Cluster over the past 2 years, best demonstrated by the latest Development Release of MySQL Cluster 7.2 which includes Adaptive Query Localization - a technique which pushes JOIN operations down to the data nodes to dramatically improve the performance on complex queries

There have also been a number of enhancements in disk handling and heartbeating which enables MySQL Cluster to perform more predictably and resiliently if the underlying hardware starts to misbehave!

Would recommend reviewing the DevZone article on MySQL Cluster 7.2 to see whats new:
http://dev.mysql.com/tech-resources/articles/mysql-cluster-7.2.html

And also take a look at the Evaluation Guide which provides guidance on determining if Cluster is the right choice, and best practices in building a PoC:
http://dev.mysql.com/downloads/MySQL_Cluster_72_DMR_EvaluationGuide.pdf (note, opens a pdf)

In terms of sharding, MySQL Cluster does this for you automatically at the database layer, eliminating the overhead of implementing sharding directly within your application

Hope this helps - and don't hesitate to contact the forum for any further questions

Options: ReplyQuote


Subject Views Written By Posted
Cluster / Sharding / Reporting 1053 Leon de Beer 02/04/2012 05:00AM
Re: Cluster / Sharding / Reporting 632 Mat Keep 02/04/2012 01:12AM
Re: Cluster / Sharding / Reporting 423 Bernhard Ocklin 02/05/2012 09:52PM
Re: Cluster / Sharding / Reporting 376 Leon de Beer 02/06/2012 09:57AM
Re: Cluster / Sharding / Reporting 367 Bernhard Ocklin 02/07/2012 01:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.