Edward M. Goldberg

Cloud Computing - News and Ideas

Edward M. Goldberg header image 4

AWS RDS Rocks!!!

October 31st, 2009 by Edward M. Goldberg

This time AWS does it right. The Relational Database Servers in AWS called “RDS” are the “Real Thing”.

I just transferred over my whole Drupal DB in a few moments to an RDS Instance. It was very simple.

Let me show you the one-line command solution:

(Warning Linux command comes next!)

$ mysqldump –add-drop-table –databases Comments EdwardMGoldberg NOC myCloudWatcher_drupal wikidb | mysql -h mycloudwatcher.xxx.us-east-1.rds.amazonaws.com -u TheCloudWatcher -pXxXxXxXxXx4

(all password info is fake)

Let me break down this command into the parts:

mysqldump:

This is the LINUX command line database dump program. I just used the default connection (defined in my.cnf) and dumped a few tables I wanted. I added the drop table option so I can update as many times as I like.

mysql -h :

This does the “remote” connection to the new RDS instance and most of the heavy lifting.

So with one line of shell script, I moved into the Cloud.

The RightScale Dashboard was used to set up my RDS instance. It made the whole process of configuration a point and click process.

Next step, look at the results and check out the tables:

http://dev.mysql.com/downloads/gui-tools/5.0.html

Download these great GUI tools and connect to the Database from your Laptop. You do have to “allow” the IP address for you Laptop in the configuration.

It took me about one hour to get setup and transferred into the Cloud. Not Bad.

What’s next? Get my monitor system to track the RDS and alert me when issues happen. I like collected for that task. so that will be my next step.

Take an hour and set up an RDS server for your database. It works great as a “Cold Backup Server”. You pay only a few cents for data storage on the “Cold RDS Server” stored as SNAP data. When you need to “Fail Over” in the Disaster Recovery (DR) mode just Launch the RDS from SNAP. In a very short amount of time you are back on line. To keep the DB up-to-date just launch it once a day for one hour and update the contents. Keep the “Delta” ready for the last few records you may need to add at Launch.

For DR and fail Over RDS ROCKS!!!!

It may be in Beta for now, but start learning how to use this service in the Cloud and never be caught without a Database Server again.

When the Beta ends you will be ready to use RDS full time for your next project.

If you are in the process of learning SQL, the RDS servers will provide you a real Database to do your homework with.

Tags:   · · · · · No Comments

Leave A Comment

0 responses so far ↓

  • There are no comments yet...Kick things off by filling out the form below.