Database Clustering Tutorial 9 – Setting up a Cluster in Clustercontrol

We’ve got most of the theory figured out, we managed to get a bunch of virtual machines up and running, and we even installed ClusterControl, but now it’s time for the fun part. We are going to create our first cluster!

Getting Started

If not open already, travel to the webpage you made your admin email and user name on in the last previous blog. The website will be:

localip/clustercontrol/

For example, mine is: 10.71.34.101/clustercontrol/

Once you get there, the “Welcome” page should show up. If not, open it by either clicking the “Get Started” button or the “Deploy” icon.




Once it comes up, click “Deploy Database Cluster.”

Now, this will come up with some forms that we can fill out.

But hold up Bro! Don’t start filling those forms out yet.

If you look at all of the different tabs, you will see several different ways we can make a cluster depending on what database and clustering technology we are using. So, we need to make sure we’re in the correct tab!

As we mentioned before, we are going to be using Galera, which is for the MySQL database. So, select the tab MySQL Galera from the menu.

Now, we can start filling out the forms.

SSH & Cluster Name

The software is going to use SSH to connect to the other machines, and once it does, it will need to use sudo privileges. In order to do that, we need to give it the appropriate user and password that has those permissions. This is the account we’ve been using throughout this blog series.  IMPORTANT: We want this user to exist on all of the machines with the same password.

Now, give a cluster name and check each of the three boxes underneath. Then click Continue.

Choosing A Vendor Database

Now, in the second page, under Vendor, it asks us what database we are going to be using. This is totally up to you. These databases will actually be created on the other machines!

Now this can seem a little confusing because we selected the MySQL Galera tab at the top. So why is it asking about different databases? Well these are different types of Mysql and Galera. There are actually a few other database systems out there that are very similar to MySQL. Percona, for example, is like an extended MySQL. MariaDB is a database that was created by the original creators of MySQL after Oracle acquired MySQL.

The third option is this Codership thing. What in the world is Codership? Codership is the company behind Galera, and they actually built Galera for the default MySQL. Percona and MariaDB provided their own versions.

I chose to go with the MariaDB, but, again, it’s totally up to you which one you choose. If you are working in production be sure that the version you choose is supported on your operating system.  

Next, decide what you want the MySQL root password to be and type it in.

Adding Nodes

Now, under Add Node, put in the IP address of each of your two master nodes, one at a time.

In the box that appears for each node, make sure that each is powered on. The green check marks tell you this.  As a reminder, this requires password SSH, which we set up earlier in this blog.  If you are jumping in out of the blue, you may want to start from the beginning.

Creating a Cluster

Now, click Deploy, and then it will begin creating a cluster!!!

This process may take a while. You can watch the progress of this by going to the Activity Viewer.

If, for some reason, you can’t seem to get it working but you desperately want to continue, go back to the installation page and try one of the other vendors: Percona, MariaDB, or Codership.

Once it’s finished, click the little logo to go to an overview page… And there is your cluster!

Conclusion

You have now set up your first cluster! In the next video I am going to be talking about how to start working with this cluster.

Further Study

  • Research the differences between Percona XtraDB, MariaDB, and Codership.

Leave a Reply

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