redis用作mysql的前端缓存

秒速五厘米 2022-01-30 03:25 199阅读 0赞

先关掉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

5.浏览器查看  
172.25.13.1

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#gearmand\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#