bmurphy

Just because you have 16gb of memory doesn't mean you won't ever swap. Firefox is not the only application running on a computer. My working set is routinely over 7gb and I have 8gb on my laptop. A goldfish will grow to full its bowl. If I had 16gb, I know I could use it. Every little bit counts.

I used MSSQL up to MSSQL 2005 and MySQL up until about the same time. Around then I switched over to PostgreSQL completely and have not had a reason to go back. My biggest complaints had to do with simple replication and that was mostly solved in Postgres 9.0. Postgres is a damn fine database.

I agree with the parent. Something very simplistic in json or yaml would be preferred.

I can't play it. I've played too many FPS and Flight Simulators in my time. The controls need to be inverted so i can fly it like a real plane. Too bad.

Absolutely. You should always be spreading your data across multiple availability zones and where feasible across multiple data centers and S3 is a great place to store your wal logs. We do the same thing.

EBS is a shared networked SAN. The performance characteristics of it are not that great and even worse, highly variable. The last thing you want to be running your database on is a system where the performance characteristics vary greatly throughout the day and you have no control over it.

The ephemeral drives are drives directly attached to the server and to the best of my knowledge are not a shared resource. Their performance characteristics are highly consistent, but if your server goes down all data on those drivers are lost.

EBS sounds nice in theory, but by going to EBS RAID you throw away most of its benefits (such as snapshotting) and take on it's worst aspects.

Very nice, thank you. Mostly all of this is good advice and correlates nicely with my experience.

One thing though:

"EBS volumes and Software RAID is best but scary on AWS"

I've managed an EBS RAID10 database for a few years now. I wouldn't touch this with a 10 foot pole.

Do yourself a favor, set up an m1.xlarge (or bigger) instance, put the ephemeral drives in a RAID0 and mirror across multiple machines using hot-standby, slony, londiste, or some other tool. You'll be much happier, your system will perform much better, and you'll have a failover strategy in place.

Agreed.

I personally go through my RSS feed every few months and re-evaluate my feeds. If I have feeds that have low signal to noise ratios, or simply publishes articles that I never read, I remove them.

Also, I segregated high volume feeds (such as Flickr picture feeds and Gizmodo/NYTimes/BBC etc.) into a separate account. I have two accounts, one (low volume) where I try to take a closer more thorough look at everything, and another (high volume) where I simply do a quick scan then mark all as read.

Don't blame RSS for your inability to manage it.

Nice. Much better.

As the Father of a 19 month old I can only say this is a complete rip-off.

Craig's list, friends and family, birthdays, holidays, garage sales, second hand stores, 50% off coupons, the list goes on and on.

$16/mo for two outfits? Really? Maybe $1/mo/outfit or something like that and I'll bite. Right now, one years subscription would be more than her entire wardrobe and we're pretty much done until age 4.

Argh. Same crap as with all the population predictions. Everybody always assumes the graph is exponential. It is not. It always levels off. The real trick is predicting where/when that will happen.

You could always replace it with an EBS volume.

I don't have solid numbers, just some experience using this. Ephemeral drives outright fail more often than EBS volumes, however, EBS volumes suffer performance degradation significantly more often than ephemeral drives. EBS volume performance is HIGHLY variable, at all times of day, no matter what load you throw at it. Ephemeral drives are very consistent most of the time.

Both types of drives CAN and DO fail, so RAID-10, fail over, and replication are a must have.

My experience has been that EBS handles concurrent loads better, ephemeral drives handle non-concurrent loads better.

Transferring 100gb+ of data on EBS (even with an 8x RAID) is a nightmare. Ephemeral drives, however, it's fairly fast.

Throw 100+ database connections at a few ephemeral drives (even in a RAID) and watch your web site slow to a crawl.