What are the causes of synchronization delays in MySQL? How to solve?

What are the reasons for the synchronization delay of the enterprise face test 042:mysql? How to solve? 1. Replication latency optimizations are caused by too many libraries: the recommended number of libraries is 3-5 2. Optimized from library hardware compared to main library hardware: Improves hardware performance 3. Slow SQL statement too much optimization: SQL statement execution time is too long, you need to optimize SQL statement 4. Master-slave replication Design Problem optimization: Master-slave replication single-threaded, can be solved by multithreading IO QL5.6.3 supports multi-threaded IO replication. 5. Network delay optimization between master and slave libraries: as long as the link is short, increase the port bandwidth 6. Main Library read-write pressure optimization: front-end plus buffer and cache. Master-Slave delay out-of-sync: No matter how much delay, as long as it doesn't affect the business 7, business design defects lead to delay affecting business optimization: No data from the library to change the main library this article from the old boy education operation and maintenance class lectures, and students after the summary, if reproduced please complete reprint and retain the copyright notice!

Linux operations must be MySQL enterprise face question nearly hundred

http://oldboy.blog.51cto.com/2561410/1681493

This article is from the "Old boy Linux ops" blog, please be sure to keep this source http://oldboy.blog.51cto.com/2561410/1682147

What are the causes of synchronization delays in MySQL? How to solve?