DEV Community


Posted on

What is MySQL Replication ?

MySQL replication is a process in which data from one MySQL database server (the master) is automatically copied to one or more other MySQL database servers (the slaves). This allows multiple copies of the same data to be maintained on different servers, providing a number of benefits, such as improved performance, higher availability, and better scalability.

There are several different types of MySQL replication, including:

Master-slave replication: In this type of replication, data is copied from a single master server to one or more slave servers. The master server receives all writes and updates, and these changes are then propagated to the slave servers. This allows the slaves to be used for read-only operations, which can improve performance and reduce the load on the master server.
Enter fullscreen mode Exit fullscreen mode

read full:

Top comments (0)