摘要
MySQL是最流行的关系型数据库管理系统之一,在国内互联网中应用十分广泛,原生的MySQL主从复制缺乏的灵活性,无法满足源端、目标端库表结构不一致的同步场景,也不能同步到异构数据存储中。基于MySQL Replication协议,设计并实现一种基于MySQL的数据同步中间件,支持增量数据的自定义规则处理,提供数据同步定制能力,目标数据存储支持MySQL、Kafka,以及其他异构数据存储。
MySQL is the most popular relational database management system today,is widely used in the domestic Internet.The native MySQL mas⁃ter-slave replication does not have high flexibility and cannot meet the synchronization scenarios where the source and target database ta⁃ble structures are inconsistent.Also cannot synchronize to heterogeneous data storage.To this end,this article designs and implements a da⁃ta synchronization middleware based on the MySQL Replication protocol,which supports custom rule processing of incremental data,pro⁃vides extremely high data synchronization customization capabilities.The target data store supports MySQL,Kafka,and other heteroge⁃neous data stores.
作者
刘丽
胡晓勤
LIU Li;HU Xiao-qin(College of Cybersecurity,Sichuan University,Chengdu 610065)
出处
《现代计算机》
2021年第2期34-40,50,共8页
Modern Computer
关键词
MYSQL
数据同步
异构
中间件
MySQL
Data Synchronization
Heterogeneous
Middleware