基于MySQL的多地多中心系统架构研究  

Research on Multi-site and Multi-center System Architecture Based on MySQL

作　　者：陈杰 方国才 方水波 Chen Jie;Fang Guocai;Fang Shuibo(Shenzhen Jiuniu Yimao Intelligent IoT Technology Co.,Ltd.,Shenzhen,Guangdong 518107,China)

机构地区：[1]深圳市九牛一毛智能物联科技有限公司,广东深圳518107

出　　处：《机电工程技术》2025年第3期175-181,共7页Mechanical & Electrical Engineering Technology

摘　　要：由于单中心的业务系统设计难于满足用户数量及分布范围不断扩大带来的高并发、响应快及高数据安全性要求,研究了一种基于“DNS+全局流量管理(GTM)+MySQL主从复制+dble+orchestrator+keepalived+LVS”多地多中心系统架构。对于无状态的应用服务,考虑了异地多活因素,通过DNS与全局流量管理(GTM)提供用户访问流量分流及就近访问业务系统的能力。对于MySQL数据库,考虑了高并发、多中心数据一致性及数据快速响应因素,进行统一中心写就近中心读的分库分表设计,其中MySQL主从复制技术为自身提供了高可用能力,dble提供了MySQL数据库的分库分表及分库分表下的读写分离就近读的能力,orchestrator提供MySQL的高可用管理及联动dble进行高可用切换的能力,LVS为dble提供负载均衡的能力,keepalived提供MySQL就近读和LVS的高可用能力。该架构使用的技术具有高成熟度,满足了业务系统多中心压力分流、快速响应、高可用及容灾要求,为有关系统的多地多中心设计提供一定的借鉴与参考。Due to the difficulty of meeting the high concurrency,fast response,and high data security requirements brought by the increasing number of users and distribution range of a single-center business system design,a multi-center system architecture based on DNS+Global Traffic Management(GTM)+MySQL master-slave replication+dble+orchestrator+keepalived+LVS is studied.For stateless application services,the factors of multi-active in different locations are considered,providing the ability for user access traffic distribution and near access to business systems through DNS and GTM.For MySQL databases,factors such as high concurrency,multi-center data consistency,and fast data response are considered,and a centralized write and near-center read sharding design is carried out.The MySQL master-slave replication technology provides high availability for itself,dble provides MySQL sharding,read/write splitting,and nearby read capabilities,orchestrator provides high availability management for MySQL,and the ability to switch high availability with dble,LVS provides load balancing for dble,and keepalived provides high availability for MySQL near-read and LVS.The technology used in this architecture is highly mature,meeting the requirements of multi-center pressure distribution,fast response,high availability,and disaster recovery for business systems,it provides some reference for the multi-site and multi-center design of related systems.

关 键 词：多地多中心系统 GTM MYSQL dble orchestrator keepalived LVS 

分 类 号：TP311.5[自动化与计算机技术—计算机软件与理论]