MySQL intra-city multi-center multi-activity implementation method and system based on group replication

The invention provides a group replication-based MySQL intra-city multi-center multi-activity implementation method and system, and the method comprises the steps: deploying a group of MySQL cluster A instance groups with a group replication protocol in a data center A, deploying a group of MySQL cluster B instance groups with a group replication protocol in a data center B, deploying traffic distribution middleware in a traffic control region, and deploying traffic distribution middleware in a traffic control region; and service access is distributed to the data center A and the data center B through middleware, so that double-writing multi-activity of the service is realized. According to the invention, when a fault occurs, no data loss and strong business continuity can be ensured, so that the overall operation and maintenance efficiency is improved. 本发明提供了一种基于组复制的MySQL同城多中心的多活实现方法和系统，包括：在数据中心A中部署一组带有组复制协议的MySQL集群A实例组，在数据中心B中部署一组带有组复制协议的MySQL集群B实例组，在流量控制区部署流量分发中间件，业务访问通过中间件分发给数据中心A和数据中心B，实现业务的双写多活。本发明在发生故障