Hack The Sec-Leading Resource Of Linux Tutorial: Galera

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" itemprop="headline" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 39px; font-weight: 500; line-height: 1.1; margin: 21px 0px 0px;">
<u><span style="color: red;">MariaDB Galera cluster on Ubuntu 14.04</span></u></h1>
<div>
<span style="background-color: #fdfdfd; color: #333333; font-size: 18px; line-height: 28px;"><span style="font-family: "georgia" , "times new roman" , serif;">We need at least 3 hosts running together with <a href="http://www.hackthesec.co.in/search/label/Ubuntu" target="_blank">Ubuntu</a> 14.04 Operating system to form a reliable cluster. The following is the hosts list that we had setup for this article, where we will deploy the <a href="http://www.hackthesec.co.in/search/label/MariaDB" target="_blank">MariaDB </a>Galera cluster:</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZp3NsfUvKk5bxQEX92Ju6r9hezo2W9ihFiK4gS49APcOp8Fi7RzAh1VX8oOTBM4j5ObnzySAJ8F1JEwSQykSmZlnMT6pGKuSqUhi5_i6BsJjr-YiSEwssTIMeL6XW1mLUdPaWpYTPOML-/s1600/galera-overview-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZp3NsfUvKk5bxQEX92Ju6r9hezo2W9ihFiK4gS49APcOp8Fi7RzAh1VX8oOTBM4j5ObnzySAJ8F1JEwSQykSmZlnMT6pGKuSqUhi5_i6BsJjr-YiSEwssTIMeL6XW1mLUdPaWpYTPOML-/s1600/galera-overview-www.hackthesec.co.in.png" /></a></div>
<div>
<span style="background-color: #fdfdfd; color: #333333; font-size: 18px; line-height: 28px;"><span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">ubuntu-node1 172.25.10.21
ubuntu-node2 172.25.10.22
ubuntu-node3 172.25.10.23</code></pre>
</div>
<div>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Now we will install the its required packages <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-size: 16.2px; padding: 2px 4px;">rsync</code>, <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-size: 16.2px; padding: 2px 4px;">galera</code> and <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-size: 16.2px; padding: 2px 4px;">mariadb-galera-server</code> that need to be installed on all the three nodes.</span></div>
<h3 id="adding-repositories-and-packages" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 26px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 21px;">
<u><span style="color: #0b5394;">Adding Repositories and Packages</span></u></h3>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Now we will start by adding the repository for Ubuntu so, first add the key files for the MariaDB repository to build the trust between the maintainers of repositories and that we can install the required packages.</span></div>
<h4 id="installing-the-gpg-key" style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 19px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Installing the GPG key</span></h4>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Run the following command of all the three hosts to install its GPG key as follow.</span></div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">root@ubuntu-node1:~# apt-get install python-software-properties
root@ubuntu-node2:~# apt-get install python-software-properties
root@ubuntu-node3:~# apt-get install python-software-properties</code></pre>
</div>
<div>
<h4 id="adding-apt-repository" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 19px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 10.5px;">
<span style="color: #0b5394;">Adding APT Repository</span></h4>
<div style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="color: #0b5394;">Now to add its APT repository have to execute the below commands.</span></div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">root@ubuntu-node1:~# apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
root@ubuntu-node2:~# apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
root@ubuntu-node3:~# apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db</code></pre>
</div>
<div>
<h4 id="adding-ubuntu-repository" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 19px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 10.5px;">
<span style="color: #0b5394;">Adding Ubuntu Repository</span></h4>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Now can add the Ubuntu repository as per required whether to use its repository as we have the trusted key in the database, let’s add the actual repository using following command on all the nodes.</span></div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">root@ubuntu-node1:~# add-apt-repository 'deb http://mirror.jmu.edu/pub/mariadb/repo/5.6/ubuntu trusty main'
root@ubuntu-node2:~# add-apt-repository 'deb http://mirror.jmu.edu/pub/mariadb/repo/5.6/ubuntu trusty main'
root@ubuntu-node3:~# add-apt-repository 'deb http://mirror.jmu.edu/pub/mariadb/repo/5.6/ubuntu trusty main'
</code></pre>
<h3 id="update-os-with-latest-repo" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 26px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 21px;">
<span style="color: #0b5394;">Update OS with Latest Repo</span></h3>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">To get the latest repositories run the update command on the three nodes we are working on.</span></div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">root@ubuntu-node1:~# apt-get update
root@ubuntu-node2:~# apt-get update
root@ubuntu-node3:~# apt-get update
</code></pre>
<h2 id="installing-mariadb-cluster-galera-and-rsync" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 32px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 21px;">
<span style="color: #0b5394;"><u>Installing MariaDB Cluster, Galera and Rsync</u></span></h2>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Let’s install the MariaDB and its related packages on each of the node with following command as:</span></div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">root@ubuntu-node1:~# apt-get install -y galera  mariadb-galera-server-5.5 mariadb-client-5.5 libmariadbclient18 mariadb-client-core-5.5 rsync netcat-openbsd
root@ubuntu-node2:~# apt-get install -y galera  mariadb-galera-server-5.5 mariadb-client-5.5 libmariadbclient18 mariadb-client-core-5.5 rsync netcat-openbsd
root@ubuntu-node3:~# apt-get install -y galera  mariadb-galera-server-5.5 mariadb-client-5.5 libmariadbclient18 mariadb-client-core-5.5 rsync netcat-openbsd</code></pre>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9M3BvZjln0AQYD8QiFGCNhnpY0ubQj4gYoLGqoXzMtMGtD-rEaGukGAYJLVmKHVpWNR4WYd1u_OWEp183t7BHBQtRNni34M0Q0o7tVneix8b5Fc6US3EPpkfcl9pKA_seZTrv5PtIVvnX/s1600/galera-cluster-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9M3BvZjln0AQYD8QiFGCNhnpY0ubQj4gYoLGqoXzMtMGtD-rEaGukGAYJLVmKHVpWNR4WYd1u_OWEp183t7BHBQtRNni34M0Q0o7tVneix8b5Fc6US3EPpkfcl9pKA_seZTrv5PtIVvnX/s1600/galera-cluster-www.hackthesec.co.in.png" /></a></div>
<div>
<span style="background-color: #fdfdfd; color: #333333; font-size: 18px; line-height: 28px;"><span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></span></div>
<div>
<span style="background-color: #fdfdfd; color: #333333; font-size: 18px; line-height: 28px;"><span style="font-family: "georgia" , "times new roman" , serif;">During the installation process you will be asked to configure the root password for the MariaDB, so make sure that you configured the same root password on all the three nodes.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnZResmDrnHN7vNkVWLczkvNP27If-WBAXzRCT-ATrOgfV3VIvHPTnEXZo2qFlHtuUphA8LIR9uLwrIzBnz8RkLtHoxjsJpkAQAkqHOq3bjMYhkK1o8ASS8A8HZspZUZnUyvIQl2VNBJg_/s1600/mariadb-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnZResmDrnHN7vNkVWLczkvNP27If-WBAXzRCT-ATrOgfV3VIvHPTnEXZo2qFlHtuUphA8LIR9uLwrIzBnz8RkLtHoxjsJpkAQAkqHOq3bjMYhkK1o8ASS8A8HZspZUZnUyvIQl2VNBJg_/s1600/mariadb-www.hackthesec.co.in.png" /></a></div>
<div>
<span style="background-color: #fdfdfd; color: #333333; font-size: 18px; line-height: 28px;"><span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></span></div>
<div>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Once the installations of these packages are done, you will get a MariaDB server on each one of your three nodes but they aren’t yet configured.</span></div>
<h2 id="configuring-mariadb-cluster" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 32px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 21px;">
<span style="color: #0b5394;">Configuring MariaDB Cluster</span></h2>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Let’s proceed with the configurations changes for the MariaDB Galera Cluster setup.</span></div>
<h3 id="mysql-settings" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 26px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 21px;">
<span style="color: #0b5394;">MySQL Settings</span></h3>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">First of all open the <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-size: 16.2px; padding: 2px 4px;">my.cnf</code> file and comment the following lines on all the three nodes.</span></div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">root@ubuntu-nodeX:~# vim /etc/mysql/my.cnf
#bind-address           = 127.0.0.1
#default_storage_engine = InnoDB
#query_cache_limit              = 128K
#query_cache_size               = 64M
</code></pre>
<h3 id="mariadb-settings" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 26px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 21px;">
<span style="color: #0b5394;">MariaDB Settings</span></h3>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Now add following lines for wsrep configuration options in <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-size: 16.2px; padding: 2px 4px;">my.cnf</code> file under <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-size: 16.2px; padding: 2px 4px;">[mysqld]</code> directive as shown below.</span></div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">root@ubuntu-nodeX:~# vim /etc/mysql/my.cnf
[mysqld]
binlog_format=ROW
default_storage_engine=innodb
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
innodb_doublewrite=1
</code></pre>
<h3 id="vsrep-providers-configurations" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 26px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 21px;">
<span style="color: #0b5394;">VSRep Providers Configurations</span></h3>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Here we will configure the vsrep configurations on each node under the <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-size: 16.2px; padding: 2px 4px;">[mysqld]</code> directory by adding the following lines in <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-size: 16.2px; padding: 2px 4px;">/etc/mysql/my.cnf</code> file on each node with their specific hostnames, root password and IP address.</span></div>
<h4 id="configurations-for-ubuntu-node1" style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 19px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Configurations for <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-size: 17.1px; padding: 2px 4px;">ubuntu-node1</code></span></h4>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">[mysqld]
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_provider_options="gcache.size=256M; gcache.page_size=128M"
wsrep_cluster_address=gcomm://ubuntu-node1
wsrep_cluster_name="MariaDB_Cluster"
wsrep_node_address="ubuntu-node1"
wsrep_node_name="ubuntu-node1"
wsrep_sst_auth="root:root123"
wsrep_node_incoming_address=172.25.10.21
wsrep_sst_receive_address=172.25.10.21
wsrep_slave_threads=16
</code></pre>
<h4 id="configurations-for-ubuntu-node2" style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 19px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Configurations For <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-size: 17.1px; padding: 2px 4px;">ubuntu-node2</code></span></h4>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">[mysqld]
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_provider_options="gcache.size=256M; gcache.page_size=128M"
wsrep_cluster_address=gcomm://ubuntu-node1
wsrep_cluster_name="MariaDB_Cluster"
wsrep_node_address="ubuntu-node2"
wsrep_node_name="ubuntu-node2"
wsrep_sst_auth="root:root123"
wsrep_node_incoming_address=172.25.10.22
wsrep_sst_receive_address=172.25.10.22
wsrep_slave_threads=16
</code></pre>
<h4 id="configurations-for-ubuntu-node3" style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 19px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">Configurations For <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-size: 17.1px; padding: 2px 4px;">ubuntu-node3</code></span></h4>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">[mysqld]
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_provider_options="gcache.size=256M; gcache.page_size=128M"
wsrep_cluster_address=gcomm://ubuntu-node1
wsrep_cluster_name="MariaDB_Cluster"
wsrep_node_address="ubuntu-node3"
wsrep_node_name="ubuntu-node3"
wsrep_sst_auth="root:root123"
wsrep_node_incoming_address=172.25.10.23
wsrep_sst_receive_address=172.25.10.23
wsrep_slave_threads=16
</code></pre>
<h3 id="restart-mysql-services" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 26px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 21px;">
<span style="color: #0b5394;">Restart MySQL Services</span></h3>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">After configuring the mysql and <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-size: 16.2px; padding: 2px 4px;">wsrep</code> parameters we need to restart its service on all the node.</span></div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">root@ubuntu-node1:~# service mysql restart
root@ubuntu-node2:~# service mysql restart
root@ubuntu-node3:~# service mysql restart</code></pre>
</div>
<div>
<h2 id="testing-mariadb-galera-cluster" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 32px; font-weight: 500; line-height: 1.1; margin-bottom: 10.5px; margin-top: 21px;">
<span style="color: #0b5394;">Testing MariaDB Galera Cluster</span></h2>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">To confirm the status of MariaDB cluster VSRep, let’s login to the MariaDB console and execute the following command to check the output of give command.</span></div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">root@ubuntu-node1:~# mysql -u root –p
MariaDB [(none)]> show status like 'wsrep_%';</code></pre>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC7bSAgKV5b8gD7cC02TgMOIKaOzOuDMQH81h7I3Fm_0EdiRZGzpp2oarlVQu3E22PQWplfxcOGG9A86Emx5TvMVpD0BOup03B1fTu33K9e7q0EdfH0Y46Yi_OSv8sk5GUfnHdd2dbu7yE/s1600/galera-mariadb-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC7bSAgKV5b8gD7cC02TgMOIKaOzOuDMQH81h7I3Fm_0EdiRZGzpp2oarlVQu3E22PQWplfxcOGG9A86Emx5TvMVpD0BOup03B1fTu33K9e7q0EdfH0Y46Yi_OSv8sk5GUfnHdd2dbu7yE/s1600/galera-mariadb-www.hackthesec.co.in.png" /></a></div>
<div>
<span style="background-color: #fdfdfd; color: #333333; font-size: 18px; line-height: 28px;"><span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></span></div>
<div>
<div style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;">
<span style="font-family: "georgia" , "times new roman" , serif;">You can also confirm the status of your running cluster and its replication by running the below command on each of your node. You will see the cluster size in response to the output of that command.</span></div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">root@ubuntu-node1:~# mysql -u root -p -e 'SELECT VARIABLE_VALUE as "cluster size" FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME="wsrep_cluster_size"'
root@ubuntu-node2:~# mysql -u root -p -e 'SELECT VARIABLE_VALUE as "cluster size" FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME="wsrep_cluster_size"'
root@ubuntu-node3:~# mysql -u root -p -e 'SELECT VARIABLE_VALUE as "cluster size" FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME="wsrep_cluster_size"'</code></pre>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0y63md-d0s8Vc1gDpaf731f1e-Fgut-xfGN1HLiElSlH4W5DvDEqP8bBsdx3LTysGDdUJfgLOQmLHoejpfaM0QoKPAmtr86uRVpjY9HSeFw7Aewag10P-Yh_dQ8MTin7tCl7RAjUP0_rG/s1600/use-galera-cluster-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0y63md-d0s8Vc1gDpaf731f1e-Fgut-xfGN1HLiElSlH4W5DvDEqP8bBsdx3LTysGDdUJfgLOQmLHoejpfaM0QoKPAmtr86uRVpjY9HSeFw7Aewag10P-Yh_dQ8MTin7tCl7RAjUP0_rG/s1600/use-galera-cluster-www.hackthesec.co.in.png" /></a></div>
<div>
<span style="background-color: #fdfdfd; color: #333333; font-size: 18px; line-height: 28px;"><span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></span></div>
<div>
<span style="background-color: #fdfdfd; color: #333333; font-size: 18px; line-height: 28px;"><span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></span></div>
<div>
<span style="background-color: #fdfdfd; color: #333333; font-size: 18px; line-height: 28px;"><span style="font-family: "georgia" , "times new roman" , serif;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></div>
</div>

How to deploy a MariaDB Galera cluster on Ubuntu 14.04

MariaDB Galera cluster on Ubuntu 14.04 We need at least 3 hosts running together with Ubuntu 14.04 Operating system to form a reliable cluster. The following is the hosts list that we had setup for t…