In this tutorial we’ll explain how to install and configure MySQL Master-Slave replication on a CentOS 7 VPS. The following MySQL replication is based on binary log position, which means it is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database.
REQUIREMENTS
The following are MySQL replication system requirements for this tutorial:
CentOS 7 Linux VPS Hosting
MySQL Database Server
MYSQL MASTER VPS
0. SSH TO YOUR MASTER CENTOS VIRTUAL SERVER
First thing to do is to login to your MySQL master virtual server via SSH and optionally fire up a screen/tmux session. For example:
ssh YOUR_MASTER_VPS_IP -p YOUR_MASTER_VPS_SSH_PORT
screen -U -S mysql-master-replication