Setup Master Slave replication in MariaDB

Databases are arguably one of the main component of any modern application. And one of the most popular implementation of SQL databases is Mysql or the new replacement MariaDB. As a system administrator, you probably have installed and configured a database before. This tutorial will walk though setting up the master-slave replication of MariaDB.
Continue reading “Setup Master Slave replication in MariaDB”

Adding new disk on Amazon EC2 instance Centos/RHEL 6

Amazon VPS instances, by default only have a single disk for the whole filesystem of the server. Unless you chose to add an additional disk when you provision the server, adding disk space to your VPS can be tricky. Here’s a run down on how to add more storage to your server on amazon by mounting a new drive.

In this tutorial, I’ve mounted the new drive to /var/lib/mysql since I need to increase the disk space used by the database. This tutorial is still applicable even if you want to increase a different folder. The process will be the same.

Continue reading “Adding new disk on Amazon EC2 instance Centos/RHEL 6”

Important MySQL commands

The following tutorials are example of the essential MySQL commands and techniques needed by system administrators. Although there are people/departments that specializes on Database administration, knowing these commands will help you understand and collaborate effectively with database administrators.
Continue reading “Important MySQL commands”

Additional MySQL Commands

When you forgot the password to your MySQL server, you can reset it using the following steps. This will require a downtime since you are going to stop MySQL service. After this, remember to keep you mysql root password.

Continue reading “Additional MySQL Commands”

Return MySQL query as PHP variable

If you have a PHP built webpage and you need to save the MySQL query as a PHP variable, then you can use the following function.
The MySQL query result should be a single entry and it will be saved on the variable when the function is called.

Continue reading “Return MySQL query as PHP variable”

Install Mongo and MBString PHP module on RedHat

The following steps walks through the installation of mongo and mbstring modules for php. This is helpful when you are required to install specific versions of the modules along with your PHP package.
Installation on CentOS of php-mbstring is straightforward as you just can get the package from the Epel-repo or on the Optional Packages repo.
Continue reading “Install Mongo and MBString PHP module on RedHat”