10th March 2020 By Hitesh Jethva
If you are a Database administrator and responsible for managing the MySQL server, you must have a knowledge of the replication concept as this will helps you in terms of Data Security, Fail-over Solution and Database Backup from Slave.
MySQL replication is the process that enables data from one MySQL server to be copied to one or more MySQL servers. By default, replication is asynchronous by default and slaves do not need to be connected permanently to receive updates from the master. It is primarily used to read access on multiple servers for scalability and also used for failover. Continue Read