mysqld 实现高可用

1、安装配置heartbeat https://blog.youkuaiyun.com/qq_37594711/article/details/79503909
2、安装配置 drbd   https://blog.youkuaiyun.com/qq_37594711/article/details/79516527
3、安装配置 mysqld https://blog.youkuaiyun.com/qq_37594711/article/details/56282199
4、从节点上关闭mysql数据库，删除数据库数据目录
# service mysqld stop
# rm -rf /data/mysql
5、从节点上修改heartbeat，配置重启heartbeat
# vi /etc/ha.d/haresources
CentOS-6.5-2-108 IPaddr::192.168.2.111/24/eth0 drbddisk::data Filesystem::/dev/drbd0::/data::ext4 mysqld
# service heartbeat restart
6、主节点上先关闭mysqld,再修改heartbeat配置重启heartbeat
#service mysqld stop
# vi /etc/ha.d/haresources
CentOS-6.5-2-108 IPaddr::192.168.2.111/24/eth0 drbddisk::data Filesystem::/dev/drbd0::/data::ext4 mysqld
# service heartbeat restart
7、验证
1）先查看主节点是否启动mysqld
# lsof -i :3306  
2、先主节点切换成从
#/usr/share/heartbeat/hb_standby
3、检查主是否关闭mysqld，从是否开启mysqld
4、如果正常再切换回来，在主上执行
# /usr/share/heartbeat/hb_takeover local