Re: Amazon High I/O instances

Just looking into High IO instances for a DB deployment. In order to get past 1TB, we are looking at RAID-0. I have heard (http://hackerne.ws/item?id=4266119) there might be a problem if TRIM isn't supported. Does anyone know if it is and has anyone used RAID-0 on these instances? (Linux of course…)

On Aug 21, 2012, at 9:36 AM, Merlin Moncure wrote:
> On Tue, Aug 21, 2012 at 12:33 AM, Sébastien Lorion
> <sl(at)thestrangefactory(dot)com> wrote:
>> Hello,
>>
>> Since Amazon has added new high I/O instance types and EBS volumes, anyone
>> has done some benchmark of PostgreSQL on them ?
>>
>> http://perspectives.mvdirona.com/2012/07/20/IOPerformanceNoLongerSucksInTheCloud.aspx
>> http://perspectives.mvdirona.com/2012/08/01/EBSProvisionedIOPSOptimizedInstanceTypes.aspx
>> http://aws.typepad.com/aws/2012/08/fast-forward-provisioned-iops-ebs.html
>>
>> I will be testing my app soon, but was curious to know if others have done
>> some tests so I can compare / have a rough idea to what to expect. Looking
>> on Google, I found an article about MySQL
>> (http://palominodb.com/blog/2012/07/24/palomino-evaluates-amazon%E2%80%99s-new-high-io-ssd-instances),
>> but nothing about PostgresSQL.
>
> here's a datapoint, stock config:
> pgbench -i -s 500
> pgbench -c 16 -T 60
> number of transactions actually processed: 418012
> tps = 6962.607292 (including connections establishing)
> tps = 6973.154593 (excluding connections establishing)
>
> not too shabby. this was run by a friend who is evaluating high i/o
> instances for their high load db servers. we didn't have time to
> kick off a high scale read only test unfortunately.
>
> Regarding 'AWS vs bare metal', I think high i/o instances full a huge
> niche in their lineup. Dollar for dollar, I'm coming around to the
> point of view that dealing with aws is a cheaper/more effective
> solution than renting out space from a data center or (even worse)
> running your own data center unless you're very large or have other
> special requirements. Historically the problem with AWS is that you
> had no solution for highly transaction bound systems which forced you
> to split your environment which ruined most of the benefit, and they
> fixed that.
>
> merlin