Log for 電訊台
backup_mysql=yes
mysql_export_location=/home/mysql_backup/
mysql_location=/var/lib/mysql
mysql_password=123456
now=
if [ "$backup_mysql" == "yes" ]; then
if [ ! -f $mysql_export_location ]; then
mkdir -p $mysql_export_location
fi
echo "Export Database start at: $now"
for database in
/usr/bin/mysqldump -u root --password=$mysql_password $database > $mysql_export_location$database.sql
done
now=
echo "Export Database stop at: $now" >> $backup_status
fi
mysql_export_location=/home/mysql_backup/
mysql_location=/var/lib/mysql
mysql_password=123456
now=
date +%Y-%m-%d\ %H:%M:%Sif [ "$backup_mysql" == "yes" ]; then
if [ ! -f $mysql_export_location ]; then
mkdir -p $mysql_export_location
fi
echo "Export Database start at: $now"
for database in
ls -l $mysql_location | grep drwx | awk '{print $9}' ; do/usr/bin/mysqldump -u root --password=$mysql_password $database > $mysql_export_location$database.sql
done
now=
date +%Y-%m-%d\ %H:%M:%Secho "Export Database stop at: $now" >> $backup_status
fi
用佢黎做vmware既storage, 設定每1小時snapshot一之, 有咩事死機, 可以馬上用snapshot開機, 然後background慢慢copy返去真既storage度, 超正!
個時用過2部Equal Logic, 一部係SAS加SSD, D SSD要7000一隻 256G, Storage既harddisk係特制, 唔可以放普通harddisk