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

What is the use of Consul+MHA in MySQL? aiming at 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 feasible way.

First, solve the problem

Second, the advantages of Consul+MHA

⑴ MHA is mature and can be switched manually or automatically, which is simple and practical.

⑵ MHA does not invade SQL and does not affect the performance of MySQL.

⑶ uses MHA to register kv to Consul, perceives the change of master, and realizes automatic business transfer.

III. Specific architecture scheme diagram

Notes:

⑴ MHA Manager is aware of the failure of the master database. After switching, the consul cluster registers the new master database information.

⑵ service acquires new main database information through http API provided by Consul to realize service disaster recovery.

The picture refers to part of the boss Yang Jianrong, because his own drawing is too ugly.

IV. Access effect

The specific effect of ⑴ is shown in the figure.

(2) Consul provides interfaces and security settings for services

① Service Interface (http):

Curl-X GET-H 'X-Consul-Token: 46ed56ddMy8cxxxxxx' http://X.X.X.23:8500/v1/kv/mha/master/test1

② security settings:

Use the token method of Consul to restrict business permissions, as shown in the figure:

I wanted to post the business code, but it involves some information of the company, so I won't upload it for the time being.

This is the answer to the question about how to use Consul+MHA 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 to learn more about it.

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.