HW04: MySQL Management and S3 due Sat 23 Sep 23:59
Documentation
Create a text document named mysql.txt. The tasks below will ask you to record various things in this file.
phpMyAdmin (10 pts)
Install phpMyAdmin an apply the security mechanisms we discussed in class:- Rename the alias to something obscure (i.e., not phpmyadmin)
- Verify that access is via port-forwarding only.
Record (in mysql.txt) the commands/steps you took to securely install phpMyAdmin.
Practice Backup/Restore (14pts)
For each of the three backup/restore methods below, record your success or failure in mysql.txt. Perform the following experiements with MySQL backup and restore:- Create a simple MySQL database with at least two InnoDB tables and some sample data.
- Perform a backup using the mysqldump utility.
- Delete data from the database.
- Restore from backup and verify that data is correct.
- Perform a backup using the “binary log” method.
- Delete data from the database.
- Restore from backup and verify that data is correct.
Record (in mysql.txt) the commands/steps you took to test backup and restore for each of the two methods.
Working with S3 (6 pts)
Utilizing off-site storage is considered an important part of securing data. We will use Amazon's S3 buckets for this purpose.- Learn how to backup a file to Amazon's S3 storage:
https://aws.amazon.com/getting-started/tutorials/backup-files-to-amazon-s3/
- Make sure the bucket contents are encrypted
- Create a snapshot of your database using mysqldump and store the backup file in your encrypted bucket.
Take a screen shot of your created bucket showing the database backup file in it.
Turning in Your Work
Store the screenshot together with your mysql.txt in a tarred-and-zipped file (mysql.tgz) and upload the file in Canvas.