percona server & raid setup on ec2

percona_raid_ec2.sh

# install percona server
wget http://www.percona.com/downloads/RPM-GPG-KEY-percona
sudo apt-key add RPM-GPG-KEY-percona
echo "deb http://repo.percona.com/apt `lsb_release -cs` main" | sudo tee -a /etc/apt/sources.list
echo "deb-src http://repo.percona.com/apt `lsb_release -cs` main" | sudo tee -a /etc/apt/sources.list
sudo apt-get update
sudo apt-get install percona-server-server-5.1 percona-server-client-5.1 percona-server-common libmysqlclient-dev



# create EBS volumes
ec2addvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 -z ap-northeast-1a -s 30
ec2addvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 -z ap-northeast-1a -s 30
ec2addvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 -z ap-northeast-1a -s 30
ec2addvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 -z ap-northeast-1a -s 30
ec2addvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 -z ap-northeast-1a -s 30
ec2addvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 -z ap-northeast-1a -s 30
ec2addvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 -z ap-northeast-1a -s 30
ec2addvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 -z ap-northeast-1a -s 30

# attach EBS volumes
ec2attvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 vol-edfcbf85 -i i-30c14331 -d /dev/sdf1
ec2attvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 vol-f1fcbf99 -i i-30c14331 -d /dev/sdf2
ec2attvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 vol-c5fcbfad -i i-30c14331 -d /dev/sdf3
ec2attvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 vol-a9fcbfc1 -i i-30c14331 -d /dev/sdf4
ec2attvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 vol-bdfcbfd5 -i i-30c14331 -d /dev/sdg1
ec2attvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 vol-81fcbfe9 -i i-30c14331 -d /dev/sdg2
ec2attvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 vol-95fcbffd -i i-30c14331 -d /dev/sdg3
ec2attvol -K shinsai-pk.pem -C shinsai-cert.pem --region ap-northeast-1 vol-51024039 -i i-30c14331 -d /dev/sdg4


# create raid array
sudo mdadm -v --create /dev/md0 --chunk=256 --level=raid0 --raid-devices=4 /dev/sdf1 /dev/sdf2 /dev/sdf3 /dev/sdf4
sudo mdadm -v --create /dev/md1 --chunk=256 --level=raid0 --raid-devices=4 /dev/sdg1 /dev/sdg2 /dev/sdg3 /dev/sdg4
sudo mdadm -v --create /dev/md2 --chunk=256 --level=raid1 --raid-devices=2 /dev/md0 /dev/md1

# add raid info to conf file
sudo mdadm --detail --scan
sudo vi /etc/mdadm/mdadm.conf

# create filesystem and mount
sudo mkfs.xfs /dev/md2
sudo mkdir /data
echo "/dev/md2  /data/  xfs  noatime,nobootwait 0 0" | sudo tee -a /etc/fstab
sudo mount -a

# change directories
sudo /etc/init.d/mysql stop
cd /var/lib
sudo mv mysql /data
sudo ln -s /data/mysql mysql
sudo mkdir /data/mysql-backup /mnt/mysql-tmp
sudo chown mysql: /data/mysql-backup
sudo chown mysql: /mnt/mysql-tmp
sudo vi /etc/mysql/my.cnf