Definitely an impressive benchmark by any standard. However, there are some things to be aware of:<p>1) They used Infiniband interconnects. Running on ethernet is likely to yield less impressive results.<p>2) Their benchmark does simple primary key lookups. If you start doing joins or transactions that need to hit multiple data nodes, things will slow down. Depending on your workload, this may or may not be an issue.<p>3) NDB is an in-memory storage engine, so you're limited to the aggregate RAM in your cluster for max storage size.<p>4) AFAIK, MySQL Cluster doesn't re-balance, you need to pre-determine how data is partitioned and changing it at runtime is hard. I don't know if this has changed in the later releases.
I'm a novice in this area, so looking past the somewhat sensationalist headline (or, perhaps, I'm missing the wit? "Now with 70x more performance!")...<p>Can someone who knows this stuff give a bit of an overview on the significance of this release?<p>I read the NoSQL stuff as Oracle/MySQL trying to compete (at least in terms of marketing-speak) with the wave of competition that's arrived in the DB market. Is there any meat to it?
MySQL Cluster seems like an awesome solution to applications with a high write to read ratio (which applies to several that I currently work on). I'd be curious to hear cases of people successfully using MySQL Cluster and some of its pros/cons in real-life applications.
When did we go from standard measure of per second for these types of things, you know, requests per second, transactions per second, to per minute? Statistics eh?
As a MySQL, Oracle and Clustrix DBA this is very sexy news. Here is the extra info on the benchmark <a href="http://mikaelronstrom.blogspot.com/2012/02/105bn-qpm-using-mysql-cluster-72.html" rel="nofollow">http://mikaelronstrom.blogspot.com/2012/02/105bn-qpm-using-m...</a><p>But no info on what disk setup they used. But for every instance node there was a storage node.
There's a great deal of hand-waving here. My understand is that it's a distributed in-memory KV store. Not something you could realistically run TPC-C against and still get "1 billion" TPM.
Looks awesome! Does anyone have a suggestion for a good site explaining what's the best path for migrating from a master / master setup to a MySQL Cluster?