Information on MySQL Cluster and MySQL Replication
Publicising announcements and other information that has been released by MySQL/Oracle as well as other useful information connected with using MySQL Cluster or replication.
-
New white paper: Guide to Optimizing Performance of the MySQL Cluster Database
Posted on December 7th, 2009 2 comments
MySQL Cluster Connection Pooling
This guide explores how to tune and optimize the MySQL Cluster database to handle diverse workload requirements. It discusses data access patterns and how to build distribution awareness into applications, before exploring schema and query optimization, tuning of parameters and how to get the best out of the latest innovations in hardware design.
The Guide concludes with recent performance benchmarks conducted with the MySQL Cluster database, an overview of how MySQL Cluster can be integrated with other MySQL storage engines, before summarizing additional resources that will enable you to optimize MySQL Cluster performance with your applications.
Download the white paper (as always, for free) from: http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_perfomance.php
MySQL Cluster MySQL, MySQL Cluster, MySQL Cluster 7.0, MySQL Cluster CGE, NDB API, Replication, Stored Procedures, White Paper2 responses to “New white paper: Guide to Optimizing Performance of the MySQL Cluster Database”
-
Does Sun have information regarding comparison of MySQL vs. Oracle and TimesTen DB Clustering?
Do you know of any independent evaluations that could be helpful for comparison purpose?
-
Hi John,
I don’t have any material comparing the products but the fundamental technology differences are:
– Oracle RAC is a shared-everything Clustering solution; the up-side is that every node in
the cluster can see all of the data which may help when you have a query that needs to
traverse all of the data. The downside is that the shared storage can be more expensive
and recovery from failures may take longer.
– MySQL Cluster is shared-nothing. The advantage is that you can scale-out with low cost
hardware and recovery from failures is extremely fast. Downsides
are that complex joins can be slow as the data is distributed amongst the data nodes.
– TimesTen is most typically used as a cache sitting between the application and an
Oracle database. TT (at least the last time I checked) doesn’t scale horizontallyRegards, Andrew.
Leave a reply
-
Jonas’s Blog
- small men with big titles October 7, 2012
Mikaels’s Blog
- Year of Anniversaries May 16, 2013
Bernd Ocklin
- O’Reilly Conference MySQL Cluster slides available April 19, 2011
- Around the volcano and home from US in 20 hours April 20, 2010
- MySQL Cluster 7.1.1 is there February 1, 2010
John DePietro December 22nd, 2009 at 12:30