I set up Amazon EC2 instance using the Ubuntu server edition, and I installed the LAMP stack on it. I did up a PHP web application running on MySQL. I have tested the web application on Amazon EC2, and it works.
I have not officially launched, but I need to know this before launching. Should I backup my database data? If so, how should I do it as cost effective as possible?
Previously for another web application, I wrote a Perl or Bash script (cannot remember) that will be executed by cron on a daily basis.
The script will then backup the database into a single
.sql file and send as email attachment to my Gmail account.
That web application was on shared hosting hence, I was quite sure I needed to do backup of my database. My files are on Git repository, so I am not worried about that.
For this new web application on Amazon Web Services (AWS), I am undecided because:
I do not think that it is a good solution as data sent over email is not safe. There is no SSL as far as I can recall though it was a cheap solution. Free. Easily retrievable by date.
Amazon may have made it redundant for me to do backup because they do that already. All I need to know is how to recover it in case of disaster (touch wood)
- (I suspect) there is a superior and cost effective way for me to do backup using Amazon S3.
I allow users to upload files, so I need to somehow backup those files as well. Which I do not know how to and have never done it before in any form.
What I want: a daily back up of my database and image files as cost effective as possible and a clear, step-by-step playguide to implement this and to recover them in case of disaster.
I am totally unfamiliar with AWS. Only know as much as setting up an account. That is all.
<< One year experience as someone newbie to Ubuntu. Most of my life in Windows.
Mostly intimate with PHP programming. Command of other programming languages is not as good due to lack of usage.