!/bin/sh

56:
安装数据ku

创建ku
create database wordpress;

grant all privileges on wordpress.* to “wordpress”@”192.168.37.%” identified by “123456”;

测试链接

安装 nfs-utils
vim /etc/exports
/data/wordpress *(rw,no_root_squash)

systemctl restart nfs
systemctl enable nfs

54,55
yum install nfs-utils -y
tar xf nginx-1.16.0.tar.gz
cd nginx-1.16.0
./configure —prefix=/apps/nginx
—user=www
—group=www
—with-http_ssl_module
—with-http_v2_module
—with-http_realip_module
—with-http_stub_status_module
—with-http_gzip_static_module
—with-pcre
—with-stream
—with-stream_ssl_module
—with-stream_realip_module
make && make install
/apps/nginx/sbin/nginx -t
useradd www -s /sbin/nologin -u 2000
安装
tar php-7.2.21.tar.gz

yum -y install libxml2 libxml2-devel openssl openssl-devel bzip2 bzip2-devel libcurl libcurl-devel libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel gmp gmp-devel libmcrypt libmcrypt-devel readline readline-devel libxslt libxslt-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel ncurses curl gdbm-devel db4-devel libXpm-devel libX11-devel gd-devel gmp-devel expat-devel xmlrpc-c xmlrpc-c-devel libicu-devel libmcrypt-devel libmemcached-devel

./configure —prefix=/apps/php
—enable-fpm
—with-fpm-user=www
—with-fpm-group=www
—with-pear
—with-curl
—with-png-dir
—with-freetype-dir
—with-iconv
—with-zlib
—with-xmlrpc
—with-mhash
—with-xsl
—with-openssl
—with-mysqli
—with-pdo-mysql
—disable-debug
—enable-zip
—enable-sockets
—enable-soap
—enable-inline-optimization
—enable-xml
—enable-ftp
—enable-exif
—enable-wddx
—enable-bcmath
—enable-calendar
—enable-shmop
—enable-dba
—enable-cli
—enable-sysvsem
—enable-sysvshm
—enable-sysvmsg

make &&make install
cd /apps/php/etc/php-fpm.d/

cp www.conf.default www.conf

cp /usr/local/src/php-7.2.15/php.ini-production
/apps/php/etc/php.ini
vim www.conf
[www]
user = www
group = www
listen = 127.0.0.1:9000
listen.allowed_clients = 127.0.0.1

cd /apps/php/etc/

cp php-fpm.conf.default php-fpm.conf

/apps/php/sbin/php-fpm -t

/apps/php/sbin/php-fpm -c /apps/php/etc/php.in

mkdir /data/nginx/wordpress -p

vim /data/nginx/wordpress/index.php
vim /apps/nginx/conf/nginx.conf

location / {
root /data/nginx/wordpress;
index index.php index.html index.htm;
}
location ~ .php$ {
root /data/nginx/wordpress;
fastcgi_pass 127.0.0.1:9000;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $实验 keepalived lvs-dr wordpress - 图1$ fastcgi_script_name;
include fastcgi_params;
}

/apps/nginx/sbin/nginx -t

/apps/nginx/sbin/nginx -s reload

cd /data/nginx/wordpress
tar xf wordpress-5.0-zh_CN.tar.gz
cd wordpress

mv wordpress/* .
rm -rf wordpress-5.0-zh_CN.tar.gz wordpress
cp wp-config-sample.php wp-config.php

vim wp-config.php
/ WordPress数据库的名称 */
define(‘DB_NAME’, ‘wordpress’);
/ MySQL数据库用户名 /
define(‘DB_USER’, ‘wordpress’);
/** MySQL数据库密码 /
define(‘DB_PASSWORD’, ‘123456’);
/* MySQL主机 /
define(‘DB_HOST’, ‘192.168.37.56’);

chown www.www /data/nginx/wordpress/ /apps/nginx/ -R

/apps/nginx/sbin/nginx -t

/apps/nginx/sbin/nginx -s reload

52.53

yum install keepalived haproxy -y

vim /etc/keepalived/keepalived.conf

! Configuration File for keepalived

global_defs {
notification_email {
acassen@firewall.loc
failover@firewall.loc
sysadmin@firewall.loc
}
notification_email_from Alexandre.Cassen@firewall.loc
smtp_server 192.168.200.1
smtp_connect_timeout 30
router_id LVS_DEVEL
vrrp_skip_check_adv_addr
vrrp_strict
vrrp_iptables
vrrp_garp_interval 0
vrrp_gna_interval 0
}

vrrp_instance VI_1 {
state MASTER
interface ens33
virtual_router_id 51
priority 100
advert_int 1
authentication {
auth_type PASS
auth_pass 1111
}
virtual_ipaddress {
192.168.37.200 dev ens33 label ens33:0

systemctl start keepalived

systemctl enable keepalived

ifconfig

scp /etc/keepalived/keepalived.conf 192.168.37.53:/etc/keepalived/keepalived.conf

53:{ vim /etc/keepalived/keepalived.conf
! Configuration File for keepalived

vrrp_instance VI_1 {
state BACKUP
interface ens33
virtual_router_id 51
priority 80
advert_int 1
authentication {
auth_type PASS
auth_pass 1111
}
virtual_ipaddress {
192.168.37.200 dev ens33 label ens33:0

systemctl start keepalived
systemctl enable keepalived
echo “net.ipv4.ip_nonlocal_bind=1” > /etc/sysctl.conf
sysctl -p

}
52:systemctl stop keepalived
53:ifconfig

52:echo “net.ipv4.ip_nonlocal_bind=1” > /etc/sysctl.conf
sysctl -p

systemctl restart keepalived
vim /etc/haproxy/haproxy.cfg
listen web-80
bind 192.168.37.200:80
server web1 192.168.37.54:80 check inter 3s fall 3 rise 5
server web1 192.168.37.55:80 check inter 3s fall 3 rise 5
scp /etc/haproxy/haproxy.cfg 192.168.37.53:/etc/haproxy/haproxy.cfg

53:systemctl start haproxy
systemctl enable haproxy

57,58
yum install keepalived -y
vim /etc/keepalived/keepalived.conf

vrrp_strict
vrrp_iptables
vrrp_garp_interval 0
vrrp_gna_interval 0
}

vrrp_instance VI_1 {
state MASTER
interface ens33
virtual_router_id 52
priority 100
advert_int 1
authentication {
auth_type PASS
auth_pass 1111
}
virtual_ipaddress {
192.168.37.201 dev ens33 label ens33:0
}
}

virtual_server 192.168.37.201 80 {
delay_loop 6
lb_algo rr
lb_kind DR
persistence_timeout 50
protocol TCP

real_server 192.168.37.52 80 {
    weight 1
    TCP_CHECK {
        connect_timeout 3
        nb_get_retry 3
        delay_before_retry 3
        connect_port 80
    }
}
    real_server 192.168.37.53 80 {
    weight 1
    TCP_CHECK {
        connect_timeout 3
        nb_get_retry 3
        delay_before_retry 3
        connect_port 80
    }
}

}

vrrp_strict
vrrp_iptables
vrrp_garp_interval 0
vrrp_gna_interval 0
}

vrrp_instance VI_1 {
state BACKUP
interface ens33
virtual_router_id 52
priority 100
advert_int 1
authentication {
auth_type PASS
auth_pass 1111
}
virtual_ipaddress {
192.168.37.201 dev ens33 label ens33:0
}
}

virtual_server 192.168.37.201 80 {
delay_loop 6
lb_algo rr
lb_kind DR
persistence_timeout 50
protocol TCP

real_server 192.168.37.52 80 {
    weight 1
    TCP_CHECK {
        connect_timeout 3
        nb_get_retry 3
        delay_before_retry 3
        connect_port 80
    }
}
    real_server 192.168.37.53 80 {
    weight 1
    TCP_CHECK {
        connect_timeout 3
        nb_get_retry 3
        delay_before_retry 3
        connect_port 80
    }
}

}
systemctl restart keepalived
yum install ipvsadm -y

ipvsadm -Ln
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP 192.168.37.201:80 rr persistent 50
-> 192.168.37.52:80 Route 1 0 0
-> 192.168.37.53:80 Route 1 0 0
scp /etc/keepalived/keepalived.conf 192.168.37.58:/etc/keepalived/keepalived.conf

修改 52,53 haproxy
listen web-80
bind 192.168.37.52:80,192.168.37.201:80
server web1 192.168.37.54:80 check inter 3s fall 3 rise 5
server web1 192.168.37.55:80 check inter 3s fall 3 rise 5

listen web-80
bind 192.168.37.53:80,192.168.37.201:80
server web1 192.168.37.54:80 check inter 3s fall 3 rise 5
server web1 192.168.37.55:80 check inter 3s fall 3 rise 5

cat lvs-dr.sh

!/bin/sh

LVS_VIP=192.168.37.201
source /etc/rc.d/init.d/functions
case “$1” in
start)
/sbin/ifconfig lo:0 $LVS_VIP netmask 255.255.255.255 broadcast $LVS_VIP
/sbin/route add -host $LVS_VIP dev lo:0
echo “1” >/proc/sys/net/ipv4/conf/lo/arp_ignore
echo “2” >/proc/sys/net/ipv4/conf/lo/arp_announce
echo “1” >/proc/sys/net/ipv4/conf/all/arp_ignore
echo “2” >/proc/sys/net/ipv4/conf/all/arp_announce
sysctl -p >/dev/null 2>&1
echo “RealServer Start OK”
;;
stop)
/sbin/ifconfig lo:0 down
/sbin/route del $LVS_VIP >/dev/null 2>&1
echo “0” >/proc/sys/net/ipv4/conf/lo/arp_ignore
echo “0” >/proc/sys/net/ipv4/conf/lo/arp_announce
echo “0” >/proc/sys/net/ipv4/conf/all/arp_ignore
echo “0” >/proc/sys/net/ipv4/conf/all/arp_announce
echo “RealServer Stoped”
;;
*)
echo “Usage: $0 {start|stop}”
exit 1
esac
exit 0

bash lvs-dr.sh

55.54
mount -t nfs 192.168.37.56:/data/wordpress /data/nginx/wordpress/wp-content/uploads/

ll /data/nginx/wordpress/wordpress/wp-content/

chown www.www /data/nginx/wordpress -R

scp 数据整合在一起 -p

chmod a+x lvs-dr.sh

vim /etc/rc.d/rc.local

vim /etc/rc.d/rc.local
bash /root/lvs-dr.sh start