小编给大家分享一下MySQL如何实现高可用+共享存储NFS，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！规划图1、首先进行资源的分析1）Vip2）Mysqld3）Nfs理清他们之间的启动先后顺序：nfs必须在mysqld启动前启动
2、nfs的配置NFS共享目录上挂载的分区，最好做成lvm，实现自动扩展2.1 安装# yum -y install nfs-utils
2.2 配置# mkdir /share# vim /etc/exports172.16.98.3:/share 172.16.98.1(rw,no_root_squash) 172.16.98.2(rw,no_root_squash)# service nfs start# groupadd -g 186 mysql# useradd -u 186 -g mysql -s /sbin/nologin -M mysql# chown mysql:mysql /share
3、在mysql1上挂载nfs分区进行mysql安装测试3.1 挂载nfs# mkdir /data# chown mysql:mysql /data# mount 172.16.98.3:/share /data
3.2 使用mysql的解压缩包安装# groupadd -g 186 mysql# useradd -u 186 -g mysql -s /sbin/nologin -M mysql
在三台机器上，创建的mysql组和用户的uid、gid要保持一致# tar -zxvf mysql-5.5.24-linux2.6-i686.tar.gz -C /usr/local# cd /usr/local# ln -s mysql-5.5.24-linux2.6-i686 mysql# cd mysql# chown -R mysql:mysql .# scripts/mysql_install_db –user=mysql –datadir=/data# chowm -R root .# cp support-files/my-large.cnf /etc/my.cnf# cp support-files/mysql.server /etc/rc.d/init.d/mysqld# chmod +x /etc/rc.d/init.d/mysqld# vim /etc/profilePATH=$PATH:/usr/local/mysql/bin# export PATH=$PATH:/usr/local/mysql/bin
3.3 编辑配置文件,启动服务# vim /etc/my.cnf[mysqld]thread_concurrency = 2datadir=/data# service mysqld start
3.4 在mysql2上的安装参考前面的步骤，需要说明一点的是MySQL的安装，这里不需要再进行初始化mysql# tar -zxvf mysql-5.5.24-linux2.6-i686.tar.gz -C /usr/local# cd /usr/local# ln -s mysql-5.5.24-linux2.6-i686 mysql# cd mysql# chowm -R root .# cp support-files/my-large.cnf /etc/my.cnf# cp support-files/mysql.server /etc/rc.d/init.d/mysqld# chmod +x /etc/rc.d/init.d/mysqld# vim /etc/profilePATH=$PATH:/usr/local/mysql/bin# export PATH=$PATH:/usr/local/mysql/bin# service mysqld start# cd /data
3.5 停止所有资源1）关闭mysql服务
# service mysqld stop2）将nfs共享目录卸载# umount /data
4、Corosync的安装前期准备1）ssh双机互信，方便配置2）时间保持一致3）/etc/hosts ,主机名设置，互相解析
4.1 在mysql1、mysql2上安装corosync# yum install -y cluster-glue-1.0.6-1.6.el5.i386.rpm
cluster-glue-libs-1.0.6-1.6.el5.i386.rpm
corosynclib-1.2.7-1.1.el5.i386.rpm corosync-1.2.7-1.1.el5.i386.rpm
heartbeat-3.0.3-2.3.el5.i386.rpm heartbeat-libs-3.0.3-2.3.el5.i386.rpm
libesmtp-1.0.4-5.el5.i386.rpm pacemaker-cts-1.1.5-1.1.el5.i386.rpm
pacemaker-libs-1.1.5-1.1.el5.i386.rpm pacemaker-1.1.5-1.1.el5.i386.rpm
perl-TimeDate-1.16-5.el5.noarch.rpm
resource-agents-1.0.4-1.1.el5.i386.rpm
4.2 corosync的配置1）mysql1# cd /etc/corosync# cp corosync.conf.example corosync.conf# vim corosync.confcompatibility: whitetank
totem { version: 2 secauth:on 开启身份验证 threads: 0 interface { ringnumber: 0 bindnetaddr: 172.16.0.0 mcastaddr: 226.94.1.1 mcastport: 5405 }}
logging { fileline: off to_stderr: on to_logfile: yes# to_syslog: yes logfile: /var/log/cluster/corosync.log debug: off timestamp: on logger_subsys { subsys: AMF debug: off }}
amf { mode: disabled}service { ver:0 name:pacemaker}# corosync-keygen 创建authkeys# scp authkeys corosync.conf node2:/etc/corosync
两台mysql上分别创建用于日志的目录# mkdir /var/log/cluster
4.3 通过mysql1开启corosync，配置资源1)开启# service corosync start# ssh node2 ‘service corosync st开发云主机域名art’# crm_mon============Last updated: Thu Aug 9 22:12:22 2012Stack: openaisCurrent DC: node1.linuxidc.com – partition with quorumVersion: 1.1.5-1.1.el5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f2 Nodes configured, 2 expected votes0 Resources configured.============
Online: [ node2.linuxidc.com node1.linuxidc.com ]
2）资源的配置# crmcrm(live)# configurecrm(live)configure# primitive vip ocf:heartbeat:IPaddr params ip=172.16.99.1crm(live)configure# primitive mysqld lsb:mysqldcrm(live)configure# primitive nfs ocf:heartbeat:Filesystem params
device=172.16.98.3:/share directory=/data fstype=nfs op start timeout=60
op stop timeout=60//定义nfs资源，默认的超时时间是20s，是小于建议的时间60s的，所以手动配置crm(live)configure# colocation vip_mysqld_nfs inf: mysqld nfs vipcrm(live)configure# order mysqld_after_nfs inf: nfs mysqldcrm(live)configure# property stonith-enabled=falsecrm(live)configure# property no-quorum-policy=ignorecrm(live)configure# verifycrm(live)configure# commit
3）检测# crm_monLast updated: Thu Aug 9 22:34:52 2012Stack: openaisCurrent DC: node1.linuxidc.com – partition with quorumVersion: 1.1.5-1.1.el5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f2 Nodes configured, 2 expected votes3 Resources configured.============
Online: [ node2.linuxidc.com node1.linuxidc.com ]
nfs (ocf::heartbeat:Filesystem): Started node1.linuxidc.comvip (ocf::heartbeat:IPaddr): Started node1.linuxidc.commysqld (lsb:mysqld): Started node1.linuxidc.com
# crm node standy# crm_mon============Last updated: Thu Aug 9 22:36:18 2012Stack: openaisCurrent DC: node1.linuxidc.com – partition with quorumVersion: 1.1.5-1.1.el5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f2 Nodes configured, 2 expected votes3 Resources configured.============
Node node1.linuxidc.com: standbyOnline: [ node2.linuxidc.com ]
nfs (ocf::heartbeat:Filesystem): Started node2.linuxidc.comvip (ocf::heartbeat:IPaddr): Started node2.linuxidc.commysqld (lsb:mysqld): Started node2.linuxidc.com以上是“MySQL如何实现高可用+共享存储NFS”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注开发云行业资讯频道！
这篇文章主要讲解了“MySQL中LIKE子句的用法”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“MySQL中LIKE子句的用法”吧！我们知道在 MySQL 中使用 SQL SELECT 命令来读取数据， 同时我…
免责声明：本站发布的图片视频文字，以转载和分享为主，文章观点不代表本站立场，本站不承担相关法律责任；如果涉及侵权请联系邮箱：360163164@qq.com举报，并提供相关证据，经查实将立刻删除涉嫌侵权内容。
微信扫一扫 
