教你使用MySQL触发器自动更新memcache

曾经终败给现在 2022-08-12 16:04 258阅读 0赞

原贴:http://www.devdao.com/Article/440369.htm  
  
**教你使用MySQL触发器自动更新memcache**  
  
文章类别：[MySQL教程][MySQL] | 发表日期：2008-8-18  
<script src="http://img.knowsky.com/img/wangzhai/wangzhai.js"></script> ![添加到QQ书签][QQ] ![雅虎收藏][yahoomyweb-cn.png] ![添加到百度搜藏][baidu.gif] ![有道书签][yodao.gif] ![添加到Google书签][Google] ![添加到新浪ViVi][ViVi] ![添加到奇客发现][diglog.gif] ![添加到和讯网摘][hexun.gif] ![添加到博拉网][bolaa.gif] ![添加到挖客][waakee_s.gif] ![LiveBookmarks][] ![YahooBuzz][] ![Twitter][] ![Mister-wong][] ![Del.icio.us][] ![Myspace][] ![Facebook][] ![Ask][] ![StumbleUpon][] ![Digg][] ![Reddit][] ![Spurl][] ![BlinkList][]

--------------------

安装步骤

安装memcached,这个步骤很简单，随处可见

安装mysql server 5.1RC，安装办法也很大众，不废话了

编译libmemcached，解压后安装即可./configure; make; make install

编译Memcached Functions for MySQL，在[http://download.tangent.org/][http_download.tangent.org]找一个最新的版本下载就是，./configure --with-mysql=/usr/local/mysql/bin/mysql\_config --libdir=/usr/local/mysql/lib/mysql/

make

make install

接下来有两个办法让Memcached Functions for MySQL在mysql中生效

在mysql的shell中执行memcached\_functions\_mysql源码目录下的sql/install\_functions.sql，这会把memcache function作为UDF加入mysql

运行memcached\_functions\_mysql源码目录下的utils/install.pl，这是一个perl脚本，作用同上一条

测试memcache function

以下测试脚本摘自memcached\_functions\_mysql的源码目录，有兴趣可以试试

PLAIN TEXTCODE: drop table if exists urls;

create table urls (

id int(3) not null,

url varchar(64) not null default '',

primary key (id)

);

select memc\_servers\_set('localhost:11211');

select memc\_set('urls:sequence', 0);

DELIMITER |

DROP TRIGGER IF EXISTS url\_mem\_insert;

CREATE TRIGGER url\_mem\_insert

BEFORE INSERT ON urls

FOR EACH ROW BEGIN

SET NEW.id= memc\_increment('urls:sequence');

SET @mm= memc\_set(concat('urls:',NEW.id), NEW.url);

END |

DELIMITER ;

insert into urls (url) values ('http://google.com');

insert into urls (url) values ('http://www.ooso.net/index.php');

insert into urls (url) values ('http://www.devdao.net/');

insert into urls (url) values ('http://slashdot.org');

insert into urls (url) values ('http://mysql.com');

select \* from urls;

select memc\_get('urls:1');

select memc\_get('urls:2');

select memc\_get('urls:3');

select memc\_get('urls:4');

select memc\_get('urls:5');

[MySQL]: http://www.devdao.com/class.asp?id=172
[QQ]: http://img.knowsky.com/img/wangzhai/qq.gif
[yahoomyweb-cn.png]: http://img.knowsky.com/img/wangzhai/yahoomyweb-cn.png
[baidu.gif]: http://img.knowsky.com/img/wangzhai/baidu.gif
[yodao.gif]: http://img.knowsky.com/img/wangzhai/yodao.gif
[Google]: http://img.knowsky.com/img/wangzhai/goog.png
[ViVi]: http://img.knowsky.com/img/wangzhai/vivi.gif
[diglog.gif]: http://img.knowsky.com/img/wangzhai/diglog.gif
[hexun.gif]: http://img.knowsky.com/img/wangzhai/hexun.gif
[bolaa.gif]: http://img.knowsky.com/img/wangzhai/bolaa.gif
[waakee_s.gif]: http://img.knowsky.com/img/wangzhai/waakee_s.gif
[LiveBookmarks]: http://img.knowsky.com/img/wangzhai/live.gif
[YahooBuzz]: http://img.knowsky.com/img/wangzhai/buzz.gif
[Twitter]: http://img.knowsky.com/img/wangzhai/twitter.gif
[Mister-wong]: http://img.knowsky.com/img/wangzhai/mister-wong-cn.jpg
[Del.icio.us]: http://img.knowsky.com/img/wangzhai/delicious.gif
[Myspace]: http://img.knowsky.com/img/wangzhai/myspace.png
[Facebook]: http://img.knowsky.com/img/wangzhai/facebook.gif
[Ask]: http://img.knowsky.com/img/wangzhai/ask.png
[StumbleUpon]: http://img.knowsky.com/img/wangzhai/su.png
[Digg]: http://img.knowsky.com/img/wangzhai/digg.png
[Reddit]: http://img.knowsky.com/img/wangzhai/reddit.png
[Spurl]: http://img.knowsky.com/img/wangzhai/spurl.png
[BlinkList]: http://img.knowsky.com/img/wangzhai/blinklist.gif
[alimamal.php_i_mm_10013700_995407_4308947_u_http_3A_2F_2Fwww.devdao.com_2FArticle_2F440369.htm_w_250_h_250_re_1280x800_sz_34_r_http_3A_2F_2Fwww.google.cn_2Fsearch_3Fhl_3Dzh-CN_26q_3Dmemcached_2B_25E6_259B_25B4_25E6_2596_25B0_25E6_2595_25B0_25E6_258D_25AE_26btnG_3DGoogle_2B_25E6_2590_259C_25E7_25B4_25A2_26meta_3D_26aq_3D0_26oq_3D_cg_a15317c411a13afa5b1f1c2164515fc8_prm_82804306_cas_prm_cah_800_caw_1280_ccd_24_ctz_8_chl_1_cpl_0_cmm_0_cf_-1_sx_492_sy_364_cbw_1263_cbh_608]: http://z.alimama.com/alimamal.php?i=mm_10013700_995407_4308947&u=http%3A%2F%2Fwww.devdao.com%2FArticle%2F440369.htm&w=250&h=250&re=1280x800&sz=34&r=http%3A%2F%2Fwww.google.cn%2Fsearch%3Fhl%3Dzh-CN%26q%3Dmemcached%2B%25E6%259B%25B4%25E6%2596%25B0%25E6%2595%25B0%25E6%258D%25AE%26btnG%3DGoogle%2B%25E6%2590%259C%25E7%25B4%25A2%26meta%3D%26aq%3D0%26oq%3D&cg=a15317c411a13afa5b1f1c2164515fc8&prm=82804306&cas=prm&cah=800&caw=1280&ccd=24&ctz=8&chl=1&cpl=0&cmm=0&cf=-1&sx=492&sy=364&cbw=1263&cbh=608
[http_download.tangent.org]: http://download.tangent.org/