This problem may occur for every ticket purchased, not just the last ticket. In addition, Node.js is single-threaded, so similar problems will not occur with stand-alone services, even with multi-core systems. However, if there are N servers running and using data from the same database, multiple processes are competing for resources.
If you want to solve this kind of problem simply, lock the table. If you want to handle this kind of problem more efficiently, you need to add some cache. If it is a high concurrency situation, you need to do some preliminary screening at the cache layer.
The data is in the database. Correctness under high concurrency depends on the database, such as using optimistic locking and adding version numbers to the data.
select version,data from table;
update table set data = 1,version = version + 1 where version = X
Judge whether it is successful based on the affectedRows returned by the update, and then spit out the results to the front end. Node itself only does request processing and forwarding of database commands. It is generally implemented with asynchronous callbacks. Multiple identical requests can be concurrently sent to the database in a single process. Generally, blocking methods are not used to request DB.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
This problem may occur for every ticket purchased, not just the last ticket. In addition, Node.js is single-threaded, so similar problems will not occur with stand-alone services, even with multi-core systems. However, if there are N servers running and using data from the same database, multiple processes are competing for resources.
If you want to solve this kind of problem simply, lock the table. If you want to handle this kind of problem more efficiently, you need to add some cache. If it is a high concurrency situation, you need to do some preliminary screening at the cache layer.
The data is in the database. Correctness under high concurrency depends on the database, such as using optimistic locking and adding version numbers to the data.
Judge whether it is successful based on the affectedRows returned by the update, and then spit out the results to the front end.
Node itself only does request processing and forwarding of database commands. It is generally implemented with asynchronous callbacks. Multiple identical requests can be concurrently sent to the database in a single process. Generally, blocking methods are not used to request DB.