Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 7D1021337B82 for ; Wed, 4 May 2011 11:04:38 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 50523-04 for ; Wed, 4 May 2011 14:04:20 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp.peak6.com (smtp.peak6.com [38.98.137.6]) by mail.postgresql.org (Postfix) with ESMTP id 8FF961337B92 for ; Wed, 4 May 2011 11:04:18 -0300 (ADT) X-AuditID: 0a64cb1e-b7c43ae000003d6d-df-4dc15ce2c319 Message-ID: <4DC15CE2.8020708@peak6.com> Date: Wed, 4 May 2011 09:04:18 -0500 From: Shaun Thomas Reply-To: Organization: Peak6 User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.7) Gecko/20100720 Lightning/1.0b2 Thunderbird/3.1.1 MIME-Version: 1.0 To: Joel Reymont CC: Subject: Re: amazon ec2 References: In-Reply-To: Content-Type: text/plain; charset="ISO-8859-1"; format=flowed content-transfer-encoding: 7bit X-Originating-IP: [10.10.221.50] X-Brightmail-Tracker: AAAAAQAAAZE= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201105/49 X-Sequence-Number: 43558 On 05/03/2011 01:48 PM, Joel Reymont wrote: > What are the best practices for setting up PG 9.x on Amazon EC2 to > get the best performance? Use EC2 and other Amazon hosting for cloud-based client access only. Their shared disk services are universally despised by basically everyone who has tried to use it for database hosting. The recommended pattern is to have the scalable cloud clients access (and memcache) a remote DB at a colo or managed services host. EBS is a nice idea, and probably fine for things like image or video hosting, but database access, especially for OLTP databases, will just result in wailing and gnashing of teeth. Just ask anyone who got bit by the recent EBS failure that spanned *several* availability zones. For all those clients who thought they were safe by deploying across multiple ACs, it was a rather rude awakening. http://aws.amazon.com/message/65648/ The consensus seems to be that Amazon's cloud is fine... so long as you stay far, far away from EBS. Apparently that needs a little more work. -- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604 312-676-8870 sthomas@peak6.com ______________________________________________ See http://www.peak6.com/email_disclaimer.php for terms and conditions related to this email