文章目录
搭建lnmp
Mysql的安装
· 移动到安装包存放路径：
cd /usr/local/src/
· 下载MySQL的二进制免编译包：
wget http://mirrors.163.com/mysql/Downloads/MySQL-5.6/mysql-5.6.39-linux-glibc2.12-x86_64.tar.gz
·解压mysql源码包文件：
tar -zxvf mysql-5.6.39-linux-glibc2.12-x86_64.tar.gz
·移动解压后的目录并更名：
mv mysql-5.6.39-linux-glibc2.12-x86_64 /usr/local/mysql
·移动至mysql目录下：
cd /usr/local/mysql
·创建一个新用户：
useradd mysql
·创建datadir的目录:
mkdir /data/
·初始化mysql，指定用户和data目录：
1./scripts/mysql_install_db --user=mysql --datadir=/data/mysql
2安装需要的依赖包：yum install -y perl-DBD-MySQL libaio*
·修改mysql的配置文件（系统自带）：
1vim /etc/my.cnf
2· 修改内容如下：
3datadir=/data/mysql
4socket=/tmp/mysql.sock
· 将mysql自带的脚本文件移至chkconfig的执行目录下，并定义basedir（程序目录）和datadir：
cp support-files/mysql.server /etc/init.d/mysqld
· 定义脚本中的basedir（程序目录）和datadir：
1basedir=/usr/local/mysql
2datadir=/data/mysql
· 将脚本文件的权限更改为755：
chmod 755 /etc/init.d/mysqld
· 将脚本文件加入到chkconfig服务中：
chkconfig --add mysqld
· 启动mysql服务
/etc/init.d/mysqld start
PHP安装
· 相关的依赖包：
yum -y install libxml2-devel libpng-devel openssl openssl-devel bzip2 bzip2-devel libjpeg-devel freetype-devel libmcrypt.x86_64 libmcrypt-devel.x86_64 curl curl-devel
· 移动到安装包存放路径：
cd /usr/local/src/
· 下载php5源码包：
wget http://cn2.php.net/distributions/php-5.6.32.tar.bz2
· 解压php5源码包
tar -jxvf php-5.6.32.tar.bz2
· 移至解压后的目录下执行命令：
./configure --prefix=/usr/local/php-fpm --with-config-file-path=/usr/local/php-fpm/etc --enable-fpm --with-fpm-user=php-fpm --with-fpm-group=php-fpm --with-mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config --with-pdo-mysql=/usr/local/mysql --with-mysql-sock=/tmp/mysql.sock --with-libxml-dir --with-gd --with-jpeg-dir --with-png-dir --with-freetype-dir --with-iconv-dir --with-zlib-dir --with-mcrypt --enable-soap --enable-gd-native-ttf --enable-ftp --enable-mbstring --enable-exif --with-pear --with-curl --with-openssl
· 最后进行编译和安装：
make && make install
· 创建php-fpm用户：
useradd -s /sbin/nologin -M php-fpm
· 复制解压目录中的配置模板到php-fpm目录下：
cp php.ini-production /usr/local/php-fpm/etc/php.ini
· 创建并修改主配置文件：
1vim /usr/local/php-fpm/etc/php-fpm.conf
2加入以下内容：
3[global]
4pid = /usr/local/php-fpm/var/run/php-fpm.pid
5error_log = /usr/local/php-fpm/var/log/php-fpm.log
6include = /etc/php/php-fpm.d/*.conf
· 创建php-fpm配置文件目录
mkdir -p /etc/php/php-fpm.d/
· 添加discuz论坛的php-fpm配置文件：
1vim /etc/php/php-fpm.d/discuz.conf
2[discuz]
3listen = /tmp/discuz.sock
4listen.mode=666
5user = php-fpm
6group = php-fpm
7pm = static
8pm.max_children = 50
9pm.start_servers = 20
10pm.min_spare_servers = 1
11pm.max_spare_servers = 35
12pm.max_requests = 500
13rlimit_files = 1024
14request_slowlog_timeout = 2
15slowlog = /usr/local/php-fpm/var/log/discuz-slow.log
· 添加dedecms论坛的php-fpm配置文件：
1vim /etc/php/php-fpm.d/dedecms.conf
2内容如下：
3[dedecms]
4listen = /tmp/dedecms.sock
5listen.mode=666
6user = php-fpm
7group = php-fpm
8pm = static
9pm.max_children = 50
10pm.start_servers = 20
11pm.min_spare_servers = 1
12pm.max_spare_servers = 35
13pm.max_requests = 500
14rlimit_files = 1024
15request_slowlog_timeout = 2
16slowlog = /usr/local/php-fpm/var/log/dedecms-slow.log
· 定时自动切割php-fpm的日志脚本
1vim /usr/local/sbin/php-fpm_logrotate.sh
2#! /bin/bash
3#php-fpm的日志存放路径为/usr/local/php-fpm/var/log/
4d=`date -d "-1 day" +%Y%m%d`
5logdir="/usr/local/php-fpm/var/log/"
6cd $logdir
7for log in `ls *.log`
8do
9mv $log $log-$d
10done
11##3 自动删除一个月以前的日志
12find /usr/local/php-fpm/var/log/ -name discuz-slow.log-* -type f –mtime +30 |xargs rm
· 创建php-fpm_logrotate.sh的日志计划任务
1crontab -e
20 0 * * * /bin/bash /usr/local/sbin/discuz-php-fpm_logrotate.sh &>>/tmp/php-fpm_logrotate.log
· 复制解压后的源码包中的启动脚本：
cp sapi/fpm/init.d.php-fpm /etc/init.d/php-fpm
· 修改启动脚本权限：
chmod 755 /etc/init.d/php-fpm
· 将脚本文件加入到chkconfig服务中：
chkconfig --add php-fpm
· 设置开机启动php-fpm：
chkconfig php-fpm on
· 查看配置文件是否正确：
/usr/local/php-fpm/sbin/php-fpm -t
· 启动php-fpm服务：
service php-fpm start
· 测试服务是否启动成功：
ps aux |grep php-fpm
Nginx安装
· 移动至目录
cd /usr/local/src
· 下载Nginx1.14版本：
wget http://nginx.org/download/nginx-1.14.0.tar.gz
· 解压源码包：
tar zxvf nginx-1.14.0.tar.gz
· 相关依赖包
yum -y install gcc* autoconf libjpeg* libpng* freetype* libxml2* zlib* glibc* glib2* bzip2* ncurses* curl* e2fsprogs* krb5* libidn-devel openssl* openldap* nss_ldap
· 移至解压后的cd nginx-1.14.0目录下执行命令：
./configure --prefix=/usr/local/nginx
· 编译安装nginx:
make && make install
· 创建编辑nginx启动脚本:
1vim /etc/init.d/nginx
2内容如下：
3#!/bin/bash
4# chkconfig: - 30 21
5# description: http service.
6# Source Function Library
7. /etc/init.d/functions
8# Nginx Settings
9
10NGINX_SBIN="/usr/local/nginx/sbin/nginx"
11NGINX_CONF="/usr/local/nginx/conf/nginx.conf"
12NGINX_PID="/usr/local/nginx/logs/nginx.pid"
13RETVAL=0
14prog="Nginx"
15
16start()
17{
18
19 echo -n $"Starting $prog: "
20 mkdir -p /dev/shm/nginx_temp
21 daemon $NGINX_SBIN -c $NGINX_CONF
22 RETVAL=$?
23 echo
24 return $RETVAL
25}
26
27stop()
28{
29
30 echo -n $"Stopping $prog: "
31 killproc -p $NGINX_PID $NGINX_SBIN -TERM
32 rm -rf /dev/shm/nginx_temp
33 RETVAL=$?
34 echo
35 return $RETVAL
36}
37
38reload()
39{
40
41 echo -n $"Reloading $prog: "
42 killproc -p $NGINX_PID $NGINX_SBIN -HUP
43 RETVAL=$?
44 echo
45 return $RETVAL
46}
47
48restart()
49{
50
51 stop
52 start
53}
54
55configtest()
56{
57
58 $NGINX_SBIN -c $NGINX_CONF -t
59 return 0
60}
61
62case "$1" in
63 start)
64 start
65 ;;
66 stop)
67 stop
68 ;;
69 reload)
70 reload
71 ;;
72 restart)
73 restart
74 ;;
75 configtest)
76 configtest
77 ;;
78 *)
79 echo $"Usage: $0 {start|stop|reload|restart|configtest}"
80 RETVAL=1
81esac
82
83exit $RETVAL
· 修改nginx启动脚本权限：
chmod 755 /etc/init.d/nginx
· 将nginx启动脚本文件加入到chkconfig服务中：
chkconfig --add nginx
· 将nginx启动脚本设置为开机启动：
chkconfig nginx on
· 创建nginx主配置文件
1vim /usr/local/nginx/conf/nginx.conf
2内容如下：
3user nobody nobody;
4worker_processes 2;
5error_log /usr/local/nginx/logs/nginx_error.log crit;
6pid /usr/local/nginx/logs/nginx.pid;
7worker_rlimit_nofile 51200;
8
9events
10{
11
12 use epoll;
13 worker_connections 6000;
14}
15
16http
17{
18
19 include mime.types;
20 default_type application/octet-stream;
21 server_names_hash_bucket_size 3526;
22 server_names_hash_max_size 4096;
23 log_format combined_realip '$remote_addr $http_x_forwarded_for [$time_local]'
24 ' $host "$request_uri" $status'
25 ' "$http_referer" "$http_user_agent"';
26 sendfile on;
27 tcp_nopush on;
28 keepalive_timeout 30;
29 client_header_timeout 3m;
30 client_body_timeout 3m;
31 send_timeout 3m;
32 connection_pool_size 256;
33 client_header_buffer_size 1k;
34 large_client_header_buffers 8 4k;
35 request_pool_size 4k;
36 output_buffers 4 32k;
37 postpone_output 1460;
38 client_max_body_size 10m;
39 client_body_buffer_size 256k;
40 client_body_temp_path /usr/local/nginx/client_body_temp;
41 proxy_temp_path /usr/local/nginx/proxy_temp;
42 fastcgi_temp_path /usr/local/nginx/fastcgi_temp;
43 fastcgi_intercept_errors on;
44 tcp_nodelay on;
45 gzip on;
46 gzip_min_length 1k;
47 gzip_buffers 4 8k;
48 gzip_comp_level 5;
49 gzip_http_version 1.1;
50 gzip_types text/plain application/x-javascript text/css text/htm
51 application/xml;
52 include vhost/*.conf;
53}
· 创建虚拟主机配置目录
mkdir /usr/local/nginx/conf/vhost/
· 创建discuz的虚拟主机配置文件
1vim /usr/local/nginx/conf/vhost/discuz.conf
2内容如下：
3server
4{
5
6 listen 80;
7 server_name discuz.yuankeedu.com;
8 index index.html index.htm index.php;
9 root /data/wwwroot/discuz.com;
10 location ~ admin\.php
11 {
12
13 auth_basic "Auth";
14 auth_basic_user_file /usr/local/nginx/conf/htpasswd;
15 include fastcgi_params;
16 fastcgi_pass unix:/tmp/discuz.sock;
17 fastcgi_index index.php;
18 fastcgi_param SCRIPT_FILENAME /data/wwwroot/discuz.com$fastcgi_script_name;
19 }
20 location ~ \.php$
21 {
22
23 include fastcgi_params;
24 fastcgi_pass unix:/tmp/discuz.sock;
25 fastcgi_index index.php;
26 fastcgi_param SCRIPT_FILENAME /data/wwwroot/discuz.com$fastcgi_script_name;
27 }
28 location ~ .*\.(gif|jpg|jpeg|png|bmp|swf)$
29 {
30
31 expires 7d;
32 access_log off;
33 }
34location ~ .*\.(js|css)$
35 {
36
37 expires 12h;
38 access_log off;
39 }
40 access_log /usr/local/nginx/logs/discuz.logs "combined_realip";
41}
· 创建dedecms的虚拟主机配置文件
1vim /usr/local/nginx/conf/vhost/dedecms.conf
2内容如下：
3server
4{
5
6 listen 80;
7 server_name dedecms.yuankeedu.com;
8 index index.html index.htm index.php;
9 root /data/wwwroot/dedecms.com;
10 location ~ login\.php
11 {
12
13 auth_basic "Auth";
14 auth_basic_user_file /usr/local/nginx/conf/htpasswd;
15 include fastcgi_params;
16 fastcgi_pass unix:/tmp/dedecms.sock;
17 fastcgi_index index.php;
18 fastcgi_param SCRIPT_FILENAME /data/wwwroot/dedecms.com$fastcgi_script_name;
19 }
20 location ~ \.php$
21 {
22
23 include fastcgi_params;
24 fastcgi_pass unix:/tmp/dedecms.sock;
25 fastcgi_index index.php;
26 fastcgi_param SCRIPT_FILENAME /data/wwwroot/dedecms.com$fastcgi_script_name;
27 }
28 location ~ .*\.(gif|jpg|jpeg|png|bmp|swf)$
29 {
30
31 expires 7d;
32 access_log off;
33 }
34location ~ .*\.(js|css)$
35 {
36
37 expires 12h;
38 access_log off;
39 }
40 access_log /usr/local/nginx/logs/dedecms.logs "combined_realip";
41}
· 创建zrlog的虚拟主机配置文件
1vim /usr/local/nginx/conf/vhost/zrlog.conf
2内容如下：
3upstream cxsw.xyz
4{
5
6 ip_hash;
7 server localhost:8080;
8}
9server
10{
11
12 listen 80;
13 server_name zrlog.yuankeedu.com;
14 location /
15 {
16
17 proxy_pass http://localhost:8080;
18 proxy_set_header Host $host;
19 proxy_set_header X-Real-IP $remote_addr;
20 proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
21 }
22 location ~ .*\.(gif|jpg|jpeg|png|bmp|swf)$
23 {
24
25 expires 7d;
26 access_log off;
27 proxy_pass http://localhost:8080;
28 proxy_set_header Host $host;
29 proxy_set_header X-Real-IP $remote_addr;
30 proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
31 }
32location ~ .*\.(js|css)$
33 {
34
35 expires 12h;
36 access_log off;
37 proxy_pass http://localhost:8080;
38 proxy_set_header Host $host;
39 proxy_set_header X-Real-IP $remote_addr;
40 proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
41 }
42 access_log /usr/local/nginx/logs/zrlog.logs "combined_realip";
43}
· 创建nginx的日志切割脚本
1vim /usr/local/sbin/nginx_logrotate.sh
2内容如下：
3#!/bin/bash
4d=`date -d "-1 day" +%Y%m%d`
5logdir="/usr/local/nginx/logs/"
6nginx_pid="/usr/local/nginx/logs/nginx.pid"
7cd $logdir
8for log in `ls *.logs`
9do
10 mv $log $log-$d
11done
12/bin/kill -HUP `cat $nginx_pid`
· 创建nginx_logrotate.sh的计划任务
1crontab -e
20 0 * * * /bin/bash /usr/local/sbin/nginx_logrotate.sh &>>/tmp/nginx_logrotate.log &>>/nginx_logrotate.log
· 检查配置nginx配置是否正确
/usr/local/nginx/sbin/nginx -t
· 启动nginx
/etc/init.d/nginx start
搭建tomcat+jdk
jdk的安装
· 前往ORACLE官网下载jdk，版本为1.8：
http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
· 下载完成后，使用xftp等工具上传到服务器/usr/local/src/目录下。
· 解压jdk压缩包
tar zxvf jdk-8u181-linux-x64.tar.gz
· 移动解压后的jdk文件：
mv jdk1.8.0_181/ /usr/local/jdk1.8
· 设置jdk环境变量:
1vim /etc/profile
2在文件最好加入以下内容：
3JAVA_HOME=/usr/local/jdk1.8/
4JAVA_BIN=/usr/local/jdk1.8/bin
5JRE_HOME=/usr/local/jdk1.8/jre
6PATH=$PATH:/usr/local/jdk1.8/bin:/usr/local/jdk1.8/jre/bin
7CLASSPATH=/usr/local/jdk1.8/jre/lib:/usr/local/jdk1.8/lib:/usr/local/jdk1.8/jre/lib
· 加载jdk环境变量生效：
source /etc/profile
· 检验jdk环境是否生效：
java -version
tomcat的安装
· 移动至/usr/local/src目录下，下载tomcat免编译包：
wget https://mirrors.tuna.tsinghua.edu.cn/apache/tomcat/tomcat-8/v8.5.34/bin/apache-tomcat-8.5.34.tar.gz
· 解压tomcat的压缩包：
tar zxvf apache-tomcat-8.5.34.tar.gz
· 移动解压后的tomcat目录：
mv apache-tomcat-8.5.34 /usr/local/tomcat
· 启动tomcat：/usr/local/tomcat/bin/startup.sh
配置mycat
· 编辑mycat主配置文件
1vim /usr/local/mycat/conf/schema.xml
2内容如下：
3<?xml version="1.0"?>
4<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
5<mycat:schema xmlns:mycat="http://io.mycat/">
6
7 <schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1"> </schema>
8 <schema name="TESTDB1" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn2"> </schema>
9 <schema name="TESTDB2" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn3"> </schema>
10 <dataNode name="dn1" dataHost="localhost1" database="zrlog" />
11 <dataNode name="dn2" dataHost="localhost2" database="discuz" />
12 <dataNode name="dn3" dataHost="localhost3" database="dedecms" />
13 <dataHost name="localhost1" maxCon="1000" minCon="10" balance="1"
14 writeType="0" dbType="mysql" dbDriver="native" switchType="2" slaveThreshold="100">
15 <heartbeat>select user()</heartbeat>
16 <writeHost host="hostM1" url="192.168.118.170:3306" user="zrlog" password="zrlog">
17 <readHost host="hostS1" url="192.168.118.171:3306" user="zrlog" password="zrlog" />
18 </writeHost>
19 </dataHost>
20 <dataHost name="localhost2" maxCon="1000" minCon="10" balance="1"
21 writeType="0" dbType="mysql" dbDriver="native" switchType="2" slaveThreshold="100">
22 <heartbeat>select user()</heartbeat>
23 <writeHost host="hostM2" url="192.168.118.170:3306" user="discuz" password="discuz">
24 <readHost host="hostS2" url="192.168.118.171:3306" user="discuz" password="discuz" />
25 </writeHost>
26 </dataHost>
27 <dataHost name="localhost3" maxCon="1000" minCon="10" balance="1"
28 writeType="0" dbType="mysql" dbDriver="native" switchType="2" slaveThreshold="100">
29 <heartbeat>select user()</heartbeat>
30 <writeHost host="hostM3" url="192.168.118.170:3306" user="dedecms" password="dedecms">
31 <readHost host="hostS3" url="192.168.118.171:3306" user="dedecms" password="dedecms" />
32 </writeHost>
33 </dataHost>
34</mycat:schema>
· 编辑mycat的server.xml用户文件
1vim /usr/local/mycat/conf/server.xml
2在文件内增加内容如下：
3<user name="zrlog">
4 <property name="password">zrlog</property>
5 <property name="schemas">TESTDB</property>
6 </user>
7
8 <user name="discuz">
9 <property name="password">discuz</property>
10 <property name="schemas">TESTDB1</property>
11 </user>
12 <user name="dedecms">
13 <property name="password">dedecms</property>
14 <property name="schemas">TESTDB2</property>
15 </user>
· 重新启动mycat
/usr/local/mycat/bin/mycat restart
· 检查进程和端口是否启动
netstat -lntp |grep mycat;ps aux |grep mycat
部署zrlog
· 编辑tomcat配置文件:
1vim /usr/local/tomcat/conf/server.xml
2增加以下内容：
3<Host name="zrlog.yuankeedu.com" appBase=""
4 unpackWARs= "true" autoDeploy="true"
5 xmlValidation="false" xmlNamespaceAware="false">
6 <Context path="" docBase="/data/wwwroot/zrlog.com/" debug="0" reloadable="true" crossContext="true"/>
7</Host>
· 下载zrlog（移动至/usr/local/src下）：
wget http://dl.zrlog.com/release/zrlog-1.7.1-baaecb9-release.war
· 创建zrlog的网站根目录
mkdir -p /data/wwwroot/zrlog.com/
· 更名并移动zrlog的war包到/usr/local/tomcat/webapps/目录下：
cp zrlog-1.7.1-baaecb9-release.war /usr/local/tomcat/webapps/zrlog.war
· 移动到目录/usr/local/tomcat/webapps/，移动解压后的zrlog下的文件，删除zrlog和zrlog.war
1mv /usr/local/tomcat/webapps/zrlog/* /data/wwwroot/zrlog.com/
2rm -rfv zrlog zrlog.war
· 连接mysql后创建zrlog数据库，以及zrlog数据库用户
1mysql -uroot -p
2create database zrlog;
3grant all on zrlog.* to 'zrlog'@'%' identified by 'zrlog';
· 重启动tomcat：
/usr/local/tomcat/bin/shutdown.sh && /usr/local/tomcat/bin/startup.sh
· 游览器访问域名，根据提示安装即可
1数据库服务器:192.168.118.169
2数据库名:TESTDB
3数据库用户名:zrlog
4数据库密码:zrlog
5数据库端口:8066
zrlog的后台二次认证
· 修改tomcat根目录下的tomcat-users.xml文件
1vim /usr/local/tomcat/conf/tomcat-users.xml
2增加内容如下：
3<role rolename="zrolg"/>
4<user username="zrlog" password="zrlog" roles="tomcat"/>
· 修改tomcat根目录下的web.xml文件
1vim /usr/local/tomcat/conf/web.xml
2增加内容如下：
3<security-constraint>
4<web-resource-collection>
5<web-resource-name>zrlog.yuankeedu.com</web-resource-name>
6<url-pattern>/admin/*</url-pattern>
7</web-resource-collection>
8<auth-constraint>
9## tomcat-users.xml中配置的rolename ##
10<role-name>zrlog</role-name>
11</auth-constraint>
12</security-constraint>
13<login-config>
14<auth-method>BASIC</auth-method>
15## 访问提示自定义 ##
16<realm-name>aminglinux</realm-name>
17</login-config>
· 重新启动tomcat：
/usr/local/tomcat/bin/shutdown.sh && /usr/local/tomcat/bin/startup.sh
部署discuz
· 下载discuz安装包到/usr/local/src/目录下
wget http://download.comsenz.com/DiscuzX/3.3/Discuz_X3.3_SC_UTF8.zip
· 解压discuz压缩包（yum -y install unzip）
unzip Discuz_X3.3_SC_UTF8.zip
· 创建discuz的网站根目录
mkdir -p /data/wwwroot/discuz.com/
· 把upload目录下文件拷贝到/data/wwwroot/discuz.com/
mv upload/* /data/wwwroot/discuz.com/
· 创建discuz的数据库和数据库用户
1mysql -uroot -p
2create database discuz;
3grant all on discuz.* to 'discuz'@'%' identified by 'discuz';
· 移动至/data/wwwroot/discuz.com/目录下，根据安装提示修改以下目录和文件的权限
chmod 777 config data data/cache data/avatar data/plugindata data/download data/addonmd5 data/template data/threadcache data/attachment data/attachment/album data/attachment/forum data/attachment/group data/log uc_client/data/cache uc_server/data/ uc_server/data/cache uc_server/data/avatar uc_server/data/backup uc_server/data/logs uc_server/data/tmp uc_server/data/view
· 在游览器输入域名或IP安装,暂时输入mysql主的信息：
1数据库服务器:192.168.118.170
2 数据库名:discuz
3 数据库用户名:discuz
4 数据库密码:discuz
5 数据表前缀:pre_
·修改服务器上discuz的配置文件，指定到mycat上，用户数据库密码与mycat对应
1vim /data/wwwroot/discuz.com/config/config_global.php
2修改内容如下：
3$_config['db']['1']['dbhost'] = '192.168.118.169:8066';
4$_config['db']['1']['dbuser'] = 'discuz';
5$_config['db']['1']['dbpw'] = 'discuz';
6$_config['db']['1']['dbcharset'] = 'utf8';
7$_config['db']['1']['pconnect'] = '0';
8$_config['db']['1']['dbname'] = 'TESTDB1';
9$_config['db']['1']['tablepre'] = 'pre_';
10$_config['db']['slave'] = '';
11$_config['db']['common']['slave_except_table'] = '';
· 重启nginx
discuz的后台二次认证
· 使用命令htpasswd创建用户和密码（先安装yum -y install httpd）：
htpasswd -c /usr/local/nginx/conf/htpasswd discuz
· 再次访问后台时需要输入用户认证信息（nginx配置在前面已经完成）
部署dedecms
· 移动到目录/usr/local/src,下载dedecms压缩包：
wget http://updatenew.dedecms.com/base-v57/package/DedeCMS-V5.7-UTF8-SP2.tar.gz
· 解压dedecms
tar zxvf DedeCMS-V5.7-UTF8-SP2.tar.gz
· 进入解压后的DedeCMS目录
cd DedeCMS-V5.7-UTF8-SP2
· 创建dedecms的网站根目录
mkdir -p /data/wwwroot/dedecms
· 把解压后的uploads目录下的所有文件拷贝到dedecms指定的跟目录下：
mv ./uploads/* /data/wwwroot/dedecms.com
· 创建dedecms的数据库和数据库用户
1mysql -uroot -p
2create database dedecms;
3grant all on dedecms.* to 'dedecms'@'%' identified by 'dedecms';
· 根据安装提示，修改以下文件的权限
chmod 777 /data/wwwroot/dedecms.com /data/wwwroot/dedecms.com/install /data/wwwroot/dedecms.com/special && chmod -R 777 /data/wwwroot/dedecms.com/plus/ /data/wwwroot/dedecms.com/dede/ /data/wwwroot/dedecms.com//data/ /data/wwwroot/dedecms.com/a/ /data/wwwroot/dedecms.com/uploads/
· 在游览器输入域名或IP安装,例：
1数据库主机:192.168.118.169:8066
2数据库用户：dedecms
3数据库密码：dedecms
4数据表前缀：dede_
5数据库名称：TESTDB2
· 根据提示继续安装即可。
dedecms的后台二次认证
· 使用命令htpasswd创建用户和密码（第二次创建不需要-c选项）：
htpasswd /usr/local/nginx/conf/htpasswd dedecms
· 再次访问后台时需要输入用户认证信息（nginx配置在前面已经完成）
Nginx负载均衡
· 在nginx代理服务器安装nginx，内容如上（以下负载均衡操作不做说明的均在代理服务器上操作）
· 创建zrlog的负载均衡配置文件：
1vim /usr/local/nginx/conf/vhost/zrlog.com.conf
2内容如下：
3upstream zrlog.com
4{
5
6 ip_hash;
7 server 192.168.118.174:80;
8 server 192.168.118.175:80;
9 server 192.168.118.176:80;
10 server 192.168.118.177:80;
11 server 192.168.118.178:80;
12 server 192.168.118.179:80;
13}
14server
15{
16
17 listen 80;
18 server_name zrlg.yuankeedu.com;
19 location /
20 {
21
22 proxy_pass http://zrlog.com;
23 proxy_set_header Host $host;
24 proxy_set_header X-Real-IP $remote_addr;
25 proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
26 }
27}
· 创建discuz的负载均衡配置文件：
1vim /usr/local/nginx/conf/vhost/discuz.com.conf
2内容如下：
3upstream discuz.com
4{
5
6 ip_hash;
7 server 192.168.118.174:80;
8 server 192.168.118.175:80;
9 server 192.168.118.176:80;
10 server 192.168.118.177:80;
11 server 192.168.118.178:80;
12 server 192.168.118.179:80;
13}
14server
15{
16
17 listen 80;
18 server_name discuz.yuankeedu.com;
19 location /
20 {
21
22 proxy_pass http://discuz.com;
23 proxy_set_header Host $host;
24 proxy_set_header X-Real-IP $remote_addr;
25 proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
26 }
27}
· 创建dedecms的负载均衡配置文件：
1vim /usr/local/nginx/conf/vhost/dedecms.com.conf
2内容如下：
3upstream dedecms.com
4{
5
6 ip_hash;
7 server 192.168.118.174:80;
8 server 192.168.118.175:80;
9 server 192.168.118.176:80;
10 server 192.168.118.177:80;
11 server 192.168.118.178:80;
12 server 192.168.118.179:80;
13}
14server
15{
16
17 listen 80;
18 server_name dedecms.yuankeedu.com;
19 location /
20 {
21
22 proxy_pass http://dedecms.com;
23 proxy_set_header Host $host;
24 proxy_set_header X-Real-IP $remote_addr;
25 proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
26 }
27}
· 创建zabbix的代理的配置文件:
1vim /usr/local/nginx/conf/vhost/zabbix.conf
2内容如下:
3server
4{
5
6 listen 80;
7 server_name zabbix.yuankeedu.com;
8 location /
9 {
10
11 proxy_pass http://192.168.118.180;
12 proxy_set_header Host $host;
13 proxy_set_header X-Real-IP $remote_addr;
14 proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
15 }
16}
· 登陆zabbix服务器，修改配置文件
1vim /etc/httpd/conf.d/zabbix
2增加一行，内容如下：
3ServerName zabbix.yuankeedu.com
4DocumentRoot "/usr/share/zabbix"
5重启httpd服务：systemctl restart httpd
· 配置完检查语法，并重新加载配置文件
nginx -t && nginx -s reload
