A distributed primary key generation method and device

Abstract

The invention discloses a distributed primary key generation method and a distributed primary key generation device. The method includes: generating a sequence table in a primary key generation server, and acquiring an available strategy from a strategy server; allowing an application that requires distribution of a primary key to access an SQL (structured query language) router, acquiring IP (internet protocol) address of the primary key generation server, and accessing the primary key generation server according to the IP address; allowing the primary key generation server accessed by the application to self-check whether the current available strategy is valid or not; allowing the primary key generation server accessed by the application to allocate a primary key to the application according to the current sequence table and update the current sequence table. The distributed primary key generation method and the device can provide lowered requirements on the size and performance of the primary key, support a high-concurrent system, meet special application demands and provide improved availability.

Description

technical field [0001] The present invention relates to the technical field of computer data processing, and more specifically, to a method and device for generating a distributed primary key. Background technique [0002] There are two common global primary key generation strategies as follows. [0003] One solution is to use UUID (Universally Unique Identifier, Universally Unique Identifier) ​​as the primary key. The disadvantage is that because the UUID is too long, it takes up a lot of storage space, and consumes a lot of computing resources when building an index and querying based on the index. [0004] Another solution is to maintain a Sequence table in combination with the database, that is, create a Sequence table in the database. The attributes include: tablename, nextid, and the nextid will be incremented by 1 each time the primary key is obtained. Its disadvantage is that all inserts need to access the table, so the table can easily become a system performance ...

AI Technical Summary

Problems solved by technology

Its disadvantage is that all inserts need to access the table, so the table can easily become a system performance bottleneck; at the same time, it also has a single point problem, once the table database fails, the entire application will not work

[0005] In the process of realizing the present invention, the inventor concluded that the existing technology has at least the following problems: the primary key is too large; the high performance requirements when building an index and querying based on the index; the access pressure with a read-write ratio of 1:1 is too high, Difficult to support high-concurrency systems; generated IDs are discontinuous and cannot meet special application requirements; low availability, once the generated policy server fails, the entire application cannot work

[0006] For the above problems in the prior art, there is no effective solution yet

Images