MySQL 8 Administrator???s Guide

Scaling using replication

Replication is the copying of a MySQL database. MySQL provides replication with a different approach. MySQL has a feature of replication that provides scale-out solutions, data security, long distance data distribution and many more benefits. We have discussed this at length in Chapter 8, Replication in MySQL 8. The following image explains the basic architecture of replication in MySQL:

Replication is one of the best features of MySQL. It simply creates a copy of the data to the new server or another physical machine, which will import the data from the master server. Whenever the data is required it will populate ...