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

Amazon RDS

15.6K
10.6K
+ 1
761
ClearDB

27
83
+ 1
28
TempoDB

4
11
+ 1
0
Advice on Amazon RDS, ClearDB, and TempoDB

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 · 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;

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

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

See more
Decisions about Amazon RDS, ClearDB, and TempoDB
Phillip Manwaring
Developer at Coach Align · | 5 upvotes · 26.3K views

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

See more
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 TempoDB
  • 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
    Be the first to leave a pro

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

    TempoDB is the first database service for time series data (ex: measuring thermostat temperatures, network latencies, heart rates). Time series is a unique Big Data problem that breaks traditional databases (MySQL, MongoDB, etc). Today, businesses spend months and millions attempting to build solutions to manage all this data and yet still fail to store as much as they need or analyze it effectively. TempoDB is a purpose-built database service that enables businesses to store and analyze massive streams of time series data, so they can learn from the past, understand the present, and predict the future.

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

    What companies use Amazon RDS?
    What companies use ClearDB?
    What companies use TempoDB?

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

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

    Blog Posts

    GitHubDockerAmazon EC2+23
    12
    6566
    JavaScriptGitHubPython+42
    53
    21865
    DockerSlackAmazon EC2+17
    18
    5969
    What are some alternatives to Amazon RDS, ClearDB, and TempoDB?
    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