2、创建等会需要用到的数据库和授权等相关操作
MariaDB [(none)]> CREATE DATABASE wpdb; ##创建WordPress所用数据库
MariaDB [(none)]> GRANT ALL ON wpdb.* TO 'wpuser'@'192.168.%.%' IDENTIFIED BY 'wppass';
###授权WordPress用户及操作操作
MariaDB [(none)]> CREATE DATABASE pma; ##授权phpmyadmin所用数据库
MariaDB [(none)]> GRANT ALL ON pma.* TO 'pmauser'@'192.168.%.%' IDENTIFIED BY 'pmapass';
###授权phpmyadmin的用户及操作权限
MariaDB [(none)]> grant all on *.* to 'pmauser'@'192.168.%.%' identified by 'pmapass';
3、在php服务器上建立php测试页,测试php是否可以正常连接数据
[root@pxe132 ~]# vim /data/vhosts/www1/index.php
This is vhost1
[root@pxe132 ~]# vim /data/vhosts/www1/index.php
This is vhost2
ok了下面我们对页面进行一次压力测试看看速度:
[root@bogon ~]# ab -n 10000 -c 1000 http://wp.magedu.com/wordpress
This is ApacheBench, Version 2.3
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/
Benchmarking wp.magedu.com (be patient)
Completed 1000 requests
Completed 2000 requests
Completed 3000 requests
Completed 4000 requests
Completed 5000 requests
Completed 6000 requests
Completed 7000 requests
Completed 8000 requests
Completed 9000 requests
Completed 10000 requests
Finished 10000 requests
Server Software: Apache/2.4.6
Server Hostname: wp.magedu.com
Server Port: 80
Document Path: /wordpress
Document Length: 239 bytes
Concurrency Level: 1000
Time taken for tests: 3.081 seconds
Complete requests: 10000
Failed requests: 0
Write errors: 0
Non-2xx responses: 10002
Total transferred: 4690938 bytes
HTML transferred: 2390478 bytes
Requests per second: 3245.20 [#/sec] (mean)
Time per request: 308.147 [ms] (mean)
Time per request: 0.308 [ms] (mean, across all concurrent requests)
Transfer rate: 1486.63 [Kbytes/sec] received 从这段测试可以看出,这没加速度比我们之前的基于module+xcache的都要快。。。。
2、编辑配置文件,我吧缓存大小调整大写看看效果
[root@pxe132 ~]# vim /etc/php.d/xcache.ini
xcache.size = 300M
3、压力测试:
[root@bogon ~]# ab -n 10000 -c 1000 http://wp.magedu.com/wordpress
This is ApacheBench, Version 2.3
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/
Benchmarking wp.magedu.com (be patient)
Completed 1000 requests
Completed 2000 requests
Completed 3000 requests
Completed 4000 requests
Completed 5000 requests
Completed 6000 requests
Completed 7000 requests
Completed 8000 requests
Completed 9000 requests
Completed 10000 requests
Finished 10000 requests
Server Software: Apache/2.4.6
Server Hostname: wp.magedu.com
Server Port: 80
Document Path: /wordpress
Document Length: 239 bytes
Concurrency Level: 1000
Time taken for tests: 3.076 seconds
Complete requests: 10000
Failed requests: 0
Write errors: 0
Non-2xx responses: 10012
Total transferred: 4695628 bytes
HTML transferred: 2392868 bytes
Requests per second: 3250.70 [#/sec] (mean)
Time per request: 307.626 [ms] (mean)
Time per request: 0.308 [ms] (mean, across all concurrent requests)
Transfer rate: 1490.63 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 46 208.7 2 3011
Processing: 0 69 191.8 31 1575
Waiting: 0 68 191.7 31 1574
Total: 21 115 337.5 34 3040