recently, a project is a theater ticket management system, but the ticket module does not know how to implement it. At first, it uses the transaction and locking mechanism of MySQL database, but there are still some problems. Finally, I think about whether we can use Redis message queue, but I don"t know how to implement it. I hope which boss can give some ideas or opinions. I"m much obliged.
12306 implemented? check the database before each purchase to see if the status is correct. If the status is right, I'll let you buy it. If it is not correct, it will show that it is booked
row-level lock will not be OK
use redis's incr , decr , incrby to control the increase and decrease of inventory, which is not so complicated.
to put it simply, when inventory is produced, Synchronize in redis also produces inventory. Users only need to add or subtract inventory in redis after the purchase request, execute redis transaction with Synchronize after successful redis operation, or introduce message queue to execute db transaction asynchronously. The reason why you can use redis to solve concurrent oversold is that redis is a single-process, single-threaded Synchronize operation, so you can design it at will, and so is the second kill operation.
Baidu found this way of thinking: needs a queue, a queue of panic buying results and a queue of inventory. In the case of high concurrency, first put the user into the queue, use a thread loop to remove a user from the queue, and judge whether the user...
1. There is no problem with testing the code locally 2. When you turn on php think queue:listen on the server, there is no response or error message, as if nothing has been moved. 3. However, you can insert a new task queue, but do not execute to the s...
the idea is that I first record several different points in redis, and then take a point as the center, get the points with a square circle, such as 500m, and sort them by distance, but find that the closer the longitude and latitude, the greater the dis...
1. Problem description gitphp-redis:git clone https: github.com edtechd phpredis.git extension=redis.so php.ini php-fpm: `[27-Apr-2018 08:19:57 UTC] PHP Warning: PHP Startup: Unable to load dynamic library redis.so (tried: usr lib64 php modules...
such as now I want to design an online seat selection system but when users sign up, they can dynamically edit unreserved seats in the background how should I design it from the generation of seats to the final registration, seat selection and editing...
Tencent s qq generally consumes points when fighting landlords. His qq coins are usually stored in memory. in addition, he also has recharged qq coins, if stored in memory, how to ensure that after each successful recharge, the currency of memory will ...
the occupation of an online redis CPU is relatively high. How to troubleshoot this? redis users provide PHP scripts to obtain data, and PHP processes data ...
is there a persistent connection for PHP and a redis class library with reconnection function? ...
how to add more listening files to listen to different job states when I have multiple job Resque_Event::listen ( eventName , [callback]); ...
the data is designed as follows: assume that the user information is stored below, 127.0.0.1:6379> HMSET user:1 username age 11 status 1 OK 127.0.0.1:6379> HMSET user:2 username age 12 status 0 OK 127.0.0.1:6379> HMSET user:3 username age...
1. Why can redis? be used after php-redis.dll is installed in the development environment is this redis the client? 2. What is the role of the redis server in the online environment? Manage redis data or something? 3. This question has been searched o...
the value taken out each time is 2. Why but the fiddler grab package also shows that it was only called once. There is no record of two calls. this happens only in js, but not if you open the interface address in the browser. ...
We all know that login usually uses session to save a state, which is used to determine whether or not to log in to a website, and different domain names generate different PHPSESSID. question: if we use redis to implement session sharing for single sig...
1. Number of users: about 5w 2. Business requirements: 5 3. Problems encountered: mysql redis ...
php adds redis cache to the page, and it has a life cycle. It has been used for a month and found that the memory is almost full. How to deal with it? What is the impact of clearing memory directly? What s the safest thing to do? Thank you! ...
can redis hset set expiration time ...
$redis->flushAll(); set 1. $redis->zAdd( stud ,11, zhangsan ,22, zhangsan1 ,33, zhangsan3 ); $redis->zAdd( stud ,66, zhangsan2 ,55, zhangsan6 ,44, zhangsan5 ); 2. ...
$obj_cluster = new RedisCluster(NULL, [ 192.168.222.130:6379 ]); ...
suppose that the order is confirmed and then pushed to the remote server, and the API limits it to 70 times per minute. It thinks of the following solutions: 1. Each click will request an API, wait for the result to return and verify the result. Probl...
I have read some redis subscription articles that talk about using subscriptions in the command exercise. Are those real-time message notifications implemented by Ajax polling? Since subscribe monopolizes the connection blocking mode, it must no longer b...