News for hackers. Stuff that matters.
Re:Ask HN: Anyone used Amazon EC2 with a database or other h... by jedberg on Sunday November 15, 2009 @01:15PM (#943151)
I'm beginning to thing that MySQL does something very different with disks than Postgres, because everyone I've talked to that said they had a problem had been running MySQL, and everyone who has been successful has been running Postgres (myself included).
Re:Ask HN: Anyone used Amazon EC2 with a database or other h... by qhoxie on Sunday November 15, 2009 @01:58PM (#943196)
This really would not be all that surprising, but it also would not surprise me if the average Postgres setup was better tuned/architected than the majority case of MySQL uses.

Our setup was surely not ideal, but even with significant tuning, it was not sufficient.

It is really good to hear successes like Reddit's, though. How long have you folks had your databases in EC2?

Re:Ask HN: Anyone used Amazon EC2 with a database or other h... by jedberg on Sunday November 15, 2009 @02:06PM (#943211)
We had some of databases at EC2 since November of 2008, and moved the rest of them over in May 2009.
Re:Ask HN: Anyone used Amazon EC2 with a database or other h... by metajack on Monday December 21, 2009 @11:30AM (#1008070)
Maybe. I know when we migrated Chesspark from native machines to EC2, the postgresql database performance was at least an order of magnitude worse, and we spent two weeks doing caching and index hunting that we never had to worry about before.