LINUX7 HA(mysql)
服务器信息：
操作系统：CentOS Linux release 7.7.1908 (Core)
| 主机名 |
|
| ha1 | 192.168.198.180/24 |
| ha2 | 192.168.198.190/24 |
各节点安装HA软件：
[root@ha1 yum.repos.d]# yum install pcs fence-agents-all
各节点关闭防火墙及selinux
systemctl stop firewalld.service systemctl disable firewalld.service sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config setenforce 0
各节点设置hacluster用户密码（保持一样）
[root@ha1 yum.repos.d]# passwd hacluster Changing password for user hacluster. New password: BAD PASSWORD: The password is shorter than 8 characters Retype new password: passwd: all authentication tokens updated successfully.
各节点启用pcsd服务并开启自启动
[root@ha1 yum.repos.d]# systemctl start pcsd.service [root@ha1 yum.repos.d]# systemctl enable pcsd.service
确认集群用户
[root@ha1 yum.repos.d]# pcs cluster auth ha1 ha2 Username: hacluster Password: ha1: Authorized ha2: Authorized
创建集群及查看状态
[root@ha1 yum.repos.d]# pcs cluster setup --start --name my_cluster ha1 ha2 Destroying cluster on nodes: ha1, ha2... ha1: Stopping Cluster (pacemaker)... ha2: Stopping Cluster (pacemaker)... ha1: Successfully destroyed cluster ha2: Successfully destroyed cluster Sending 'pacemaker_remote authkey' to 'ha1', 'ha2' ha1: successful distribution of the file 'pacemaker_remote authkey' ha2: successful distribution of the file 'pacemaker_remote authkey' Sending cluster config files to the nodes... ha1: Succeeded ha2: Succeeded Starting cluster on nodes: ha1, ha2... ha1: Starting Cluster (corosync)... ha2: Starting Cluster (corosync)... ha1: Starting Cluster (pacemaker)... ha2: Starting Cluster (pacemaker)... Synchronizing pcsd certificates on nodes ha1, ha2... ha1: Success ha2: Success Restarting pcsd on the nodes in order to reload the certificates... ha1: Success ha2: Success
[root@ha1 yum.repos.d]# pcs status Cluster name: my_cluster WARNINGS: No stonith devices and stonith-enabled is not false Stack: unknown Current DC: NONE Last updated: Sat Jul 11 21:22:04 2020 Last change: Sat Jul 11 21:21:47 2020 by hacluster via crmd on ha1 2 nodes configured 0 resources configured Node ha1: UNCLEAN (offline) Node ha2: UNCLEAN (offline) No resources Daemon Status: corosync: active/disabled pacemaker: active/disabled pcsd: active/enabled
[root@ha1 yum.repos.d]# pcs cluster enable --all ha1: Cluster Enabled ha2: Cluster Enabled
隔离配置（生产环境加上隔离相关配置，防止其中某节点hang住的情况）：
[root@ha1 yum.repos.d]# pcs property set stonith-enabled=false
vmware添加一个共享的存储
[root@ha1 ~]# fdisk -l Disk /dev/sda: 32.2 GB, 32212254720 bytes, 62914560 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk label type: dos Disk identifier: 0x000b122a Device Boot Start End Blocks Id System /dev/sda1 * 2048 2099199 1048576 83 Linux /dev/sda2 2099200 62914559 30407680 8e Linux LVM Disk /dev/sdb: 10.7 GB, 10737418240 bytes, 20971520 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes [root@ha2 ~]# fdisk -l Disk /dev/sda: 32.2 GB, 32212254720 bytes, 62914560 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk label type: dos Disk identifier: 0x000b122a Device Boot Start End Blocks Id System /dev/sda1 * 2048 2099199 1048576 83 Linux /dev/sda2 2099200 62914559 30407680 8e Linux LVM Disk /dev/sdb: 10.7 GB, 10737418240 bytes, 20971520 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes
创建lvm
[root@ha1 yum.repos.d]# pvcreate /dev/sdb
Physical volume "/dev/sdb" successfully created.
[root@ha1 yum.repos.d]# vgcreate my_vg /dev/sdb
Volume group "my_vg" successfully created
[root@ha1 yum.repos.d]# lvcreate -L5G -n my_lv my_vg
Logical volume "my_lv" created.
[root@ha1 yum.repos.d]# mkfs.xfs /dev/my_vg/my_lv
meta-data=/dev/my_vg/my_lv isize=512 agcount=4, agsize=327680 blks
= sectsz=512 attr=2, projid32bit=1
= crc=1 finobt=0, sparse=0
data = bsize=4096 blocks=1310720, imaxpct=25
= sunit=0 swidth=0 blks
naming =version 2 bsize=4096 ascii-ci=0 ftype=1
log =internal log bsize=4096 blocks=2560, version=2
= sectsz=512 sunit=0 blks, lazy-count=1
realtime =none extsz=4096 blocks=0, rtextents=0
[root@ha1 yum.repos.d]# lvs LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert root centos -wi-ao---- 26.99g swap centos -wi-ao---- 2.00g my_lv my_vg -wi-a----- 5.00g
创建lvm关在目录及mysql用户（各节点执行）
[root@ha1 yum.repos.d]# mkdir -p /wsgw [root@ha1 yum.repos.d]# useradd mysql [root@ha1 yum.repos.d]# chown mysql:mysql /wsgw/ [root@ha1 yum.repos.d]# mount /dev/my_vg/my_lv /wsgw/ [root@ha1 yum.repos.d]# umount /wsgw
[root@ha2 yum.repos.d]# mkdir -p /wsgw [root@ha2 yum.repos.d]# useradd mysql [root@ha2 yum.repos.d]# chown mysql:mysql /wsgw/ [root@ha2 yum.repos.d]# mount /dev/my_vg/my_lv /wsgw/
独占启用集群中的lvm（各节点配置）
#修改 /etc/lvm/lvm.conf中locking_type为1，且use_lvmetad为0.同时停用lvmetad程序 lvmconf --enable-halvm --services --startstopservices #在 /etc/lvm/lvm.conf修改volume_list配置（不受集群管控的lvm，比如你本地的root相关的lvm） volume_list = [ "centos" ]
重建initramfs（各节点配置），重启节点
[root@ha1 yum.repos.d]# dracut -H -f /boot/initramfs-$(uname -r).img $(uname -r) [root@ha1 yum.repos.d]# reboot [root@ha2 yum.repos.d]# dracut -H -f /boot/initramfs-$(uname -r).img $(uname -r) [root@ha2 yum.repos.d]# reboot
查看集群状态
[root@ha1 ~]# pcs cluster status Cluster Status: Stack: corosync Current DC: ha2 (version 1.1.20-5.el7-3c4c782f70) - partition with quorum Last updated: Sat Jul 11 21:48:43 2020 Last change: Sat Jul 11 21:45:23 2020 by root via cibadmin on ha1 2 nodes configured 0 resources configured PCSD Status: ha1: Online ha2: Online
创建lvm资源
[root@ha1 ~]# pcs resource create mysql_lvm LVM volgrpname=my_vg exclusive=true --group mysqlgroup Assumed agent name 'ocf:heartbeat:LVM' (deduced from 'LVM')
[root@ha1 ~]# pcs status
Cluster name: my_cluster
Stack: corosync
Current DC: ha2 (version 1.1.20-5.el7-3c4c782f70) - partition with quorum
Last updated: Sat Jul 11 21:49:42 2020
Last change: Sat Jul 11 21:49:39 2020 by root via cibadmin on ha1
2 nodes configured
1 resource configured
Online: [ ha1 ha2 ]
Full list of resources:
Resource Group: mysqlgroup
mysql_lvm (ocf::heartbeat:LVM): Started ha1
Daemon Status:
corosync: active/enabled
pacemaker: active/enabled
pcsd: active/enabled
#或使用pcs resource show命令查看资源状态
创建文件系统资源
[root@ha1 ~]# pcs resource create mysql_fs Filesystem device="/dev/my_vg/my_lv" directory="/wsgw" fstype="ext4" --group mysqlgroup
mysqlgroup Assumed agent name 'ocf:heartbeat:Filesystem' (deduced from 'Filesystem')
[root@ha1 ~]#pcs status
Cluster name: my_cluster
Stack: corosync
Current DC: ha2 (version 1.1.20-5.el7-3c4c782f70) - partition with quorum
Last updated: Sat Jul 11 21:52:00 2020
Last change: Sat Jul 11 21:51:55 2020 by root via cibadmin on ha1
2 nodes configured
2 resources configured
Online: [ ha1 ha2 ]
Full list of resources:
Resource Group: mysqlgroup
mysql_lvm (ocf::heartbeat:LVM): Started ha1
mysql_fs (ocf::heartbeat:Filesystem): Started ha1
创建vip资源
[root@ha1 ~]# pcs resource create mysql_vip IPaddr2 ip=198.168.198.185 cidr_netmask=24 nic=ens33 --group mysqlgroup
Assumed agent name 'ocf:heartbeat:IPaddr2' (deduced from 'IPaddr2')
pcs resource show
Resource Group: mysqlgroup
mysql_lvm (ocf::heartbeat:LVM): Started ha1
mysql_fs (ocf::heartbeat:Filesystem): Started ha1
mysql_vip (ocf::heartbeat:IPaddr2): Started ha1
创建mysql资源
[root@ha1 ~]#pcs resource create mysql_wsgw ocf:heartbeat:mysql binary="/usr/local/mysql-5.7.27/bin/mysqld_safe" client_binary="/usr/local/mysql-5.7.27/bin/mysql" config="/etc/my.cnf" datadir="/wsgw/data" --group mysqlgroup
[root@ha1 ~]# pcs resource show
Resource Group: mysqlgroup
mysql_lvm (ocf::heartbeat:LVM): Started ha1
mysql_fs (ocf::heartbeat:Filesystem): Started ha1
mysql_vip (ocf::heartbeat:IPaddr2): Started ha1
mysql_wsgw (ocf::heartbeat:mysql): Started ha1
测试资源配置：
[root@ha1 ~]# pcs cluster standby ha1
[root@ha1 ~]# pcs resource show
Resource Group: mysqlgroup
mysql_lvm (ocf::heartbeat:LVM): Started ha2
mysql_fs (ocf::heartbeat:Filesystem): Started ha2
mysql_vip (ocf::heartbeat:IPaddr2): Started ha2
mysql_wsgw (ocf::heartbeat:mysql): Started ha2
[root@ha1 ~]# pcs cluster unstandby ha1
手工切换资源到指定节点
[root@ha1 ~]# pcs resource move mysql_lvm ha2
[root@ha1 ~]# pcs resource show
Resource Group: mysqlgroup
mysql_lvm (ocf::heartbeat:LVM): Started ha1
mysql_fs (ocf::heartbeat:Filesystem): Started ha1
mysql_vip (ocf::heartbeat:IPaddr2): Started ha1
mysql_wsgw (ocf::heartbeat:mysql): Stopping ha1
[root@ha1 ~]# pcs resource show
Resource Group: mysqlgroup
mysql_lvm (ocf::heartbeat:LVM): Starting ha2
mysql_fs (ocf::heartbeat:Filesystem): Stopped
mysql_vip (ocf::heartbeat:IPaddr2): Stopped
mysql_wsgw (ocf::heartbeat:mysql): Stopped
[root@ha1 ~]# pcs resource show
Resource Group: mysqlgroup
mysql_lvm (ocf::heartbeat:LVM): Started ha2
mysql_fs (ocf::heartbeat:Filesystem): Started ha2
mysql_vip (ocf::heartbeat:IPaddr2): Started ha2
mysql_wsgw (ocf::heartbeat:mysql): Starting ha2
[root@ha1 ~]# pcs resource show
Resource Group: mysqlgroup
mysql_lvm (ocf::heartbeat:LVM): Started ha2
mysql_fs (ocf::heartbeat:Filesystem): Started ha2
mysql_vip (ocf::heartbeat:IPaddr2): Started ha2
mysql_wsgw (ocf::heartbeat:mysql): Starting ha2
参考文档：
