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
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).
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.
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.
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.