Sign in
Sign in
or
Create a new account
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

CockroachDB (pay-as-you-go)

Cockroach Labs

Reviews from AWS customer

4 AWS reviews
  • 5 star
    0
  • 4 star
    4
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

34 reviews
from and

External reviews are not included in the AWS star rating for the product.

    SanjeevSingh4

Has in-built auto geo partitioning and doesn't require serves in separate regions

  • July 11, 2024
  • Review from a verified AWS customer

What is most valuable?

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.

Performance-wise, it's great once you know how to use it properly. The key benefit is that data sits on the edge closest to the user, regardless of their location. This leads to improved speed.

However, there's a downside - if you don't understand how it works, your queries might run everywhere. You need to fine-tune your queries to avoid this issue.

What needs improvement?

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.

For how long have I used the solution?

We went into production four months ago. We have been doing a proof of concept for the last eight months, so I have used it for less than a year.

What do I think about the stability of the solution?

We've had some issues with stability. They don't thoroughly test all their patches for all use cases. Given the complexity, I'm not sure how they could do that anyway. Some of their patch releases have burned us. We had to do rollbacks and fix things ad hoc. I rate it a seven point five out of ten.

What do I think about the scalability of the solution?

The tool has auto-scaling features. It can adjust automatically in the background.

How are customer service and support?

The support team is not as responsive as we'd like. Their support is not as robust as that of some other providers. It's kind of hit or miss, depending on who you get to help you.

How was the initial setup?

We had to migrate from PostgreSQL. It was very complex. Depending on your current model, it can be complicated. But if everything is somewhat similar to what CockroachDB expects, then it's not too bad.

What about the implementation team?

We did the tool's deployment in-house.

What was our ROI?

The solution is worth its money if you use case fits. I've seen value and impact from this tool. Cost-wise, it's quite good compared to setting up a dedicated environment at each location. It leverages cloud providers like Google and AWS, using their servers, which makes it much cheaper. This makes it well worth it.

What's my experience with pricing, setup cost, and licensing?

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

What other advice do I have?

There is a learning curve with this tool. People who are coming from traditional databases and coders need to adjust. You have to know how to do distributed database calls. So, there's a learning curve for those who manage it and write code against it.

I would recommend CockroachDB to others, especially if they need an SQL database with solid transaction capabilities. For advice, understand each database's strengths and match them to your use case. There is a learning curve, so always try to learn what problems the database solves and how it fits your needs.

I rate the overall product an eight out of ten.

    Umang Singh

A resilient distributed database that offers resiliency features and geo-partitioning capabilities

  • November 29, 2023
  • Review provided by PeerSpot

What is our primary use case?

My company uses CockroachDB since it is a resilient distributed database.

What is most valuable?

The most valuable features of the solution are its resiliency features and the geo-partitioning capabilities.

What needs improvement?

CockroachDB's automatic failover capability is an area of concern where improvements are required.

For how long have I used the solution?

I have been using CockroachDB for two years. My company previously had a partnership with CockroachDB, but now we are just customers.

What do I think about the scalability of the solution?

It is a scalable solution. Scalability-wise, I rate the solution an eight to nine out of ten.

More than 100 people in my company use the solution.

How was the initial setup?

The product's initial setup phase was difficult since you need to follow certain standards set by CockroachDB. The product's initial setup process was cumbersome.

The solution is deployed on an on-premises model.

The time to deploy the solution varies depending on what you want to do.

What's my experience with pricing, setup cost, and licensing?

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.

What other advice do I have?

CockroachDB is the best relational database and also a cloud-native database.

I rate the overall tool an eight and a half out of ten.

    Suresh Ayyavoo

An easily scalable product that enables organizations to keep their nodes in different locations and isolate their data

  • November 24, 2023
  • Review from a verified AWS customer

What is our primary use case?

We have a legal and compliance team. We have a compliance request that the personal data from the EU must stay in the EU, and the data from Singapore must stay in Singapore. CockroachDB is a distributed database system. It exactly fits our requirement to keep the data isolated. At the same time, we can have multiple instances globally. We cannot keep the nodes in different locations in a relational database like Oracle or MySQL.

What is most valuable?

The distributed nature of CockroachDB helps us isolate the data when required. We also have some application logic that determines where the data must go. The best feature of CockroachDB is the ability to keep the nodes in different locations. It solves many problems.

What needs improvement?

The product is not an enterprise-level solution. The product must improve its disaster recovery features. It must also improve on support, logging, and backup restore.

For how long have I used the solution?

I have been using the solution for almost three to three and a half years.

What do I think about the stability of the solution?

We haven't encountered many problems with the tool’s stability. It is pretty stable.

What do I think about the scalability of the solution?

The tool is easily scalable. One of the reasons we chose it is its scalability. If a CPU hits 80%, by default, it can spin off new instances and provide quick support. Overall, we have 1000 people using the solution in our organization. We have 200 concurrent users. We plan to use it more in the future.

How are customer service and support?

The technical support team is getting better. The support is pretty good. The team wants good customer feedback and takes the product to the next level. Initially, we had some issues getting support 24/7. Over time, the support has improved. I rate the technical support a seven or eight out of ten. We need to pay a little if we want enterprise-level support.

How would you rate customer service and support?

Neutral

Which solution did I use previously and why did I switch?

We were using MySQL. We had difficulties in isolating the data, so we switched to CockroachDB. CockroachDB is an open-source tool. The support is pretty good, and the support fee is much lower than the competitors. There were only three to four products in the market at that time.

How was the initial setup?

The initial setup is simple and straightforward. The default out-of-the-box solution comes with the basic setup. We can set it up quickly. We need some technical knowledge for disaster recovery and backup restorations, but it is not that complex.

What was our ROI?

The solution is worth the money.

Which other solutions did I evaluate?

We evaluated another product, but it was very expensive compared to CockroachDB.

What other advice do I have?

I will advise people to use the product. It will be beneficial in the long run. Overall, I rate the tool an eight out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)

    Arucy Lionel

Reliable operational database with an easy setup process

  • November 20, 2023
  • Review from a verified AWS customer

What is our primary use case?

We use CockroachDB as the main database to handle the high-velocity data and ensure real-time processing for a music platform. It enables the processing of a large volume of credit scoring records online within a limited timeframe. It helps us distribute the workload among nodes and create a cluster to improve performance and scalability. It is useful for applications that don't require Postgres-specific features. Also, its compatibility with Postgres makes switching between the databases easier.

What is most valuable?

The product has valuable security features. It is easy to set up SSL certificates for communication between nodes. It has a user-friendly observability feature in terms of UI, helping us monitor login performance, identify slow queries, and view latency between the nodes. It is very adaptable, allowing us to tune specific details easily. It is based on a distributed architecture that determines and manages the number of nodes. It has an automatic rebalancing feature to manage the scenarios where nodes go offline and return online. It provides good performance if used for the right use case. Additionally, its compatibility with Postgres is a valuable feature as well.

What needs improvement?

The platform could be more extensible. At the moment, I have to use Postgres for extension issues. There needs to be better integration features. Additionally, the product’s Change Data Capture Integrations with tools such as Kafka needs improvement.

For how long have I used the solution?

We have been using CockroachDB for two years.

What do I think about the stability of the solution?

The product is very stable. Sometimes, queries overuse the memory, leading to downtime. I rate the stability a nine out of ten.

What do I think about the scalability of the solution?

The product is scalable. Its scalability is a nine or ten out of ten. The number of users depends on the client’s organization and ranges from a few thousand to millions of users.

How are customer service and support?

While learning its functionality, I contacted the product’s technical support team regarding extensibility issues.

Which solution did I use previously and why did I switch?

I used Postgres, I switched because I needed a distributed version with Postgres-like functionality and high resilience.

How was the initial setup?

The initial setup was quite easy for me. The process of security setting and certificate generation may be complicated. It requires experience and knowledge of using the Linux administration system.

What about the implementation team?

In-house

What was our ROI?

The product generates a return on investment.

What's my experience with pricing, setup cost, and licensing?

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

What other advice do I have?

I rate CockroachDB a nine out of ten. It is a reliable and best operational database product for higher use cases.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)

    Antonio Tringali

Open source with extensive documentation and a University for training

  • November 15, 2023
  • Review provided by PeerSpot

What is our primary use case?

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 ~500GB database in-house.

3. Serverless: hosted in Google Cloud Platform (the main database).

A number of Python scripts and some Java applications are happily reading and writing to the database.

The solution allows for scaling in cases where a PostgreSQL server (unless you use sophisticated partitioning across some machines) would not be enough to handle the load. This kind of database is particularly used for backtests.

How has it helped my organization?

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.

What is most valuable?

The main aspects that are valuable include:

  • It is compatible with the wire protocol of PostgreSQL. All applications did not need to be modified. DBeaver and SquirrelSQL worked with the normal PostgreSQL JDBC drivers. Libraries for other languages (C++, Go) also worked.
  • The subset of SQL that my client is using is completely supported.
  • The Cockroach documentation is extensive.
  • Cockroach University is a very good starting point to learn.
  • The availability of the open source offer, no strings attached, allows a full evaluation of the product.

What needs improvement?

I find the serverless offer a bit confusing. The price is a function of the maximum database size.

A single SELECT can use a number of request units, for example. If the throughput is high enough, you could run out of request units and be throttled if you do not pay attention to how your database is used.

For how long have I used the solution?

I've used the solution since 2020.

What do I think about the stability of the solution?

I have never had a crash for the workload I experimented with. However, this is not useful information, since you may always hit a bug or a daunting workload according to your necessities.

What do I think about the scalability of the solution?

The scalability is very good, considering that it is a relational database.

How are customer service and support?

I have no experience with technical support at the moment.

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

CockroachDB is a big data substitute for PostgreSQL.

I have used a number of databases in my professional activity, and every tool has its drawbacks. For example, for certain kinds of jobs, when you do not need relations among tables, Apache Cassandra is a better choice for big data.

How was the initial setup?

You have just to follow the instructions. Of course, installing and configuring all by yourself requires a skilled administrator.

What about the implementation team?

I handled the setup in-house. The serverless solution is the one offered by Cockroach on Google Cloud Platform.

What was our ROI?

The ROI is good. At the moment the serverless solution is affordable according to the given workload.

What's my experience with pricing, setup cost, and licensing?

For their use case, my client wanted a "certified" version that they would forget to administrate, and so, for the main database, they chose the serverless offer.

For experimenting in-house they like to use the freely downloadable open source version, which is very easy to install. The price is irresistible, and if some crash happens there is a reliable backup in the cloud.

Which other solutions did I evaluate?

I have evaluated TimescaleDB and Amazon RedShift. However, I chose CockroachDB as I had produced an experimental application some years ago using an older version and found it very easy to use.

What other advice do I have?

It is a complex database under the hood. It scales using big data techniques, synchronizing among nodes using Raft and continually compacting.

The integrated web console makes it apparently easy to use. But be prepared to study and spend some quality time with Cockroach University and the documentation. This will be useful when performing optimizations on throughput.

Also, if you can distribute the load on multiple nodes (possibly more than three), you will gain in scalability. There are some little formulas that bind the replication factor to the number of nodes to use.

    Aman-Narang

Completes node syncing in short time

  • November 15, 2023
  • Review provided by PeerSpot

What is our primary use case?

CockroachDB helped us sync the nodes in a short time.

What is most valuable?

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

What needs improvement?

CockroachDB needs to improve store processes.

What do I think about the stability of the solution?

The tool is stable.

What do I think about the scalability of the solution?

CockroachDB is scalable. We have more than 35 million records.

How are customer service and support?

CockroachDB's support is good, though they take some time to reply.

How would you rate customer service and support?

Neutral

How was the initial setup?

If you do it for the first time, the tool's deployment is complex. Once you get an overview, it is easy.

What other advice do I have?

I rate CockroachDB an eight out of ten.

    K Madhusudan C.

Distributed SQL database designed for scalability and high availability

  • October 10, 2023
  • Review provided by G2

What do you like best about the product?
Horizontal scalability of the cockroach DB allows us to add more nodes to the cluster easily based on the data growth.
Built-in high availability features that make it resilient to node failures using its automatic data replication and failover mechanism
What do you dislike about the product?
It is resource-intensive and consumes high CPU, memory, and storage. Sometimes there are latency issues too.
Setting up and configuring for the first time is a bit complex.
Also, it has a limited ecosystem
What problems is the product solving and how is that benefiting you?
High availability is the main problem that it solves and it has become geo-distributed applications where we were storing huge amounts of metadata that was required across the regions. Due to these, we were able to achieve low latency and high available across regions.

    Victor AugustoDe Souza E Silva

An RDBMS that Replicates Your Data for Availability and Guarantees Consistency

  • August 15, 2023
  • Review provided by PeerSpot

What is our primary use case?

The solution is used for Kubernetes to put on database.

What is most valuable?

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

What needs improvement?

The initial setup and pricing could be improved.

For how long have I used the solution?

I have experience with CockroachDB.

What do I think about the stability of the solution?

It is a stable solution.I would rate the stability a nine out of ten.

What do I think about the scalability of the solution?

It is a scalable solution. I would late the scalability a nine out of ten.

Which solution did I use previously and why did I switch?

Previously, I have used Postgres but the operator for Postgres is not very good and that is why we shifted to CockroachDB.

How was the initial setup?

The initial setup of CockroachDB can be difficult initially if you are pushing on the operator line but then it becomes easy. Only one person is required for the maintenance of any project on CockroachDB.

What about the implementation team?

We are using the Helm. So we do the the upgrade and the deployment of the cockroach by ourselves.

What's my experience with pricing, setup cost, and licensing?

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

What other advice do I have?

The advice of just to read the documentation and look for examples. I would rate the overall solution an eight out of ten.

    Benjamin Y.

Great Open-Source Database Product

  • October 10, 2022
  • Review provided by G2

What do you like best about the product?
I have an option to evaluate this product using an open source option and take some university courses to educate myself on how to use the database product. From there, I can figure out which projects I plan to use it for (specifically anything business-related or personal / hobby projects).
What do you dislike about the product?
I'm not sure as I am continuing to explore more of the product and I hope that there isn't too many limitations when it comes to adding specific data that I would need to create the database.
What problems is the product solving and how is that benefiting you?
The fact that I can get started for free to evaluate CockroachDB right away. Although the limitation is up to 5GB, that is all I would really need for a starter project and for evaluation. Evidently, they also offer a pay-as-you-go plan, which is also similar to other companies.

    Sohail G.

Best postgre database

  • May 27, 2022
  • Review provided by G2

What do you like best about the product?
Basically cockroachdb is easy to use and it is open source distributed database. It accepts complex architectures which makes it globally accepted. It's best feature is geo partitioning into it's clusters. Support team is so awesome that they solve problems in matter of minutes.
What do you dislike about the product?
Though CockroachDB is an open source , there ain't any forum except stack overflow. It's setup is slightly complex from others. Other than that everything works fine.
What problems is the product solving and how is that benefiting you?
We use CockroachDB for Distributed storage of complex data for high reliability and high performance.

showing 11 - 20