Friday, May 23, 2008

Configuration Tool

I have written a Configuration Tool for MySQL Cluster.
It is located on www.severalnines.com/config

The configuration tool lets you:
  • Configure a Cluster based on MySQL Cluster 6.2 or MySQL Cluster 6.3
  • The number of data nodes, mysqlds, and management servers
  • Chose how much DataMemory to allocate for the data nodes
  • Specify on which hosts to install the software on etc etc
Finally, configuration files (config.ini and my.cnf) and a set of scripts are generated based on your input and emailed to you.

With those scripts you can then:
  • Download and compile 6.3
  • Distribute the Cluster binaries onto the hosts you have specified)
  • Bootstrap the system (create directories, mysql user account, install mysql database, configuration files etc)
  • Start the cluster
  • Stop the cluster
  • Rolling restart
  • Backups
  • Stop/start nodes
All of this from a single location! It requires that you setup shared ssh keys on your root account or you will have to enter the password a lot of times..

Moreover, these scripts and the config files are not in any way related to MySQL or Sun Microsystem meaning that MySQL Support will not be able to support this. However, the config.ini file that is generated is Best Practice.

Good luck and let me know if there are any issues (the Configuration Tool is still quite Beta - if you make a mistake then you have to start from scratch again..).

MySQL Cluster 6.2 - officially released

I guess I am bit late with these news... but.. IT IS GREAT NEWS!

Short summary (read more on Ramon's blog)
  • Cluster was pulled out of 5.1.24

  • Don't use 5.0 any longer

  • MySQL Cluster 6.2 is what everyone should use (unless CGE 6.3 features are needed). It is a great piece of software, thoroughly tested by telcos and put in production around the world!

Why pull Cluster out of 5.1.24? As everyone knows 5.1.24 is delayed and at the same time CGE 6.2 has lived its own life and matured in production and in test labs.

Although the mysql server parts are based on 5.1.23 the Cluster parts of 6.2 is production quality (like e.g geo-redundancy), but the non-cluster parts such as innodb and myisam etc are still RC quality.

By releasing it independently it can be maintained and released more often instead of being stuck to the official MySQL release schedule.

What has been referred to as CGE 6.2 in my previous blog posts are applicable to MySQL Cluster 6.2, it is the same version, but now you can get binary builds of it.

MySQL Cluster 6.3 (previously known, and still known, as CGE 6.3) has not got any binary builds yet, and is still currently only delivered in source.

Look here for feature differences between MySQL Cluster 6.2 and MySQL Cluster 6.3!

Good luck with your clustering!