Shulou(Shulou.com)06/01 Report--

In 2020, we will comprehensively promote the use of MGR in the business system. At present, there is a very important problem, that is, how to solve the problem of client redirection when the master node of MGR is abnormal: 1. Use official connector 2, use load balancing equipment such as F53, use router, such as MySQL Router 8.04, middleware. For example, some manufacturers' products, or proxySQL.

We are all testing the above schemes.

It is important to understand that although the database service is available, in the event of a server crash, those clients connected to it must be redirected, or failed over, to a different server. This is not something Group Replication attempts to resolve. A connector, load balancer, router, or some form of middleware are more suitable to deal with this issue. For example see MySQL Router 8.0.

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.