Centos Yum Install Mysql Cluster

  1. Centos Yum Install Mysql Clustered
  2. Centos Yum Install Mysql Client
  3. Centos Yum Install Rpm

Hi all. Before we start the second part, let’s review about what we have done in Part 01. In Part 01 of this clustering series, we’ve discussed about clustering technique and in which cases it can be used along with the advantages and disadvantages of clustering. And also we have covered the pre-requisites for this setup and what each package will do after we configured the kind of a setup.

You can review Part 01 and Part 03 from below links.

As I said in my last article, that we prefer 3 servers for this setup; one server act as a cluster server and others as nodes.

Mysql

In today’s Part 2, we will see how to install and configure clustering on Linux. For this we need to install below packages in all three servers.

  1. Ricci (ricci-0.16.2-75.el6.x86_64.rpm)
  2. Luci (luci-0.26.0-63.el6.centos.x86_64.rpm)
  3. Mod_cluster (modcluster-0.16.2-29.el6.x86_64.rpm)
  4. CCS (ccs-0.16.2-75.el6_6.2.x86_64.rpm)
  5. CMAN(cman-3.0.12.1-68.el6.x86_64.rpm)
  6. Clusterlib (clusterlib-3.0.12.1-68.el6.x86_64.rpm)

Step 1: Installing Clustering in Linux

So let’s start installing these packages in all three servers. You can easily install all these packages using yum package manager.

I will start by installing “ricci” package on all these three servers.

Install MariaDB. Install the MariaDB server through the CentOS package manager (yum) by running the following command at a command prompt: sudo yum install mariadb-server Allow remote access. Run the following command to allow remote access: firewall-cmd --zone=public --add-service=mysql --permanent Set the root password.

[[email protected] ~]# yum -y install centos-release-openstack-queens. In this post I am going to install a MySQL cluster as refer to the architecture as below: MySQL cluster is consists of 3 types of node: Data node (mysql-data1 & mysql-data2) Sql daemon node (mysql-mysqld1 & mysql-mysqld2) Management node (mysql-management) Data node will hold the database and it will replicated automatically to all data nodes.

Install Ricci Package

After ricci installation is done, we can see it has installed mod_cluster and cluster lib as its dependencies.

Next I’m installing luci using yum install “luci” command.

Install Luci Package

After the installation of luci, you can see it has installed the dependencies it needed.

Now, let’s install ccs package in the servers. For that I entered yum install ccs.x86_64 which is shown in the list when I issued yum list |grep “ccs” or else you can simply issue yum install “ccs”.

Install CSS Package

Let’s install cman as the last requirement for this particular setup. The command is yum install “cman” or yum install cman.x86_64 as shown in the yum list as I mentioned earlier.

We need to confirm the installations are in place. Issue below command to see whether the packages we needed are installed properly in all three servers.

All Packages Installed

Perfect all the packages are installed and all we need to do is configuring the setup.

Step 2: Configure Cluster in Linux

1. As the first step for setting up the cluster, you need to start the ricci service on all three servers.

Start Ricci On Node 01

2. Since ricci is started in all servers, now it’s time to create the cluster. This is where ccs package comes to our help when configuring the cluster.

If you don’t want to use ccs commands then you will have to edit the “cluster.conf” file for adding the nodes and do other configs. I guess easiest way is to use following commands. Let’s have a look.

Since I haven’t created the cluster yet, there’s no cluster.conf file created in /etc/cluster location yet as shown below.

Check Cluster Configuration File

In my case, I do this in 172.16.1.250 which is dedicated for cluster management. Now onwards, everytime we try to use ricci server, it will ask for ricci’s password. So you will have to set the password of ricci user in all servers.

Centos Yum Install Mysql Clustered

Enter passwords for ricci user.

Now enter the command as shown below.

You can see after entering above command, cluster.conf file is created in /etc/cluster directory.

Create Cluster Configuration

This is how my default cluster.conf looks like before I do the configs.

Centos Yum Install Mysql Client

3. Now let’s add the two nodes to the system. In here also we use ccs commands to make the configurations. I’m not going to manually edit the cluster.conf file but use the following syntax.

Add Nodes to Cluster

Add the other node too.

This is how cluster.conf file looks like after adding the node servers.

Cluster Configuration with Nodes

You also can enter below command to verify node details.

Centos Yum Install Rpm

Perfect. You have successfully created the cluster yourself and added two nodes. For further details about ccs command options, enter ccs –help command and study the details. Since now you know how to create the cluster and add nodes to it, I will post Part 03 soon for you.

Centos Yum Install Mysql Cluster

Thank you, till then keep connected with Tecmint for handy and latest How To’s.

Share