Re: Using AWS ephemeral SSD storage for production database workload?

On Mon, 29 Jan 2018 23:27:32 +0530
Pritam Barhate <pritambarhate(at)gmail(dot)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(at)wrkhors(dot)com +1 888 359 3508