The worst thing happened: I accidentally deleted all the user data on our server! I don't know how this could have happened, but instead of issuing a 'select * from users', the command I saw in the history was 'delete from users' ! -- all user data gone in less than a second -- worst nightmare come true!!!
Fortunately, I had developed a backup script that would backup all the databases to our S3 server. What a blessing! Now I could restore all data with simply mounting the backup snapshot.
Lesson learned? Amazon EC2 and S3 rock, and having a backup script is the i dot! Take a look here for an introduction.
Tuesday, November 3, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment