CockroachDB vs MariaDB comparison

Read 59 MariaDB reviews

8,351 Views
7,579 Comparison Views

96% willing to recommend

CockroachDB

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between CockroachDB and MariaDB 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.

To learn more, read our detailed CockroachDB vs. MariaDB Report (Updated: October 2024).

Download the complete report

CockroachDB vs. MariaDB

October 2024

Helped 816,406 peers since 2012

Categories and Ranking

CockroachDB

Ranking in Relational Databases Tools

11th

Average Rating

8.0

Reviews Sentiment

7.7

Number of Reviews

Ranking in other categories

No ranking in other categories

MariaDB

Ranking in Relational Databases Tools

5th

Average Rating

8.2

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

Open Source Databases (4th)

Mindshare comparison

As of November 2024, in the Relational Databases Tools category, the mindshare of CockroachDB is 3.0%, up from 2.3% compared to the previous year. The mindshare of MariaDB is 8.6%, down from 8.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Relational Databases Tools

Featured Reviews

Antonio Tringali

Software Engineer at a consultancy with self employed

Open source with extensive documentation and a University for training

I am a freelancer. A client of mine wanted a solution that would allow them to scale yet not abandon the familiar PostgreSQL front-end (and rewrite a part of their source code). Scalability aside, CockroachDB is a fine way forward from PostgreSQL and is not changing the client source code part of the system. If you are lucky and you do not use newer features from recent versions of PostgreSQL or PostgreSQL extensions, it's fine. There are nice-to-have features for big organizations like regional tables. At the moment, my client simply does not use these. However, the serverless offer from CockroachDB is reacting well as data grows.

Read full review

KumarManish

Senior Technical Manager at Johnson Controls, Inc.

Easy to deploy, cost-effective, and integrates seamlessly with other products

We had planned for an RDBMS version and not NoSQL. We use MariaDB Galera Cluster. It's a good product. It is cheap, scalable, performs well, and is efficient. We use GCP’s BigQuery for machine learning. We must follow the best practices of the tool. We missed some best practices like the storage engine and InnoDB. It was very difficult to identify why we were having performance issues. Then, we realized that some of our tables were still on MyISAM, the default storage engine. When we switched it back to the InnoDB, it was very smooth. InnoDB is the recommended one. We must follow the best practices given in the documentation during the initial setup. Overall, I rate the product a nine out of ten.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The best feature of CockroachDB is the ability to keep the nodes in different locations."

"The most valuable feature is that CockroachDB is a distributed database, which can deploy nodes running in different regions."

"CockroachDB is highly reliable."

"The availability and the easy to use feature is the most valuable. The documentation is also good."

"What I like best is its ability to solve data residency issues. The main advantage is auto geo partitioning, built into the product. This means we don't have to spin up separate servers in each region, which would be much more costly."

"The product has valuable security features."

"The initial setup and deployment are simple."

"The tool's most valuable feature is node syncing, which takes only 0.54 milliseconds."

More CockroachDB pros

"It delivers fast processing times, particularly for frequent select queries and insert/update operations."

"MariaDB is stable and the initial setup is straightforward."

"It is very simple to install, and the commands are exactly the same as MySQL."

"Easy to use and available in most environments."

"The most valuable feature of the solution is the query speed it offers."

"It is a scalable solution. It easily scales up and scales down."

"The most valuable feature is that it uses multiple cores, which is better than some of the other databases."

"Great monitoring and performance stability."

More MariaDB pros

Cons

"The initial setup and pricing could be improved."

"The platform could be more extensible."

"The product must improve its disaster recovery features."

"Cockroach does not support all types of protocols. I need to improve it myself to support a CouchDB on my network."

"I think the engine itself could be improved. If you miss a partition key, it should be able to be modeled. This is where AI could be really helpful. For example, if a user is from Australia, the system should know to look for their data there first instead of searching in the US or another continent."

"I find the serverless offer a bit confusing."

"We are looking for more features to support distributed high availability and geo-partitioning."

"I would like CockroachDB to have more compatibility with PostgreSQL, especially with the connection string and technical integrations."

More CockroachDB cons

"MariaDB could improve by adding support for non-relational structures and new data types."

"The product needs more features and more functionality. It's imperative that it supports more platforms, and supports more operating systems."

"The maintenance and performance could be a bit better."

"It's not very stable. It needs improvement."

"The configuration could be improved. It should be easier."

"The stability could always continue to be improved upon."

"I am editing."

"The solution can improve by having support for more integration. However, at this time it is working well for us."

More MariaDB cons

Pricing and Cost Advice

"The product's price depends on the user's company and the contract model they enter into with CockroachDB. Depending on the contract model one enters into with CockroachDB, the product may or may not be expensive."

"I've used CockroachDB at a small scale on the free accounts because we are only testing."

"The platform is affordable even for the enterprise version. It provides value for investment in terms of performance."

"The pricing is good but can be made cheaper. I would rate the pricing a five out of ten."

"The solution's pricing is not cheap. However, the good thing is that customers are willing to pay for it if they want it."

"I rate the product's price a three on a scale of one to ten, where one is low price, and ten is high price since there are some support costs involved, even though it isn't an open-source solution."

"The solution is free, but if you want the enterprise version you will need to pay for some licenses but the cost is less than other solutions, such as Oracle."

"This is an open-source product, which can be used free of charge."

"The price of this solution represents a very good compromise between the cost and what it offers."

"The licensing cost is approximately $4000.00 per year and the licensing is based on the software and the number of posts that you make."

"MariaDB is an open-source software, meaning I don't need to pay for the product."

"It is an open-source solution."

"This is an open source solution with no licensing fees."

More MariaDB pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.

See recommendations

816,406 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

39%

Computer Software Company

14%

Retailer

University

Computer Software Company

15%

Financial Services Firm

10%

Educational Organization

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about CockroachDB?

The subset of SQL that my client is using is completely supported.

What needs improvement with CockroachDB?

I think the engine itself could be improved. If you miss a partition key, it should be able to be modeled. This is where AI could be really helpful. For example, if a user is from Australia, the sy...

What is your primary use case for CockroachDB?

Cockroach nodes were installed in the following: 1. Single host, triple nodes (containers): for evaluation on a low-end PC. 2. Single host, triple nodes (process): to test applications against a ~5...

What do you like most about MariaDB?

The integration with other products is seamless.

What is your experience regarding pricing and costs for MariaDB?

I have found the price of commercial MariaDB to be pretty steep, although not as high as Oracle. Customers often prefer the Community Edition because it's free.

What needs improvement with MariaDB?

The only potential area for improvement could be the pricing model, which might benefit from being more flexible or a bit cheaper.

Oracle Database vs CockroachDB

Comparisons

Compared 21% of the time

Citus Data vs CockroachDB

Compared 18% of the time

MySQL vs CockroachDB

Compared 11% of the time

SQL Server vs CockroachDB

Compared 10% of the time

SAP HANA vs CockroachDB

Compared 3% of the time

More CockroachDB Competitors

SQL Server vs MariaDB

Compared 31% of the time

Firebird SQL vs MariaDB

Compared 19% of the time

Oracle Database vs MariaDB

Compared 13% of the time

PostgreSQL vs MariaDB

Compared 11% of the time

Tibero vs MariaDB

Compared 1% of the time

More MariaDB Competitors

Product Reports

Download CockroachDB product report

CockroachDB

November 2024

Download MariaDB product report

November 2024

Learn More

Cockroach

Video not available

Overview

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.

MariaDB is an open source relational database created by the original founders of MySQL. It is considered one of the most popular and trusted database servers throughout the world. MariaDB is a valued component found in most cloud offerings and is the default in many Linux tools. It is also widely used by Wikipedia, WordPress, and Google, among other well-known sites. Maria DB easily melds data into concise information from a vast array of applications, such as banking, online shopping, websites, and more.

MariaDB was originally created to improve MySQL performance. It is the most widely chosen database server due to the solution being super fast, robust, user-friendly, and easily scalable. MariaDB also offers a substantial ecosystem of plugins, storage engines, and numerous other valuable tools that make it very attractive for a significant offering of use cases.

The solution’s newest functionalities include compatibility with Oracle Database and Temporal Data Tables, and advanced clustering with Galera Cluster 4, which make it easier for users to research data history from any point in the past. Additionally, the most recent versions include JSON and GIS features. MariaDB is committed to staying an open source solution.

MariaDB Features

More storage: MariaDB works with more storage engines than MySQL and most other database servers available. Some storage options include, but are not limited to ARCHIVE, MERGE, CSV, MEMORY, BLACKHOLE, MyISAM, ColumnStore, MyRocks, and Cassandra.
Super fast: MariaDB offers faster authentication checks. The FlushSSL permits SSL certificates to be reloaded without a server restart, resulting in huge time savings.
Improved testing: MariaDB offers an extending testing suite that runs faster and can test more than ever before. Bugs can be easily fixed and invalid tests removed.
Genuinely open source: Every code in MariaDB is GPL, LGPL, or BSD. Client libraries [for Windows (ODBC), Java (JDBC), or C] allow linking to closed source software. All fixed bug cases and development plans are completely public. MariaDB is a community-developed solution representing the true spirit of open source products.

Reviews from Real Users

Faustine C., Engineering Supervisor- Corporate Data Solutions and Services at TZ Telecoms Corporation, shares, “The software provides a lot of information on what is happening inside the database. For most performance parameters it is easy to know if something is not right in the configuration or optimization which helps engineers take remedial fine-tuning measures. For example, if the database is underperforming it is easy to know which performance parameter can be adjusted to handle the workload. It is difficult to troubleshoot database issues if many performance parameters can not be monitored or debugged which is the case with some database management systems. It provides great monitoring of data storage, processing, and performance stability which is really important for real-time data storage and processing. It's a user-friendly product.”

A PeerSpot user who is a Senior Engineer at a tech services company relates, “ The solution's high availability is its most valuable aspect. We have found the product to be stable and the initial setup is pretty simple. I'd rate the solution at a ten out of ten. I'm very happy with it overall. I would recommend the solution to others. It's easy to find details about the product online and to learn about it.”

Sample Customers

Baidu, Kindred, Tierion, Heroic Labs, Gorgias

Google, Wikipedia, Tencent, Verizon, DBS Bank, Deutsche Bank, Telefónica, Huatai Securities