Blog
Product
Super regions: Safe and simple multi-region data domiciling
For operators, architects and developers alike, data domiciling can be one tough technical nemesis. Privacy regulations like GDPR create strict requirements where data can live in the world. To meet these requirements companies traditionally had to run separate databases in different geographic regions. This results in a huge operational overhead and reliability also takes a hit, since it can be hard to guarantee region survival while complying with data domiciling restrictions.
Michelle Gienow
June 13, 2022
Product
AMD vs. Intel and more: What’s new in the 2022 Cloud Report
The 2022 Cloud Report is finally here, and we think it was worth the wait! In this completely free 70+ report, you’ll find the results of over 3,000 OLTP test runs analyzing 56 different instance types across AWS, GCP, and Azure for performance and price, as well as hundreds of additional runs benchmarking CPU performance, network latency and throughput, and storage. Want a little taste of what’s inside? For the first time ever, we saw machines with AMD chips eclipse Intel: instance types with the latest-gen AMD Milan CPUs took the top spots for both performance and price-for-performance in our OLTP benchmarking.
Charlie Custer
June 13, 2022
Design
Here's how CockroachDB keeps your database from collapsing under load
In CockroachDB v21.2 we introduced a new admission control and resource allocation subsystem, and in our most recent release (v22.1) we’ve made substantial improvements. In this blog post, we’ll cover the improvements made to admission control, including a description of the generally applicable mechanisms we developed, which should be relevant for any distributed transactional database with multi-node transactions.
Sumeer Bhola
June 6, 2022
Product
Getting started with the ccloud CLI tool in CockroachDB 22.1
Let’s be real: while there’s nothing wrong with a nice GUI, doing things with the command line is just faster. At least once you know what you’re doing. That’s why in CockroachDB 22.1, we’ve added a new tool that’s designed to make it faster and easier than ever to create and manage CockroachDB clusters right from the command line: ccloud.
Charlie Custer
June 3, 2022
System
How to choose the right metadata store
Choosing the right metadata store should be contingent on your system architecture. There is no definitive ‘right choice’. But if you are building your products or services on top of distributed systems then your choices are certainly narrowed. Recently, the data security company Rubrik, wrote a three-part blog series about how they chose a metadata store for Rubrik CDM. Their journey began with Cassandra and ended with CockroachDB. This blog is a summary of the challenges they ran into with Cassandra, the reasons they chose CockroachDB as their metadata store, and what their CockroachDB use case looks like.
Dan Kelly
June 3, 2022
Product
Cloud integration made easy: CockroachDB and Google Pub/Sub
Have you ever wanted to stream data from your database without having to install additional resources that require more time and energy to maintain? Just recently, I spoke with a {person who shall remain nameless} about how they wanted to dump new data to a file, move it from one cloud provider to another, and then place it in storage for consumption by downstream systems. There was more to it and it hurt my head to listen. I had only one question for {person to remain nameless} “When did you start hating your fellow coworkers?” I mean, really… other people will have to maintain that mess.
Jeff Carlson
June 3, 2022
Product
Get started automating database ops with the CockroachDB Cloud API
CockroachDB 22.1 is here, and with it comes a highly-requested feature: a REST API that allows you to access and manage your clusters programmatically, rather than having to navigate the web UI. Want to automate your database ops? Let’s get started!
Charlie Custer
May 25, 2022
Product
CockroachDB Admission Control? Yes, please!
Last week, while running a workload consisting of 200 different queries, we noticed right away that a CPU imbalance was causing a performance issue. Looking at the first graph, below, you can see right away that one of the three CockroachDB nodes was operating at near 100% CPU. Not ideal.
Michael Goddard
May 23, 2022
Design
Multi-region applications with Google Cloud Run and CockroachDB
When you deploy a web application in the cloud, you typically select a region for your cloud resources first — a region being the physical datacenter location where your cloud-based application will live. It’s common to choose just one region, but you can also stitch multiple regions together. Why would you choose multi-region architecture? Three words: resiliency, latency and localization.
Michelle Gienow
May 23, 2022