I have an application that we are currently running on several shared servers, and I am interested in moving everything to the cloud.
I have an outdated application working with Postgres and its replacement application using MySql as a data store. I am interested in moving to EC2 and hoping to make it as painful as possible. I planned to use Amazon RDS for MySql data storage, but I am looking for Postgres installation options.
I know Heroku is built on top of EC2 and supports Postres and wondered
Does anyone have experience accessing the Heroku Postgres database from an application running in EC2. Comments on performance, administration reliability
Another alternative is to install Postgres on EC2 with EBS volumes, but I have heard mixed reviews about the performance, reliability, and ease of administration.
Thank you in advance for any experience and suggestions.
source share