一、拓扑图

二、硬件环境

三台服务器 + windows客户端

主机名称

IP地址

服务

备注

 

Dns

192.168.100.100

DNS、HeartBeat

 

 

192.168.100.200

HeartBeat

Dns服务的心跳地址

 

dns2

 

192.168.100.101

Dns、HeartBeat

 

 

n1

192.168.100.102

Nginx、LVS HeartBeat

Mysql

负载均衡、故障转移

 

192.168.100.10/150

LVS-NAT、LVS-DR

 

 

n2

 

192.168.106.103

Nginx、HeartBeat、mysql

负载均衡、故障转移

 

Client

 

 

 

 

四、部署步骤

1.Linux服务配置基础信息设置

修改主机名

[root@localhost ~]# vim /etc/hosts

127.0.0.1   localhost dns localhost4 localhost4.localdomain4

::1         localhost dns localhost6 localhost6.localdomain6

 

[root@localhost ~]# vim /etc/sysconfig/network

NETWORKING=yes

HOSTNAME=dns

NTPSERVERARGS=iburst

[root@localhost ~]# reboot

依次修改主机名分别为

关闭防火墙

[root@dns ~]# iptables -L

Chain INPUT (policy ACCEPT)

target     prot opt source               destination        

Chain FORWARD (policy ACCEPT)

target     prot opt source               destination        

Chain OUTPUT (policy ACCEPT)

target     prot opt source               destination  

 

[root@dns ~]# iptables -F

[root@dns ~]# service iptables stop

 

[root@dns ~]# chkconfig –list iptables

iptables             0:关闭      1:关闭      2:启用      3:启用      4:启用      5:关闭      6:关闭

[root@dns ~]# chkconfig –level 2345 iptables off

[root@dns ~]# chkconfig –list iptables

iptables             0:关闭      1:关闭      2:关闭      3:关闭      4:关闭      5:关闭      6:关闭

配置本地yum源

[root@dns ~]# df -h

Filesystem                    Size  Used Avail Use% Mounted on

/dev/mapper/VolGroup-lv_root   18G  3.8G   13G  24% /

tmpfs                         491M   76K  491M   1% /dev/shm

/dev/sda1                     485M   35M  426M   8% /boot

/dev/sr0                      4.2G  4.2G     0 100% /media/CentOS_6.5_Final

[root@dns ~]# cd /etc/yum.repos.d/

[root@dns yum.repos.d]# ll

[root@dns yum.repos.d]# mv CentOS-Base.repo CentOS-Base.repo.tmp

[root@dns yum.repos.d]# ll

总用量 16

-rw-r–r–. 1 root root 1926 11月 27 2013 CentOS-Base.repo.tmp

-rw-r–r–. 1 root root  638 11月 27 2013 CentOS-Debuginfo.repo

-rw-r–r–. 1 root root  640 11月 25 06:36 CentOS-Media.repo

-rw-r–r–. 1 root root 3664 11月 27 2013 CentOS-Vault.repo

[root@dns yum.repos.d]# vim CentOS-Media.repo

[root@dns yum.repos.d]# cd ~

2.安装DNS服务

[root@dns ~]# yum install -y bind bind-chroot

 

[root@dns ~]# vim /etc/named.conf

 

[root@dns ~]# vim /etc/named.rfc1912.zones

zone “bainan.cn” IN {

        type master;

        file “bn.cn”;

        allow-update { none; };

};

 

zone “100.168.192.in-addr.arpa” IN {

        type master;

        file “100.empty”;

        allow-update { none; };

};

[root@dns ~]# cd /var/named/

[root@dns named]# ll

[root@dns named]# cp named.localhost bn.cn

[root@dns named]# cp named.empty 100.empty

[root@dns named]# chgrp named *

[root@dns named]# ll

总用量 40

-rw-r—–. 1 root  named  270 11月 26 03:26 100.empty

-rw-r—–. 1 root  named  262 11月 26 03:25 bn.cn

drwxr-x—. 6 root  named 4096 11月 25 06:37 chroot

drwxrwx—. 2 named named 4096 11月 25 06:43 data

drwxrwx—. 2 named named 4096 11月 26 03:27 dynamic

-rw-r—–. 1 root  named 1892 2月  18 2008 named.ca

-rw-r—–. 1 root  named  152 12月 15 2009 named.empty

-rw-r—–. 1 root  named  152 6月  21 2007 named.localhost

-rw-r—–. 1 root  named  168 12月 15 2009 named.loopback

drwxrwx—. 2 named named 4096 8月  27 2013 slaves

[root@dns named]# vim bn.cn

$TTL 3H

@       IN SOA  @ dns.bainan.cn. (

                                        0       ; serial

                                        1D      ; refresh

                                        1H      ; retry

                                        1W      ; expire

                                        3H )    ; minimum

        NS      dns.bainan.cn.

dns     IN      A       192.168.100.100

dns2    IN      A       192.168.100.101

n1      IN      A       192.168.100.102

n2      IN      A       192.168.100.103

www     IN      A       192.168.100.200

[root@dns named]# vim 100.empty

$TTL 3H

@       IN SOA  @ dns.bainan.cn. (

                                        0       ; serial

                                        1D      ; refresh

                                        1H      ; retry

                                        1W      ; expire

                                        3H )    ; minimum

        NS      dns.bainan.cn.

100     IN      PTR     dns.bainan.cn.

101     IN      PTR     dns2.bainan.cn.

102     IN      PTR     n1.bainan.cn.

103     IN      PTR     n2.bainan.cn.

200     IN      PTR     www.bainan.cn.

[root@dns named]# service named start

启动 named:                                               [确定]

[root@dns ~]# nslookup

> dns.bainan.cn

Server:               192.168.100.100

Address:   192.168.100.100#53

 

Name:      dns.bainan.cn

Address: 192.168.100.100

> dns2.bainan.cn

Server:               192.168.100.100

Address:   192.168.100.100#53

 

Name:      dns2.bainan.cn

Address: 192.168.100.101

> n1.bainan.cn

Server:               192.168.100.100

Address:   192.168.100.100#53

 

Name:      n1.bainan.cn

Address: 192.168.100.102

> n2.bainan.cn

Server:               192.168.100.100

Address:   192.168.100.100#53

 

Name:      n2.bainan.cn

Address: 192.168.100.103

将dns1的DNS配置文件复制到dns2上

[root@dns ~]# scp /etc/named.conf 192.168.100.101:/etc/named.conf

[root@dns ~]# scp /etc/named.rfc1912.zones 192.168.100.101:/etc/named.rfc1912.zones

[root@dns ~]# scp /var/named/bn.cn 192.168.100.101:/var/named/

[root@dns ~]# scp /var/named/100.empty 192.168.100.101:/var/named/

 

在dns2上启动DNS服务

[root@dns2 yum.repos.d]# cd ~

[root@dns2 ~]# service named start

Generating /etc/rndc.key:                                              [确定]

启动 named:                                               [确定]

[root@n2 ~]# nslookup

> dns.bainan.cn

Server:               192.168.100.100

Address:   192.168.100.100#53

Name:      dns.bainan.cn

Address: 192.168.100.100

> dns2.bainan.cn

Server:               192.168.100.100

Address:   192.168.100.100#53

 

Name:      dns2.bainan.cn

Address: 192.168.100.101

> n1.bainan.cn

Server:               192.168.100.100

Address:   192.168.100.100#53

Name:      n1.bainan.cn

Address: 192.168.100.102

> n2.bainan.cn

Server:               192.168.100.100

Address:   192.168.100.100#53

 

Name:      n2.bainan.cn

Address: 192.168.100.103

[root@dns ~]# chkconfig –list named

named          0:关闭      1:关闭      2:关闭      3:关闭      4:关闭      5:关闭      6:关闭

[root@dns ~]# chkconfig –level 2345 named on

[root@dns ~]# chkconfig –list named

named          0:关闭      1:关闭      2:启用      3:启用      4:启用      5:启用      6:关闭

在dns2上做相同的操作

 

3.HeartBeat 高可用集群

配置个服务器基本网络环境

[root@dns ~]# ifconfig

 

[root@dns2 ~]# ifconfig

 

安装HeartBeat及相关的组件包(本地yum源安装方法)

[root@dns ~]# cd /etc/yum.repos.d/

[root@dns yum.repos.d]# ll

[root@dns yum.repos.d]# rm -f CentOS-Base.repo

[root@dns yum.repos.d]# ll

[root@dns yum.repos.d]# vim CentOS-Media.repo

[c6-media]

name=CentOS-$releasever – Media

baseurl=file:///media/CentOS_6.5_Final/

        file:///media/cdrom/

        file:///media/cdrecorder/

gpgcheck=1

enabled=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6

 

[root@dns yum.repos.d]# cd /tmp/

[root@dns tmp]# mkdir hb

[root@dns tmp]# cd hb/

将HeartBeat相关的组件包复制到/tmp/hb/下

 

[root@dns hb]# yum localinstall -y *.rpm

配置主服务器的HeartBeat

进入HeartBeat的配置文件模板目录,复制模板到配置文件目录中

[root@dns ~]# cd /usr/share/doc/heartbeat-3.0.4/

[root@dns heartbeat-3.0.4]# ls

apphbd.cf  AUTHORS    COPYING       ha.cf        README

authkeys   ChangeLog  COPYING.LGPL  haresources

[root@dns heartbeat-3.0.4]# cp authkeys ha.cf haresources  /etc/ha.d/

[root@dns heartbeat-3.0.4]#  cd /etc/ha.d/

[root@dns ha.d]# ls

authkeys  ha.cf  harc  haresources  rc.d  README.config  resource.d  shellfuncs

 

编辑认证文件authkeys,定义节点服务器间的认证方式

[root@dns ha.d]# vi authkeys

auth 3

1 crc

2 sha1 HI!

3 md5 Hello!

修改authkeys文件的权限

[root@dns ha.d]# ll authkeys

-rw-r–r–. 1 root root 641 11月 26 06:20 authkeys

[root@dns ha.d]#  chmod 600 authkeys

[root@dns ha.d]# ll authkeys

-rw——-. 1 root root 641 11月 26 06:20 authkeys

 

编辑资源管理文件

[root@dns ha.d]# vi haresources

在末行插入

dns   192.168.100.200/24/eth1:0   named

//dns:主服务器名

//192.168.100.200:vip

//named 服务名称

 

编辑主配置文件:

[root@dns ha.d]# vi ha.cf

24 debugfile /var/log/ha-debug      //定义调试信息文件路径

29 logfile /var/log/ha-log          //定义日志文件

48 keepalive 3              //定义心跳检查的时间间隔单位s

56 deadtime 30              //定义死亡时间单位s

61 warntime 10              //定义警告时间为10s(10s没收到心跳就告警)

71 initdead 60              //定义初始化时间为60s

76 udpport 694              //定义udp监听端口为694

122 ucast eth0 192.168.100.101      //定义侦听心跳的接口和对端IP地址

157 auto_failback on            //启用抢占模式

213 node    dns         //定义成员节点

214 node    dns2

254 respawn hacluster /usr/lib64/heartbeat/ipfail   //定义使用该脚本去侦听对方是否活着

配置从服务器的HeartBeat

通过scp将三个主要的配置文件传到dns2上

[root@dns ha.d]# scp authkeys haresources ha.cf 192.168.100.101:/etc/ha.d/

修改心跳设置

[root@dns2 ~]# cd /etc/ha.d/

You have new mail in /var/spool/mail/root

[root@dns2 ha.d]#  vi ha.cf

122 ucast eth1 192.168.100.100

启动HeartBeat的服务,先主后从的启动

[root@dns ha.d]# service heartbeat start

[root@dns ha.d]# service httpd start

正在启动 httpd:

[root@dns ha.d]# service httpd status

httpd (pid  9978) 正在运行…

 

[root@dns ha.d]# ifconfig

 

在从服务器上启动HeartBeat服务

[root@dns2 ha.d]# service heartbeat start

Starting High-Availability services: INFO:  Resource is stopped

Done.

 

[root@dns2 ~]# service httpd start

正在启动 httpd:  

 

[root@dns2 ~]# ifconfig

 

[root@dns ~]# chkconfig –list heartbeat

heartbeat          0:关闭      1:关闭      2:启用      3:启用      4:启用      5:启用      6:关闭

dns2同理

[root@dns2 ~]# chkconfig –list heartbeat

heartbeat          0:关闭      1:关闭      2:启用      3:启用      4:启用      5:启用      6:关闭

访问测试  

 

将上面的Apache替换成Nginx,在n1和n2中安装Nginx服务停掉dns和dns2中httpd服务

Nginx负载均衡

安装Nginx

创建nginx的yum源文件

[root@n1 ~]# vi /etc/yum.repos.d/nginx.repo

[nginx]

name=nginx repo

baseurl=http://nginx.org/packages/centos/6/$basearch/

gpgcheck=0

enabled=1

[root@n1 ~]# yum makecache

 

[root@n1 yum.repos.d]# rpm -ivh nginx-1.10.1-1.el6.ngx.x86_64.rpm

[root@n1 yum.repos.d]# yum -l install nginx

 

[root@n1 yum.repos.d]# which nginx

/usr/sbin/nginx

[root@n1 yum.repos.d]# service nginx status

-b 已停

[root@n1 yum.repos.d]# service nginx start

正在启动 nginx:                                           [确定]

 

安装支持的模块

[root@n1 ~]# yum install zlib

Loaded plugins: fastestmirror, refresh-packagekit, security

Loading mirror speeds from cached hostfile

 * c6-media:

Setting up Install Process

Package zlib-1.2.3-29.el6.x86_64 already installed and latest version

Nothing to do

[root@n1 ~]# yum install pcre

Loaded plugins: fastestmirror, refresh-packagekit, security

Loading mirror speeds from cached hostfile

 * c6-media:

Setting up Install Process

Package pcre-7.8-6.el6.x86_64 already installed and latest version

Nothing to do

[root@n1 ~]# yum install openssl

Loaded plugins: fastestmirror, refresh-packagekit, security

Loading mirror speeds from cached hostfile

 * c6-media:

Setting up Install Process

Package openssl-1.0.1e-15.el6.x86_64 already installed and latest version

Nothing to do

 

[root@n1 ~]# service httpd status

httpd 已停

[root@n1 ~]# chkconfig –list httpd

httpd              0:关闭      1:关闭      2:关闭      3:关闭      4:关闭      5:关闭      6:关闭

 

[root@n1 ~]# chkconfig –level 2345 nginx on

[root@n1 ~]# chkconfig –list nginx

nginx              0:关闭      1:关闭      2:启用      3:启用      4:启用      5:启用      6:关闭

 

[root@n1 ~]# vim /etc/nginx/nginx.conf

      use epoll;

          worker_connections  65535;

      }

 

      http {

          include mime.types;

          default_type application/octet-stream;

          sendfile on;

          tcp_nopush on;

          tcp_nodelay on;

          keepalive_timeout 65;

          server_tokens off;

          server_names_hash_bucket_size 128;

 

                      log_format  ups  \’$remote_addr [$time_local]  $request $status \’

                              \’u_content_t $upstream_http_content_type \’

                              \’u_addr $upstream_addr \’

                              \’u_status $upstream_status \’

                              \’u_rsp_ti $upstream_response_time \’

                      \’$http_user_agent\’ ;

 

     upstream bainan.cn {

             server n1.bainan.cn:80  weight=10       max_fails=3     fail_timeout=20s;

             server n2.bainan.cn:80  weight=10       max_fails=3     fail_timeout=20s;

 

              }

 

              server{

              listen  80;

              server_name www.bainan.cn 192.168.100.200;

              index index.htm index.html;

              root    /website/bainan.cn;

                      location / {

                     access_log  /dev/shm/access.log ups;

                      proxy_pass http://bainan.cn;

                      proxy_redirect off;

                      proxy_set_header Host $remote_addr;

                      proxy_set_header remote_addr $remote_addr;

                      proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;

                      client_body_buffer_size 128K;

                      proxy_connect_timeout 90;

                      proxy_send_timeout 90;

                      proxy_read_timeout 90;

                      proxy_buffer_size 64k;

                      proxy_buffers   4 32k;

                      proxy_busy_buffers_size 64k;

                      proxy_temp_file_write_size 64k;

                      }

              error_page   500 502 503 504  /50x.html;

              location = /50x.html {

                  root   /usr/share/nginx/html;

                      }

              }

      }

[root@n1 ~]# nginx -s reload

在Client上创建测试站点

N1

 

 

N2

 

 

 

 

虚拟IP:192.168.100.200

(VIP)

LVS负载均衡(NAT)配置-wrr

[root@n1 桌面]# ifconfig eth1:0 192.168.100.200 netmask 255.255.255.0

[root@n1 桌面]# ifup eth1:0

eth1:0    Link encap:Ethernet  HWaddr 00:0C:29:36:85:9E 

          inet addr:192.168.100.200  Bcast:192.168.100.255  Mask:255.255.255.0

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

[root@n2 桌面]# ifconfig eth1:1 192.168.100.110 netmask 255.255.255.0

[root@n2 桌面]# ifup eth0

eth1:1    Link encap:Ethernet  HWaddr 00:0C:29:36:85:9E 

          inet addr:192.168.100.111  Bcast:192.168.100.255  Mask:255.255.255.0

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

在Node1上安装ipvsadm及其组件

[root@n1 ~]# cd 桌面

[root@n1 桌面]# yum localinstall popt-static-1.13-7.el6.x86_64.rpm

[root@n1 桌面]# yum install -y libnl*

[root@n1 桌面]# yum install -y ipvsadm

查看和加载ipvsadm是否在内核模块中

[root@n1 桌面]# lsmod | grep ip_vs

[root@n1 桌面]# modprobe ip_vs

[root@n1 桌面]# lsmod | grep ip_vs

 

[root@n1 桌面]# ifconfig eth1:1 192.168.100.110 netmask 255.255.255.0

[root@n1 桌面]# ifconfig eth1:1

eth1:1    Link encap:Ethernet  HWaddr 00:0C:29:08:C8:EE 

          inet addr:192.168.100.110  Bcast:192.168.100.255  Mask:255.255.255.0

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

 

[root@n1 桌面]# ipvsadm -C

[root@n1 桌面]# ipvsadm –set 30 5 60

[root@n1 桌面]# ipvsadm -A -t 192.168.100.200:80 -s wrr -p 20

[root@n1 桌面]# ipvsadm -L

 

[root@n1 桌面]# ipvsadm -a -t 192.168.100.200:80 -r 192.168.100.110:80 -g -w 1

[root@n1 桌面]# ipvsadm -L -n

IP Virtual Server version 1.2.1 (size=4096)

Prot LocalAddress:Port Scheduler Flags

  -> RemoteAddress:Port           Forward Weight ActiveConn InActConn

TCP  192.168.100.200:80 wrr persistent 20

  -> 192.168.100.110:80           Route   1      0          0    

[root@n1 桌面]# ifconfig eth1:1 192.168.100.110 netmask 255.255.255.0

[root@n1 桌面]# ifconfig lo:0 192.168.100.200 netmask 255.255.255.255

[root@n1 桌面]# echo 1 > /proc/sys/net/ipv4/conf/lo/arp_ignore

[root@n1 桌面]# echo 2 > /proc/sys/net/ipv4/conf/lo/arp_announce

[root@n1 桌面]# echo 1 > /proc/sys/net/ipv4/conf/all/arp_ignore

[root@n1 桌面]# echo 2 > /proc/sys/net/ipv4/conf/all/arp_announce

 

n2同理

 

LVS负载均衡(DR)配置加DNS

安装DNS服务、配置yum源步骤同上

[root@dns ~]# lsmod |grep ip_vs

[root@dns ~]# modprobe ip_vs

[root@dns ~]# lsmod |grep ip_vs

 

[root@dns ~]# yum install ipvsadm

 

[root@dns ~]# ipvsadm -S

[root@dns ~]# ipvsadm -L

[root@dns ~]# ifconfig

 

root@dns ~]# ifconfig eth1:1 192.168.100.10 netmask 255.255.255.0

[root@dns ~]# ifconfig

[root@dns ~]# ipvsadm -A -t 192.168.100.10:80 -s wlc

[root@dns ~]# ipvsadm -a -t 192.168.100.10:80 -r 192.168.100.102 -g -w 2

[root@dns ~]# ipvsadm -a -t 192.168.100.10:80 -r 192.168.100.103 -g -w 1

[root@dns ~]# ipvsadm -S

 

[root@dns ~]# ipvsadm -L

 

[root@dns ~]# service ipvsadm save

ipvsadm: Saving IPVS table to /etc/sysconfig/ipvsadm:      [确定]

[root@dns ~]# cat /etc/sysconfig/ipvsadm

 

[root@dns ~]# service ipvsadm restart

ipvsadm: Clearing the current IPVS table:                  [确定]

ipvsadm: Unloading modules:                                [确定]

ipvsadm: Clearing the current IPVS table:                  [确定]

ipvsadm: Applying IPVS configuration:                      [确定]

 

[root@dns ~]# ipvsadm -L

 

转到n1上

[root@n1 ~]# ifconfig lo:0 192.168.100.10 netmask 255.255.255.255

[root@n1 ~]# echo 1 > /proc/sys/net/ipv4/conf/lo/arp_ignore

[root@n1 ~]# echo 1 > /proc/sys/net/ipv4/conf/all/arp_ignore

[root@n1 ~]# echo 2 > /proc/sys/net/ipv4/conf/all/arp_announce

[root@n1 ~]# echo 2 > /proc/sys/net/ipv4/conf/lo/arp_announce

 

[root@n1 ~]# ifconfig

转到n1上

[root@n1 ~]# ifconfig lo:0 192.168.100.10 netmask 255.255.255.255

[root@n1 ~]# echo 1 > /proc/sys/net/ipv4/conf/lo/arp_ignore

[root@n1 ~]# echo 1 > /proc/sys/net/ipv4/conf/all/arp_ignore

[root@n1 ~]# echo 2 > /proc/sys/net/ipv4/conf/all/arp_announce

[root@n1 ~]# echo 2 > /proc/sys/net/ipv4/conf/lo/arp_announce

 

[root@n1 ~]# ifconfig

 

转到n2上

[root@n2 ~]# ifconfig

[root@n2 ~]# ifconfig lo:0 192.168.100.10 netmask 255.255.255.255

 

[root@n2 ~]# echo 1 > /proc/sys/net/ipv4/conf/lo/arp_ignore

[root@n2 ~]# echo 1 > /proc/sys/net/ipv4/conf/all/arp_ignore

[root@n2 ~]#  echo 1 > /proc/sys/net/ipv4/conf/all/arp_ignore

[root@n2 ~]#  echo 2 > /proc/sys/net/ipv4/conf/lo/arp_announce

 

[root@n2 ~]# service nginx stop

停止 nginx:                                               [确定]

[root@n2 ~]# service httpd start

正在启动 httpd:httpd: Could not reliably determine the server\’s fully qualified domain name, using ::1 for ServerName

                                                           [确定]

 

 

Heartbeat双热备(安装Mysql)

在dns主机上

添加mysql的DNS正反向查找

[root@dns ~]# cd /var/named/

[root@dns named]# ll

在DNS服务中天sql正反向解析, 详细步骤参照前面DNS服务部署步骤哦

[root@dns named]# vim bn.cn

[root@dns named]# vim 100.empty

安装mysql服务

[root@dns ~]# rpm -ivh mysql-community-server-8.0.13-1.el6.x86_64.rpm

[root@dns ~]# mysql -n root

[root@dns ~]# service mysqld start

 

 

n1、n2 同理安装MySql’

 

 

[root@dns ~]# mysql -n root -h 192.168.100.102 -p

[root@dns ~]#

N2

[root@n2 ~]# mysqladmin -u root password ‘123456’

[root@n2 ~]# mysql -u root -p

输入密码

Mysql> shoy database;

 

Mysql> create database stus;

 

Mysql> use stus;

 

Mysql> create table students(id char(8) not null,name varchae(20) npt null,age int ,primary key(id));

 

Mysql> desc students;

 

Mysql> show tables;

 

Mysql> insert into students(id,name,age) values(‘20190301’,’llili’,20);

 

Mysql> select * from students;

 

Mysql> quit

 

[root@n2 ~]# mysql -u root -h 192.168.100.102 -p

[root@n2 ~]# mysql -u root -h 127.0.0.1 -p

 

 

# gedit /etc/my.cnf

7# bind-address=0.0.0.0

 

#service mysqld restart

 

[root@n2 ~]# mysql -u root -h 192.168.100.102 -p

[root@n2 ~]# mysql -u root -h 127.0.0.1 -p

 

>show database;

>use mysql;

>desc database;

 

>select host,user from user;

> update user set host=’%’ where host=’n2’;

>select host,user from user;

 

>quit

#mysql -u root -h 192.168.100.103 -p

#service mysqld restart

[root@n2 ~]# mysql -u root -h 192.168.100.102 -p

[root@n2 ~]# mysql -u root -h 127.0.0.1 -p

>use musql

>select host,user from user;

>flush privileges;

> update user set host=’n2’ where host=’%’;

>select host,user from user;

> update user set host=’%’ where host=’127.0.0.1’;

>select host,user from user;

>select host,user,password from user;

> update user set host=’127.0.0.1’ where host=’%’;

>select host,user,password from user;

> update user set host=’127.0.0.1’ where host=’root’;

>quit

N1同理

dns#mysql -n root -h 192.168.100.102 -p

dns#mysql -n root -h 192.168.100.101 -p

在n1和n2上添加Hertbeat服务,故障转移#

Heartbeat安装过程参照文档前面Heartbeat安装步骤

注意hare****文件155行添加

N1   192.168.100.2150/24/eth1:0   mysqld

N2 同理。

 

版权声明:本文为bainanblogs原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://www.cnblogs.com/bainanblogs/articles/10042970.html