CockroachDB vs MySQL
When comparing CockroachDB vs MySQL, the Slant community recommends MySQL for most people. In the question“What are the best open-source Relational Databases?” MySQL is ranked 2nd while CockroachDB is ranked 5th. The most important reason people chose MySQL is:
MySQL is made to handle a lot of data and to be used in large applications. This makes it extremely scalable and fast, even under a lot of workload.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro High availability
Pro Distributed transactions
Pro Automated scaling & repair
Pro Cross Cloud Provider Replication/Migration
Run CockroachDB nodes in two or more cloud networks (AWS, GCP, Azure) and replicate the databases. Migrate from one cloud provider to another.
See this blog article for details: https://www.cockroachlabs.com/blog/cross-cloud-migration/
Pro SQL
Pro Strong consistency
Pro Simplified deployment
Pro Scalable
MySQL is made to handle a lot of data and to be used in large applications. This makes it extremely scalable and fast, even under a lot of workload.
Pro Multiple third-party tools that help working with MySQL
Since MySQL is one of the most popular relational databases, maybe the most popular, there exist many third-party tools and applications that help developers to use MySQL in their development.
Pro Easy to start working with
Because of it's popularity there are a lot of tutorials and guides out there that help developers install and work with MySQL. The installation process itself is not very hard and there are multiple powerful GUI tools that make it extremely easy to work with MySQL for a beginner.
Cons
Con Immature project
Some important features are missing and heavy use in production is minimal.
Con Error messages usually are not very detailed
When you are trying to do something in MySQL and something goes wrong it will simply give you an error message with an error code. Which does not say much about what went wrong unless you look it up online. This can be a little cumbersome during development.