本文介绍如何通过iSCSI配置共享存储，并使用GFS2集群文件系统实现两台服务器间的高可用性MySQL集群。文章详细记录了从安装配置iSCSI目标器与启动器、创建LVM卷组、搭建MySQL集群到最终实现服务自动迁移的全过程。
注：此博文在博文“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 ~]#
扫一扫
281
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
