Re: Using AWS ephemeral SSD storage for production databaseworkload? - Mailing list pgsql-general

From Steven Lembark
Subject Re: Using AWS ephemeral SSD storage for production databaseworkload?
Date
Msg-id 20180129134145.7f96c816@wrkhors.com
Whole thread Raw
In response to Re: Using AWS ephemeral SSD storage for production database workload?  (Pritam Barhate <pritambarhate@gmail.com>)
Responses Re: Using AWS ephemeral SSD storage for production database workload?  (Paul A Jungwirth <pj@illuminatedcomputing.com>)
List pgsql-general
On Mon, 29 Jan 2018 23:27:32 +0530
Pritam Barhate <pritambarhate@gmail.com> wrote:

> In short, I am just trying to learn from other people's experience.

This is identical to solutions that use tmpfs on linux for 
database storage or dealing with a fully failed storage 
system. Think about what you'd do if a RAID controller 
fried and botchd your entire array at once. You'll feel
just the same way if a box using ephemeral storage goes
down.

Your application needs to handle restarting transactions
and either a reverse proxy/load-balancer or client-side
switchover.

Depending on your tolerance for data loss you might need
three servers up, on as a secondary failover if the primary
fails so that you (pretty much) always have two servers up
to maintain the data. The last server only has to last long
enough for a restart and recovery so it might not have to
be very heavy duty, it's main purpose is to keep the database
alive long enough to recover the "real" server.

Q: Why not just use RDS?

It'll be simpler.

-- 
Steven Lembark                                       1505 National Ave
Workhorse Compuing                                 Rockford, IL 61103
lembark@wrkhors.com                                    +1 888 359 3508


pgsql-general by date:

Previous
From: Vitaliy Garnashevich
Date:
Subject: Re: EXPLAIN BUFFERS: dirtied
Next
From: Paul A Jungwirth
Date:
Subject: Re: Using AWS ephemeral SSD storage for production database workload?