You can setup two types of replication in MySQL. First is the master master replication and other one is master slave replication.
But master slave replication provides only load balancing for the databases, it does not provide failover. It means if your master server goes down, you can not execute queries directly on the slave server. In master master replication, it will allows data to be copied from one server to the other. This will adds redundancy and increases efficiency when accessing database.
In this tutorial, we will learn how to configure mysql master master replication between two Ubuntu 16.04 host.
Two server running Ubuntu 16.04.
Static IP address 192.168.15.237 configured on first master server.
Static IP address 192.168.15.100 configured on second master server.
A non-root user with sudo privileges configure on both server.
Install and Configure MySQL on First Master Server
First, you will need to install mysql server and client on first server. You can install it with the following command:
sudo apt-get install mysql-server mysql-client
Next, you will need to make some changes in my.cnf file:
If you find your cPanel disk space filling up, or an email address has hit its disk space quota, cPanel has a helpful built in Email Disk Usage tool. This will provide you with a simple to understand breakdown of how much disk space each folder for a particular email...
Although WHM will normally automatically keep itself up to date, you may want to manually check for server updates / push through an update that is pending, or it may be that you have automatic updates switched off on your cPanel server. In this guide we will show you how...
You may sometimes need to manually adjust the PHP settings on your cPanel server – for example if a site is hitting the PHP memory, or file size upload limit. WHM allows you to quickly change the settings of any PHP version installed on the server when needed, using the...