Re: Using AWS ephemeral SSD storage for production database workload? - Mailing list pgsql-general
G'day all,
We have been doing this in production for about five years, the client is aware of the trade off between speed, cost and availability. (By this I mean, if it goes down for a few minutes, no big concern to them). We had around 2 million users, but very small payloads.
We take full database backups every six hours, log-ship to s3, and run multiple hot streaming servers for a high level of user query activity.
Obviously, the risk was always there of an un-planned shutdown, but we had very good performance on a very cheap setup. m3.medium / ubuntu anyone!
Disclaimer - we don't do this any more for our bigger production systems ... for a number of reasons. We ran out of space on the SSD, our write queries are generally small and not complex, so we went to EBS backed without PIOPS, and haven't really noticed any major problems with performance. I felt that the risk / humbug associated with needing to upgrade the operating system etc made it easier to just use the EBS. This does also mean we can vertically scale our DB server easily and securely. We still have hot-streaming replications, back ups and log shipping.
hth
cheers
Ben
On 30 January 2018 at 04:36, Pritam Barhate <pritambarhate@gmail.com> wrote:
Thank you, Paul and Steven, for the information.@Paul: Thanks for the link. Planning to read through most of fdr's comments on Hacker News.@Steven:> Q: Why not just use RDS?
> It'll be simpler.Already using it for multiple deployments. I am primarily a programmer. But now want to get out of the RDS convenience zone.Regards,Pritam.
Dr Ben Madin
Managing Director
m : +61 448 887 220
5 Shuffrey Street, Fremantle
Western Australia
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this email are the opinion of the writer only and are not endorsed by Ausvet unless expressly stated otherwise. Although Ausvet uses virus scanning software we do not accept liability for viruses or similar in any attachments.
pgsql-general by date: