pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Shaun Thomas <sthomas@peak6.com>
To: Joel Reymont <joelr1@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: amazon ec2
Date: Wed, 4 May 2011 09:04:18 -0500
Message-ID: <4DC15CE2.8020708@peak6.com> (raw)
In-Reply-To: <ADB48657-780F-4465-ABE6-752C2FB3AF48@gmail.com>
References: <ADB48657-780F-4465-ABE6-752C2FB3AF48@gmail.com>

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



view thread (16+ messages)  latest in thread

Message-ID: <4DC15CE2.8020708@peak6.com>
Permalink:  ../4DC15CE2.8020708@peak6.com/
Also on:    postgresql.org/message-id/4DC15CE2.8020708@peak6.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sthomas@peak6.com, joelr1@gmail.com
  Subject: Re: amazon ec2
  In-Reply-To: <4DC15CE2.8020708@peak6.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox