README.md

aws_create_snapshot_mysql

Creating automated snapshots at AWS for a MySQL partition (Slave DB Server)

Purpose:

1. Create a snapshot from the Mysql Slave server
   1. Only if the replication lag is 0; else wait until the slave gets up-to-date with the master

Requisite:

1. You'll need a MySQL Standby DB Server running
2. You'll need a root access to that MYSQL Instance
3. The script is run locally on the slave server
4. Assuming the slave server is hosted in AWS, you'll need to create an IAM role with full EC2 access.
5. You'll need to create a topic and a subscription in SNS. So if the snapshot fails you'll get an email alert.
6. The script assumes that you are running your MySQL DB in the /mysql volume.
7. Change all the CHANGEME to your settings/values.
8. You'll need the AWSCLI tool installed on your instance.

Usage:

1. Adding permission to the files: chmod +x mysql-create-snapshot.*
2. From the root directory, run: bash mysql-create-snapshot.sh
3. mkdir -p /root/scripts/logs/