Need advice about which tool to choose?Ask the StackShare community!

ClearDB

27
78
+ 1
28
TrueVault

3
9
+ 1
0
Add tool

ClearDB vs TrueVault: What are the differences?

Developers describe ClearDB as "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. On the other hand, TrueVault is detailed as "HIPAA compliant Database as a Service". TrueVault was built to help startups simplify the complexities of HIPAA. TrueVault will save you hundreds of dev hours. Focus on building your software's core functionality, and let TrueVault protect your data at HIPAA-security levels.

ClearDB and TrueVault can be primarily classified as "SQL Database as a Service" tools.

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, TrueVault provides the following key features:

  • HIPAA Compliant - We handle all of the technical requirements mandated by the HIPAA Security Rule. Typical integration takes days and saves months of dev time.
  • Built for Developers- Store and search protected health information (PHI) in any file format with a simple RESTful API. No pre-defined schemas to follow.
  • BAA + Insurance - TrueVault will sign a Business Associate Agreement (BAA), and protects customers under a comprehensive Privacy/Data Breach insurance policy.
Advice on ClearDB and TrueVault

Hi, I'm a beginner at using MySQL, I currently deployed my crud app on Heroku using the ClearDB add-on. I didn't see that coming, but the increased value of the primary key instead of being 1 is set to 10, and I cannot find a way to change it. Now I`m considering switching and deploying the full app and MySql to DigitalOcean any advice on that? Will I get the same issue? Thanks in advance!

See more
Replies (2)
Andy Gee
Freelance Developer at DGTEpro · | 2 upvotes · 4.8K views
Recommends

If a database tables has had some records added to it, and those records are then deleted the Auto Increment value is not automatically reset to avoid accidentally referencing an incorrect row. (e.g. maybe another reference to that row ID exists somewhere). If that's not a problem you can manually reset it with

ALTER TABLE tablename AUTOINCREMENT = 0;

Alternatively, if you were to TRUNCATE the table (DELETE ALL RECORDS), this would also reset the AUTO INCREMENT value: TRUNCATE TABLE table_name;

See more
austin heisley-cook
backend specialist and develop at msyekf · | 1 upvotes · 8.3K views

what does your database look like? did you add auto-increment that could add a nubetr t ass

See more
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of ClearDB
Pros of TrueVault
  • 7
    Cloud SQL
  • 6
    Heroku
  • 4
    Fast
  • 3
    Great Backup
  • 3
    Easy to use
  • 2
    Scalability
  • 1
    Great Support
  • 1
    Geographic redundancy
  • 1
    Master / master replication
    Be the first to leave a pro

    Sign up to add or upvote prosMake informed product decisions

    What is ClearDB?

    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 TrueVault?

    TrueVault was built to help startups simplify the complexities of HIPAA. TrueVault will save you hundreds of dev hours. Focus on building your software's core functionality, and let TrueVault protect your data at HIPAA-security levels.

    Need advice about which tool to choose?Ask the StackShare community!

    What companies use ClearDB?
    What companies use TrueVault?
      No companies found
      See which teams inside your own company are using ClearDB or TrueVault.
      Sign up for StackShare EnterpriseLearn More

      Sign up to get full access to all the companiesMake informed product decisions

      What tools integrate with ClearDB?
      What tools integrate with TrueVault?
        No integrations found

        Sign up to get full access to all the tool integrationsMake informed product decisions

        What are some alternatives to ClearDB and TrueVault?
        MySQL
        The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
        Heroku Postgres
        Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.
        Firebase
        Firebase is a cloud service designed to power real-time, collaborative applications. Simply add the Firebase library to your application to gain access to a shared data structure; any changes you make to that data are automatically synchronized with the Firebase cloud and with other clients within milliseconds.
        Amazon RDS
        Amazon RDS gives you access to the capabilities of a familiar MySQL, Oracle or Microsoft SQL Server database engine. This means that the code, applications, and tools you already use today with your existing databases can be used with Amazon RDS. Amazon RDS automatically patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery. You benefit from the flexibility of being able to scale the compute resources or storage capacity associated with your Database Instance (DB Instance) via a single API call.
        Amazon Aurora
        Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL at a price point one tenth that of a commercial database while delivering similar performance and availability.
        See all alternatives