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…

MySQL Replication

Creating a MySQL cluster with real time replication is simple than many think. It has very few config changes and the result is magnificent. You can add as many MySQL slaves as you want to the Master MySQL Server. You have the choice of doing real time replication on a few slaves while you can…