Php + memcached cache technology instance

1. Introduction to memcached in many occasions, we will hear the name of memcached, but many people have heard it, but they have never used it or actually learned it. they only know it is a good stuff. Here is a brief introduction. memcached is an efficient and fast distributed memory object caching... SyntaxHighlighter. all ();

1. Introduction to memcached

On many occasions, we will hear the name memcached, but many of you have heard of it, and have never used it or actually understood it. I only know that it is a good stuff. Memcached is an efficient and fast distributed memory object cache system, mainly used to accelerate dynamic WEB applications.

II. install memcached

First Download memcached, the latest version is 1.1.12, directly from the official website to download to the memcached-1.1.12.tar.gz. In addition, memcached used libevent and I downloaded the libevent-1.1a.tar.gz.

Next are the libevent-1.1a.tar.gz and memcached-1.1.12.tar.gz unwrapped packages, compilation, installation:

# Tar-xzf libevent-1.1a.tar.gz # cd libevent-1.1a #. /configure -- prefix =/usr # make install # cd .. # tar-xzf memcached-1.1.12.tar.gz # cd memcached-1.1.12 #. /configure -- prefix =/usr # make install

After the installation is complete, memcached should be in/usr/bin/memcached.

III. run the memcached daemon

Running the memcached daemon is simple. you only need one command line and no configuration file needs to be modified (and no configuration file is modified for you ):

/Usr/bin/memcached-d-m 128-l 192.168.1.1-p 11211-u httpd

Parameter description:

-D runs memcached in daemon mode;-m sets the memory size available for memcached, in MB;-l sets the IP address of the listener, if it is a local machine, this parameter can be left unspecified.-p is used to set the listening port. the default value is 11211, so this parameter can be left unspecified.-u specifies the user. if the current value is root, you need to use this parameter to specify the user.

Of course, there are other parameters that can be used. man memcached can be seen at a moment.

IV. how memcached works

First, memcached runs on one or more servers as a daemon and accepts client connection operations at any time. the client can be written in various languages, currently, known client APIs include Perl, PHP, Python, Ruby, Java, C #, and C. After the PHP client establishes a connection with the memcached service, the next thing is to access the object. each accessed object has a unique identifier key, and the access operation is performed through this key, objects saved to memcached are actually stored in the memory, not in the cache file. This is why memcached is so efficient and fast. Note that these objects are not persistent. after the service is stopped, the data in the objects will be lost.

III. how does PHP act as the memcached client?

You can use PHP as the memcached client to call the memcached service for object access.

First, PHP has an extension called memcache. during compilation in Linux, The-enable-memcache [= DIR] option must be included, and the Window is in php. remove the annotator in front of php_memcache.dll in ini to make it available.

In addition, there is also a way to avoid the trouble of extension and re-compilation, that is, directly using php-memcached-client.

The second method is used in this article. although the efficiency is slightly lower than that of the extended library, it is not a problem.

IV. PHP memcached application example

First download the memcached-client.php, after downloading the memcached-client.php, you can operate the memcached service through the class "memcached" in this file. In fact, code calls are very simple. The main methods used include add (), get (), replace (), and delete (). The methods are described as follows:

Add ($ key, $ val, $ exp = 0)
Write an object to memcached. $ key is the unique identifier of the object. $ val is the data of the written object. $ exp is the expiration time, in seconds. the default value is unlimited;

Get ($ key)
Get object data from memcached and get it through the unique identifier $ key of the object;

Replace ($ key, $ value, $ exp = 0)
Replace $ value with the content of the $ key object in memcached. the parameter works only when the $ key object exists like the add () method;

Delete ($ key, $ time = 0)
Delete an object with the identifier $ key in memcached. $ time is an optional parameter, indicating how long it will take before deletion.

The following is a simple test code that allows you to access the object data with the identifier 'MyKey:

// Contains the memcached class file
Require_once ('memcached-client. php ');
// Option settings
$ Options = array (
'Servers' => array ('192. 168.1.1: 100'), // address and port of the memcached service. multiple array elements can be used to represent multiple memcached services.
'Debug' => true, // whether to enable debug
'Compress _ threshold '=> 10240, // when the number of bytes of data exceeds
'Persistant' => false // whether to use persistent connection
);
// Create a memcached object instance
$ Mc = new memcached ($ options );
// Set the unique identifier used by this script
$ Key = 'MyKey ';
// Write an object to memcached
$ Mc-> add ($ key, 'some random string ');
$ Val = $ mc-> get ($ key );
Echo "n". str_pad ('$ mc-> add ()', 60, '_'). "n ";
Var_dump ($ val );
// Replace the written object data value
$ Mc-> replace ($ key, array ('some' => 'hahaha', 'array' => 'XXX '));
$ Val = $ mc-> get ($ key );
Echo "n". str_pad ('$ mc-> replace ()', 60, '_'). "n ";
Var_dump ($ val );
// Delete an object in memcached
$ Mc-> delete ($ key );
$ Val = $ mc-> get ($ key );
Echo "n". str_pad ('$ mc-> delete ()', 60, '_'). "n ";
Var_dump ($ val );
?>

Is it very easy? in actual applications, the database query result set is usually saved to memcached. The result set is obtained directly from memcached during the next visit, instead of performing database query operations, this can greatly reduce the burden on the database. Generally, the value after the md5 () of the SQL statement is used as the unique identifier key. Below is an example of using memcached to cache the database query result set (this code snippet is followed by the above sample code ):

 

$ SQL = 'select * FROM users ';
$ Key = md5 ($ SQL); // memcached object identifier
If (! ($ Datas = $ mc-> get ($ key ))){
// If no cached data is obtained in memcached, use database query to obtain the record set.
Echo "n". str_pad ('read datas from MySQL. ', 60,' _ '). "n ";
$ Conn = mysql_connect ('localhost', 'test', 'test ');
Mysql_select_db ('test ');
$ Result = mysql_query ($ SQL );
While ($ row = mysql_fetch_object ($ result ))
$ Datas [] = $ row;
// Save the result set data obtained from the database to memcached for the next access.
$ Mc-> add ($ key, $ datas );
} Else {
Echo "n". str_pad ('read datas from memcached. ', 60,' _ '). "n ";
}
Var_dump ($ datas );
?>

It can be seen that after memcached is used, the database connection and query operations can be reduced, the database load is reduced, and the script running speed is also improved.

I have previously written an article titled "PHP achieves multi-server sharing SESSION data". the SESSION in this article is saved in a database. when the concurrency traffic is high, the load on the server is very large and often exceeds the maximum number of connections in MySQL. using memcached, we can solve this problem well. The working principle is as follows:

When a user accesses the webpage, check whether the current user's SESSION data exists in memcached and use session_id () as the unique identifier. if the data exists, the system returns the result directly. if the data does not exist, the system connects to the database, obtain the SESSION data and save the data to memcached for the next use. when the current PHP operation ends (or session_write_close () is used), My_Sess: write () is called () method to write data to the database. in this way, database operations are still performed each time. optimization is also required for this method. Use a global variable to record the SESSION data when the user enters the page, and then compare the data with the SESSION data to be written in the write () method, different databases are connected and written to the database. at the same time, the corresponding objects in memcached are deleted. if they are the same, the SESSION data is not changed, so no operation can be performed and the data is returned directly; so how can we solve the user's SESSION expiration time? Do you remember that the add () method of memcached has an expiration time parameter $ exp? Set this parameter to a value smaller than the maximum SESSION survival time. In addition, do not forget to extend the SESSION duration for those users who have been online. this can be solved in the write () method. by judging the time, the database data will be updated if the conditions are met.