![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461961392.webp)
Developing a
memcached
Application
1372
import sys
import MySQLdb
import memcache
memc = memcache.Client(['127.0.0.1:11211'], debug=1);
try:
conn = MySQLdb.connect (host = "localhost",
user = "sakila",
passwd = "password",
db = "sakila")
except MySQLdb.Error, e:
print "Error %d: %s" % (e.args[0], e.args[1])
sys.exit (1)
popularfilms = memc.get('top5films')
if not popularfilms:
cursor = conn.cursor()
cursor.execute('select film_id,title from film order by rental_rate desc limit 5')
rows = cursor.fetchall()
memc.set('top5films',rows,60)
print "Updated memcached with MySQL data"
else:
print "Loaded data from memcached"
for row in popularfilms:
print "%s, %s" % (row[0], row[1])
When executed for the first time, the data is loaded from the MySQL database and stored to the
memcached
server.
shell> python memc_python.py
Updated memcached with MySQL data
Because the data is automatically serialized using
cPickle
/
pickle
, when you load the data back
from
memcached
, you can use the object directly. In the example above, the information stored to
memcached
is in the form of rows from a Python DB cursor. When accessing the information (within
the 60 second expiry time), the data is loaded from
memcached
and dumped:
shell> python memc_python.py
Loaded data from memcached
2, ACE GOLDFINGER
7, AIRPLANE SIERRA
8, AIRPORT POLLOCK
10, ALADDIN CALENDAR
13, ALI FOREVER
The serialization and deserialization happens automatically. Because serialization of Python data may
be incompatible with other interfaces and languages, you can change the serialization module used
during initialization. For example, you might use JSON format when you store complex data structures
using a script written in one language, and access them in a script written in a different language.
15.6.3.6. Using MySQL and
memcached
with PHP
PHP provides support for the Memcache functions through a PECL extension. To enable the PHP
memcache
extensions, build PHP using the
--enable-memcache
option to
configure
when
building from source.
If you are installing on a Red Hat-based server, you can install the
php-pecl-memcache
RPM:
root-shell> yum --install php-pecl-memcache
On Debian-based distributions, use the
php-memcache
package.
To set global runtime configuration options, specify the configuration option values within your
php.ini
file. The following table provides the name, default value, and a description for each global
runtime configuration option.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...