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

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!

Replies (2)

Andy Gee

Freelance Developer at DGTEpro · Sep 17, 2021 | 2 upvotes · 5.4K 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;

austin heisley-cook

backend specialist and develop at msyekf · Jul 10, 2021 | 1 upvotes · 8.8K views

Recommends

DigitalOcean Managed Databases

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

Decisions about Amazon RDS, ClearDB, and Google Cloud SQL

Phillip Manwaring

Developer at Coach Align · Mar 18, 2021 | 5 upvotes · 26.3K views

Chose

over

(

)

Using on-demand read/write capacity while we scale our userbase - means that we're well within the free-tier on AWS while we scale the business and evaluate traffic patterns.

Using single-table design, which is dead simple using Jeremy Daly's dynamodb-toolbox library

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.

Learn More

Pros of Amazon RDS

Pros of ClearDB

Pros of Google Cloud SQL

165
Reliable failovers
156
Automated backups
130
Backed by amazon
92
Db snapshots
87
Multi-availability
30
Control iops, fast restore to point of time
28
Security
24
Elastic
20
Push-button scaling
20
Automatic software patching
4
Replication
3
Reliable
2
Isolation

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

13
Fully managed
10
Backed by Google
10
SQL
4
Flexible
3
Encryption at rest and transit
3
Automatic Software Patching
3
Replication across multiple zone by default

Sign up to add or upvote prosMake informed product decisions

What is 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.

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 Google Cloud SQL?

Run the same relational databases you know with their rich extension collections, configuration flags and developer ecosystem, but without the hassle of self management.

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

What companies use Amazon RDS?

What companies use ClearDB?

What companies use Google Cloud SQL?

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

What tools integrate with Amazon RDS?

What tools integrate with ClearDB?

What tools integrate with Google Cloud SQL?

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

Blog Posts

Redux: Scaling LaunchDarkly From 4 to 200 Billion Feature Flag...

Mar 12 2019 at 3:11PM

LaunchDarkly

+23

6686

How Raygun Processes Millions of Error Events Per Second

May 17 2018 at 1:38AM

Raygun

+22

8704

How Opsee Chose A Container Orchestration Platform

May 27 2016 at 5:01AM

Opsee Co

+23

6566

Scaling Zapier to Automate Billions of Tasks

Feb 4 2016 at 6:44PM

Zapier

+42

21860

Scaling Clearbit to 2M API Requests Per Day

Sep 4 2015 at 8:23AM

Clearbit

+17

5969

How The World's Largest Design Marketplace Builds and Ships Co...

May 1 2015 at 12:32PM

99designs

+35

1735

How Gusto Processes Billions Of Dollars In Annual Payroll

Apr 17 2015 at 2:44AM

Gusto

+29

3052

What are some alternatives to Amazon RDS, ClearDB, and Google Cloud SQL?

Amazon Redshift

It is optimized for data sets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions.

Apache Aurora

Apache Aurora is a service scheduler that runs on top of Mesos, enabling you to run long-running services that take advantage of Mesos' scalability, fault-tolerance, and resource isolation.

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.

Oracle

Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.

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.

See all alternatives

Amazon RDS vs ClearDB vs Google Cloud SQL

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

Pros of Amazon RDS

Pros of ClearDB

Pros of Google Cloud SQL

Sign up to add or upvote prosMake informed product decisions

What is Amazon RDS?

What is ClearDB?

What is Google Cloud SQL?

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

What companies use Amazon RDS?

What companies use ClearDB?

What companies use Google Cloud SQL?

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

What tools integrate with Amazon RDS?

What tools integrate with ClearDB?

What tools integrate with Google Cloud SQL?

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

Blog Posts

Related Comparisons

Trending Comparisons

Top Comparisons