redis用作mysql的前端缓存

最新推荐文章于 2024-01-23 18:45:00 发布

原创最新推荐文章于 2024-01-23 18:45:00 发布 · 347 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#redis #mysql缓存

Linux企业部分专栏收录该内容

45 篇文章

订阅专栏

博客主要记录了信息技术相关的安装配置过程。先关闭redis-server服务并杀掉进程，接着在server1进行nginx解压、配置等操作，安装PHP相关软件并开启服务；在server2修改redis配置文件并开启服务；server1修改php页面并重新加载Nginx配置；server3安装mariadb - server并进行初始化、建库授权等操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

先关掉redis-server服务

yum whatprovides killall
yum install -y psmisc-22.20-11.el7.x86_64

查看进程

ps ax

杀掉redis-server进程

killall -9 redis-server

再次查看

ps ax

server1：

1.解压nginx

tar zxf nginx-1.16.0.tar.gz

2.解决依赖性

 yum install -y gcc pcre-devel zlib-devel

3.配置

cd nginx-1.16.0/
./configure --prefix=/usr/local/nginx --with-threads --with-file-aio

4.make && make install

cd nginx-1.16.0/
make && make install

5.修改配置文件，使其不debug

vim auto/cc/gcc
=================
171 # debug
172 #CFLAGS="$CFLAGS -g"

6.更改Nginx配置文件

cd /usr/local/nginx/
vim conf/nginx.conf
=====================
  2 user  nginx nginx;
  3 worker_processes  auto;

==========================
 43         location / {
 44             root   html;
 45             index  index.php index.html index.htm;
 46         }
=======================================
 65         location ~ \.php$ {
 66             root           html;
 67             fastcgi_pass   127.0.0.1:9000;
 68             fastcgi_index  index.php;
 69            # fastcgi_param  SCRIPT_FILENAME  /scripts$fastcgi_script_name;
 70             include        fastcgi.conf;
 71         }

7.添加Nginx用户

useradd nginx

8.查看Nginx版本及语法

sbin/nginx -V
sbin/nginx -t

9.安装PHP相关软件及依赖

cd rhel7/
ot@server1 rhel7]# ls
gearmand-1.1.12-18.el7.x86_64.rpm
libevent-devel-2.0.21-4.el7.x86_64.rpm
libgearman-1.1.12-18.el7.x86_64.rpm
libgearman-devel-1.1.12-18.el7.x86_64.rpm
libzip-0.10.1-8.el7.x86_64.rpm
openssl-1.0.2k-16.el7.x86_64.rpm
openssl-libs-1.0.2k-16.el7.x86_64.rpm
php-cli-5.4.16-46.el7.x86_64.rpm
php-common-5.4.16-46.el7.x86_64.rpm
php-fpm-5.4.16-46.el7.x86_64.rpm
php-mysql-5.4.16-46.el7.x86_64.rpm
php-pdo-5.4.16-46.el7.x86_64.rpm
php-pecl-gearman-1.1.2-1.el7.x86_64.rpm
php-pecl-igbinary-1.2.1-1.el7.x86_64.rpm
php-pecl-redis-2.2.8-1.el7.x86_64.rpm
php-process-5.4.16-46.el7.x86_64.rpm
php-xml-5.4.16-46.el7.x86_64.rpm
[root@server1 rhel7]# 
========================================
yum install -y *

10.开启PHP服务

systemctl start php-fpm.service

11.查看端口

yum install -y net-tools
netstat -antpule

server2:

1.修改redis配置文件
#删除主从配置项

2.开启redis服务

/etc/init.d/redis_6379 start

server1：
1.修改php页面

cd /usr/local/nginx/html
lftp 172.25.13.250
mv test.php index.php
vim index.php
============================================================
  3         $redis->connect('172.25.13.2',6379) or die ("could net connect redis     server");

 10                         $connect = mysql_connect('172.25.13.3','redis','redh    at');

============================================================

2.重新加载Nginx配置文件

nginx -s reload

server3：

1.安装mariadb-server

 yum install -y mariadb-server

2.开启服务，安全初始化

systemctl start mariadb

mysql_secure_installation

3.新建库，并对redis用户授权

mysql -p
MariaDB [test]>CREATE DATABASE test;
MariaDB [test]> GRANT ALL ON test.* to redis@'%' identified by 'redhat';
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

4.导入测试库

lftp 172.25.13.250
vim test.sql
====================
CREATE DATABASE test;
use test;
CREATE TABLE `test` (`id` int(7) NOT NULL AUTO_INCREMENT, `name` char(8) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `test` VALUES (1,'test1'),(2,'test2'),(3,'test3'),(4,'test4'),(5,'test5'),(6,'test6'),(7,'test7'),(8,'test8'),(9,'test9');

#DELIMITER $$
#CREATE TRIGGER datatoredis AFTER UPDATE ON test FOR EACH ROW BEGIN
#    SET @RECV=gman_do_background('syncToRedis', json_object(NEW.id as `id`, NEW.name as `name`));
#  END$$
#DELIMITER ;
============================================================
mysql -predhat < test.sql