I am studying how to deploy CockroachDB and YugaByteDB, and learning some basic information about them. I am testing these databases as part of my school application to find a suitable database for our applications. Currently, I am using PostgreSQL, however, I want to try some distributed databases for testing purposes.

The most valuable feature is that CockroachDB is a distributed database, which can deploy nodes running in different regions. Geo-replication capabilities are also important for production applications. Having database servers close to my customers, for example, in the US or UK, would improve performance.

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

I have been studying and testing CockroachDB and YugaByteDB for about six months.

I did not contact the technical support by CockroachDB. However, their website has an AI chatbot, which I found to be very useful.

Positive

Currently, I am using PostgreSQL. I want to try some distributed databases for testing purposes.

I deployed a three-node database in a local system using Docker. I have successfully deployed a secure cluster.

I am not very familiar with the pricing as I am now only in the experimental phase.

I am also studying and testing YugaByteDB alongside CockroachDB.

I'd rate the solution eight out of ten.

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.

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.

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.

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. 

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

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.

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.

We did the tool's deployment in-house. 

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. 

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

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. 

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

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

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

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

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.

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.

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.

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.

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.

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.

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.

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

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

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.

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.

Neutral

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.

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.

The solution is worth the money.

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

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.

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.

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.

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.

We have been using CockroachDB for two years.

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

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.

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

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

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.

In-house

The product generates a return on investment.

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

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

CockroachDB helped us sync the nodes in a short time. 

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

CockroachDB needs to improve store processes. 

The tool is stable. 

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

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

Neutral

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

I rate CockroachDB an eight out of ten. 

The solution is used for Kubernetes to put on database. 

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

The initial setup and pricing could be improved. 

I have experience with CockroachDB.

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

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

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

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.

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

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

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