ClearDB vs Heroku Postgres: What are the differences?
What is ClearDB? Fault tolerant database-as-a-service in the cloud for your MySQL powered applications. ClearDB uses a combination of advanced replication techniques, advanced cluster technology, and layered web services to provide you with a MySQL database that is "smarter" than usual.
What is Heroku Postgres? Heroku's Database-as-a-Service. Based on the most powerful open-source database, PostgreSQL. Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.
ClearDB belongs to "SQL Database as a Service" category of the tech stack, while Heroku Postgres can be primarily classified under "PostgreSQL as a Service".
Some of the features offered by ClearDB are:
- Global Multi-Master Design- ClearDB uses geo-distributed MySQL database configurations for the ultimate in database availability, survivability, and performance. Even if whole cloud regions go offline, your database will stay online.
- Completely Fault Tolerant- ClearDB is the only cloud database in the market today that offers true multi-regional read/write mirroring with 100% uptime, even if networks or disks fail.
- Native MySQL- Our clusters use native MySQL so that you don't have to worry about re-tuning your applications to work with ClearDB.
On the other hand, Heroku Postgres provides the following key features:
- High Availability
"Cloud SQL" is the primary reason why developers consider ClearDB over the competitors, whereas "Easy to setup" was stated as the key factor in picking Heroku Postgres.
According to the StackShare community, Heroku Postgres has a broader approval, being mentioned in 74 company stacks & 39 developers stacks; compared to ClearDB, which is listed in 5 company stacks and 3 developer stacks.
What is ClearDB?
What is Heroku Postgres?
Need advice about which tool to choose?Ask the StackShare community!
Sign up to add, upvote and see more prosMake informed product decisions
What are the cons of using ClearDB?
Sign up to get full access to all the companiesMake informed product decisions
Sign up to get full access to all the tool integrationsMake informed product decisions
I could spin up an Amazon EC2 instance and install PostgreSQL myself, review latest configuration best practices, sort Amazon EBS storage for data, set up a snapshot process etc.
Alternatively I could use Amazon RDS, Amazon RDS for PostgreSQL or Heroku Postgres and have most of that work handled for me, by a team of world experts...
Stores the admin database for the SRX apps - includes an audit log, error tracking, and SRX admin message log.
Will also store PRS rules when refactor is complete.
Rock solid transactional storage of user, purchase and course activity data. During development database dumps were easy to create and download locally for testing.
We use heroku PostgreSQL databases for testing alongside our sandboxed application(s) in heroku.
Extremely simple, practically a one-click setup.
4 years of experience using Heroku Postgres for data storage and management.