关系数据库分片研究
首发时间:2011-12-23
摘要:文章基于关系数据库,研究关系数据库在数据量增加以及访问量增加时的数据分片方法,从而扩展数据库的存储和性能。文章主要研究了主从库、单主库多从库、垂直分库、范围法、哈希法、一致性哈希等技术在数据库扩展和性能提升中的使用,并给出案例说明该种技术如何使用以及优缺点,此外文章也简单研究了多个库时数据的同步,通过这些技术的综合,可以构建大数据量健壮的数据库系统,满足海量数据的存储以及高并发访问的需求,从而实现更多的业务需求。
关键词: 计算机应用技术 关系数据库 水平分库 垂直分库 一致性哈希 主从库
For information in English, please click here
Relational Database Sharding
Abstract:In this paper, based on relational database, the sharding method of database was studied when data increasing to extend the database storage and the use of principal and subordinate database,single principal and many subordinate database,ranging,hashing methods and consistent hashing was studied ,and examples and advantages and disadvantages of each technology are given ,also in this paper the data synchronization in many databases was introduced .through these technologies, robust database system of amount data can be bulit to meet the massivedata storage and high concurrent access requirements, so more business needs can be achieved.
Keywords: computer application technology relational database scale up scale out consistent hashing principal and subordinate database
基金:
论文图表:
引用
No.****
同行评议
共计0人参与
勘误表
关系数据库分片研究
评论
全部评论0/1000