Implementation of HA high availability cluster based on NFS shared MySQL

192.168.139.8 as Nfs-server, 192.168.139.2 and 192.168.13.4 are used to install MySQL

___________________________________________________________________________________________ the following operations on 192.168.139.8

[[email protected] ~]# fdisk-l//First to prepare a disk for the partition, to do the LV, then the LV format and then mount and//share with NFS, let the other nodes as a MySQL data storage directory

Device Boot Start End Blocks Id System

/DEV/SDB1 1 1060258+ Linux

/DEV/SDB2 133 394 2104515-Up Linux

/DEV/SDB3 395 787 3156772+-up Linux

[[email protected] ~]# PVCREATE/DEV/SDB1/DEV/SDB2//Create a PV

Physical volume "/DEV/SDB1" successfully created

Physical volume "/DEV/SDB2" successfully created

[[email protected] ~]# vgcreate MYVG/DEV/SDB1/DEV/SDB2//Create a VG named MYVG

Volume Group "MYVG" successfully created

[[email protected] ~]# Vgdisplay//View VG

---Volume Group---

VG Name MYVG

System ID

Format lvm2

Metadata Areas 2

Metadata Sequence No 1

VG Access Read/write

VG Status resizable

MAX LV 0

Cur LV 0

Open LV 0

Max PV 0

Cur PV 2

ACT PV 2

VG Size 3.01 GiB

PE Size 4.00 MiB

Total PE 771

Alloc pe/size 0/0

Free Pe/size 771/3.01 GiB

VG UUID V4jclc-viq1-31rq-vdhb-ir1u-vf0y-zmhkkx

[[email protected] ~]# lvcreate-l 3g-n mylv MYVG//Create a MYVG on MYLV with a size of 3G

Logical volume "Mylv" created.

[[email protected] ~]# Lvdisplay//view LV

---Logical volume---

LV PATH/DEV/MYVG/MYLV

LV Name Mylv

VG Name MYVG

LV UUID 6fkufw-r7ni-iawz-zcgu-tuby-f5uf-fqnm8w

LV Write Access Read/write

LV Creation Host, Time www.zxl.com, 2016-11-10 05:39:52 +0800

LV Status Available

# Open 0

LV Size 3.00 GiB

Current LE 768

Segments 2

Allocation inherit

Read ahead Sectors Auto

-Currently set to 256

Block Device 253:2

[Email protected] ~]# mke2fs-j/DEV/MYVG/MYLV//formatted as EXT3

[[email protected] ~]# groupadd-g 3306 mysql//create MySQL Group

[[email protected] ~]# useradd-u 3306-g mysql-s/sbin/nologin-m mysql//create MySQL user, group//m Ysql, unable to log on to the system, and no specified login directory

[Email protected] ~]# Mkdir/mydata

[[email protected] ~]# vim/etc/fstab//Let boot automatically mount

/dev/myvg/mylv/mydata ext3 defaults 0 0

[[email protected] ~]# mount-a//re-mount Mount in/etc/fstab

[[email protected] ~]# mount//already mounted

/dev/mapper/myvg-mylv on/mydata type ext3 (rw)

[Email protected] ~]# Mkdir/mydata/data

[[email protected] ~]# chown-r mysql.mysql/mydata/data//Change data directory belongs to group and owner is MySQL

[[email protected] ~]# vim/etc/exports//Do NFS sharing

/mydata 192.168.139.0/24 (NO_ROOT_SQUASH,RW)//If there is no No_root_squash, the MySQL system is initialized with the//root identity, and Root accesses NFS be mapped to Guest account, no permissions

[[Email protected] ~] #service rpcbind start//Initiate RPC

[[Email protected] ~] #service NFS Start//Start NFS

[[Email protected] ~] #showmount-e 192.168.139.2//See if NFS is shared

___________________________________________________________________________________________

192.168.139.2

[[email protected] mnt]# groupadd-g 3306 MySQL

[Email protected] mnt]# useradd-u3306-g 3306-s/sbin/nologin-m MySQL

[Email protected] mnt]# Mkdir/mydata

[email protected]/]# Mount 192.168.139.8:/mydata/mydata

[Email protected]/]# cd/mydata/

[email protected] mydata]# LL

Total 20

Drwxr-xr-x. 2 Nobody nobody 4096 Nov data

DRWX------. 2 Nobody nobody 16384 Nov Lost+found

[[email protected] mydata]# usermod-s/bin/bash mysql//test MySQL user can write in the data directory

[Email protected] mydata]# Su-mysql

Su:warning:cannot Change directory to/home/mysql:no such file or directory//as Created MySQL user specified-M

-bash-4.1$ cd/mydata/data/

-bash-4.1$ Touch A

-bash-4.1$ LL

Total 0

-rw-rw-r--. 1 Nobody nobody 0 Nov A//description can be written

-bash-4.1$ RM A

-bash-4.1$ exit

[[email protected] mydata]# usermod-s/sbin/nologin MySQL

[Email protected]/]# umount/mydata/

__________________________________________________________________________________________

Repeat above steps on 192.18.139.4

___________________________________________________________________________________________

192.168.139.2 installing MySQL

Http://mirrors.sohu.com/mysql/MySQL-5.5/mysql

[Email protected] tool]# TAR-XF mysql-5.5.53.tar.gz-c/usr/local

[Email protected] tool]# cd/usr/local/

[email protected] local]# LL

Drwxr-xr-x. 7161 31415 4096 Sep 23:05 mysql-5.5.53

[[email protected] local]# ln-sv mysql-5.5.53 MySQL

' MySQL ', ' mysql-5.5.53 '

[[Email protected] local]# CD MySQL

[Email protected] mysql]# chown-r root:mysql./*

[email protected] mysql]# LL

Total 248

Drwxr-xr-x. 2 root mysql 4096 Sep 23:05 BUILD

-rw-r--r--. 1 root mysql 8528 Sep 23:01 build-cmake

......

[email protected] mysql]# Mount 192.168.139.8:/mydata/mydata/

[Email protected] mysql]# script/mysql_install_db--user=mysql--datadir=/mydata/data

MySQL initialization, specifies to run as MySQL, the data directory is/mydata/data, where the/mydata directory is mounted 192.168.139.8_nfs shared/mydata directory.

___________________________________________________________________________________________

Initialization error occurred. Find out on the Internet very do not know why (^_^)

[Email protected] mysql]# scripts/mysql_install_db--user=mysql--datadir=/mydata/data

-bash:scripts/mysql_install_db:no such file or directory//Discovery scripts directory without//mysql_ INSTALL_DB has/mysql_install_db.sh.

[Email protected] mysql]# scripts/mysql_install_db.sh--user=mysql--datadir=/mydata/data

-bash:scripts/mysql_install_db.sh:permission denied//no permissions

[Email protected] scripts]# chown-r mysql:mysql mysql_install_db.sh

[email protected] scripts]# LL

-rw-r--r--. 1 mysql mysql 14806 Sep 23:01 mysql_install_db.sh

[Email protected] scripts]# scripts/mysql_install_db.sh--user=mysql--datadir=/mydata/data

-bash:scripts/mysql_install_db.sh:no such file or directory//or cannot initialize, is there a problem with the package?

[[email protected] opt]# Find/-name mysql_install_db//Still not found

[Email protected] opt]# cd/usr/local/

[Email protected] local]# RM-RF mysql-5.5.53/

___________________________________________________________________________________________

Re-install a package

[[email protected] mysql]# rpm-qa |grep mysql//Uninstall the system originally installed

Mysql-libs-5.1.73-5.el6_6.x86_64

[[email protected] mysql]# rpm-e--nodeps mysql-libs-5.1.73-5.el6_6.x86_64//uninstall already installed, want to suddenly Slightly dependent relationships

[[email protected] local]# Unzip Mysql-5.5.53.zip//Unzip

[[email protected] local]# RM-RF mysql-5.5.53.zip//Delete original package

[Email protected] local]# LN-SV mysql-5.5.53/mysql

' MySQL ', ' mysql-5.5.53/'

[[Email protected] tool]# CD MySQL

[Email protected] mysql]# scripts/mysql_install_db--user=mysql--datadir=/mydata/data System initialization MySQL

[[email protected] mysql]# cp/usr/local/support-files/my-large.cnf/etc/my.cnf//Copy the MySQL configuration file

[Email protected] mysql]# VIM/ETC/MY.CNF

Datadir=/mydata/data//Join Data storage Directory

innodb_file_per_table=1//Open MySQL table space per table

[[email protected] mysql]# CP support-files/mysql.server.sh/etc/init.d/mysql//copy MySQL startup script

[[email protected] mysql]# chkconfig--add mysql//add MySQL to system service

[[email protected] mysql]# chkconfig mysqld off//cluster resource does not boot from boot

[[Email protected] mysql]# service mysqld start

[[Email protected] mysql]# service mysqld stop

[Email protected] mysql]# umount/mydata/

___________________________________________________________________________________________

Re-installing MySQL on 192.168.139.4

___________________________________________________________________________________________

192.168.139.2

[[Email protected] mysql]service heartbeat start

[[email protected] mysql]ssh 192.168.139.4 service Heartbeat start

[[email protected] MySQL] Hb_gui//In the graphical interface will Mysql,vip (192.168.139.10), filesystem configured as a capital//source group, and let the VIP start first, in the boot filesystem, and finally start MySQL

[Email protected] Mysql]crm_mon

You can see that 192.168.139.4 is selected for DC

[[email protected] mysql]mysql-uroot-p-h192.168.139.10//Connect VIP, can connect up

Let the 192.168.139.4 break down

[[email protected] mysql]mysql-uroot-p-h192.168.139.10//can still connect up

The main point is that the MySQL data storage directory is the Nfs-server shared directory, so that on the two hosts installed MySQL will be a common data storage directory, so that the data consistency, so that MySQL is highly available, but Nfs-server is still a single node, Easy to become a cluster failure point

This article is from the "11097124" blog, please be sure to keep this source http://11107124.blog.51cto.com/11097124/1871489

Implementation of HA high availability cluster based on NFS shared MySQL