MySQL Cluster Manager 1.2 – using the new features

MySQL Cluster Manager logoOracle have just announced that MySQL Cluster Manager 1.2 is Generally Available. For anyone not familiar with MySQL Cluster Manager – it’s a command-line management tool that makes it simpler and safer to manage your MySQL Cluster deployment – use it to create, configure, start, stop, upgrade…. your cluster.

So what has changed since MCM 1.1 was released?

The first thing is that a lot of work has happened under the covers and it’s now faster, more robust and can manage larger clusters. Feature-wise you get the following (note that a couple of these were released early as part of post-GA versions of MCM 1.1):

  • Automation of on-line backup and restore
  • Single command to start MCM and a single-host Cluster
  • Multiple clusters per site
  • Single command to stop all of the MCM agents in a Cluster
  • Provide more details in “show status” command
  • Ability to restart “initial” the data nodes in order to wipe out the database ahead of a restore

A new version of the MySQL Cluster Manager white paper has been released that explains everything that you can do with it and also includes a tutorial for the key features; you can download it here.

Watch this video for a tutorial on using MySQL Cluster Manager, including the new features:

Using the new features

Single command to run MCM and then create and run a Cluster

A single-host cluster can very easily be created and run – an easy way to start experimenting with MySQL Cluster:

You can then connect to MCM:

Or access the database itself simply by running the regular mysql client.

Extra status information

When querying the status of the processes in a Cluster, you’re now also shown the package being used for each node:

Simplified on-line backup & restore

MySQL Cluster supports on-line backups (and the subsequent restore of that data); MySQL Cluster Manager 1.2 simplifies the process.

The database can be backed up with a single command (which in turn makes every data node in the cluster backup their data):

The list command can be used to identify what backups are available in the cluster:

You may then select which of these backups you want to restore by specifying the associated BackupId when invoking the restore command:

Note that if you need to empty the database of its existing contents before performing the restore then MCM 1.2 introduces the initial option to the start cluster command which will delete all data from all MySQL Cluster tables.

Stopping all MCM agents for a site

A single command will now stop all of the agents for your site:

Getting started with MySQL Cluster Manager

You can fetch the MCM binaries from edelivery.oracle.com and then see how to use it in the MySQL Cluster Manager white paper.

Please try it out and let us know how you get on!

10 thoughts on “MySQL Cluster Manager 1.2 – using the new features

  1. Andrew,

    Very nice article and tutorial. I downloaded the white paper and found that the upgrade information provided is not complete and clear under section 3.4.11.

    There are no clear steps on how to upgrade the existing mcm to 1.2 version.

    The doc says, just stop the agents. That’s it.

    Any help on this, please?
    Thanks

    1. Hi Bheemsen,

      just stop the MCM 1.1 agents and then run the MCM 1.2 binaries – that should be all that’s required.

      Regards, Andrew.

  2. I have a backup of size 1.8G, which I have created using backup cluster cluster_name. But when trying to restore data I am getting
    ERROR 9003 (00MGR): Tx {0 372420 48} timed out on agent 0 @{49 0 210 Wait ndbd restore complete} participants: 0@host1:1186[X] 1@host2:1862[X] 1 1.

    1. Hi Ramesh – what version of MCM are you using? There are a couple of bugs which could have caused this – both of which have fixes in 1.2.4.

      Regards, Andrew.

    1. Hi Ramesh,

      chances are that upgrading MCM to 1.2.4 will fix your problem. If not then please raise a case/bug report.

      Thanks, Andrew.

  3. Andrew, can you clarify something?

    In your instructions, you use mcm/bin/mcmd:

    billy@black:~$ tar xfz mcm-1.2.1-cluster-7.2.9-linux-glibc2.5-x86-32bit.tar.gz
    billy@black:~$ mv mcm-1.2.1-cluster-7.2.9-linux-glibc2.5-x86-32bit mcm
    billy@black:~$ mcm/bin/mcmd –bootstrap

    But when I download the tarball from Oracle Edelivery, I need to use a different path. I need to use mcm/mcm1.x.y/bin instead of mcm/bin/ . Has the path changed? Am I downloading the right product?

    [stefanl@db1 ~]$ tar xfz mcm-1.2.4-cluster-7.3.2-linux-rhel5-x86-64bit.tar.gz
    ### Move the directory, like they do in the tutorial
    [stefanl@db1 ~]$ mv mcm-1.2.4-cluster-7.3.2-linux-rhel5-x86-64bit mcm
    [stefanl@db1 ~]$ mcm/bin/mcmd
    bash: mcm/bin/mcmd: No such file or directory
    ### Where is mcmd??? It’s under mcm/mcm1.2.4/bin , not mcm/bin .
    [stefanl@db1 ~]$ mcm/mcm1.2.4/bin/mcmd –bootstrap
    MySQL Cluster Manager 1.2.4 (64bit) started
    [stefanl@db1 ~]$

Leave a Reply

Your email address will not be published. Required fields are marked *

Please enter. * Time limit is exhausted. Please reload CAPTCHA.