News for hackers. Stuff that matters.

A comment on Why I left Heroku, and notes on my new AWS setup. Parent comment

Re:Why I left Heroku, and notes on my new AWS setup by toomuchtodo on Monday May 20, 2013 @12:21PM (#5738420)
RDS is pretty expensive for what you get. You can't restore to a running instance from snapshots, you get very little control over the environment, and you can't replicate between geographic regions (only availability zones).

I know you said you're a two man shop, but in this case it may make more sense to leverage other IaaS DB services instead of RDS.

[ Parent | on HN ]
Re:Why I left Heroku, and notes on my new AWS setup by riffraff on Monday May 20, 2013 @01:35PM (#5738831)
I am not sure what you mean by "You can't restore to a running instance from snapshots" cause, well, I've done it a few times.

Could you expand a bit maybe?

[ Parent | on HN ]
Re:Why I left Heroku, and notes on my new AWS setup by toomuchtodo on Monday May 20, 2013 @02:40PM (#5739178)
My apologies. I should've said "to an existing instance."

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_R...

"You must create a DB snapshot before you can restore a DB instance from one. When you restore the DB instance, you provide the name of the DB snapshot to restore from, and then provide a name for the new DB instance that is created from the restore. You cannot restore from a DB snapshot to an existing DB instance; a new DB instance is created when you restore."

[ Parent | on HN ]
Re:Why I left Heroku, and notes on my new AWS setup by rschmitty on Monday May 20, 2013 @01:49PM (#5738919)
I have also used their snapshots with success
[ Parent | on HN ]
Re:Why I left Heroku, and notes on my new AWS setup by gazarsgo on Monday May 20, 2013 @01:42PM (#5738867)
"you get very little control over the environment" also seems spurious. You get parameter groups to control just about everything you can from a standalone mysql instance. logs or things that load from disk (LOAD DATA ...) are the only things you can't touch, but a small price to pay for automated backups, failover and scaling (both up AND down...)
[ Parent | on HN ]
Re:Why I left Heroku, and notes on my new AWS setup by toomuchtodo on Monday May 20, 2013 @01:54PM (#5738955)
Sorry if I wasn't specific enough.

In my opinion, you don't get enough control over the environment for what you're paying on a per hour basis. Automated backups? Great, they aren't that difficult to being with. Failover? Sure, within the same AZ, when you need to be doing it between datacenters. Scaling? I will grant that it scales up and down fast automagically.

[ Parent | on HN ]