How to Configure MySQL Master-Slave Replication on CentOS 7
|
|
MySQL replication is a process that allows you to automatically copy data from one database server to one or more servers.
|
|
MySQL supports a number of replication topologies with Master/Slave topology being one of the most well-known topologies in which one database server acts as the master, while one or more servers act as slaves. By default, the replication is asynchronous where the master sends events that describe database modifications to its binary log and slaves request the events when they are ready.
In this tutorial, we will explain how to set up a MySQL Master/Slave replication with one master and one slave server on CentOS 7. The same steps apply for MariaDB.
This type of replication topology is best suited for deploying of read replicas for read scaling, live databases backup for disaster recovery and for analytics jobs.
Full Story |
This topic does not have any threads posted yet!
You cannot post until you login.
