MySQL Replication setup the easy way

The MySQL replication setup requires three basic steps, we need to setup the master, then setup the client and finally start the replication process.

We will need to modify a file called my.cnf, which is the main configuration file for mysql. On most systems it’s located in /etc/ or /etc/mysql/ and it contains all important configuration data.

First, let’s ensure that networking is enabled and mysql listens on all, or at least the client’s IP addresses. We also have ...