“But postgres isn’t a document store!” I hear you cry. After waiting around nine months for this feature to be added, we ended up giving up and looking for something else, ultimately choosing to use Postgres on AWS RDS.
Unfortunately at the time Dynamo didn’t support encryption at rest. Since all our other services are running in AWS, the obvious choice was DynamoDB – Amazon’s NoSQL database offering. We lost at least two months of engineering time a year doing this database management work.Īll of these problems, combined with the hefty annual fee we were paying for the support contract and OpsManager, left us looking for an alternative database option, with the following requirements: It also didn’t deliver on its “one-click upgrade” promise, due to changes in the authentication schema between different versions of Mongo DB. For instance, actually managing OpsManager itself – in particular upgrading from OpsManager 1 to 2 – was very time consuming, and required specialist knowledge about our OpsManager setup. OpsManager didn’t really deliver on its promise of hassle-free database management. When clocks get out of sync, networking becomes a nightmare. We ended up having to run knowledge sharing sessions about database management in the team – something we’d hoped OpsManager would make easy.
This was non-trivial, as Mongo didn’t provide any tooling for getting set up easily on AWS – we needed to hand write the cloudformation to define all the infrastructure, and on top of that we wrote hundreds of lines of ruby scripts to handle installation of monitoring/automation agents and orchestration of new DB instances. We used OpsManager to manage backups, handle orchestration and provide monitoring for our database cluster.ĭue to editorial requirements, we needed to run the database cluster and OpsManager on our own infrastructure in AWS rather than using Mongo’s managed database offering.
Aws postgresql error software#
We decided to purchase OpsManager – Mongo’s database management software – along with a Mongo support contract – to help with the cloud migration. Photograph: Sarah Lee/GuardianĪfter this, the Guardian’s migration to AWS became that bit more urgent. Hot weather: good for fountain dancing, bad for data centres.
0 kommentar(er)
