Patrick Collands wrote: collands (AT) gmail com
I'd be very grateful for an invitation.
Thank you.
Nov. 29, 2009 12:37 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.
The Enterprise Cloud Requires a real time infrastructure and a management discipline that understands and can enforce service level discipline.
CloudBench Applications, Inc. announced its financial results for the three months and nine months ending September 30, 2009. All amounts are stated in Canadian dollars unless otherwise noted. Revenues from BasicGov, the Company's cloud computing solution for local government, gr...
The new contract is an industry first, with CSC being the first Microsoft partner to lead and win a cloud computing services agreement of this scale. Under terms of the contract, CSC will provide Royal Mail Group's 30,000 employees with access to new IT services using Microsoft's...
Operates in over 170 countries and is one of the world’s leading providers of communications solutions and services. Richard Tarboton talks for MeettheBoss.TV on his role as Head of Energy & Carbon for BT and what they are doing towards reducing carbon emissions.
CA is going to put its Agile Planner software on salesforce.com’s Force.com platform in the first half to accelerate development time and give users visibility over their development initiatives to reduce time-to-market. Customers are supposed to be able to accelerate the deploym...
