… actual physical volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual machines tend… files on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster… not responsive because of swapping is pretty bad for a cluster and we often ended up is strange, unexpected states. What…
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
When I did NDB Cluster engagements, it happened a few time that I had to cover the NDB API. Once, a customer asked… on how to perform a simple scan. Remembering that some examples are within the NDB source tree, under ./storage/ndb/ndbapi-examples/ and…-laptop:/opt/mysql-cluster-gpl-7.0.8/storage/ndb/ndbapi-examples/ndbapi_scan$ LD_LIBRARY_PATH=/usr/local/mysql-cluster-gpl-7…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
NDB cluster is a very interesting solution in term of high availability … IP in the cluster config and perform an rolling restart! no? In fact this will not work, since the cluster is already in degraded mode, restarting the surviving node of the degraded node group (NoOfReplicas=2) will cause the NDB cluster…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… NDB cluster. @Gerry: I have seen cluster that have been up for more than a years and I maintain it is 5 9s. NDB… replication can reduce the downtime. I agree that for good performance, data needs to be in memory but… that about the…, most of them would have covered by Heartbeat/DRBD or NDB Cluster. @Todd: Replication are two different ways of replicating data, from…
Post: Tutorial Insights for Percona Live, London
August 24, 2011 By Leave a Comment
… NDB Cluster Tutorial which is full day in depth tutorial focused on NDB Cluster/MySQL Cluster technology which is rapidly gaining popularity for building high performance… Cluster consultants in United States, having worked with MySQL Cluster deployments in many high scale mission critical applications. Yves specializes in MySQL Cluster Performance…
Comment: Announcement of Percona XtraDB Cluster (alpha release)
January 12, 2012 By 30 Comments
Pretty good discussion here on NDB vs XtraDB clusters. One point that didn’t come up is that NDB is a real-time… or 2 ms. For InnoDB (ie XtraDB Cluster) you will not see as stable performance as this, although if your data fits… server to an NDB Cluster. This is all true. Otoh in your case if you are already running on MySQL Cluster, the same…
Comment: Is VoltDB really as scalable as they claim?
March 2, 2011 By 3 Comments
… node (data nodes) MySQL Cluster. That’s the largest NDB Cluster I’ve heard of so far. Even if NDB allows some hundred nodes in the configuration file, I was still impressed to hear about such a large cluster actually up and running and performing well. Until then we had heard of about 16-24 node clusters, even then…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…’s common to see much higher numbers from NDB and 5.5.x clusters with not just simple queries or simple transactions… to show just how far things have come with MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building-a-mysql… cloud service that can be used to host rapidly scalable NDB clusters (commence with inserting a shameless plug that users can then…
Comment: Finding your MySQL High-Availability solution – The questions
October 27, 2009 By 36 Comments
… Zed, NDB cluster does not really make sense for Data warehouse applications. There was a discussion on what is good for cluster on the mailing list, check out the thread that starts here: http://lists.mysql.com/cluster/6960. In terms of performance… the thread sums up rather well what scales well with NDB.
