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

ClearDB

24
73
+ 1
28
Google Cloud SQL

509
528
+ 1
46
Add tool

ClearDB vs Google Cloud SQL: 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, Google Cloud SQL is detailed as "Store and manage data using a fully-managed, relational MySQL database". MySQL databases deployed in the cloud without a fuss. Google Cloud Platform provides you with powerful databases that run fast, don’t run out of space and give your application the redundant, reliable storage it needs.

ClearDB and Google Cloud SQL 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, Google Cloud SQL provides the following key features:

  • Familiar Infrastructure
  • Flexible Charging
  • Security, Availability, Durability

"Cloud SQL" is the top reason why over 5 developers like ClearDB, while over 12 developers mention "Fully managed" as the leading cause for choosing Google Cloud SQL.

Policygenius, Implisit, and OTOBANK are some of the popular companies that use Google Cloud SQL, whereas ClearDB is used by Salesforce, Movielala, and Skype. Google Cloud SQL has a broader approval, being mentioned in 73 company stacks & 28 developers stacks; compared to ClearDB, which is listed in 5 company stacks and 3 developer stacks.

Advice on ClearDB and Google Cloud SQL

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.5K 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 · 7.9K 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