Apache PHP mairadb 分在3台服务器上

Apache PHP mairadb 分在3台服务器上

LAMP整体框架

Apache(192.168.6.6)

yum groupinstall "development tools"yum install pcre-devel openssl-devel expat-develtar xvf httpd-2.4.27.tar.gztar xf apr-1.6.2.tar.gz -C /app/httpd-2.4.27/srclib/tar xf apr-util-1.6.0.tar.gz -C /app/httpd-2.4.27/srclib/cd /app/httpd-2.4.27/srclib/mv apr-1.6.2/ aprmv apr-util-1.6.0/ apr-utilcd .../configure --prefix=/app/httpd24 \--enable-so --enable-ssl \--enable-cgi \--enable-rewrite \--with-zlib --with-pcre \--with-included-apr \--enable-modules=most \--enable-mpms-shared=all \--with-mpm=prefork \--enable-proxy \--enable-proxy-fcgimake && make install

php(192.168.6.16)

yum -y install bzip2-devel libmcrypt-devel libxml2-devel openssl-devel# libmcrypt-devel需要epel源yum groupinstall "development tools"./configure --prefix=/app/php \--enable-fpm \--with-config-file-scan-dir=/etc/php.d \--with-libxml-dir=/usr --with-openssl  \--with-zlib --with-bz2 \--with-jpeg-dir --with-png-dir \--with-freetype-dir --enable-mbstring \--with-mcrypt --enable-sockets --with-mysql=mysqlnd \--with-mysqli=mysqlnd --with-pdo-mysql=mysqlnd注意：--with-mysql几个选项都要为mysqlnd；因为mysql服务器单独为另一台机器make && make installcp php.ini-production /etc/php.inicp sapi/fpm/init.d.php-fpm /etc/rc.d/init.d/php-fpmchmod +x /etc/rc.d/init.d/php-fpmchkconfig --add php-fpmchkconfig php-fpm onchkconfig --list php-fpmcd /app/php/etccp cp php-fpm.conf.default php-fpm.confvi php-fpm.conf[global]; Pid file; Note: the default prefix is /usr/local/php/var; Default Value: nonepid = run/php-fpm.pid #这项启用；下面几项对应的改为相应的值即可;pm.max_children = 50; The number of child processes created on startup.; Note: Used only when pm is set to 'dynamic'service php-fpm startss -tunl | grep 9000

整合PHP和Apache

vi /usr/local/php/etc/php-fpm.conf定位到listen；IP地址更改为别人可用访问进来的IP地址listen = 192.168.6.16:9000service php-fpm restartss -tnul | grep 9000tcp    LISTEN    0      128        172.16.251.87:9000#建立几个目录作为虚拟主机目录到Apache主机上；找一个目录下面建立几个不同的目录作为虚拟主机目录；vi /app/httpd24/conf/httpd.conf# Virtual hostsInclude /etc/httpd24/extra/httpd-vhosts.conf #开启这项最后加上AddType application/x-httpd-php .phpAddType application/x-httpd-php-source .phps定位至DirectoryIndexDirectoryIndex index.php index.html #添加index.php定位到LoadModuleLoadModule proxy_module modules/mod_proxy.so #开启#LoadModule proxy_connect_module modules/mod_proxy_connect.so#LoadModule proxy_ftp_module modules/mod_proxy_ftp.so#LoadModule proxy_http_module modules/mod_proxy_http.soLoadModule proxy_fcgi_module modules/mod_proxy_fcgi.so #开启vi /etc/httpd24/extra/httpd-vhosts.conf  编辑虚拟主机<VirtualHost *:80>    ServerAdmin [e-mail]    DocumentRoot "/app/web1/"    ServerName www.a.com    ErrorLog "logs/dummy-host.example.com-error_log"    CustomLog "logs/dummy-host.example.com-access_log" common    ProxyRequests Off #关闭正向代理    ProxyPassMatch ^/(.*\.php)$ fcgi://172.18.253.66:9000/app/php/web1/$1 #转到php服务器/app/php/web1目录    <Directory /app/web1>        Options none        AllowOverride none        Require all granted    </Directory></VirtualHost><VirtualHost *:80>    ServerAdmin [e-mail]    DocumentRoot "/app/web2/"    ServerName www.b.com    ErrorLog "logs/dummy-host2.example.com-error_log"    CustomLog "logs/dummy-host2.example.com-access_log" common    ProxyRequests Off #关闭正向代理    ProxyPassMatch ^/(.*\.php)$ fcgi://172.18.253.66:9000/app/php/web2/$1 #转到php服务器/app/php/web2目录    <Directory /app/web2>        Options none        AllowOverride none        Require all granted    </Directory></VirtualHost>

mariadb二进制安装(192.168.6.17)

创建逻辑卷createpv /dev/sdb /dev/sdccreatevg vg0 /dev/sdb /dev/sdccreatelv -n lv-mysql -L 100G vg0mkfs.ext4 /dev/vg0/lv-mysqlmkdir /app/mydatamount /dev/vg0/lv-mysql /app/mydata安装数据库tar xvf mariadb-5.5.57-linux-x86_64.tar.gz -C /usr/local/cd /usr/local/ln -sv mariadb-5.5.57-linux-x86_64/ mysqlcd mysql/useradd -r -s /sbin/nologin mysqlchown mysql /app/mydatascripts/mysql_install_db --datadir=/app/mydata/ --user=mysqlmkdir /etc/mysqlcp support-files/my-large.cnf /etc/mysql/my.cnfvi /etc/mysql/my.cnf[mysqld] #加一行datadir         = /app/mydatacp support-files/mysql.server /etc/init.d/mysqld#添加环境变量vi /etc/profile.d/mysql.shPATH=/usr/local/mysql/bin:$PATH. /etc/profile.d/mysql.sh#开机自启动chkconfig --add mysqldchkconfig mysqld onchkconfig --list mysqld#添加man手册vi /etc/man.configMANPATH /usr/local/mysql/man #添加一行mkdir /var/log/mariadbchown mysql /var/log/mariadb/service mysqld start#下面的较为重要；这是授权PHP主机可以访问的mysql> grant all privileges on *.* to 'root'@'192.168.6.17' identified by '123456';

WordPress安装配置

在Apache和php主机对应的目录下下载WordPress软件包并解压

在数据库服务器上创建用户名、密码、数据库

create database wpdb;grant all on wpdb.* to root@"192.168.6.16" identified by '123456';

然后访问博客目录，看是否成功。
涉及到访问数据库、PHP服务器时授权访问用户权限时要授权直接访问mysql服务器的用户，我们这个是PHP服务器