Method for realizing timed task atomicity by using database lock

Abstract

The invention provides a method for realizing timed task atomicity by using a database lock, and the method comprises the following steps: S1, setting a plurality of groups of virtual machine nodes, and deploying an ntp server on each group of virtual machine nodes; S2, setting a time specification corresponding to the timing task time lock; S3, setting a time lock main key, and setting a timing task of a time lock to preempt a database row-level lock; S4, according to a time lock return result in the step S3, judging whether the task is preempted or not; S5, enabling the timed task preempting the time lock to enter a task execution queue and execute the task, wherein the timed task which does not preempt the time lock gives up the task executed this time; S6, updating the lock data after the task is executed, and checking a task execution result. According to the method, based on the timed task characteristics, the timed task time lock is integrated with the database row-level lock to realize the atomicity of the timed task, and the uniqueness of the service timed task under the condition of multiple copies is ensured, so that the problem of dirty data caused by the timed task is avoided.

Description

technical field [0001] The invention belongs to the field of information technology, and in particular relates to a method for realizing the atomicity of timed tasks by using database locks. Background technique [0002] With the development of computer applications, application services have already shifted from monolithic services to microservice architectures. Early monolithic services had many disadvantages, and service maintenance was difficult. The emergence of microservice architectures solved the disadvantages of monolithic services, but in many When the replica service executes the scheduled task, there will be the following problems: (1), when multiple copies execute the same scheduled task at the same time, the same task will be executed multiple times at the same time point, and there will be inconsistency in the data updated by each service, which will directly The problem of making business data inconsistent; (2), multiple copies pull a large amount of data fro...

AI Technical Summary

Problems solved by technology

[0002] With the development of computer applications, application services have already shifted from monolithic services to microservice architectures. Early monolithic services had many disadvantages, and service maintenance was difficult. The emergence of microservice architectures solved the disadvantages of monolithic services, but in many When the replica service executes the scheduled task, there will be the following problems: (1), when multiple copies execute the same scheduled task at the same time, the same task will be executed multiple times at the same time point, and there will be inconsistency in the data updated by each service, which will directly The problem of making business data inconsistent; (2), multiple copies pull a large amount of data from remote services at the same time, and write them into the database, and a large amount of repeated data is written into the database, which increases the processing pressure of the database and affects the task execution schedule; therefore , there is an urgent need for a method of using database locks to realize the atomicity of timed tasks

Images