In web development, we often cache time-consuming operations of our database, but there may be a trap. At the moment when the cache becomes invalid, a large number of accesses will get cache invalid indications, and all go to the backend to query the database, resulting in a large number of requests at the same time. Database queries are time-consuming and problems such as database downtime may occur. This problem is deeply hidden and difficult to find. This project is mainly used to solve the inter-process lock problem of PHP.
Example:
Copy the code as follows:
/**
* Test example, open two pages at the same time, you can find the code that only one page can always enter the lock range at the same time
* @link http://code.google.com/p/phplock/
* @author sunli
* @svnversion $Id: test.php 2 2009-11-24 07:14:27Z sunli1223 $
* @version v1.0 beta1
* @license Apache License Version 2.0
* @copyright sunli1223@gmail.com
*/
require 'class.phplock.php';
$lock = new PHPLock ( 'lock/', 'lockname' ) ;
$lock->startLock ();
$lock->startLock ();
//process code
echo "enter lock
rn";
ob_end_flush();
flush();
ob_flush();
sleep ( 5 ); //Sleep for 20 seconds, simulate concurrent operations
echo "Execution completed
rn";
$lock->unlock ();
$lock->endLock ();
echo "Release lock completed
rn";
/**
* cache operation
*
* @return $array
*/
function getCache($key) {
return $cache;
}
/**
* Set cache
*
* @param string $key
* @param array $value
*/
function setCache($key,$value) {
}
$cache=getCache($key);
if (! $cache) {
//The cache does not exist, Start locking
$lock = new PHPLock ( 'lock/', $key );
$lock->startLock ();
$lock->startLock ();
//Try to determine whether there is data in the cache, maybe There is already access to rebuild the cache, so there is no need to query the database again
$cache=getCache();
if(!$cache){
//Database query operation, the code is omitted
$data=$dbdata;
setCache($ key,$data);
}
//Release lock
$lock->unlock ();
$lock->endLock ();
}
?>
For more related articles, please pay attention to PHP Chinese website (www.php.cn)!