CentOS 配置 mysql+redis

前言

有一个大数据库需要写，想用redis在中间做缓存，第一次配置记录一下。

环境：CenOS 7

mysql 配置

cat /etc/redhat-release 

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

rpm -ivh mysql-community-release-el7-5.noarch.rpm

yum install mysql-community-server

systemctl start  mysqld.service

防火墙

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --zone=public --add-port=8080/tcp --permanent
firewall-cmd --reload

sudo nano /etc/my.cnf

在mysqld中添加默认字符编码

[mysqld]
character_set_server=utf8
init-connect=‘SET NAMES utf8’

systemctl daemon-reload

mysql中设置

mysql -uroot

开启外网主机访问数据库权限

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '$PASSWORD' WITH GRANT OPTION;

mysql>SHOW VARIABLES LIKE 'character%';

设置开机启动

shell> systemctl enable mysqld
shell> systemctl daemon-reload

redis配置

下载

http://download.redis.io/releases/

安装gcc 并升级

yum install cpp
yum install binutils
yum install glibc
yum install glibc-kernheaders
yum install glibc-common
yum install glibc-devel
yum install gcc
yum install make

yum -y install centos-release-scl
yum -y install devtoolset-9-gcc devtoolset-9-gcc-c++ devtoolset-9-binutils
scl enable devtoolset-9 bash

设置永久升级：

echo “source /opt/rh/devtoolset-9/enable” >>/etc/profile

安装redis

make
make install PREFIX=/usr/local/redis

###设置启动服务

前台启动

cd /usr/local/redis/bin/
./redis-server

后台启动

从 redis 的源码目录中复制 redis.conf 到 redis 的安装目录

cp /usr/local/redis-6.0.9/redis.conf /usr/local/redis/bin/

修改 redis.conf 文件，把 daemonize no 改为 daemonize yes
bind 127.0.0.1 修改为 0.0.0.0

./redis-server redis.conf

开机自启动

vi /etc/systemd/system/redis.service

Description=redis-server
After=network.target

[Service]
Type=forking
ExecStart=/usr/local/redis/bin/redis-server /usr/local/redis/bin/redis.conf
PrivateTmp=true

[Install]
WantedBy=multi-user.target

设置开机自启动

systemctl daemon-reload

systemctl start redis.service

systemctl enable redis.service

创建 redis 命令软链接

[root@localhost ~]# ln -s /usr/local/redis/bin/redis-cli /usr/bin/redis

---

防火墙

firewall-cmd --zone=public --add-port=6379/tcp --permanent

服务操作命令

systemctl start redis.service   #启动redis服务

systemctl stop redis.service   #停止redis服务

systemctl restart redis.service   #重新启动服务

systemctl status redis.service   #查看服务当前状态

systemctl enable redis.service   #设置开机自启动

systemctl disable redis.service   #停止开机自启动