Manage your database cluster with the ClusterControl Application

Prerequisites

• Your database cluster has been deployed with our database configurators as of 2013-03-06 which means the ClusterControl package will now include the ClusterControl REST API and our new UI.
• The deploy.sh script has been successfully completed.
• A unique ClusterControl API token. The token is printed on the last confirmation page for our  database configurators and on the terminal window after a successful deploy.sh install.

Add your database cluster

A typical ClusterControl deployment consists of a ClusterControl node and a number of database nodes that make up the database cluster.

The ClusterControl UI uses the ClusterControl REST API and an unique API token to securely manage and monitor your database cluster. As default the API calls uses HTTPS however it can easily be changed to use HTTP instead.

You can only register the database cluster that you have created from our database configurators on our severalnines.com site or within the ClusterControl application itself.

To add your database cluster with the ClusterControl UI open your web browser and enter this URL:

http://<your ClusterControl node's IP address or hostname>/cmonapi

Verify that the hostname is correct to your ClusterControl node (cmon controller). We use 'curl -s ifconfig.me/host' to fetch your host's perceived external IP. For Amazon EC2 deployments this IP is usually correct while for "on-premise" deployments you probably want to use your private IP instead to your ClusterControl node.

Clicking 'Login Now' will take you to the ClusterControl application login page and the username is the email address that you used to create the database configuration and the default password is 'admin' which you can change later.

After you have successfully logged on you should see the Cluster Registrations page. The last step is now to just enter you unique ClusterControl API token and then click on the 'Register' button to make this database cluster show up in your ClusterControl application. You can also modify the input fields for example to change the API URL to use HTTP instead of HTTPS.

Your ClusterControl API token is shown on the last page of our database configurators and also written to your terminal window after you have successfully run the initial deployment script.

Enter your ClusterControl API token and add your database cluster.

Your new database cluster.

Register more database cluster

It's very easy from now on to register more database cluster to this ClusterControl application. Create a new database configuration by clicking on 'Create database cluster' button. Follow the instructions and then register it by going to http://<your other clustercontrol node>/cmonapi  and as the ClusterControl Node URL use your previous ClusterControl node's IP.

Create database configurations

You can create new database configurations from the ClusterControl application itself. In fact this is the recommendation if you have ClusterControl installed on-premise and not go to our severalnines.com site for this. The only requirement is that you have an internet connection from your ClusterControl node since the deployment scripts are still generated on our site. You might need to open your firewall settings to allow HTTP calls to www.severalnines.com depending on your environment.

Click on 'Create database cluster' and you will be able to deploy the following databases:

• Galera Cluster for MySQL
• MySQL Cluster (NDB storage engine)
• MySQL Replication
• MongoDB in sharded deployment

 Troubleshooting

If you encounter a registration error then it could mean one of the following:

• The ClusterControl node's URL is not reachable
• The ClusterControl node's URL is incorrect
• The ClusterControl API Token has already been registered with this ClusterControl application