Shulou(Shulou.com)05/31 Report--

This article mainly introduces the example analysis of replication replication in mysql, which has a certain reference value, and interested friends can refer to it. I hope you can learn a lot after reading this article.

1 first, the master server writes the data changes to the binary log (binary log).

2 the slave server copy the binary log file of the master server to its own relay log.

3 replay the events in the relay log from the server and update your own related data.

Let's explain in detail below. When the master server updates data, including insert, create,drop and other operations, it will write specific events to its own binary log, even if the specific operation is an error operation, it will also write related events to its own binary log. Then the slave server will actively go to the master server to copy its generated binary log file and write it to its own relay log. In this process, the slave server will set up an I / O thread. To put it bluntly, the slave server will establish a client connection to actively connect with the master server, and then start a process. The role of this process is to read events from the binary log of the master server. When the slave server copies the binary log file of the master server to its own relay log file, the slave server will start a thread to read the contents of the relay log and replay the contents to synchronize the master. It is important to note that replication is asynchronous and synchronous, which means that the data from the server is not always updated, there may be a delay between them, it may be seconds, minutes, or even hours in a large database. Oh,my sky!!

Thank you for reading this article carefully. I hope the article "sample Analysis of replication replication in mysql" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.