---------------------------------------
Initial database server setup procedure
---------------------------------------

## VM configuration

# Network selection

NIC 1: Server Network
NIC 2: 10G 01
NIC 3: 10G 02

# Disk configuration

1: 40GB Thick Provision Eager Zero

# OS 

Install Centos 6.x, set an IP for all three interfaces either through DHCP or statically assigned.

## CentOS configuration

# Turn of selinux
setenforce permissive
sed -i 's/SELINUX=enforcing/SELINUX=permissive/g' /etc/selinux/config

# Install some extra software
yum -y install nfs-utils wget vim unzip php php-mysql git

# Install EqualLogic dell tools ( The ISO is located on the EqualLogic support site, this Dropbox location will be invalid
# after I leave)
wget https://www.dropbox.com/s/a3m1r7jj77fq6pu/equallogic-host-tools-1.3.0-2.iso?dl=0 -O equallogic-host-tools-1.3.0-2.iso
mkdir /eqltools-cd
mount -o loop -t iso9660 equallogic-host-tools-1.3.0-2.iso /eqltools-cd
cd /eqltools-cd
./install --nogpgcheck

cd ~
umount /eqltools-cd

# Install VMware tools if needed

# Add credentials for the Equal Logic 
asmcli create group-access --name=eql1 --user-name=grpadmin --ip-address=10.60.0.4 --management-ip=192.168.31.51

# Mount the smart copy directory from the server, it may or may not exist yet
rm -rf /var/lib/equallogic/asm/smart-copies/*
mkdir -p /var/lib/equallogic/asm/smart-copies
echo '192.168.31.238:/ /var/lib/equallogic/asm/smart-copies nfs defaults 0 0' >> /etc/fstab
mount /var/lib/equallogic/asm/smart-copies

# Setup mysql
cd ~ && wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
rpm -ivh mysql-community-release-el6-5.noarch.rpm
yum install --yes mysql-server
service mysqld stop
sed -i 's/^/#/' /usr/share/mysql/my-default.cnf
rm -rf /var/lib/mysql
mkdir /data
ln -s /data/data/mysql /var/lib/mysql
# Mysql can not start on boot because asmcli is a dynamic mount
chkconfig mysqld off
# This system link allows the script to function between two different types of MySql installations
ln -s /etc/init.d/mysqld /etc/init.d/mysql

# Copy the included my.cnf over the existing configuration. Be sure to modify the innodb cache size to be 80% of the server's total memory.

# Generate ssh keys and copy them to the source server
ssh-keygen -t rsa -b 4096 -C `hostname`
ssh-copy-id 192.168.31.238

# Make sure your new server's host is listed as an IP on the source MySQL server. I have already added 10.40.* 
and 192.168.31.* for dev_script

# Setup adapters to work with the smart-copy system
rswcli -E --default=exclude
rswcli -I --network=10.60.0.0 --mask=255.255.255.0

# iscsi tweaking
eqltune fix
sed -i 's/node.startup.*/node.startup = manual/g' /etc/iscsi/iscsid.conf
sed -i 's/node.session.initial_login_retry_max.*/ node.session.initial_login_retry_max = 12/g' /etc/iscsi/iscsid.conf
sed -i 's/node.session.cmds_max.*/node.session.cmds_max = 1024/g' /etc/iscsi/iscsid.conf
sed -i 's/node.session.queue_depth.*/node.session.queue_depth = 128/g' /etc/iscsi/iscsid.conf

# Service configuration
chkconfig multipathd off
chkconfig iscsid on
chkconfig ehcmd on

# At this point you should reboot the server

## Refresh script setup

# Git clone the repo replacing <user> with your username
git clone https://<user>@github.com/theorchard/system-utils