RHCS套件实现高可用负载均衡集群（三）——共享存储

最新推荐文章于 2022-04-30 10:10:26 发布

20butterfly

最新推荐文章于 2022-04-30 10:10:26 发布

阅读量314

点赞数

CC 4.0 BY-SA版权

文章标签： linux

本文链接：https://blog.youkuaiyun.com/hh5820/article/details/81387976

本文介绍如何通过iSCSI配置共享存储，并使用GFS2集群文件系统实现两台服务器间的高可用性MySQL集群。文章详细记录了从安装配置iSCSI目标器与启动器、创建LVM卷组、搭建MySQL集群到最终实现服务自动迁移的全过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

注：此博文在博文“RHCS套件实现高可用负载均衡集群（二）”的基础上完成

实验开始前设置实验环境

target端配置——server3

[root@server3 ~]# yum install -y scsi-*
[root@server3 ~]# vim /etc/tgt/targets.conf 
 38 <target iqn.2008-09.com.example:server.target1>
 39     backing-store /dev/vdb
 40     initiator-address 172.25.54.1
 41     initiator-address 172.25.54.2
 42 </target>
 [root@server3 ~]# /etc/init.d/tgtd start
Starting SCSI target daemon:                               [  OK  ]
[root@server3 ~]# tgt-admin -s
Target 1: iqn.2008-09.com.example:server.target1
    System information:
        Driver: iscsi
        State: ready
    I_T nexus information:
    LUN information:
        LUN: 0
            Type: controller
            SCSI ID: IET     00010000
            SCSI SN: beaf10
            Size: 0 MB, Block size: 1
            Online: Yes
            Removable media: No
            Prevent removal: No
            Readonly: No
            Backing store type: null
            Backing store path: None
            Backing store flags: 
        LUN: 1
            Type: disk
            SCSI ID: IET     00010001
            SCSI SN: beaf11
            Size: 21475 MB, Block size: 512
            Online: Yes
            Removable media: No
            Prevent removal: No
            Readonly: No
            Backing store type: rdwr
            Backing store path: /dev/vdb
            Backing store flags: 
    Account information:
    ACL information:
        172.25.54.1
        172.25.54.2
[root@server3 ~]#

initiator端配置——server1、server2

[root@server1 ~]# yum install -y iscsi-*
[root@server2 ~]# yum install -y iscsi-*

server1

[root@server1 ~]# iscsiadm -m discovery -t st -p 172.25.54.3
##发现 iSCSI 设备
Starting iscsid:                                           [  OK  ]
172.25.54.3:3260,1 iqn.2008-09.com.example:server.target1
[root@server1 ~]# iscsiadm -m node -l
##登录并导入 iSCSI 设备
Logging in to [iface: default, target: iqn.2008-09.com.example:server.target1, portal: 172.25.54.3,3260] (multiple)
Login to [iface: default, target: iqn.2008-09.com.example:server.target1, portal: 172.25.54.3,3260] successful.
[root@server1 ~]# fdisk -l  ##存在 /dev/sda
Disk /dev/sda: 21.5 GB, 21474836480 bytes
64 heads, 32 sectors/track, 20480 cylinders
Units = cylinders of 2048 * 512 = 1048576 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
[root@server1 ~]# /etc/init.d/clvmd status
clvmd (pid  1264) is running...
Clustered Volume Groups: (none)
Active clustered Logical Volumes: (none)
[root@server1 ~]# lvs
  LV      VG       Attr       LSize   Pool Origin Data%  Move Log Cpy%Sync Convert
  lv_root VolGroup -wi-ao----  18.54g                                             
  lv_swap VolGroup -wi-ao---- 992.00m                                             
[root@server1 ~]#

server2

[root@server2 ~]# iscsiadm -m discovery -t st -p 172.25.54.3
Starting iscsid:                                           [  OK  ]
172.25.54.3:3260,1 iqn.2008-09.com.example:server.target1
[root@server2 ~]# iscsiadm -m node -l
Logging in to [iface: default, target: iqn.2008-09.com.example:server.target1, portal: 172.25.54.3,3260] (multiple)
Login to [iface: default, target: iqn.2008-09.com.example:server.target1, portal: 172.25.54.3,3260] successful.
[root@server2 ~]# cat /proc/partitions 
major minor  #blocks  name

 252        0   20971520 vda
 252        1     512000 vda1
 252        2   20458496 vda2
 253        0   19439616 dm-0
 253        1    1015808 dm-1
   8        0   20971520 sda
[root@server2 ~]#

LVM创建

##server1
[root@server1 ~]# pvcreate /dev/sda 
  Physical volume "/dev/sda" successfully created
[root@server1 ~]# pvs
  PV         VG        Fmt  Attr PSize  PFree 
  /dev/sda   clustervg lvm2 a--  20.00g 16.00g
  /dev/vda2  VolGroup  lvm2 a--  19.51g     0 
[root@server1 ~]#

##server2
[root@server2 ~]# pvs    ##还未同步
  PV         VG       Fmt  Attr PSize  PFree
  /dev/vda2  VolGroup lvm2 a--  19.51g    0 
[root@server2 ~]# pvs    ##已同步
  PV         VG       Fmt  Attr PSize  PFree 
  /dev/sda            lvm2 a--  20.00g 20.00g
  /dev/vda2  VolGroup lvm2 a--  19.51g     0 
[root@server2 ~]#

##server1
[root@server1 ~]# vgcreate clustervg /dev/sda 
  Clustered volume group "clustervg" successfully created
[root@server1 ~]# vgs
  VG        #PV #LV #SN Attr   VSize  VFree 
  VolGroup    1   2   0 wz--n- 19.51g     0 
  clustervg   1   1   0 wz--nc 20.00g 16.00g
[root@server1 ~]#

##server2
[root@server2 ~]# vgs
  VG        #PV #LV #SN Attr   VSize  VFree 
  VolGroup    1   2   0 wz--n- 19.51g     0 
  clustervg   1   0   0 wz--nc 20.00g 20.00g
[root@server2 ~]#

##server1
[root@server1 ~]# lvcreate -L 4G -n demo clustervg
  Logical volume "demo" created
[root@server1 ~]# lvs
  LV      VG        Attr       LSize   Pool Origin Data%  Move Log Cpy%Sync Convert
  lv_root VolGroup  -wi-ao----  18.54g                                             
  lv_swap VolGroup  -wi-ao---- 992.00m                                             
  demo    clustervg -wi-a-----   4.00g                                             
[root@server1 ~]# 

##server2
[root@server2 ~]# lvs
  LV      VG        Attr       LSize   Pool Origin Data%  Move Log Cpy%Sync Convert
  lv_root VolGroup  -wi-ao----  18.54g                                             
  lv_swap VolGroup  -wi-ao---- 992.00m                                             
  demo    clustervg -wi-a-----   4.00g                                             
[root@server2 ~]#

[root@server1 ~]# mkfs.ext4 /dev/clustervg/demo 
[root@server1 ~]# clusvcadm -d nginx 
##关闭前面实验的nginx
Local machine disabling service:nginx...Success
[root@server1 ~]#

这里写图片描述

Mysql 测试——挂载测试

[root@server1 ~]# yum install -y mysql-server
[root@server2 ~]# yum install -y mysql-server

[root@server1 ~]# ll -d /var/lib/mysql/
drwxr-xr-x 2 mysql mysql 4096 Aug  9  2013 /var/lib/mysql/
[root@server1 ~]# cd /var/lib/mysql/
[root@server1 mysql]# ls
[root@server1 mysql]# ll -d .
drwxr-xr-x 2 mysql mysql 4096 Aug  9  2013 .
[root@server1 mysql]# cd
[root@server1 ~]# mount /dev/clustervg/demo /var/lib/mysql/
[root@server1 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1228212  16934140   7% /
tmpfs                           510188   25656    484532   6% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
/dev/mapper/clustervg-demo     4128448  139256   3779480   4% /var/lib/mysql
[root@server1 ~]# ll -d /var/lib/mysql/
drwxr-xr-x 3 root root 4096 Aug  2 15:49 /var/lib/mysql/
[root@server1 ~]# chown mysql.mysql /var/lib/mysql/
[root@server1 ~]# ll -d /var/lib/mysql/
drwxr-xr-x 3 mysql mysql 4096 Aug  2 15:49 /var/lib/mysql/
[root@server1 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1228212  16934140   7% /
tmpfs                           510188   25656    484532   6% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
/dev/mapper/clustervg-demo     4128448  139256   3779480   4% /var/lib/mysql
[root@server1 ~]# /etc/init.d/mysqld start
[root@server1 ~]# cd -
/var/lib/mysql
[root@server1 mysql]# ls
ibdata1  ib_logfile0  ib_logfile1  lost+found  mysql  mysql.sock  test
[root@server1 mysql]# /etc/init.d/mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@server1 mysql]# cd
[root@server1 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1228216  16934136   7% /
tmpfs                           510188   25656    484532   6% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
/dev/mapper/clustervg-demo     4128448  160724   3758012   5% /var/lib/mysql
[root@server1 ~]# umount /var/lib/mysql/
[root@server1 ~]# 

[root@server2 ~]# mount /dev/clustervg/demo /var/lib/mysql/
[root@server2 ~]# ll -d /var/lib/mysql/
drwxr-xr-x 5 mysql mysql 4096 Aug  2 16:02 /var/lib/mysql/
[root@server2 ~]# cd /var/lib/mysql/
[root@server2 mysql]# ls
ibdata1  ib_logfile0  ib_logfile1  lost+found  mysql  test
[root@server2 mysql]# /etc/init.d/mysqld start
Starting mysqld:                                           [  OK  ]
[root@server2 mysql]# /etc/init.d/mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@server2 mysql]# cd
[root@server2 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1148688  17013664   7% /
tmpfs                           510188   25656    484532   6% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
/dev/mapper/clustervg-demo     4128448  160724   3758012   5% /var/lib/mysql
[root@server2 ~]# umount /var/lib/mysql/
[root@server2 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1148688  17013664   7% /
tmpfs                           510188   25656    484532   6% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
[root@server2 ~]#

这里写图片描述

[root@server1 ~]# clustat 
Cluster Status for tutu @ Thu Aug  2 16:13:35 2018
Member Status: Quorate

 Member Name                                        ID   Status
 ------ ----                                        ---- ------
 server1                                                1 Online, Local, rgmanager
 server2                                                2 Online, rgmanager

 Service Name                              Owner (Last)                              State         
 ------- ----                              ----- ------                              -----         
 service:mysql                             server1                                   started       
[root@server1 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1228232  16934120   7% /
tmpfs                           510188   25656    484532   6% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
/dev/mapper/clustervg-demo     4128448  160724   3758012   5% /var/lib/mysql
[root@server1 ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.71 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+---------------------+
| Database            |
+---------------------+
| information_schema  |
| #mysql50#lost+found |
| mysql               |
| test                |
+---------------------+
4 rows in set (0.00 sec)

mysql> quit
Bye
[root@server1 ~]# cd /var/lib/mysql/
[root@server1 mysql]# ls
ibdata1  ib_logfile0  ib_logfile1  lost+found  mysql  mysql.sock  test
[root@server1 mysql]# cd
[root@server1 ~]#

这里写图片描述

[root@server1 ~]# clustat 
Cluster Status for tutu @ Thu Aug  2 16:30:18 2018
Member Status: Quorate

 Member Name                                        ID   Status
 ------ ----                                        ---- ------
 server1                                                1 Online, Local, rgmanager
 server2                                                2 Online, rgmanager

 Service Name                              Owner (Last)                              State         
 ------- ----                              ----- ------                              -----         
 service:mysql                             server1                                   stopping      
 ##server1 正在停止   
[root@server1 ~]# clustat 
Cluster Status for tutu @ Thu Aug  2 16:30:32 2018
Member Status: Quorate

 Member Name                                        ID   Status
 ------ ----                                        ---- ------
 server1                                                1 Online, Local, rgmanager
 server2                                                2 Online, rgmanager

 Service Name                              Owner (Last)                              State         
 ------- ----                              ----- ------                              -----         
 service:mysql                             server2                                   started       
##server2 开始工作
[root@server1 ~]#

这里写图片描述

集群化文件系统

本地文件系统演示

[root@server2 ~]# clustat 
Cluster Status for tutu @ Thu Aug  2 17:08:17 2018
Member Status: Quorate

 Member Name                                        ID   Status
 ------ ----                                        ---- ------
 server1                                                1 Online, rgmanager
 server2                                                2 Online, Local, rgmanager

 Service Name                              Owner (Last)                              State         
 ------- ----                              ----- ------                              -----         
 service:mysql                             server2                                   started       
[root@server2 ~]# clusvcadm -d mysql
Local machine disabling service:mysql...Success
[root@server2 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1148744  17013608   7% /
tmpfs                           510188   25656    484532   6% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
[root@server2 ~]#

这里写图片描述

[root@server1 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1228292  16934060   7% /
tmpfs                           510188   25656    484532   6% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
[root@server1 ~]# lvs
  LV      VG        Attr       LSize   Pool Origin Data%  Move Log Cpy%Sync Convert
  lv_root VolGroup  -wi-ao----  18.54g                                             
  lv_swap VolGroup  -wi-ao---- 992.00m                                             
  demo    clustervg -wi-a-----   4.00g                                             
[root@server1 ~]# mount /dev/clustervg/demo /var/lib/mysql/
[root@server1 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1228292  16934060   7% /
tmpfs                           510188   25656    484532   6% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
/dev/mapper/clustervg-demo     4128448  160724   3758012   5% /var/lib/mysql

[root@server1 ~]# vgs
  VG        #PV #LV #SN Attr   VSize  VFree 
  VolGroup    1   2   0 wz--n- 19.51g     0 
  clustervg   1   1   0 wz--nc 20.00g 16.00g
[root@server1 ~]# 

[root@server2 ~]# vgs
  VG        #PV #LV #SN Attr   VSize  VFree 
  VolGroup    1   2   0 wz--n- 19.51g     0 
  clustervg   1   1   0 wz--nc 20.00g 16.00g
[root@server2 ~]#

[root@server1 ~]# lvextend -L +8G /dev/clustervg/demo 
##逻辑卷拉伸
  Extending logical volume demo to 12.00 GiB
  Logical volume demo successfully resized
[root@server1 ~]# vgs
  VG        #PV #LV #SN Attr   VSize  VFree
  VolGroup    1   2   0 wz--n- 19.51g    0 
  clustervg   1   1   0 wz--nc 20.00g 8.00g
[root@server1 ~]#

[root@server2 ~]# vgs
  VG        #PV #LV #SN Attr   VSize  VFree
  VolGroup    1   2   0 wz--n- 19.51g    0 
  clustervg   1   1   0 wz--nc 20.00g 8.00g
[root@server2 ~]#

[root@server2 ~]# lvs
  LV      VG        Attr       LSize   Pool Origin Data%  Move Log Cpy%Sync Convert
  lv_root VolGroup  -wi-ao----  18.54g                                             
  lv_swap VolGroup  -wi-ao---- 992.00m                                             
  demo    clustervg -wi-a-----  12.00g                                             
[root@server2 ~]#

[root@server1 ~]# lvs
  LV      VG        Attr       LSize   Pool Origin Data%  Move Log Cpy%Sync Convert
  lv_root VolGroup  -wi-ao----  18.54g                                             
  lv_swap VolGroup  -wi-ao---- 992.00m                                             
  demo    clustervg -wi-ao----  12.00g                                             
[root@server1 ~]#

[root@server1 ~]# resize2fs /dev/clustervg/demo 
[root@server1 ~]# df -h
Filesystem                    Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root   19G  1.2G   17G   7% /
tmpfs                         499M   26M  474M   6% /dev/shm
/dev/vda1                     485M   33M  427M   8% /boot
/dev/mapper/clustervg-demo     12G  159M   12G   2% /var/lib/mysql
[root@server1 ~]#

[root@server2 ~]# mount /dev/clustervg/demo /var/lib/mysql/
[root@server2 ~]# df -h
Filesystem                    Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root   19G  1.1G   17G   7% /
tmpfs                         499M   26M  474M   6% /dev/shm
/dev/vda1                     485M   33M  427M   8% /boot
/dev/mapper/clustervg-demo     12G  159M   12G   2% /var/lib/mysql
[root@server2 ~]#

[root@server1 ~]# cd /var/lib/mysql/
[root@server1 mysql]# ls
ibdata1  ib_logfile0  ib_logfile1  lost+found  mysql  test
[root@server1 mysql]# cp /etc/passwd .
[root@server1 mysql]# ls
ibdata1  ib_logfile0  ib_logfile1  lost+found  mysql  passwd  test
[root@server1 mysql]#

[root@server2 ~]# cd /var/lib/mysql/
[root@server2 mysql]# ls
##此时会有一个错误提示
ls: cannot access passwd: Input/output error
ibdata1  ib_logfile0  ib_logfile1  lost+found  mysql  passwd  test
[root@server2 mysql]#  cd
[root@server2 ~]# umount /var/lib/mysql/
[root@server2 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1148752  17013600   7% /
tmpfs                           510188   25656    484532   6% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
[root@server2 ~]#

[root@server1 mysql]# cd
[root@server1 ~]# umount /var/lib/mysql/
[root@server1 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1228296  16934056   7% /
tmpfs                           510188   25656    484532   6% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
[root@server1 ~]#

这种方式一个文件修改后，在另一台主机上看不到更改后的内容
因为所用的文件系统是ext4，这是一种本地的文件系统，所以更改后不能同时生效
真实的生产环境中是不能用这种方式实现磁盘共享的

解决方法：使用网路文件系统gfs2

使用这种文件系统，两个initiator端要实现通信，实现通信的方法是将initiator主机加入到一个集群中
GFS2 作为 RedHat
集群文件系统采用分布式元数据和多日志方式(multiple journal),并且 RedHat 仅支持 GFS2
文件系统作为高可用性集群文件系统部署使用。因为性能问题,从 RedHat Enterprise Linux 6
开始,GFS2 不再被支持作为单节点文件系统使用。

集群化文件系统

##查看集群中的主机
[root@server1 ~]# clustat 
Cluster Status for tutu @ Thu Aug  2 17:30:23 2018
Member Status: Quorate

 Member Name                                        ID   Status
 ------ ----                                        ---- ------
 server1                                                1 Online, Local, rgmanager
 server2                                                2 Online, rgmanager

 Service Name                              Owner (Last)                              State         
 ------- ----                              ----- ------                              -----         
 service:mysql                             (server2)                                 disabled         
[root@server1 ~]# mkfs.gfs2 -j 3 -p lock_dlm -t tutu:mygfs2 /dev/clustervg/demo 
##格式化磁盘创建文件系统
## -j 3  通常日志的存放文件个数是节点数+1
[root@server1 ~]# mount /dev/clustervg/demo /var/lib/mysql/
[root@server1 ~]# cd /var/lib/mysql/
[root@server1 mysql]# ll
total 0
[root@server1 mysql]# ll -d
drwxr-xr-x 2 root root 3864 Aug  2 17:40 .
[root@server1 mysql]# 

[root@server2 ~]# mount /dev/clustervg/demo /var/lib/mysql/
[root@server2 ~]# ll -d /var/lib/mysql/
drwxr-xr-x 2 root root 3864 Aug  2 17:40 /var/lib/mysql/
[root@server2 ~]#

[root@server1 mysql]# /etc/init.d/mysqld 
[root@server1 mysql]# ll -d
drwxr-xr-x 4 mysql mysql 3864 Aug  2 17:44 .
[root@server1 mysql]# ls
ibdata1  ib_logfile0  ib_logfile1  mysql  mysql.sock  test
[root@server1 mysql]#

[root@server2 ~]# ll -d /var/lib/mysql/
drwxr-xr-x 4 mysql mysql 3864 Aug  2 17:44 /var/lib/mysql/
[root@server2 ~]# ls /var/lib/mysql/
ibdata1  ib_logfile0  ib_logfile1  mysql  mysql.sock  test
[root@server2 ~]#


[root@server2 ~]# gfs2_tool sb /dev/clustervg/demo all
##配置、调试文件系统或收集有关文件系统的信息
  mh_magic = 0x01161970
  mh_type = 1
  mh_format = 100
  sb_fs_format = 1801
  sb_multihost_format = 1900
  sb_bsize = 4096
  sb_bsize_shift = 12
  no_formal_ino = 2
  no_addr = 23
  no_formal_ino = 1
  no_addr = 22
  sb_lockproto = lock_dlm
  sb_locktable = tutu:mygfs2
  uuid = b81d11be-6c2d-2841-1980-30410272190f
[root@server2 ~]# gfs2_tool journals /dev/clustervg/demo all
journal2 - 128MB
journal1 - 128MB
journal0 - 128MB
3 journal(s) found.
[root@server2 ~]# 

[root@server1 mysql]# /etc/init.d/mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@server1 mysql]# cd
[root@server1 ~]#

##开机自动挂载测试
[root@server1 ~]# vim /etc/fstab 
[root@server1 ~]# cat /etc/fstab | tail -n 1
/dev/clustervg/demo /var/lib/mysql      gfs2    _netdev     0 0
[root@server1 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1228304  16934048   7% /
tmpfs                           510188   31816    478372   7% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
/dev/mapper/clustervg-demo    12581504  286520  12294984   3% /var/lib/mysql
[root@server1 ~]# umount /var/lib/mysql/
[root@server1 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1228304  16934048   7% /
tmpfs                           510188   25656    484532   6% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
[root@server1 ~]# mount -a
[root@server1 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1228304  16934048   7% /
tmpfs                           510188   31816    478372   7% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
/dev/mapper/clustervg-demo    12581504  286520  12294984   3% /var/lib/mysql
[root@server1 ~]#

[root@server2 ~]# vim /etc/fstab 
[root@server2 ~]# cat /etc/fstab | tail -n 1
/dev/clustervg/demo /var/lib/mysql      gfs2    _netdev     0 0
[root@server2 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1148760  17013592   7% /
tmpfs                           510188   31816    478372   7% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
/dev/mapper/clustervg-demo    12581504  286520  12294984   3% /var/lib/mysql
[root@server2 ~]# mount -a
[root@server2 ~]# df
Filesystem                   1K-blocks    Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root  19134332 1148760  17013592   7% /
tmpfs                           510188   31816    478372   7% /dev/shm
/dev/vda1                       495844   33466    436778   8% /boot
/dev/mapper/clustervg-demo    12581504  286520  12294984   3% /var/lib/mysql
[root@server2 ~]#

[root@server1 ~]# clustat 
Cluster Status for tutu @ Thu Aug  2 17:54:33 2018
Member Status: Quorate

 Member Name                                        ID   Status
 ------ ----                                        ---- ------
 server1                                                1 Online, Local, rgmanager
 server2                                                2 Online, rgmanager

 Service Name                              Owner (Last)                              State         
 ------- ----                              ----- ------                              -----         
 service:mysql                             (server2)                                 disabled      
[root@server1 ~]# clusvcadm -e mysql   
##本节点，即server1 启用 mysql 服务
Local machine trying to enable service:mysql...Success
service:mysql is now running on server1
[root@server1 ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.71 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> quit
Bye
[root@server1 ~]# clusvcadm -r mysql -m server2   
## 切换节点进行 mysql 服务
Trying to relocate service:mysql to server2...Success
service:mysql is now running on server2
[root@server1 ~]# clustat 
Cluster Status for tutu @ Thu Aug  2 18:06:07 2018
Member Status: Quorate

 Member Name                                                   ID   Status
 ------ ----                                                   ---- ------
 server1                                                           1 Online, Local, rgmanager
 server2                                                           2 Online, rgmanager

 Service Name                                         Owner (Last)                                         State         
 ------- ----                                         ----- ------                                         -----         
 service:mysql                                        server2                                              started       
[root@server1 ~]#

[root@server2 ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.71 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> quit
Bye
[root@server2 ~]#