Need advice about which tool to choose?Ask the StackShare community!
Amazon RDS vs ClearDB: What are the differences?
What is Amazon RDS? Set up, operate, and scale a relational database in the cloud. 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? 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.
Amazon RDS and ClearDB can be categorized as "SQL Database as a Service" tools.
Some of the features offered by Amazon RDS are:
- Pre-configured Parameters
- Monitoring and Metrics
- Automatic Software Patching
On the other hand, ClearDB provides the following key features:
- 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.
"Reliable failovers" is the primary reason why developers consider Amazon RDS over the competitors, whereas "Cloud SQL" was stated as the key factor in picking ClearDB.
Airbnb, Netflix, and Coursera are some of the popular companies that use Amazon RDS, whereas ClearDB is used by Salesforce, Movielala, and Skype. Amazon RDS has a broader approval, being mentioned in 1435 company stacks & 526 developers stacks; compared to ClearDB, which is listed in 5 company stacks and 3 developer stacks.
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!
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;
what does your database look like? did you add auto-increment that could add a nubetr t ass
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
Pros of Amazon RDS
- Reliable failovers165
- Automated backups156
- Backed by amazon130
- Db snapshots92
- Multi-availability87
- Control iops, fast restore to point of time30
- Security28
- Elastic24
- Push-button scaling20
- Automatic software patching20
- Replication4
- Reliable3
- Isolation2
Pros of ClearDB
- Cloud SQL7
- Heroku6
- Fast4
- Great Backup3
- Easy to use3
- Scalability2
- Great Support1
- Geographic redundancy1
- Master / master replication1