MySQL Replication is very simple to set up. In this post I’ll
discuss its importance and five handy tools for monitoring and
managing MySQL replication.
What is MySQL Replication? It’s the process of copying the
(real-time events) data from one master instance to another slave
instance and maintaining the redundant consistent data in a
different machine. This enables a distributed database system
that shares the same level of information.
In MySQL the replication works based on the three threads as
shown below.
1) I/O thread on the slave server: To start on receiving
replication events, an I/O thread starts on the slave server and
connects to the master server.
2) Master connection handler thread: As a connection
handier, master starts a thread whenever a replication slave
connects to a master. The master server sends the events from its
binary log file to the slave I/O thread, notifying slave …
[Read more]