Hack The Sec-Leading Resource Of Linux Tutorial: MaraiDB

How to Install MariaDB on Ubuntu 16.04

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #990000; font-family: verdana, geneva, sans-serif; font-size: large;"><span style="line-height: 26px;"><b><u>Installing MariaDB on Ubuntu 16.04</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/search/label/MariaDB" target="_blank">MariaDB </a>is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original developers of <a href="http://www.hackthesec.co.in/search/label/Mysql" target="_blank">MySQL</a>, who forked it due to concerns over its acquisition by Oracle.Contributors are required to share their copyright with the MariaDB Foundation.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://mariadb.org/wp-content/uploads/2015/10/mariadb-usa-inc.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://mariadb.org/wp-content/uploads/2015/10/mariadb-usa-inc.png" /></a></div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">MariaDB intends to maintain high compatibility with MySQL, ensuring a "drop-in" replacement capability with library binary equivalency and exact matching with MySQL APIs and commands.It includes the XtraDB storage engine for replacing InnoDB,as well as a new storage engine, Aria, that intends to be both a transactional and non-transactional engine perhaps even included in future versions of <a href="http://www.hackthesec.co.in/search/label/Mysql" target="_blank">MySQL</a>.</span></span><br />
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><b><u>Installing MariaDB</u></b></span></span><br />
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Installing from Ubuntu default repository is a straightforward way, but this may have bit old version of MariaDB.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo apt-get update -y
sudo apt-get install mariadb-server</pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><b><u>Installing MariaDB from Official Mirror:</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">MariaDB offers an official installer package for MariaDB; you can choose any one of mirrors from the <a href="https://downloads.mariadb.org/mariadb/repositories" target="_blank">MariaDB downloads page</a> to download it.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Run below commands in the terminal to configure MariaDB repository straight away.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://ftp.utexas.edu/mariadb/repo/10.1/ubuntu xenial main'</pre>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">OR</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">You can manually create and update the MariaDB repository file under<b> /etc/apt/sources.list.d/</b>.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo nano /etc/apt/sources.list.d/mariadb.list</pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Place the following entries into the above file.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"># MariaDB 10.1 repository list - created 2016-06-18 06:14 UTC
# http://downloads.mariadb.org/mariadb/repositories/
deb [arch=amd64,i386] http://ftp.utexas.edu/mariadb/repo/10.1/ubuntu xenial main
deb-src http://ftp.utexas.edu/mariadb/repo/10.1/ubuntu xenial main</pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Now, install MariaDB using the following command.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo apt-get update
sudo apt-get install mariadb-server</pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">MariaDB installation by running mysql_secure_installation.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo mysql_secure_installation</pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><b><u>Accessing MariaDB:</u></b></span></span><br />
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">To access the MariaDB instance, run the following command on the terminal.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">mysql -u root -p</pre>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Enter the password of root user that you have set during the installation when prompted.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Once after entering the password, you would get a MariaDB shell.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">hackthesec@server:~$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.1.14-MariaDB-1~xenial mariadb.org binary distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><b><u>Managing MaraDB:</u></b></span></span><br />
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">In case if you want to start / stop the MariaDB use the following command.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo systemctl start mariadb
sudo systemctl stop mariadb</pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Run the following command in the terminal to check whether MariaDB is running.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo systemctl status mariadb</pre>
<div style="text-align: center;">
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></div>
<div style="text-align: center;">
<br /></div>
</div>

How to Install MariaDB on Ubuntu 16.04

Installing MariaDB on Ubuntu 16.04 MariaDB is a community-developed fork of the MySQL relational database management system intended to re...

How to deploy a MariaDB Galera cluster on Ubuntu 14.04

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

How to Install MariaDB On CentOS 6

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #660000; font-family: "arial" , "helvetica" , sans-serif; font-size: x-large;">Install MariaDB On CentOS 6</span><br />
<div>
<span style="color: #660000; font-family: "arial" , "helvetica" , sans-serif; font-size: x-large;"><br /></span>
<br />
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="background-color: white; box-sizing: border-box; font-size: 16px; font-weight: 700; line-height: 28.7999992370605px; text-align: justify;">MariaDB</span><span style="background-color: white; font-size: 16px; line-height: 28.7999992370605px; text-align: justify;"> is a community-developed fork of the MySQL relational database management system, the impetus being the community maintenance of its free status under the GNU GPL. Being a fork of a leading open source software system, it is notable for being led by its original developers and triggered by concerns over direction by an acquiring commercial company Oracle</span></span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZvWjf2im0TY93a7A8KGA0V-SkPtD5YpfMjN2QXn2duiNXM4FQcYUiC4aeU_M0Chfly9qjEV6C133P1tGPxAyj2jp1qQTrrlQLRf43ECkwqmf6vbNOaRMCLYj1C8OBlHNkEzlopemSjS8/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/AVvXsEgZvWjf2im0TY93a7A8KGA0V-SkPtD5YpfMjN2QXn2duiNXM4FQcYUiC4aeU_M0Chfly9qjEV6C133P1tGPxAyj2jp1qQTrrlQLRf43ECkwqmf6vbNOaRMCLYj1C8OBlHNkEzlopemSjS8/s1600/MariaDB_www.hackthesec.co.in.png" /></a></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="background-color: white; font-size: 16px; line-height: 28.7999992370605px; text-align: justify;"><br /></span></span></div>
<div>
<div>
<h4 class="heading2" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; color: #0379bf; font-family: 'Roboto Slab'; font-size: 20px; font-stretch: normal; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
Step1: <span style="font-family: "lato" , "arial" , sans-serif; font-size: 16px; line-height: 28.7999992370605px; text-align: justify;">Add repository on Centos 6 32-bit</span></h4>
</div>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6000003814697px;"># vi /etc/yum.repos.d/MariaDB.repo</span></span></pre>
<div>
<h4 class="heading2" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-size: 20px; font-stretch: normal; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="font-size: 16px; font-weight: normal; line-height: 28.7999992370605px; text-align: justify;"><span style="font-family: "arial" , "helvetica" , sans-serif;"> and paste following line:</span></span></h4>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6000003814697px;">[mariadb]
 name = MariaDB
 baseurl = http://yum.mariadb.org/5.5/centos6-x86
 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
 gpgcheck=1</span></span></pre>
<div>
<h4 class="heading2" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; color: #0379bf; font-family: 'Roboto Slab'; font-size: 20px; font-stretch: normal; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
 <span style="font-family: "lato" , "arial" , sans-serif; font-size: 16px; line-height: 28.7999992370605px; text-align: justify;">Add repository on Centos 6 64-bit</span></h4>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6000003814697px;">[mariadb]    
name = MariaDB
baseurl = http://yum.mariadb.org/5.5/centos6-amd64    
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB   
gpgcheck=1</span></span></pre>
<div>
<h4 class="heading2" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-size: 20px; font-stretch: normal; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="box-sizing: border-box; font-size: 16px; line-height: 28.7999992370605px; text-align: justify;"><span style="color: #0379bf; font-family: "roboto slab"; font-size: 20px; font-weight: bolder; line-height: 30px; text-align: left;">Step2:</span><span style="color: #0b5394; font-family: "arial" , "helvetica" , sans-serif;"> Start Install</span></span></h4>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6000003814697px;"># yum install MariaDB-server MariaDB-client -y</span></span></pre>
<div>
</div>
</div>
<div>
<div>
<h4 class="heading2" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-stretch: normal; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; text-align: justify; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0379bf; font-family: "roboto slab";"><span style="font-size: 20px; font-weight: bolder; line-height: 30px;"> </span></span><span style="color: #0379bf; font-family: "roboto slab"; font-size: 20px; font-weight: bolder; line-height: 30px; text-align: left;">Step3: </span><span style="background-color: transparent; color: #0379bf; font-family: "arial" , "helvetica" , sans-serif; line-height: 28.7999992370605px;">After complete installation process, start MariaDB :</span></h4>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6000003814697px;"># service mysql start</span></span></pre>
<div>
<div>
<h4 class="heading2" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; color: #0379bf; font-family: 'Roboto Slab'; font-size: 20px; font-stretch: normal; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
 <span style="font-weight: bolder;">Step4: </span><span style="font-family: "lato" , "arial" , sans-serif; font-size: 16px; font-weight: bolder; line-height: 28.7999992370605px; text-align: justify;">Set MariaDB to start on boot:</span></h4>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6000003814697px;"># chkconfig mysql on</span></span></pre>
<div>
<h4 class="heading2" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; color: #0379bf; font-family: 'Roboto Slab'; font-size: 20px; font-stretch: normal; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="font-weight: bolder;">Step5: </span><span style="font-family: "lato" , "arial" , sans-serif; font-size: 16px; line-height: 28.7999992370605px; text-align: justify;">Secure MariaDB after installation to :</span></h4>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6000003814697px;">– Set (Change) root password
– Remove anonymous users
– Disallow root login remotely
– Remove test database and access to it
– Reload privilege tables</span></span></pre>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6000003814697px;">[root@Unixmen-centos65 Downloads]# mysql_secure_installation</span></span></pre>
<div>
<h4 class="heading2" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; color: #0379bf; font-family: 'Roboto Slab'; font-size: 20px; font-stretch: normal; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="font-weight: bolder;">Step6: </span><span style="font-family: "lato" , "arial" , sans-serif; font-size: 16px; line-height: 28.7999992370605px; text-align: justify;"> Check the new root password and databases:</span></h4>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6000003814697px;"># mysql -u root -p</span></span></pre>
<div>
<h4 class="heading2" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; color: #0379bf; font-stretch: normal; font-weight: bolder; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; text-align: left; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="font-size: 20px; font-weight: bolder; line-height: 30px; text-align: justify;"><span style="font-family: "roboto slab";">Result Bellow</span></span><span style="font-family: "lato" , "arial" , sans-serif; font-size: 16px; font-weight: bolder; line-height: 28.7999992370605px; text-align: justify;">:</span></h4>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6000003814697px;">Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 13
Server version: 5.5.34-MariaDB MariaDB Server
Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]></span></span></pre>
</div>
</div>
</div>
<div>
<a href="https://mariadb.com/">Click Here</a> For More Information About MariaDB</div>
<div>
<ul style="text-align: left;">
<li><span style="font-size: large;"><span style="color: red;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-mariadb-10-on-centos-7.html">Installing MariaDB 10 on CentOS 7 / RHEL 7</a> </span></span></li>
</ul>
</div>
<div>
<span style="color: white;"><span style="line-height: 15.6000003814697px;"><br /></span></span></div>
<div>
</div>
</div>
</div>
<div>
</div>
</div>
</div>
<div>
</div>
</div>
</div>
</div>
</div>

How to Install MariaDB On CentOS 6

Install MariaDB On CentOS 6 MariaDB is a community-developed fork of the MySQL relational database management system, the impetus bei...