Worry-Free PostgreSQL cloud deployment with IBM Cloud Databases for PostgreSQL
October 25, 2019

Worry-Free PostgreSQL cloud deployment with IBM Cloud Databases for PostgreSQL

Jon Tara | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Modules Used

  • CloudFoundry - Ruby Sinatra
  • Cloud Object Store
  • App ID
  • Key Protect
  • Activity Monitor
  • LogDNA
  • Availability Monitoring

Overall Satisfaction with IBM Cloud Databases (formerly Compose)

IBM Cloud Databases is used (along with IBM Cloud Object Store) as part of a backend system supporting client, eGrove Education Inc.'s, mobile app which helps high school and college STEM students develop their spatial visualization skills through automatically-graded free-hand sketching in a mobile app.

A CloudFoundry app uses IBM Cloud Databases as a synchronization source/sink and system of record for assigned material (both text and media blob data), course rosters, grading results, etc. (Because of the volume of student-produced sketches, student sketches are stored in Cloud Object Store).
  • ACID Compliance vs non-ACID compliance of the most popular open-source relational database (MySQL).
  • Fully managed solution: no bumbling with server installation/setup/maintenance.
  • Reliable high-availability implementation.
  • Yet more fine-grained provisioning (but thanks for the improvements!) For example, currently there is a 3-core minimum for dedicated cores.
  • It is difficult to determine for this use case, as it is a new use case, and not yet fully scaled-out in the market. Costs have and are projected to be more than acceptable, and at a welcome reduction from the previous Compose cost structure.
I have no historical basis to answer this.
This had no impact. You offer our preferred relational database, PostgreSQL. This is all that matters. Currently, have no interest/need in the other offerings, but good to know they are available with similar support and easy provisioning.
We actually did have a single one-hour outage of our primary PostgreSQL server, a few months ago. It failed-over to the backup server without interruption of service.

Although I designed a very resilient synchronization process for the associated mobile app, (it can tolerate a back-end outage of a few minutes or a few days, while allowing students to continue to work) it was good not to have students see warning messages and potentially lose confidence in the app.
I did compare IBM Compose for PostgreSQL with PostgreSQL offerings available from Amazon and Google. IBM Compose was judged easier to provision and maintain.

I'm pleased with the additional more granular provisioning flexibility and more favorable cost structure that has come with the transition to IBM Databases for PostgreSQL.
This is my current go-to solution where a relational database in the cloud is a requirement. The IBM Cloud Databases PostgreSQL implementation is particular attractive vs. alternatives available from other cloud providers because of relational databases scale "up" well (while generally not scaling "out" well or at all) and IBM is able to offer the ultimate scale-up, the recently available, Hyper Protect DBAAS. I can build today on IBM Cloud Databases for PostgreSQL with the knowledge that in the future, if needed, I can scale up to a solution running on massive Z-Series hardware that is at the same time much more secure (particularly from side-channel attack) than solutions running on Intel hardware.

IBM Cloud Databases Feature Ratings

Automatic software patching
Database scalability
Automated backups
Database security provisions
Monitoring and metrics
Automatic host deployment