实现Redis缓存Mysql数据库

安装LNMP环境

之前文章有不在赘述

#### 配置Nginx连接PHP

 1. Nginx连接PHP需要先启动PHP-FPM服务
 

```bash
cd /usr/local/php/etc/
cp -a php-fpm.conf.default php-fpm.conf
vim php-fpm.conf
取消这行的注释
pid = run/php-fpm.pid
cd /usr/local/php/etc/php-fpm.d/
mv www.conf.default www.conf
vim www.conf
修改启动服务用户和所属组
User=nginx
group=nginx

ps: 修改配置nginx配置文件以支持机械*.php
vim /usr/local/nginx/conf/nginx.conf
取消 location ~ \.php$字段下的所有注释
修改include fastcgi_params;
include fastcgi_params; ==> include fastcgi.conf;
修改local \ 中主页访问优先级
location / {
root html; 
index index.php index.html; 
}

重启nginx服务
nginx -s reload
启动php-fpm
php-fpm
netstat -anpt查看80和9000端口是否打开
编写测试index.php文件写入/usr/local/nginx/html/index.php

测试结果:

安装Redis连接Mysql的工具

unzip phpredis-master.zip
cd phpredis-master
phpize
./configure --with-php-config=/usr/bin/php-config
make && make install
vim /usr/local/php/etc/php.ini
extension=redis.so
# 开启支持redis模块
php-fpm restart

• 开启redis编写连接脚本

vim /usr/local/nginx/html/test.php
<?php
		ini_set("display_errors", "On");
		error_reporting(E_ALL | E_STRICT);
		//开启debug 
	
	
		// mysql 库: mytest 表：test 
        $redis = new redis();
        $redis->connect('127.0.0.1',6379);
        $query = "select * from test limit 5";
        for ($key=1;$key<=5;$key++)
        {
                if (!$redis->get($key))
				//判断redis中是否有1 2 3 4 5 的键，没有连接数据库查询mytest库的test表，然后插入到redis中
                {
                        $connect = mysql_connect('127.0.0.1','root','123456');
                        mysql_select_db(mytest);
                        $result = mysql_query($query);
						var_dump ($result);
                        while ($row = mysql_fetch_assoc($result))
                        {
                                $redis->setex($row['id'],30,$row['name']);
								//从MySQL中获取的资源插入到redis中，并设置有效时间为30s
                        }
                        $myserver = 'mysql';
                        break;
                }
                else
				//判断redis中是否有1 2 3 4 5 的键，有直接打印redis中的 1 2 3 4 5 键的值。
                {
                        $myserver = "redis";
                        $data[$key] = $redis->get($key);
                }
        }
                        echo $myserver;
                        echo "<br>";
                        for ($key=1;$key<=5;$key++)
                        {
                                echo "number is <b><font color=#FF0000>$key</font></b>";
                                echo "<br>";
                                echo "name is <b><font color=#FF0000>$data[$key]</font></b>";
                                echo "<br>";
                        }
?>