| 注册
首页|期刊导航|机电工程技术|基于MySQL的多地多中心系统架构研究

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

陈杰 方国才 方水波

机电工程技术2025,Vol.54Issue(3):175-181,7.
机电工程技术2025,Vol.54Issue(3):175-181,7.DOI:10.3969/j.issn.1009-9492.2025.03.031

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

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

陈杰 1方国才 1方水波1

作者信息

  • 1. 深圳市九牛一毛智能物联科技有限公司,广东 深圳 518107
  • 折叠

摘要

Abstract

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

Key words

multi-site multi-center system/GTM/MySQL/dble/orchestrator/keepalived/LVS

分类

信息技术与安全科学

引用本文复制引用

陈杰,方国才,方水波..基于MySQL的多地多中心系统架构研究[J].机电工程技术,2025,54(3):175-181,7.

机电工程技术

1009-9492

访问量0
|
下载量0
段落导航相关论文