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

ClearDB

27
83
+ 1
28
Google Cloud SQL

556
570
+ 1
46
Add tool

ClearDB vs Google Cloud SQL: What are the differences?

  1. Database Engine: ClearDB uses MySQL as its database engine, while Google Cloud SQL supports multiple databases such as MySQL, PostgreSQL, and SQL Server. This difference in database engines can impact the compatibility and performance of applications running on these platforms.

  2. Scalability: Google Cloud SQL offers automated vertical scaling, allowing users to easily adjust the computing power of their database instances, whereas ClearDB does not offer this feature. This can be crucial for applications experiencing fluctuating workloads that require dynamic scaling of resources.

  3. Pricing Model: ClearDB follows a pay-as-you-go pricing model, where users are charged based on their actual resource usage, while Google Cloud SQL offers different pricing tiers with fixed monthly costs. This difference in pricing models can influence the cost-effectiveness of each service based on the specific needs of the user.

  4. Integration with Cloud Services: Google Cloud SQL seamlessly integrates with other Google Cloud Platform services such as Compute Engine and App Engine, enabling easier deployment and management of applications, while ClearDB does not have the same level of integration. This can simplify the development and deployment process for users utilizing Google Cloud Platform services.

  5. High Availability and Backups: Google Cloud SQL includes built-in high availability features and automated backups, ensuring data redundancy and disaster recovery, which may require additional configurations in ClearDB. This difference can impact the reliability and availability of databases in case of failures or data loss scenarios.

In Summary, ClearDB and Google Cloud SQL differ in their database engines, scalability options, pricing models, integration with cloud services, and high availability features, which can influence the performance, cost, and ease of use for users based on their specific requirements.

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 · 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
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More