MariaDB database server is an open source server that is a fork of MySQL and a drop-in replacement. It is now the fastest growing open source database server today. Over the many years, MySQL was the king of database servers [...]
Mariadb
How to Completely Remove Mysql and Install MariaDB 10
We have some popular database tools which are independent and commonly used. Normally you can use two different relational database management system (RDBMS) on the same server if they don't use the same port but it is not advised if you [...]
How to Setup and Use MariaDB on Docker Container
I’m following my series of articles about the rock stars of the devops ecosystem. In today's article I will show you how to setup and use MariaDB on docker container and as bonus we will be able to reuse the [...]
How to Configure Mariadb Maxscale Master-Slave with Galera Cluster
In this article we will install MariaDB galera cluster with MaxScale proxy database by MariaDB corporation. MaxScale is inteligent proxy database that can route database statements from cluster to one server. But unlike HAproxy, MaxScale uses asynchronius I/O of the [...]
How to Create Mariadb Users Accounts and Grant Privileges
MariaDB is an open-source MySQL project with more improved features. It is highly compatible with MySQL and it can be considered as a drop-in replacement for MySQL. All client libraries, client-server protocols, SQL dialect, MySQL replication, Master-slave configuration etc are quite [...]
How to Setup MariaDB Galera Cluster with HAproxy on CentOS 7
In todays article we will install MariaDB Galera cluster with HAproxy for load balanced MariaDB and wordpress. Galera is active-active clustering technology, meaning that it can support writes on all nodes which are then replicated across cluster. There is also [...]
How to Setup Mail Server Using Postfix, MariaDB, Dovecot and Roundcube
Hello everybody, today we are going to setup mail server using Postfix, Devcot and MariaDB on Ubuntu 16.04 LTS. In this article we will shows you how to setup Postfix (smtp server), Dovecot (imap/pop server) and MariaDB to store information [...]
How to Install MariaDB 10 on CentOS 7 CPanel Server
MariaDB is a enhanced open source and drop-in replacement for MySQL. It is developed by MariaDB community and available under the terms of the GPL v2 license. Software Security is the main focus for the MariaDB developers. They maintain its [...]
Howto Install and Configure FEMP Stack (FreeBSD 10.2, Nginx, MariaDB, PHP)
FreeBSD is free and open source Unix-like operating system from Berkeley Software Distribution (BSD) and it is one of the most popular server platform. Designed with advanced networking, security and server storage. Until now freebsd has been ported to a [...]
How to Configure MariaDB Replication on CentOS Linux
Its a process of creating duplicate versions of a the DB. Replication process is not only copies a database, but also synchronizes changes from master to one of the slaves. But this is does not means that slave databases are [...]
Simple Steps Migration From MySQL To MariaDB On Linux
Hi all, this tutorial is all gonna be about how to migrate from MySQL to MariaDB on Linux Server or PC. So, you may ask why should we really migrate from MySQL to MariaDB for our database management. Here, below [...]