Re:How to move from Amazon RDS to a dedicated PostgreSQL server
by vacri on Tuesday May 24, 2016 @08:44PM
(#11766821)
I'm not sure that the article moved to bare iron. The author could have just set up postgres on a regular ec2 instance.
Re:How to move from Amazon RDS to a dedicated PostgreSQL server
by eliribble on Tuesday May 24, 2016 @09:38PM
(#11767074)
Yes, we did move to a regular EC2 instance for our cloud service. Where we install databases on premises for our customers it can be bare iron, but it can also be a similar virtualized setup.
Re:How to move from Amazon RDS to a dedicated PostgreSQL server
by samcheng on Tuesday May 24, 2016 @09:24PM
(#11767006)
Does that bring performance or cost savings? What is the motivation and calculus for making that transition?
Re:How to move from Amazon RDS to a dedicated PostgreSQL server
by eliribble on Tuesday May 24, 2016 @09:40PM
(#11767086)
It can bring a cost savings, but the savings is very slight if you're comparing apples-to-apples. For example, if you're using RDS in a multi-AZ replication set up with periodic S3 backups you have to take into account running each of the replica instances and the S3 costs. What we found was that RDS was treated like a black box to our automation (which was a good thing for a long time) and so we were less attentive to being over-provisioned and actually testing failover situations than we should have been.
Do people do this for security / policy purposes, or are they motivated by cost savings? Does removing all that virtualization buy improved performance?