Log-slave-updates causes MySQL to synchronize abnormally slowly from the node

Source: Internet
Author: User
1, from the library only to open the Log-bin function, do not add log-slave-updates parameters, the data from the library copied from the main library will not be written to the Log-bin log file.

2. When writing data directly from the library, it is written to the Log-bin log.

3. When the Log-slave-updates parameter is turned on, data copied from the library from the main library is written to the Log-bin log file. This is also the function of this parameter

Note: Adding Log-slave-updates=1 from the node configuration file, synchronization is unusually slow

Log-slave-updates causes MySQL to synchronize abnormally slowly from the node

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.