We performed a comparison between CockroachDB and MySQL based on real PeerSpot user reviews.Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
"CockroachDB is highly reliable."
"I use CockroachDB to test big data samples and to create the best structure for databases. We have four users and required 10 people for deployment and maintenance."
"MySQL's most significant attribute is its capability to create, modify, and maintain databases. This is crucial and advantageous in procedures, such as SOAR. Therefore, all SQL functions are beneficial to any backend developer or developer who requires data storage."
"It's a mature solution that's been around for decades."
"We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good."
"MySQL is an open-source product and has good community support. If you encounter any problem, you can easily ask other members of the community to help. They help you a lot. On top of being free, MySQL is a cross-platform database, meaning it can work on both Windows and Linux. It is very good for us."
"The solution is great for small applications in particular."
"The initial setup for the SQL database is not complex and it even integrates into the platform. You set up the recipe and then just follow the runbook, the build book. Then it works as long as you follow the procedures."
"MySQL is easy to use, has fast performance, and it is comfortable for end-user to use. The schema level and structure we are using are very simple and easy to understand. Additionally, packaging tool development is straightforward and the data is presented in a way that is very simple to understand."
"The solution is easy to use."
"The closer they can make CockroachDB to being completely compatible with Postgres, the better. It's almost compatible, but not completely. If it was, it would be nice to just be able to use Postgres libraries without any fiddling."
"Cockroach does not support all types of protocols. I need to improve it myself to support a CouchDB on my network."
"The availability of tools could be improved in the MySQL open-source platform. They can provide more analytical tools. I haven't had any particularly difficult issues to troubleshoot on MySQL, but in the past, on Microsoft SQL Server, I had to troubleshoot some difficult issues, and better tools were in place to see what was going on in real-time on the server. So, that's the bit that is lacking on the MySQL open-source platform."
"I would like to see some improvements in the solution’s integration aspects."
"Since we upgraded from 8.0.12 to 8.0.22, it has had some slowness-related issues. Some of the queries that were fast previously are quite slow now. I did some research, and I found many people complaining about it."
"Improvements to MySQL depend on the specific use case. For example, in my scenario, I frequently need to maintain and store data, which can then be utilized to generate reports. On the other hand, others may suggest incorporating a feature that allows for easier visualization of the data, such as what is available in Power BI or other similar tools."
"I did the implementation of the solution myself and I used community support. The support from the vendor costs money."
"When I run into issues, I really have to research how to fix them."
"Even for the best database, we always want the database to perform much better, so we wish MySQL would be much better, in terms of performance."
"The auto-tuning and NDB cluster has some limitations regarding foreign keys."
CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.
CockroachDB is inspired by Google’s Spanner and F1 technologies, and it’s completely open source.
MySQL is an open-source relational database management system (RDBMS) owned by Oracle. Before Oracle acquired the product, it was completely free for users. After the merge, the solution started offering paid services with more features, alongside a free version. MySQL can easily integrate with a wide variety of programming languages, which makes it one of the most flexible and reliable products among its competitors. This cost-effective solution helps users deliver high-performance and scalable database applications through several products. They include:
My SQL Features
The characteristics of each MySQL edition differ depending on what it offers and what clients it is catered towards. But the main features of the product include the following:
MySQL brings many benefits to organizations that use it for their data. The most common ones include:
Reviews from Real Users
According to a database engineer at a retailer with more than 10,000 employees, MySQL is a great open-source product that offers great scalability and compatibility.
Yong S., a solutions specialist, system integration, appreciates this product because it has different licensing options and is easy to set up.
CockroachDB is ranked 12th in Relational Databases Tools with 2 reviews while MySQL is ranked 3rd in Relational Databases Tools with 40 reviews. CockroachDB is rated 8.6, while MySQL is rated 8.4. The top reviewer of CockroachDB writes "Reliable, quick and simple implementation ". On the other hand, the top reviewer of MySQL writes "A great open-source product that offers great scalability and compatibility". CockroachDB is most compared with Oracle Database, Citus Data, Amazon Aurora, SQL Server and SingleStore, whereas MySQL is most compared with Firebird SQL, MariaDB, Oracle Database, SQL Server and Oracle Java DB. See our CockroachDB vs. MySQL report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.