分布式数据库中全局唯一主键生成策略的设计与实现
esign and Implementation of Global Unique Primary Key Generation Strategy In Distributed Database System
随着互联网的发展以及数据的爆炸式增长,集中式数据库已经无法满足海量数据快速存储和查询的要求了,这时分布式数据库应运而生。分布式数据库是用计算机网络物理上分散的多个数据库单元连接起来组成的一个逻辑上统一的数据库。分布式数据库使用全局唯一主键从逻辑上保证其数据全局的唯一性。本文提出了一种新的生成全局唯一主键的策略,通过建立主键生成服务器集群、使用MYSQL相关设置属性和一致性哈希来实现全局唯一主键生成系统的可用性、容灾性和扩展性。此外,本文还通过实验数据来证明此策略的可用性、容灾性和扩展性。
With the development of Internet and the explosive growth of the data, centralized database has been unable to meet the requirements of massive data storage and query quickly, and then distributed database came into being. Distributed database is a logically unified database consist of multiple databases dispersed units in physicals. In distributed database, the global unique primary key guarantees the uniqueness of the data on the logic. This paper proposed a new generation strategy of global unique primary key. Build generation server cluster and use MYSQL settings properties and consistent hash to achieve availability, disaster recovery and scalability. Besides, confirm the availability, disaster recovery and scalability of this strategy according to the experiment data.
王晶、胡云亭
计算技术、计算机技术
分布式数据库MYSQL一致性哈希负载均衡
istributed DatabaseMYSQLonsistent HashLoad Balance
王晶,胡云亭.分布式数据库中全局唯一主键生成策略的设计与实现[EB/OL].(2013-12-23)[2025-08-18].http://www.paper.edu.cn/releasepaper/content/201312-706.点此复制
评论