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

This article is to share with you about the principle of negative value in MySQL and what the process is. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The negative principle and flow of MySQL

First, execute the sart slave command on the Slave server to turn on the master-slave replication switch and start the master-slave replication.

2. At this point, the I / O thread of the Slave server connects to the master server through a request for replication user rights authorized on the master, and requests that the binlog log contents be sent from the specified location where the binlog log file is executed (the log file name and location are specified by the change master command when configuring the master-slave replication service).

3. After the Master server receives the request from the IO thread of the Slave server, the binary dump IO thread reads the binlog log information after the specified location of the specified binlog log file in batches according to the information requested by the IO thread of the Slave server, and then returns it to the IO thread on the Slave side. In addition to the contents of the binlog log, the new binlog file name recorded on the master server side and the next specified update location in the new binlog are returned.

4. When the IO thread of the Slave server obtains the log contents, log files and location points sent by the IO thread on the Master server, the binlog log contents will be written to the end of the Relay Log (relay log) file (MySQL-relay-bin.xxx) of the server itself, and the new binlog file name and location will be recorded in the master-info file. So that the next time you read the new binlog log on the master side, you can tell the Master server to start reading the new binlog log from the specified file and location of the new binlog log.

5. The Slave thread on the server side detects the new log content of the IO thread in the local Relay Log in real time, then parses the contents of the Relay LOG file into sql statements in time, and executes such sql statements on its own Slave server in the order in which the SQL statements are parsed, and records the file name and location point of the current application relay log in relay-log.info.

Thank you for reading! This is the end of the article on "what is the negative principle and process in MySQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.