mysql 主键分布式生成的方法_分布式数据库中全局唯一主键生成策略的设计与实现...

Design and Implementation of Global Unique Primary Key Generation Strategy In Distributed Database System

HU Yunting

1

胡云亭(1990-)，男，工学硕士，主要研究方向：业务网络智能化

WANG Jing

2

王晶(1974-)，女，副教授，主要研究方向：业务网络智能化

1、 Beijing University of Posts and Telecommunications Institute of Technology Network, Beijing 100876

2、Beijing University of Posts and Telecommunications Institute of Technology Network, Beijing 100876

Abstract：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.