Setting up MySQL master to slave replication

May 16, 2020

First you need to configure MySQL to run on a reachable socket both on the master and slave, something else then localhost. Assign each server with an unique server id. Make a snapshot of the current database. Import that into the slave system. Create a user on the master that is allow to replicate. Set up the master configuration on the slave.

Read more