Sales locking method and system based on caching

Abstract

The invention discloses a sales locking method and system based on caching, and the method comprises the following steps: S1, dividing commodity information into a plurality of parts according to themodulus of a commodity code, and respectively storing the commodity information in a cache library of a corresponding code of Redis according to a preset rule; S2, obtaining and analyzing a sales locking request of the commodity to obtain a request list; S3, recording an inventory change intermediate table in the same transaction according to the request list, and then updating the commodity information in the cache library of the corresponding code of the Redis; and S4, asynchronously updating the commodity information in the database by using the second-level JOB according to the inventory change intermediate table. According to the method, the use of a single Redis cache library for storing a large amount of data is avoided; query efficiency is improved, atomicity of LUA scripts is usedfor replacing database affairs to guarantee data consistency, inventory concurrency control is conducted by means of the characteristics of Redis single threads, and the gray scale state is used forsolving the problem that cache and database data are inconsistent due to data processing when requests come in the process of switching the data to the cache.

Description

technical field [0001] The invention relates to the technical field of computer software, in particular to a cache-based sales locking method and system. Background technique [0002] With the development of the Internet, traditional stores are gradually replaced by online shopping platforms. More and more users choose to shop online, and at the same time, in order to attract users, online shopping platforms have launched a variety of promotional activities, such as flash sales, rush purchases, group purchases, etc. Promotional activities will generate instantaneous high concurrency, which puts forward high requirements on the processing efficiency of the entire transaction link. The maintenance of inventory quantity is a core part of it, and efficient processing is also crucial. [0003] In the current inventory deduction method, the sales lock (temporary lock + official lock) and delivery lock (logistics delivery) adopt the scheme based on database + application lock tech...

AI Technical Summary

Problems solved by technology

[0007] In order to solve the problems of the prior art, the embodiment of the present invention provides a cache-based sales locking method and device to overcome the DB performance bottleneck in the prior art of sales locking when dealing with high concurrency, and the low TPS processing capacity during sales promotion However, the system has a single inventory structure, which cannot meet business needs, and requires pre-maintenance activities, etc.

Images