yum安装lamp及Xcache加速

LAMP的搭建：

使用两台虚拟机，一台虚拟机安装httpd及php，把php作为模块编译进httpd中，另一台安装mysql，让php能调用mysql来读取数据。

虚拟机1：172.18.250.76 Centos6.7 安装httpd、php

虚拟机2：172.18.250.10 Centos6.7 安装mysql

利用httpd创建两基于域名的虚拟主机，分别运行wordpress博客和phpmyadmin数据库。

一：yum安装httpd

[root@localhost ~]# yum -y install httpd

1、编辑配置文件，注释DocumentRoot

[root@localhost ~]# vim /etc/httpd/conf/httpd.conf#DocumentRoot "/var/www/html"

2、创建虚拟主机文件，编辑文件

[root@localhost php]# vim /etc/httpd/conf.d/vhost.confNameVirtualHost 172.18.250.76:80   ServerName www.a.com   DocumentRoot "/www/blog"      Options None   Allowoverride None   Order allow,deny   allow from all      ServerName www.b.net   DocumentRoot "/www/php"      Options None   Allowoverride None   Order allow,deny   allow from all   

3、启动httpd服务，查看监听端口

[root@localhost php]# netstat -ntlpActive Internet connections (only servers)Proto Recv-Q Send-Q Local Address       Foreign Address     State     PID/Program name   tcp       0     0    :::80                   :::*           LISTEN      2201/httpd

4、创建虚拟主机路径，并验证能否正常访问

[root@localhost conf.d]# mkdir -p /www/blog[root@localhost conf.d]# mkdir -p /www/php[root@localhost conf.d]# cd /www/php[root@localhost php]# echo "[root@localhost conf.d]# cd /www/blog[root@localhost blog]# echo "www.a.com">index.html

重启httpd服务，验证：

二、yum安装php

[root@localhost php]# yum -y install php[root@localhost php]# httpd -M    //查看httpd所加载的模块 php5_module (shared)             //php已经编辑进httpd

验证php能否正常加载：

[root@localhost php.d]# vim /www/blog/index.php 

三、安装mysql

[root@lsj ~]# yum -y install mysql-server[root@lsj ~]# service mysqld start

授权一个远程账号，让PHP能访问mysql

mysql> grant all on *.* to admin@'172.18.250.76' identified by "admin";

安装mysql驱动，支持php远程

[root@localhost modules]# yum -y install php-mysql[root@localhost modules]# vim /www/blog/index.php  

四、安装wordpress和phpmyadmin软件

[root@localhost wordpress]# unzip wordpress-4.3.1-zh_CN.zip[root@localhost blog]# cd wordpress[root@localhost wordpress]# cp wp-config-sample.php wp-config.php[root@localhost wordpress]# vim wp-config.php /** WordPress数据库的名称 */define('DB_NAME', 'mytest');/** MySQL数据库用户名 */define('DB_USER', 'admin');/** MySQL数据库密码 */define('DB_PASSWORD', 'admin');/** MySQL主机 */define('DB_HOST', '172.18.250.10');

验证能都正常登陆：

登陆博客：

[root@localhost blog]# cd /www/php/[root@localhost php]# unzip phpMyAdmin-4.4.14.1-all-languages.zip[root@localhost php]# ln -s phpMyAdmin-4.4.14.1-all-languages pma

生成一段随机数，用作登陆phpmyadmin

[root@localhost pma]# cp config.sample.inc.php config.inc.php  [root@localhost pma]# openssl rand -base64 30d8yhR7wOU5+HzeZjGEusyAmNiQv/+rTzWQuoDiCR[root@localhost pma]# vim config.inc.php$cfg['blowfish_secret'] = 'd8yhR7wOU5+HzeZjGEusyAmNiQv/+rTzWQuoDiCR';$cfg['Servers'][$i]['host'] = '172.18.250.10';

验证网页是否能打开：

安装个php-mbstring，支持中文字符集

[root@localhost pma]# rpm -ivh php-mbstring-5.3.3-40.el6_6.x86_64.rpm

刷新页面：

输入刚才授权的账号密码：

。。。。。。

解决思路：
1、升级mysql版本。
2、降级phpmyadmin版本。

降低版本的方法：

[root@localhost pma]# cd libraries/[root@localhost libraries]# vim common.inc.phpif (PMA_MYSQL_INT_VERSION < 50500) { 改成if (PMA_MYSQL_INT_VERSION < 50100 {

再次刷新，输入账号密码：

OK，数据库登录成功。

五、安装Xcache对php进行加速

[root@localhost libraries]# yum -y install php-xcache

1、先测试没开启加速前的请求速度：

[root@localhost setup]# ab -n100 -c10 http://172.18.250.76/wordpress/index.phpBenchmarking 172.18.250.76 (be patient).....doneServer Software:        Apache/2.2.15Server Hostname:        172.18.250.76Server Port:            80Document Path:          /wordpress/index.phpDocument Length:        0 bytesConcurrency Level:      10Time taken for tests:   4.792 secondsComplete requests:      100Failed requests:        0Write errors:           0Non-2xx responses:      100Total transferred:      36800 bytesHTML transferred:       0 bytesRequests per second:    20.87 [#/sec] (mean)Time per request:       479.161 [ms] (mean)Time per request:       47.916 [ms] (mean, across all concurrent requests)Transfer rate:          7.50 [Kbytes/sec] receivedConnection Times (ms)              min  mean[+/-sd] median   maxConnect:        0    1   3.8      0      20Processing:   143  459 331.6    352    1783Waiting:      143  458 331.6    343    1783Total:        143  460 331.4    360    1783Percentage of the requests served within a certain time (ms)  50%    360  66%    405  75%    512  80%    581  90%    895  95%   1375  98%   1720  99%   1783 100%   1783 (longest request)

2、重启httpd服务，开启Xcache，在测试下

[root@localhost setup]# ab -n100 -c10  Benchmarking 172.18.250.76 (be patient).....doneServer Software:        Apache/2.2.15Server Hostname:        172.18.250.76Server Port:            80Document Path:          /wordpress/index.phpDocument Length:        0 bytesConcurrency Level:      10Time taken for tests:   1.659 secondsComplete requests:      100Failed requests:        0Write errors:           0Non-2xx responses:      100Total transferred:      36800 bytesHTML transferred:       0 bytesRequests per second:    60.27 [#/sec] (mean)   //三倍加速请求Time per request:       165.908 [ms] (mean)Time per request:       16.591 [ms] (mean, across all concurrent requests)Transfer rate:          21.66 [Kbytes/sec] receivedConnection Times (ms)              min  mean[+/-sd] median   maxConnect:        0    1   2.6      0      10Processing:    41  158  27.5    158     235Waiting:       40  158  27.6    158     235Total:         41  159  28.7    158     245Percentage of the requests served within a certain time (ms)  50%    158  66%    166  75%    168  80%    171  90%    192  95%    213  98%    240  99%    245 100%    245 (longest request)

六：对访问phpmyadmin网页时进行SSL加密认证

签证及CA认证是怎么进行可以参考我的博文：Linux中加密解密技术及CA认证

1、先下载mod_ssl模块，因为httpd2.2没包含这个模块

[root@localhost ssl]# yum -y install mod_ssl

2、编辑/etc/httpd/conf.d/ssl.conf文件

[root@localhost ssl]# vim /etc/httpd/conf.d/ssl.conf DocumentRoot "/www/php"      //取消注释，修改虚拟主机的urlServerName      //虚拟主机名 SSLEngine on                 //确保为onSSLCertificateFile /etc/httpd/ssl/httpd.crt       //存放签署的证书SSLCertificateFile /etc/httpd/ssl/httpd.key       //存放私钥的位置

3、重启httpd服务器，查看443端口是否启用

[root@localhost ssl]# netstat -ntlptcp    0   0 :::443          :::*                        LISTEN      6080/httpd

4、验证页面是否能访问

5、从虚拟机把CA证书下载到windows主机上

[root@www CA]# sz cacert.pem

6、把证书导入到浏览器当中

7、重新打开浏览器，输入虚拟主机名：