Mysql 5.7安装：https://www.cnblogs.com/shipment/p/14325309.html
KeepAlived：https://blog.csdn.net/qq_43377292/article/details/87364778
Rsync+inotify-tools：https://jackyu.cn/tech/rsync-plus-inotify-tools/
安装php：https://www.cnblogs.com/chenliang725/p/12575926.html

一、安装Mysql

  1. yum -y install mariadb-server
  3. systemctl start mariadb
  4. systemctl enable mariadb
  6. #初始化mariadb数据库
  7. mysql_secure_installation

Server1配置

  1. vim /etc/my.cnf
  2. #在mysqld下添加如下内容
  4. server-id = 1         
  5. log-bin = mysql-bin     
  6. sync_binlog = 1
  7. binlog_checksum = none
  8. binlog_format = mixed
  9. auto-increment-increment = 2     
  10. auto-increment-offset = 1    
  11. slave-skip-errors = all 
  13. systemctl restart mariadb
  15. GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
  17. flush privileges;

Server2配置

  1. vim /etc/my.cnf
  2. #在mysqld下添加如下内容
  4. server-id = 2
  5. log-bin = mysql-bin
  6. sync_binlog = 1
  7. binlog_checksum = none
  8. binlog_format = mixed
  9. auto-increment-increment = 2
  10. auto-increment-offset = 2
  11. slave-skip-errors = all
  13. systemctl restart mariadb

Server1配置

  1. flush tables with read lock;
  3. show master status;
  5. unlock tables; 
  7. stop slave;
  9. change  master to master_host='192.168.1.82',master_user='root',master_password='123456',master_log_file='mysql-bin.000001',master_log_pos=487;
  11. start slave;
  13. show slave status \G;

Server2配置

  1. flush tables with read lock;
  3. show master status;
  5. unlock tables; 
  7. stop slave;
  9. change  master to master_host='192.168.1.81',master_user='root',master_password='123456',master_log_file='mysql-bin.000001',master_log_pos=487;
  11. start slave;
  13. show slave status \G;

二、配置Keepalived

安装keepalived

  1. yum install keepalived ipvsadm -y

配置Server 1 keepalived

  1. vim /etc/keepalived/keepalived.conf
  3. #主节点标识，从节点不一致
  4.    router_id QF_HA_Node01 
  5. }
  7. vrrp_instance VI_1 {
  8. #表示这是master主节点
  9. state MASTER
  10. #标识虚拟ip绑定的网卡
  11.     interface ens192
  12. virtual_router_id 51
  13. #优先级一般主节点比从节点的大
  14.     priority 120
  15. advert_int 1
  16. #密码 主从一致
  17.     authentication {
  18.         auth_type PASS
  19.         auth_pass 1111
  20. }
  21. #定义虚拟ip
  22.     virtual_ipaddress {
  23.         192.168.1.83
  24.     }
  25. }
  27. #定义后端真实成员
  28. virtual_server 192.168.1.83 80 3306 {
  29.     delay_loop 6
  30.     lb_algo rr
  31.     lb_kind DR
  32.     persistence_timeout 0
  33.     protocol TCP
  35.     real_server 192.168.1.81 80 3306 {
  36.         weight 100
  37.     TCP_CHECK {            
  38.     connect_timeout 3
  39.         nb_get_retry 3
  40.         delay_before_retry 3
  41.     connect_port 80 3306       
  42.         }
  43.     }
  44. real_server 192.168.1.82 80 3306 {
  45.         weight 100
  46.     TCP_CHECK {            
  47.     connect_timeout 3
  48.         nb_get_retry 3
  49.         delay_before_retry 3
  50.     connect_port 80 3306        
  51.         }
  52.     }
  53. }
  55. systemctl restart keepalived

Server2配置keepalived

  1. vim /etc/keepalived/keepalived.conf
  3. #主节点标识，从节点不一致
  4.    router_id QF_HA_Node02
  5. }
  7. vrrp_instance VI_1 {
  8. #表示这是master主节点
  9. state MASTER
  10. #标识虚拟ip绑定的网卡
  11.     interface ens192
  12. virtual_router_id 51
  13. #优先级一般主节点比从节点的大
  14.     priority 119
  15. advert_int 1
  16. #密码 主从一致
  17.     authentication {
  18.         auth_type PASS
  19.         auth_pass 1111
  20. }
  21. #定义虚拟ip
  22.     virtual_ipaddress {
  23.         192.168.1.83
  24.     }
  25. }
  27. #定义后端真实成员
  28. virtual_server 192.168.1.83 80 3306 {
  29.     delay_loop 6
  30.     lb_algo rr
  31.     lb_kind DR
  32.     persistence_timeout 0
  33.     protocol TCP
  35.     real_server 192.168.1.81 80 3306 {
  36.         weight 100
  37.     TCP_CHECK {            
  38.     connect_timeout 3
  39.         nb_get_retry 3
  40.         delay_before_retry 3
  41.     connect_port 80 3306       
  42.         }
  43.     }
  44. real_server 192.168.1.82 80 3306 {
  45.         weight 100
  46.     TCP_CHECK {            
  47.     connect_timeout 3
  48.         nb_get_retry 3
  49.         delay_before_retry 3
  50.     connect_port 80 3306        
  51.         }
  52.     }
  53. }
  54. systemctl restart keepalived

安装LAMP

  1. yum install httpd httpd-devel mariadb-libs mariadb-devel mariadb php-mysql 
  2. yum install -y php-gd php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-snmp php-soap curl curl-devel php-bcmath


  1. rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
  2. rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm
  4. yum -y install php72w php72w-cli php72w-fpm php72w-common php72w-devel php72w-mysql

yum install -y php72w php72w-opcache php72w-xml php72w-mcrypt php72w-gd php72w-devel php72w-mysql php72w-intl php72w-mbstring

在网站根目录下创建test.php进行测试

  1. <?php  
  2.     echo phpinfo();  
  3. ?>

systemctl start httpd
systemctl enable httpd
systemctl start keepalived
systemctl enable keepalived

安装rsync

Server1配置

  1. yum install rsync -y
  3. vim /etc/rsyncd.conf 
  4. log file = /var/log/rsyncd.log 
  5. #日志文件位置，启动rsync后自动产生这个文件，无需提前创建
  7. pidfile = /var/run/rsyncd.pid  
  8. #pid文件的存放位置
  10. lock file = /var/run/rsync.lock  
  11. #支持max connections参数的锁文件
  13. secrets file = /etc/rsyncd.password  
  14. #用户认证配置文件，里面保存用户名称和密码，后面会创建这个文件
  16. motd file = /etc/rsyncd.Motd  
  17. #rsync启动时欢迎信息页面文件位置（文件内容自定义）
  19. [web] #自定义名称
  20. path = /var/www/html/  
  21. #rsync服务端数据目录路径
  23. comment = web 
  24. #模块名称与自定义名称相同
  26. uid = root 
  27. #设置rsync运行权限为root
  29. gid = root 
  30. #设置rsync运行权限为root
  32. port = 873  
  33. #默认端口
  35. use chroot = no 
  36. #默认为true，修改为no，增加对目录文件软连接的备份
  38. read only = no  
  39. #设置rsync服务端文件为读写权限
  41. list = yes 
  42. #显示rsync服务端资源列表
  44. max connections = 200 
  45. #最大连接数
  47. timeout = 300  
  48. #设置超时时间
  50. auth users = web 
  51. #虚拟用户名
  53. hosts allow = 192.168.1.82
  54. #允许进行数据同步的服务器，可以设置多个，用英文逗号隔开
  57. systemctl start rsyncd
  58. systemctl enable rsyncd
  60. echo "web:123456" > /etc/rsyncd.password
  61. echo "123456" > /etc/rsyncd.pw
  63. chmod 600 /etc/rsyncd.conf
  64. chmod 600 /etc/rsyncd.password
  65. chmod 600 /etc/rsyncd.pw

Server2配置

  1. yum install rsync -y
  3. vim /etc/rsyncd.conf 
  4. log file = /var/log/rsyncd.log 
  5. #日志文件位置，启动rsync后自动产生这个文件，无需提前创建
  6. pidfile = /var/run/rsyncd.pid  
  7. #pid文件的存放位置
  9. lock file = /var/run/rsync.lock  
  10. #支持max connections参数的锁文件
  12. secrets file = /etc/rsyncd.password  
  13. #用户认证配置文件，里面保存用户名称和密码，后面会创建这个文件
  15. motd file = /etc/rsyncd.Motd  
  16. #rsync启动时欢迎信息页面文件位置（文件内容自定义）
  18. [web] 
  19. #自定义名称
  21. path = /var/www/html/  
  22. #rsync服务端数据目录路径
  24. comment = web 
  25. #模块名称与自定义名称相同
  27. uid = root 
  28. #设置rsync运行权限为root
  30. gid = root 
  31. #设置rsync运行权限为root
  33. port = 873  
  34. #默认端口
  36. use chroot = no 
  37. #默认为true，修改为no，增加对目录文件软连接的备份
  39. read only = no  
  40. #设置rsync服务端文件为读写权限
  42. list = yes 
  43. #显示rsync服务端资源列表
  45. max connections = 200 
  46. #最大连接数
  48. timeout = 300  
  49. #设置超时时间
  51. auth users = web 
  52. #虚拟用户名
  54. hosts allow = 192.168.1.81
  55. #允许进行数据同步的服务器，可以设置多个，用英文逗号隔开
  57. systemctl start rsyncd
  58. systemctl enable rsyncd
  60. echo "web:123456" > /etc/rsyncd.password
  61. echo "123456" > /etc/rsyncd.pw
  63. chmod 600 /etc/rsyncd.conf
  64. chmod 600 /etc/rsyncd.password
  65. chmod 600 /etc/rsyncd.pw
  68. rsync --daemon

安装notify-tools

Server1配置

  1. sysctl -w fs.inotify.max_queued_events="99999999"
  2. sysctl -w fs.inotify.max_user_watches="99999999"
  3. sysctl -w fs.inotify.max_user_instances="65535"
  5. vi /etc/sysctl.conf #添加以下代码
  6. fs.inotify.max_queued_events=99999999
  7. fs.inotify.max_user_watches=99999999
  8. fs.inotify.max_user_instances=65535
  10. vim web.sh
  11. #!/bin/sh
  12. srcdir=/var/www/html/
  13. dstdir=web
  14. rsyncuser=web
  15. rsyncpassdir=/etc/rsyncd.pw
  16. dstip="192.168.1.82"
  17. for ip in $dstip
  18. do
  19.     rsync -avH --port=873 --progress --delete $srcdir $rsyncuser@$ip::$dstdir --password-file=$rsyncpassdir
  20. done
  21.     /usr/bin/inotifywait -mrq --timefmt '%d/%m/%y %H:%M' --format '%T %w%f%e' -e close_write,modify,delete,create,attrib,move $srcdir | while read file
  22. do
  24.     for ip in $dstip
  25.     do
  26.         rsync -avH --port=873 --progress --delete $srcdir $rsyncuser@$ip::$dstdir --password-file=$rsyncpassdir
  27.         echo " ${file} was rsynced" >> /tmp/rsync.log 2>&1
  28.     done
  29. done
  32. chmod a+x web.sh 
  33. vi /etc/rc.d/rc.local
  34. chmod +x /etc/rc.d/rc.local

Server2配置

  1. sysctl -w fs.inotify.max_queued_events="99999999"
  2. sysctl -w fs.inotify.max_user_watches="99999999"
  3. sysctl -w fs.inotify.max_user_instances="65535"
  5. vi /etc/sysctl.conf #添加以下代码
  6. fs.inotify.max_queued_events=99999999
  7. fs.inotify.max_user_watches=99999999
  8. fs.inotify.max_user_instances=65535
  10. vim web.sh
  11. #!/bin/sh
  12. srcdir=/var/www/html/
  13. dstdir=web
  14. rsyncuser=web
  15. rsyncpassdir=/etc/rsyncd.pw
  16. dstip="192.168.1.81"
  17. for ip in $dstip
  18. do
  19.     rsync -avH --port=873 --progress --delete $srcdir $rsyncuser@$ip::$dstdir --password-file=$rsyncpassdir
  20. done
  21.     /usr/bin/inotifywait -mrq --timefmt '%d/%m/%y %H:%M' --format '%T %w%f%e' -e close_write,modify,delete,create,attrib,move $srcdir | while read file
  22. do
  24.     for ip in $dstip
  25.     do
  26.         rsync -avH --port=873 --progress --delete $srcdir $rsyncuser@$ip::$dstdir --password-file=$rsyncpassdir
  27.         echo " ${file} was rsynced" >> /tmp/rsync.log 2>&1
  28.     done
  29. done
  32. chmod a+x web.sh