In a project Severalnines is engaged in, we are developing a realtime application based on Cluster/J. To start with, I must say cluster/j is fantastic and so far I am very happy with it and beaten our expectations big time. It is quite new however and we stumbled on a couple of issues, but those were fixed very fast by the Cluster/J developers. The bugs we encountered were:

• bug 59942
• bug 59941
  

Both which were worked around, and really we never did need to have a binary or a varbinary as the PK, we used a

Performance is great - we have two data nodes (nehalem, 32GB RAM, 146GB SAS 10K disk, 2x4 core 2.4GHz (E5620) ) and two application hosts (same spec, less RAM as data …

CMON 1.1.4 - the Cluster Monitor and Manager has recently been released and here is a little how to about how to install from binary and source (at the end), deployment etc. If you use RPMs, you should follow the install guide here.


1. Download the cmon binary package to a monitoring host
Currently there are binaries available for Linux 64-bit and 32-bit (statically linked) and works for MySQL Cluster 7.0.9 and later 7.0.x versions and also 7.1.x.

In this case the monitoring host will be on 'ndb05' (IP address 10.0.1.5) - see 9. Suggested Deployment for a picture describing the setup.

The Monitoring machine should have installed:

CMON - the Cluster Monitor has recently been released and here is a little how to about how to install from binary and source (at the end), deployment etc.

1. Download the cmon binary package to a monitoring host
Currently there are binaries available for Linux 64-bit and 32-bit (statically linked) and works for MySQL Cluster 7.0.9 and later.

In this case the monitoring host will be on 'ndb05' (IP address 10.0.1.5) - see 9. Suggested Deployment for a picture describing the setup.

The Monitoring machine should have installed:

• a mysql server up and running that will store the cmon database (if you build from source you need to have the mysql cluster libraries and include files)
• apache (if you want to have the web interface) + php_mysql
• rrdtool (if you want to have graphs in web interface)
…

A new version of CMON - the monitor for MySQL Cluster - has been released. Many thanks to everyone who helped me with bug fixing and beta testing!

CMON monitors all events and information that you can get from MySQL Cluster.

Some of the things that CMON monitors:

• Cluster status (starting, started, stopped, recovering, degraded etc)
• Data node status (started, stopped, starting etc)
• Application (mysqld) node status (connected/disconnected)
• DataMemory/IndexMemory/Tablespace utilization
• Statistics from data nodes
  
• Statistics from mysql servers
• Replication (basic currenty) support -picks up if a mysql server is a slave and checks if is running or not
• Alarm generation

There are pre-built binaries for Linux 64-bit (I have not got …

The main fixes in cmon 0.13 are:

• filtering of clusterlog
• better graphs interface with filtering
  
• fixed bug in load average graphs. Now the loadavg graphs works
• added replication role, socket when adding a mysql server to be monitored from the web interface.
  
• corrected bug with how often mysql_variables are collected
• fixed problems with graphs
• added images directory
• revamped graphs - now producing files in images directory,
• ajax support for Storage graphs
• divided helpers into smaller files

Upgrade from cmon 0.12

• Stop cmon 0.12 (e.g. killall cmon from the command line)
• Execute this sql script …

cmon 0.12 is now released and can be downloaded from www.severalnines.com/cmon.

Release notes:

• connection handling - cmon will now retry connects forever. cmon will also recover and automatically reconnect to cluster after a cluster failure or if the connection to the mysql server crashes where cmon logs information. This means you will have to terminate the cmon using e.g 'killall cmon' or /etc/init.d/cmon stop
• disk data - cmon now gathers information about the amount of table space used and this is presented in the web interface
  
• init.d scripts - fixed bugs in creating the init.d scripts during make install-extra
• fixed compiler warnings - now 0 compiler warnings on Linux systems
• mysql_statistics table - now explicitly using engine=myisam
• web interface - changed printout if cmon …