Nginx代理+PHPMyadmin+Mysql+redis

PhpMyAdmin 是一个基于PHP的MySQL管理平台PhpMyAdmin 默认存放Session在本地目录,也可以由PHP-FPM服务指定存放Session的信息到Redis服务器中

环境说明

#nginx代理1台

10.0.0.160

​

#LNP（PhpMyadmin）两台

10.0.0.161

10.0.0.162

​

#Mysql服务器1台

10.0.0.150

​

#Redis服务器1台

10.0.0.151

Mysql以及Redis部署

---

#mysql这里我采用二进制安装，用脚本安装，此处步骤省略

[root@mysql ~]#bash install_mysql5.7or8.0.sh

开始安装MySQL数据库...

安装相关包完成! [ OK ]

创建mysql用户 [ OK ]

数据库安装完成 [ OK ]

​

[root@mysql ~]#systemctl status mysql

● mysqld.service - LSB: start and stop MySQL

Loaded: loaded (/etc/rc.d/init.d/mysqld; generated)

Active: active (running) since Sat 2022-12-0314:40:21 CST; 9min ago

Docs: man:systemd-sysv-generator(8)

Process: 2025ExecStart=/etc/rc.d/init.d/mysqld start(code=exited, status=0/S>

Tasks: 40 (limit: 11175)

​

​

#创建用户并授权，用于后续phpmyadmin连接

mysql> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

​

Database changed

mysql> create user admin@'10.0.0.%' identified by '123456';

Query OK, 0 rows affected (0.00 sec)

​

mysql> grant all on *.* to admin@'10.0.0.%';

Query OK, 0 rows affected (0.01 sec)

​

#redis部署，这里采用包安装方式

[root@redis ~]#yum install redis

Last metadata expiration check: 0:41:37 ago on Sat 03 Dec 202202:06:58 PM CST.

Dependencies resolved.

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

Package Arch Version Repository Size

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

Installing:

redis x86_64 5.0.3-5.module+el8.5.0+657+2674830e AppStream 926 k

Enabling module streams:

redis 5

​

Transaction Summary

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

Install 1 Package

​

Total download size: 926 k

Installed size: 3.2 M

Is this ok [y/N]:

编译安装php7.4和php-Redis模块

---

#创建账号

[root@ubuntu2004 ~]#groupadd -g 80 www && useradd -u 80 -g www www

​

#安装依赖包

[root@ubuntu2004 ~]#apt install gcc make autoconf libpcre3 libpcre3-dev openssl libssl-dev zlib1g-dev libxml2-dev pkg-config libsqlite3-dev libtool

​

#分别在两台web服务器编译php，编译php前需先编译oniguruma，注意编译尽可能调大内存以及CPU，以免出现om报错无法编译下去，至少4G

#下载oniguruma，也可下载上传到服务器解压进行编译

[root@ubuntu2004 ~]#wget -O oniguruma-6.9.4.tar.gz

https://github.com/kkos/oniguruma/archive/refs/tags/v6.9.4.tar.gz

​

[root@ubuntu2004 ~]#cd oniguruma-6.9.4/

[root@ubuntu2004 oniguruma-6.9.4]#ls

AUTHORS COPYING m4 oniguruma.pc.in

autogen.sh depcomp Makefile.am README

ChangeLog doc make_win32.bat README_japanese

cmake harnesses make_win64.bat README.md

CMakeLists.txt HISTORY make_win.bat sample

compile index.html missing src

config.guess index_ja.html NEWS test

config.sub INSTALL onig-config.in test-driver

configure.ac install-sh oniguruma.pc.cmake.in windows

​

[root@ubuntu2004 oniguruma-6.9.4]#./autogen.sh

Generating autotools files.

libtoolize: putting auxiliary files in'.'.

libtoolize: copying file './ltmain.sh'

libtoolize: putting macros in AC_CONFIG_MACRO_DIRS, 'm4'.

libtoolize: copying file 'm4/libtool.m4'

libtoolize: copying file 'm4/ltoptions.m4'

libtoolize: copying file 'm4/ltsugar.m4'

libtoolize: copying file 'm4/ltversion.m4'

libtoolize: copying file 'm4/lt~obsolete.m4'

configure.ac:44: installing './compile'

configure.ac:6: installing './missing'

sample/Makefile.am: installing './depcomp'

​

Run ./configure, make, and make install.

​

[root@ubuntu2004 oniguruma-6.9.4]#ls

aclocal.m4 config.sub index_ja.html make_win.bat sample

AUTHORS configure INSTALL missing src

autogen.sh configure.ac install-sh NEWS test

autom4te.cache COPYING ltmain.sh onig-config.in test-driver

ChangeLog depcomp m4 oniguruma.pc.cmake.in windows

cmake doc Makefile.am oniguruma.pc.in

CMakeLists.txt harnesses Makefile.in README

compile HISTORY make_win32.bat README_japanese

config.guess index.html make_win64.bat README.md

​

[root@ubuntu2004 oniguruma-6.9.4]#./configure

​

[root@ubuntu2004 oniguruma-6.9.4]#make && make install

​

#编译php7.4

#先下载二进制源码包

[root@ubuntu2004 ~]#wget https://www.php.net/distributions/php-7.4.30.tar.gz