Detailed explanation of examples of rush buying solutions under large traffic using PHP

This article mainly introduces a brief discussion of PHP's plan to realize rush buying under large traffic. The editor thinks it is quite good. Now I will share it with you and give you a reference. Let’s follow the editor to take a look, I hope it can help everyone.

It is required to display a real-time countdown of hours, minutes and seconds. Modifying the date and time on the client side will not affect the normal display of the countdown (that is, based on the server time).

In fact, this has the same requirements as the time limit function of many examination and other systems.

You can’t use ajax to get the server time every second, so the real-time countdown must be implemented with javascript. This is very simple, there are a lot of examples on the Internet.

The current problem is to solve the impact of the user-side modified date and time on our display.

The solution is to calculate the time difference between the client time and the server time, so that the problem is solved.

In this way, you only need to run php once, and the real-time countdown time will be synchronized with the server time.

The theory is synchronization, but the actual test will have an error of 1 second. (The specific reason is related to the Internet speed. The faster the Internet speed, the smaller the error.) But this will never affect our above requirements.

Note: The flash sale time is from 1:00 am to 10:00 pm.

Code is as follows:

<?php
//php的时间是以秒算。js的时间以毫秒算
date_default_timezone_set(&#39;PRC&#39;); 
//date_default_timezone_set("Asia/Hong_Kong");//地区
//配置每天的活动时间段 
$starttimestr = "08:00:00"; 
$endtimestr = "22:00:00";
$starttime = strtotime($starttimestr); 
$endtime = strtotime($endtimestr); 
$nowtime = time(); 
if ($nowtime<$starttime){ 
die("活动还没开始,活动时间是：{$starttimestr}至{$endtimestr}"); 
} 
$lefttime = $endtime-$nowtime; //实际剩下的时间（秒） 
?>
<script language="JavaScript"> 
</script>
<h4><strong id="RemainH">XX</strong>:<strong id="RemainM">XX</strong>:<strong id="RemainS">XX</strong></h4>

There seems to be no problem with the above, but when encountering traffic, there will be some problems with the wrong quantity, such as caused by the concurrent entry of large traffic into the database. The problem of negative inventory

We know that the database processes SQL one by one. Assume that the process of purchasing goods is like this:

sql1: Query product inventory

if(库存数量 > 0) 
{ 
//生成订单… 
sql2:库存-1 
}

When there is no concurrency, the above process looks so perfect. Assume that two people place orders at the same time, and there is only 1 inventory. In the sql1 stage, the inventory queried by both people is >0 , so sql2 was finally executed, and the inventory finally became -1, indicating that it was oversold. Either replenish the inventory or wait for user complaints.

The more popular ideas to solve this problem:

1. Use an additional single process to process a queue, put the order requests in the queue, and process them one by one, so there will be no concurrency problems Yes, but the additional background processes and latency issues will not be considered.

2. Database optimistic locking, which roughly means querying the inventory first, then immediately adding 1 to the inventory, and then after the order is generated, query the inventory again before updating the inventory to see if it is consistent with the expected inventory quantity. If it is consistent, it will be rolled back if it is inconsistent, and the user will be prompted that the inventory is insufficient.

3. To judge based on the update result, we can add a judgment condition update in sql2... where inventory > 0. If false is returned, it means that the inventory is insufficient and the transaction will be rolled back.

4. With the help of file exclusive lock, when processing the order request, use flock to lock a file. If the lock fails, it means that other orders are being processed. At this time, either wait or directly prompt the user "server busy"

This article is going to talk about the fourth solution. The approximate code is as follows:

Blocking (waiting) mode

<?php
$fp = fopen("lock.txt", "w+");
if(flock($fp,LOCK_EX))
{
 //..处理订单
 flock($fp,LOCK_UN);
}
fclose($fp);
?>

Non-blocking mode

##

<?php
$fp = fopen("lock.txt", "w+");
if(flock($fp,LOCK_EX | LOCK_NB))
{
 //..处理订单
 flock($fp,LOCK_UN);
}
else
{
 echo "系统繁忙，请稍后再试";
}
fclose($fp);
?>

Related recommendations:

How does PHP solve the problem of large traffic and high website traffic? Concurrency

#PHP Large traffic optimization?

PHP product flash sale timing implementation (solution to large traffic)

The above is the detailed content of Detailed explanation of examples of rush buying solutions under large traffic using PHP. For more information, please follow other related articles on the PHP Chinese website!