How to install and configure MySQL Master-Slave replication on a CentOS 7 VPS

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

Full Story