How to realize High availability + shared Storage NFS by MySQL
Editor to share with you how MySQL to achieve high availability + shared storage NFS, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!
a planning chart
1. First of all, analyze the resources.
1) Vip
2) Mysqld
3) Nfs
Sort out the startup sequence between them: nfs must be started before mysqld starts
2. Configuration of nfs
The partition mounted on the NFS shared directory is best made into lvm to achieve automatic expansion.
2.1 installation
# yum-y install nfs-utils
2.2 configuration
# mkdir / share
# vim / etc/exports
172.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. Mount the nfs partition on mysql1 for mysql installation test
3.1Mount nfs
# mkdir / data
# chown mysql:mysql / data
# mount 172.16.98.3:/share / data
3.2 install using mysql's unzipped package
# groupadd-g 186 mysql
# useradd-u 186-g mysql-s / sbin/nologin-M mysql
On the three machines, the mysql group created should be consistent with the user's uid and 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/profile
PATH=$PATH:/usr/local/mysql/bin
# export PATH=$PATH:/usr/local/mysql/bin
3.3 Edit the configuration file and start the service
# vim / etc/my.cnf
[mysqld]
Thread_concurrency = 2
Datadir=/data
# service mysqld start
3.4 installation on mysql2
Referring to the previous steps, what needs to be explained is the installation of MySQL. There is no need to initialize mysql here.
# 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/profile
PATH=$PATH:/usr/local/mysql/bin
# export PATH=$PATH:/usr/local/mysql/bin
# service mysqld start
# cd / data
3.5 stop all resources
1) shut down the mysql service
# service mysqld stop
2) Uninstall the nfs shared directory
# umount / data
4. Installation of Corosync
Preparation in advance
1) ssh computers trust each other, which is easy to configure.
2) keep the time consistent
3) / etc/hosts, set hostname, resolve each other
4.1 install corosync on mysql1, mysql2
# 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 configuration of corosync
1) mysql1
# cd / etc/corosync
# cp corosync.conf.example corosync.conf
# vim corosync.conf
Compatibility: whitetank
Totem {
Version: 2
Secauth:on enables authentication
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 create authkeys
# scp authkeys corosync.conf node2:/etc/corosync
Create directories for logs on the two mysql
# mkdir / var/log/cluster
4.3 enable corosync via mysql1 to configure resources
1) enable
# service corosync start
# ssh node2 'service corosync start'
# crm_mon
=
Last updated: Thu Aug 9 22:12:22 2012
Stack: openais
Current DC: node1.linuxidc.com-partition with quorum
Version: 1.1.5-1.1.el5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f
2 Nodes configured, 2 expected votes
0 Resources configured.
=
Online: [node2.linuxidc.com node1.linuxidc.com]
2) allocation of resources
# crm
Crm (live) # configure
Crm (live) configure# primitive vip ocf:heartbeat:IPaddr params ip=172.16.99.1
Crm (live) configure# primitive mysqld lsb:mysqld
Crm (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
/ / define nfs resources. The default timeout is 20s, which is less than the recommended time of 60s, so configure it manually.
Crm (live) configure# colocation vip_mysqld_nfs inf: mysqld nfs vip
Crm (live) configure# order mysqld_after_nfs inf: nfs mysqld
Crm (live) configure# property stonith-enabled=false
Crm (live) configure# property no-quorum-policy=ignore
Crm (live) configure# verify
Crm (live) configure# commit
3) Detection
# crm_mon
Last updated: Thu Aug 9 22:34:52 2012
Stack: openais
Current DC: node1.linuxidc.com-partition with quorum
Version: 1.1.5-1.1.el5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f
2 Nodes configured, 2 expected votes
3 Resources configured.
=
Online: [node2.linuxidc.com node1.linuxidc.com]
Nfs (ocf::heartbeat:Filesystem): Started node1.linuxidc.com
Vip (ocf::heartbeat:IPaddr): Started node1.linuxidc.com
Mysqld (lsb:mysqld): Started node1.linuxidc.com
# crm node standy
# crm_mon
=
Last updated: Thu Aug 9 22:36:18 2012
Stack: openais
Current DC: node1.linuxidc.com-partition with quorum
Version: 1.1.5-1.1.el5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f
2 Nodes configured, 2 expected votes
3 Resources configured.
=
Node node1.linuxidc.com: standby
Online: [node2.linuxidc.com]
Nfs (ocf::heartbeat:Filesystem): Started node2.linuxidc.com
Vip (ocf::heartbeat:IPaddr): Started node2.linuxidc.com
Mysqld (lsb:mysqld): Started node2.linuxidc.com
These are all the contents of the article "how to achieve High availability + shared Storage NFS in MySQL". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!
