Linux下Memcache服务搭建

yum -y install httpd php php-mysql mysql-server

      /etc/init.d/httpd start

      echo "<?php phpinfo()?>" > /var/www/html/index.php

  tar xf libevent-2.0.22-stable.tar.gz

  cd libevent-2.0.22-stable

     ./configure --prefix=/usr/local/libevent && make && make install

  tar xf memcached-1.4.36.tar.gz

  cd memcached-1.4.36

  ./configure --prefix=/usr/local/memcached --with-libevent=/usr/local/libevent/

  make && make install 

  cd  /etc/profile.d/ 

  vim mem.sh

  export PATH="/usr/local/memcached/bin:$PATH"  #写入 profile 文件开机自动导入 

  memcached -m 32 -p 11211 -d -c 8192 -u root   #m 分出内存大小 p 端口 d 混合模式 c 最大连接数 

  netstat -anptu | grep memcached        #查看是否启动，运行多实例更改端口即可 

  free -m                      #可以看到内存越来越少，因为被分配出去了

  ps -aux | grep memcached            #查看进程 pid 是多少 

  kill -9 1234                   # 关闭 memcached 服务 

   pkill memcached                  # 同上 

   printf "set first 0 30 5\r\nmmmmm\r\n" | nc 127.0.0.1 11211   #存数据（字段分别为 key，标志，效期，长度，值）

  printf "get first\r\n" | nc 127.0.0.1 11211            # 取数据 

  telnet 127.0.0.1 11211    # 然后就可以使用相关的 memcached 命令了 

  yum -y install php-devel

  tar xf memcache-2.2.7.tgz

  cd memcache-2.2.7

  phpize          #打模块，生成 configure 等文件 

  which php-config      # 查看 php-config 路径位置 

  ./configure --enable-memcache --with-php-config=/usr/bin/php-config

  make && make install 

  cd /etc/php.d/

  cp mysql.ini memcache.ini  #vim 进行编辑将 extension 的值设置成 memcache.so

  tar xf memcache_page.tar.gz -C /var/www/html/

  cd !$

  /etc/init.d/mysqld  start

  mysql_secure_installation 

  grant all on *.* to 'root'@'127.0.0.1' identified by '123456'

  flush privileges

<?php
$memcachehost = '192.168.1.113';
$memcacheport = 11211;
$memcachelife = 60;          #memcache 默认有效期 
$memcache = new Memcache;
$memcache->connect($memcachehost,$memcacheport) or die ("Could not connect");  # 连接 memcache 服务器 
$num=$_POST["num"];
$db=db1;
$tb=T1;
$query="select * from $tb where ID=$num";  #mysql 查询语句 
#$key=md5($query);
$key=md5($num);                  # 对参数进行加密，可以看出 memcache 存储的值是进过加密的 
if(!$memcache->get($key))            # 尝试先从 memcache 取值，如果没有去数据库取，顺便给 memcache 来一份 
{$conn=mysql_connect("127.0.0.1","root","123456");
                mysql_select_db($db);
                $result=mysql_query($query);
#       echo "mysql $num";
                while ($row=mysql_fetch_assoc($result))
                {$arr[]=$row;
                }
                $f = 'mysql';
                $memcache->add($key,serialize($arr),0,30);
                $data = $arr ;
}
else{$f = 'memcache';
        $data_mem=$memcache->get($key);
        $data = unserialize($data_mem);
}
echo "$f $num";
echo "key is $key";
echo "<br>";
?> 

<?php
$memcachehost = '192.168.1.113';
$memcacheport = 11211;
$memcachelife = 60;
$memcache = new Memcache;
$memcache->connect($memcachehost,$memcacheport) or die ("Could not connect");
$num=$_POST["num"];
$db=db1;
$tb=T1;
$query="insert into $tb values($num)";
#$key=md5($query);
$key=md5($num);
if(!$memcache->get($key))            // 先尝试更新 memcache，如果不存在，则再去更新数据库，同时更新存储到 memcachce
{$conn=mysql_connect("127.0.0.1","root","123456");
                mysql_select_db($db);
                $result=mysql_query($query);

                while ($row=mysql_fetch_assoc($result))
                {$arr[]=$row;
                }
                $f = 'mysql';
                $memcache->add($key,serialize($arr),0,30);        //mysql 插入成功后，插入 memcached
                $data = $arr ;
#}
#else{
        $f1 = 'memcache';
        $data_mem=$memcache->get($key);
        $data = unserialize($data_mem);
}
echo "$f $f1 $num";
echo "<br>";
?>

seq 1 999 > /tmp/sum  #创建 1 -999 的测试数据 

create database db1; create T1(id int)engine=innodb;

  load data infile '/tmp/sum' into table T1;  #导入测试数据 

！111