MySQL Cluster is, without doubt, the most interesting MySQL product Oracle offers to the people out there.
It’s the flagship, the holy grail, based on the knowledge and technology developed doing our well known MySQL Server.

I’m not going to go through why MySQL Cluster is so great, that you can find anywhere.
I’m going to show how to use the new MySQL Cluster Manager (aka MCM) to easy and quick setup your Cluster.

If you ever setup a cluster, you’d know that “easy” and “quick” are not the first association one have when thinking about MySQL Cluster. Let’s face it; Cluster is pain to setup…
It has millions of parameters to play with, each has to be set on all nodes, you have to be very careful when you change things and if, by any chance, you have to upgrade your Cluster…. Than, well…. May the force be with you.

Just imagine you have 24 nodes cluster, with 8 data groups – you have to stop, upgarde, check settings and start each node at the specific order to keep your cluster running. It can be done, but it’s gonna take you a long excruciating painful hours. It’s not for the faint of heart.

That’s exactly where MySQL Cluster Manager gets into the picture!

If you take special pleasure staring at black terminal windows for hours just to finally get your prompt back without error and with no SMS saying: “YOU’RE FIRED!”, stop reading. this post is ot for you.

Every ones loves hands-on tutorials with code snippets and stuff to establish the knowledge that something can be done.

So here is my first one; MySQL Enterprise Backup 3.5.
The new and shiny backup solution for MySQL.

Our clients, for a long time, are asking for an enterprise ready, stable, safe, quick, easy, feature rich, cross-platform backup solution. Nothing more. Easy pissy.
Yeah, everybody are using mysqldump with joy, but things are getting pretty complicated when you have more than 5 tables with 18.4Mbyte of data…
Let’s forget the backup time of a big database server with mysqldump, or the size of the files. Have you ever tried to restore a dump?
Those of you that did, knows it’s the most nerve racking task ever.
Simply due to the fact it takes ages to restore. And I mean ages!

The new MySQL Enterprise Backup 3.5 comes to the rescue, with this impressive list of features (very partial list):