Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to learn the extra parameters of Manager in mysql

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

How to learn the extra parameters of Manager in mysql? in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

Description: who will take over when the main library is down?

1. All slave node logs are consistent, and a new master is selected by default in the order of the configuration file.

two。 If the slave node log is inconsistent, the slave library closest to the master library is automatically selected.

3. If a candidate_master=1 is set for a node, the weight node is preferred.

However, if the log volume of this node lags behind the 100m log of the main database, it will not be selected. You can cooperate with check_repl_delay=0 to turn off the check of log volume and force the selection of candidate nodes.

(1) ping_interval=1

# set the monitoring master database, the time interval for sending ping packets, and automatically failover when there is no response for three attempts

(2) candidate_master=1

# set as candidate master. If this parameter is set, this slave database will be promoted to master database after master-slave switching occurs, even if the master database is not the latest slave of events in the cluster.

(3) check_repl_delay=0

# by default if a slave lags behind the relay logs of master 100m

MHA will not select this slave as a new master, because the recovery of this slave will take a long time. Setting check_repl_delay=0,MHA to trigger switching will ignore replication delay when selecting a new master. This parameter is very useful for hosts with candidate_master=1 set, because the candidate host must be the new master during the handover.

This is the answer to the question about how to learn the extra parameters of Manager in mysql. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report