mairadb+galera+haproxy+keepalived實現mysql負載均衡與高可用

百聯達發表於2017-04-15
AIMySql負載
一：伺服器資源

Haproxy+keepalived    node1   10.116.19.251

Haproxy+keepalived    node2   10.44.90.201

mariadb+galera    node1  10.44.66.2

mariadb+galera    node2 10.116.148.103

mariadb+galera    node3 10.170.142.108

二：mariadb 叢集安裝

請參照上一篇博文，安裝成功後，叢集中新增haproxy訪問使用者

mysql -u root -p
CREATE USER 'haproxy'@' 10.116.19.251';
CREATE USER 'haproxy'@' 10.44.90.201';
FLUSH PRIVILEGES;

三：haproxy 安裝

sudo yum install haproxy

配置haproxy vi /etc/haproxy/haproxy.cfg


點選(此處)摺疊或開啟

  1. #---------------------------------------------------------------------
  2. # Example configuration for a possible web application. See the
  3. # full configuration options online.
  4. #
  5. # http://haproxy.1wt.eu/download/1.4/doc/configuration.txt
  6. #
  7. #---------------------------------------------------------------------

  9. #---------------------------------------------------------------------
  10. # Global settings
  11. #---------------------------------------------------------------------
  12. global
  13.     # to have these messages end up in /var/log/haproxy.log you will
  14.     # need to:
  15.     #
  16.     # 1) configure syslog to accept network log events. This is done
  17.     # by adding the '-r' option to the SYSLOGD_OPTIONS in
  18.     # /etc/sysconfig/syslog
  19.     #
  20.     # 2) configure local2 events to go to the /var/log/haproxy.log
  21.     # file. A line like the following can be added to
  22.     # /etc/sysconfig/syslog
  23.     #
  24.     # local2.* /var/log/haproxy.log
  25.     #
  26.     log 127.0.0.1 local2

  28.     chroot /var/lib/haproxy
  29.     pidfile /var/run/haproxy.pid
  30.     maxconn 4000
  31.     user haproxy
  32.     group haproxy
  33.     daemon

  35.     # turn on stats unix socket
  36.     stats socket /var/lib/haproxy/stats

  38. #---------------------------------------------------------------------
  39. # common defaults that all the 'listen' and 'backend' sections will
  40. # use if not designated in their block
  41. #---------------------------------------------------------------------
  42. defaults
  43.     mode http
  44.     log global
  45.     option httplog
  46.     option dontlognull
  47.     option http-server-close
  48.     option forwardfor except 127.0.0.0/8
  49.     option redispatch
  50.     retries 3
  51.     timeout http-request 10s
  52.     timeout queue 1m
  53.     timeout connect 10s
  54.     timeout client 1m
  55.     timeout server 1m
  56.     timeout http-keep-alive 10s
  57.     timeout check 10s
  58.     maxconn 3000

  60. #---------------------------------------------------------------------
  61. # main frontend which proxys to the backends
  62. #---------------------------------------------------------------------
  63. frontend main *:5000
  64.     acl url_static path_beg -i /static /images /javascript /stylesheets
  65.     acl url_static path_end -i .jpg .gif .png .css .js

  67.     use_backend static if url_static
  68.     default_backend app

  70. #---------------------------------------------------------------------
  71. # static backend for serving up images, stylesheets and such
  72. #---------------------------------------------------------------------
  73. backend static
  74.     balance roundrobin
  75.     server static 127.0.0.1:4331 check

  77. #---------------------------------------------------------------------
  78. # round robin balancing between the various backends
  79. #---------------------------------------------------------------------
  80. backend app
  81.     balance roundrobin
  82.     server app1 127.0.0.1:5001 check
  83.     server app2 127.0.0.1:5002 check
  84.     server app3 127.0.0.1:5003 check
  85.     server app4 127.0.0.1:5004 check

  87. listen mariadb-cluster
  88. bind 0.0.0.0:3306
  89. mode tcp
  90. option tcplog
  91. option mysql-check user haproxy
  92. balance roundrobin
  93. server mdb01 10.44.66.2:3306 check
  94. server mdb02 10.116.148.103:3306 check
  95. server mdb03 10.170.142.108:3306 check

  97. listen web-interface
  98. bind 0.0.0.0:8888
  99. mode http
  100. stats enable
  101. stats uri /
  102. stats realm Strictly\ Private
  103. stats auth admin:admin

啟動haproxy

chkconfig haproxy on
/etc/init.d/haproxy start

haproxy 監控結果



四：安裝keepalived

sudo yum install keepalived -y

配置haproxy+keepalived node1   vi /etc/keepalived/keepalived.conf


點選(此處)摺疊或開啟

  1. global_defs {
  2.         lvs_id LBL01
  3. }
  4.  
  5. vrrp_sync_group SyncGroup01 {
  6.         group {
  7.                 FloatIP1
  8.         }
  9. }
  10.  
  11. vrrp_script check_haproxy {
  12.         script "killall -0 haproxy"
  13.         interval 2
  14.         weight 2
  15. }
  16.  
  17. vrrp_instance FloatIP1 {
  18.         state MASTER
  19.         interface eth0
  20.         virtual_router_id 10
  21.         priority 101
  22.         advert_int 1
  23.         virtual_ipaddress {
  24.                 192.168.1.60
  25.         }
  26.         track_script {
  27.                 check_haproxy
  28.         }
  29. }

配置haproxy+keepalived node2   vi /etc/keepalived/keepalived.conf


點選(此處)摺疊或開啟

  1. global_defs {
  2.         lvs_id LBL01
  3. }
  4.  
  5. vrrp_sync_group SyncGroup01 {
  6.         group {
  7.                 FloatIP1
  8.         }
  9. }
  10.  
  11. vrrp_script check_haproxy {
  12.         script "killall -0 haproxy"
  13.         interval 2
  14.         weight 2
  15. }
  16.  
  17. vrrp_instance FloatIP1 {
  18.         state BACKUP
  19.         interface eth0
  20.         virtual_router_id 10
  21.         priority 100
  22.         advert_int 1
  23.         virtual_ipaddress {
  24.                 192.168.1.60
  25.         }
  26.         track_script {
  27.                 check_haproxy
  28.         }
  29. }


啟動keepalived   

chkconfig keepalived on

/etc/init.d/keepalived start

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28624388/viewspace-2137324/，如需轉載，請註明出處，否則將追究法律責任。

相關文章