Need advice about which tool to choose?Ask the StackShare community!
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
- Rollback
- Dataclips
"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.
Considering moving part of our PostgreSQL database infrastructure to the cloud, however, not quite sure between AWS, Heroku, Azure and Google cloud. Things to consider: The main reason is for backing up and centralize all our data in the cloud. With that in mind the main elements are: -Pricing for storage. -Small team. -No need for high throughput. -Support for docker swarm and Kubernetes.
DigitalOcean's offering is pretty solid. Easy to scale, great UI, automatic daily backups, decent pricing.
Amazon RDS for PostgreSQLGood balance between easy to manage, pricing, docs and features.
Pros of ClearDB
- Cloud SQL7
- Heroku6
- Fast4
- Great Backup3
- Easy to use3
- Scalability2
- Master / master replication1
- Great Support1
- Geographic redundancy1
Pros of Heroku Postgres
- Easy to setup29
- Follower databases3
- Dataclips for sharing queries3
- Extremely reliable3
Sign up to add or upvote prosMake informed product decisions
Cons of ClearDB
Cons of Heroku Postgres
- Super expensive2
Sign up to add or upvote consMake informed product decisions
What is ClearDB?
What is Heroku Postgres?
Need advice about which tool to choose?Ask the StackShare community!
What companies use ClearDB?
What companies use Heroku Postgres?
Sign up to get full access to all the companiesMake informed product decisions
What tools integrate with ClearDB?
Sign up to get full access to all the tool integrationsMake informed product decisions
Blog Posts
+47
+25
+24
+20