redis做mysql缓存服务器
清理环境
server1:
killall redis-server
若没有killall
yum install psmisc-22.20-11.el7.x86_64
[root@server1 ~]# cd rhel7/
[root@server1 rhel7]# yum install -y *
[root@server1 rhel7]# systemctl start php-fpm
[root@server1 rhel7]# netstat -anltp
[root@server1 html]# mv test.php index.php
[root@server1 html]# ls
index.php
[root@server1 html]# vim index.php
<?php
$redis = new Redis();
$redis->connect('172.25.24.2',6379) or die ("could net connect redis server");
# $query = "select * from test limit 9";
$query = "select * from test";
for ($key = 1; $key < 10; $key++)
{
if (!$redis->get($key))
{
$connect = mysql_connect('172.25.24.3','redis','redhat');
mysql_select_db(test);
$result = mysql_query($query);
//如果没有找到$key,就将该查询sql的结果缓存到redis
while ($row = mysql_fetch_assoc($result))
{
$redis->set($row['id'],$row['name']);
}
$myserver = 'mysql';
break;
}
else
{
$myserver = "redis";
$data[$key] = $redis->get($key