Database-based inter-service integral log ID generation method

Abstract

The invention discloses a database-based inter-service integral log ID generation method, and the method comprises the steps: S1, unifying the generation configuration of integral log IDs in an ID database, and enabling the generation configuration to comprise a business identifier, a maximum ID value, an ID number segment length and a version number; S2, distributing a corresponding service identifier and an ID number segment for each service in each service system according to the generation configuration; and S3, enabling the service system to read the currently available ID value from the distributed ID number segment, and if the currently distributed ID number segment consumes to a set threshold value, automatically loading the next ID number segment to the memory of the service system from the ID database. According to the method, system service congestion caused by database reading and writing in each ID generation process can be effectively reduced, and the system response performance is improved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method for generating integral log IDs between multiple services based on a database. Background technique [0002] Generating a unique ID for the integral log data of multiple databases and multiple data tables is the basic function of the integral system. It is based on the premise of database read-write separation and sub-database sub-table architecture design, using the database to achieve unique ID generation . [0003] The existing commonly used point log ID generation scheme is: jointly maintain a data table for ID generation in each database, and set the ID generation of each point log database to a different step length, thereby avoiding point log IDs from appearing in different systems Duplicate situation. However, as the amount of data grows, the number of databases will inevitably increase, and it is difficult to expand the database in this solution. After the d...

AI Technical Summary

Problems solved by technology

However, as the amount of data grows, the number of databases will inevitably increase, and it is difficult to expand the database in this solution. After the database and step size have been defined, if a new database needs to be added, the step size of the database needs to be readjusted. And every time a new ID is obtained, a database read and write is required. When the number of requests to generate integral log IDs increases, the pressure of database read and write is high, which is likely to cause system blockage

Images