当前位置：网站首页>Master-slave delay reason and solution

Master-slave delay reason and solution

2022-08-08 23:08:00 【Also believe that light?】

Reason: The main library is single-threaded and the slave library is multi-threaded

Solution:

1, read data from cache

2, improve the configuration from the library

3, disable the binary log from the library bin_log

4, modify sync_binlog=0 in the configuration 0: The system judges to synchronize immediately after receiving the update 1: The efficiency is 5 times that of 0, but the performance takes up a lot

5,log_slave_update_log

6, use the middleware mysql _proxy

7, force to fetch data from the main library

原网站

版权声明
本文为[Also believe that light?]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/220/202208082301426140.html

边栏推荐

猜你喜欢

随机推荐