L W wrote: Dear Sir, Please do forward a Google Wave Invitation to lvw.iv4 (at) gmail (dot) com, at your earliest convenience?
Much appreciated!
Nov. 30, 2009 03:56 PM EST
.gif)
This time AWS has 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. Is 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 time as I like.
mysql -h :
This does the “remote” connection to the new RDS instance and most of the heavy lifting.
So with a 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
Down load 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 DRS and alert me when issue happen. I like collectd 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 Beta for now, but start learning how to use this service in the Cloud and never be caught with no Database Server again.
When the Beta ends you will be ready to use RDS full time for you 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.
Performance implications of certain CSS Selectors are not specific to a certain JavaScript Library like Prototype. I recently blogged about the internals of CSS Selectors in jQuery. The same holds true for every JavaScript library that offers CSS Selectors. Certain lookups can be...
Adobe put out this press release - well, kinda, it was released at 6am Saturday morning and the company didn't bother to tell its staff about it, least of all its sales people. Anyway, it's about how Acrobat.com, Adobe's contribution to the flock of Office-challenging web apps, h...
The .append() method is perhaps the most misused of all jQuery methods. While an extremely useful and easy method to work with, it dramatically affects the performance of your page. When misused, the .append() method can cripple your JavaScript code's performance. When used well,...
Recently I installed the Beta 2 version of "Geneva", or ADFS 2.0. All of my machines are now Windows 7 machines, including just about all of my VHDs and virtual machines. The only time I use Win2k8 R2 is when the product I'm installing specifically requires me to do that. So when...
SYS-CON Events (http://events.sys-con.com) announced today that the "show prospectus" for the 5th International Cloud Computing Conference & Expo (www.CloudComputingExpo.com) is now shipping.
5th International Cloud Expo will take place April 19-21, 2010, at the Jacob Javits C...
