Best inroduction on master and slave replication
Answers
Answered by
0
Implementing Master-Slave replication (also known as mirror) is really important to prevent data loss, increase performance, support database backup and as one of the solutions to alleviate system failures.
To give you an idea on what Master-Slave is, imagine two MySQL server instances where the Master server is being copied automatically to a Slave server while the master is still fulfilling its job. You can actually have multiple slave servers. So, what happened is that if the master database server crashed, there will be an exact copy of the data from the master in the slave server.
To give you an idea on what Master-Slave is, imagine two MySQL server instances where the Master server is being copied automatically to a Slave server while the master is still fulfilling its job. You can actually have multiple slave servers. So, what happened is that if the master database server crashed, there will be an exact copy of the data from the master in the slave server.
Similar questions