MariaDB Cluster with HAProxy

Hey folks This video will get you through the implementation of MariaDB Cluster using the builtin galera method and in addition to that using the HAProxy application, we will build High Availability in the cluster. Both the servers will be in master-master configuration. Various commands that we run on the three boxes are mentioned below…

MySQL Master Master Configuration

Hello Folks Creating a Master – Master replication for MySQL has never been so simple. We shall be using terminal and phpmyadmin, both, to create the Master-Master Replication. Will be using 2 numbers of Ubuntu 16.04 LTS, 64 bit edition server for this activity. Server 1- 192.168.65.11 & hostname: mysqldb1 Server 2- 192.168.65.12 & hostname:…

PHP 7, Phpmyadmin & MySQL 5.7 in Ubuntu 16.04

Hello folks Ubuntu Xenial Xerus (16.04) is a cracker of a release. It is one of the best releases ever. While the desktop edition has several changes on the skin and under it making it one of the most stable releases of Ubuntu, the server edition has been updated with latest releases of various important…

Temperature Monitor for Ubuntu Servers

We are all aware of software & method of monitoring temperature of processors, motherboards etc on ubuntu desktops using software like psensor. However, for servers, it becomes quite difficult to monitor as there is no GUI. You have depend on command line. Following is a simple way of monitoring temperature of key components like processor,…

CPU & Memory Stats in phpmyadmin

It is observed that in phpmyadmin, under the status -> monitor tab only top 3 graphs work while the bottom three graphs don’t. Below is a simple addition that needs to be done to enable bottom 3 graphs as well. sudo nano /etc/phpmyadmin/apache.conf add : :/proc/meminfo:/proc/stat at the end of the linephp_admin_value open_basedir` Before adding…