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”
Tag: MySQL
MySQL
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.
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.