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..).

2 comments:

Jim Dowling said...

This sounds very similar to ndbinstaller. Can you elaborate on the differences?

cidcampeador said...
This comment has been removed by the author.