分布式关系型数据库研究与金融行业应用

Distributed Relational Database Research and Its Application in Financial Industry

数据库作为金融信息化建设的重要组成部分,需要面对持续的业务量增长、高度可用性和扩展性等挑战,而以MySQL、Oracle等为代表的传统数据库单点架构,在可用性、扩展性和存储能力上已经无法满足当前的金融服务要求.分布式数据库的出现,旨在解决单机数据库所面临的各种挑战,提供更加灵活的架构,保障系统稳定运行.为此,本文在结合实际的金融业务需求下,研究实现了具有分布式事务支持、分布式SQL引擎、混合事务分析处理等特点的分布式数据库.系统采用全组件的冗余设计,通过类Raft增强一致性算法保证了存储层高可用和数据强一致,同时利用基于Zookeeper的集群调度方案保证调度层的高可用.

As an important part of financial informatization,the database faces the challenges of continuous business growth and high availability and scalability,while the traditional single-point architecture of databases,represented by MySQL,Oracle,etc.,fails to meet the current requirements of financial services in terms of availability,scalability and storage capacity.Distributed databases are designed to address the challenges faced by single-site databases and provide the more flexible architecture,ensuring stable system operation.To this end,this study,subject to actual financial service requirements,researches and implements a distributed database equipped with a distributed SQL engine,which is capable of distributed transaction support and hybrid transactional/analytical processing.The system is designed with full component redundancy.In addition,high availability of the storage layer and strong consistency of the data are ensured by the Raft-like enhanced consistency algorithm,while high availability of the scheduling layer is guaranteed by the Zookeeper-based cluster scheduling scheme.