[ `id -u` -ne 0 ] && echo "ERROR: Script must be run as root" && exit 1
DISK="/dev/sdb"
[ `fdisk -l ${DISK} | wc -l` -eq 0 ] && echo "ERROR: A second disk '${DISK}' was not found" && exit 2
fdisk -l ${DISK}
pvdisplay ${DISK} 
[ $? -eq 0 ] && echo "ERROR: Physical Volume for '${DISK}' already exists" && exit 3
pvcreate ${DISK}
vgcreate appvg ${DISK}

lvcreate -L 100M -n mysql_data0_data_lv appvg
lvcreate -L 100M -n mysql_audit0_lv appvg
lvcreate -L 100M -n mysql_binlog0_lv appvg
lvcreate -L 100M -n mysql_tmp0_lv appvg

mkfs.ext4 /dev/appvg/mysql_data0_data_lv
mkfs.ext4 /dev/appvg/mysql_audit0_lv
mkfs.ext4 /dev/appvg/mysql_binlog0_lv
mkfs.ext4 /dev/appvg/mysql_tmp0_lv

mkdir -p /mysql/data0/data /mysql/audit0 /mysql/binlog0 /mysql/tmp0

echo "
/dev/appvg/mysql_data0_data_lv /mysql/data0/data ext4 defaults  0 0
/dev/appvg/mysql_audit0_lv /mysql/audit0 ext4 defaults  0 0
/dev/appvg/mysql_binlog0_lv /mysql/binlog0 ext4 defaults  0 0
/dev/appvg/mysql_tmp0_lv /mysql/tmp0 ext4 defaults  0 0" >> /etc/fstab

mount /mysql/data0/data
mount /mysql/audit0
mount /mysql/binlog0
mount /mysql/tmp0

df -h