You'll most likely want your CF server in close proximity to the cloud based MySQL server, i.e. your server would want to be an EC2 instance.
I've a few servers setup in the Amazon cloud and for the most part it is really neat. Things to be aware of though are outages, servers have a habit of "disappearing" (not a frequent issue, but it is there). If using EC2 for servers, having a backup and restoration plan is paramount. A copy of your latest server image should be ready to be booted up at a snap and all data should be stored on a detachable volume and backed up regularly (Amazon Elastic Storage for detachable volumes and potentially S3 for backup). It would be interesting to see how connecting to the RDS would work from a non Amazon hosted server, I imagine it would suffer lag - pretty cheap to find out though :) HTH Dominic On 18 February 2011 04:57, Chris . <mister...@mistergin.net> wrote: > > Stumbled onto Amazon RDS (link: http://aws.amazon.com/rds/) and the > concept from what I'm reading at least, sounds great. > > I currently use shared hosting with CF and MySQL. I'm pouring over the > documentation but most of it is over my head as I'm not familiar with Amazon > web services and/or MySQL server administration. > > From what I'm getting though, I can create the MySQL database there, import > data into it, and then connect to it from the CF server during CFQUERY > calls. > > Has anyone looked into this or tried something like this? I'm skeptical > and imagine there'd be overhead that would make it unusable but I'm not > finding anything to back that up.. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342421 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
