MariaDB

Install MariaDB Database in RHEL/CentOS/Fedora and Debian/Ubuntu

MariaDB is a binary drop-in replacement for MySQL, developed by original authors of MySQL Project and fully compatible with MySQL having more features and better performance enhancement. Till we wrote this post, MariaDB 10.0 Series is the development version (Alpha) and MariaDB 5.5 is the current stable (GA) release. Install MariaDB in Linux Why should…

Installing MariaDB 10.1 in Debian Jessie and Running Various MariaDB Queries

In our last article The Story Behind Acquisition of ‘MySQL’ and the Rise of ‘MariaDB’ was highly appreciated. In this article, we have already discussed the need to fork MySQL, the rise of MariaDB, Features of it, a comparative study of MariaDB and MySQL, Movement of some of the world’s renowned Corporates and Companies (Google,…

How to Upgrade MariaDB 5.5 to MariaDB 10.1 on CentOS/RHEL 7 and Debian Systems

MariaDB is a famous MySQL community fork that gained lots of popularity after Oracle acquisition of the MySQL project. On December 24th 2015 the latest stable version has been released which is MariaDB 10.1.10. Upgrade MariaDB 5.5 to MariaDB 10.1 on RHEL/CentOS 7 What’s new Few new features have been added in this version and you…

How to Setup MariaDB (Master-Slave) Replication in CentOS/RHEL 7 and Debian 8/9

Even when some IT people hear the phrase “Database replication“, they often associate it with the need of having multiple copies of the same information to avoid data loss in the event of hardware failure or data corruption. While that is true at some extent, there is much more to database replication than the common…

Learn MySQL / MariaDB for Beginners – Part 1

In this article we will show how to create a database (also known as a schema), tables (with data types), and explain how to perform Data Manipulation Language (DML) operations with data on a MySQL / MariaDB server. It is assumed that you have previously 1) installed the necessary packages on your Linux system, and…