Andy-Woods
Author

Andy Woods

Director, Product Management

Andy Woods is the Director of Product Management at Cockroach Labs, leading the teams that connect CockroachDB to the broader application ecosystem. A former consultant turned product leader, Andy thrives at the intersection of technology and business. When he's not thinking about databases, he’s checking off all the Brooklyn playgrounds with his daughters, diving into a new fantasy book, or searching for the perfect burger in NYC.

Read more articles from this author
CRL BlogHeader Zero-downtimeScaling

Product

How to get zero-downtime scaling from single-region to multi-region applications

CockroachDB offers a number of features aimed at making it easy to support your application in multiple regions. In CockroachDB 20.1, we introduced a new feature Online Primary Key Changes that allows you to upgrade your application from a single-region to multi-region with zero downtime. We wrote a bit recently about the technical challenges involved in building online primary key changes and in this blog post, we'll walk through some of the use cases and benefits the feature can lead to.

Andy-Woods

Andy Woods

June 11, 2020

2020 Cloud Report Blog-header (1)

Performance

AWS, Azure, and GCP respond to the 2020 Cloud Report

In December 2019, we published the 2020 Cloud Report and an accompanying blog post, which summarized original research we conducted benchmarking the performance of Amazon Web Services (AWS), Microsoft Azure (Azure), and the Google Cloud Platform (GCP).

Andy-Woods

Andy Woods

March 12, 2020

2020 Cloud Report Blog-header

Performance

GCP comes out swinging against AWS and Azure in 2020 Cloud Report

Since 2017, Cockroach Labs has run thousands of benchmark tests across dozens of machine types with the goal of better understanding performance across cloud providers. If there’s one thing we’ve learned in our experiments, it’s this: benchmarking the clouds is a continuous process. Since results fluctuate as the clouds adopt new hardware, it’s important to regularly re-evaluate your configuration (and cloud vendor).

Andy-Woods

Andy Woods

December 11, 2019

multirow by lea heinrich final-1

features

Reducing multi-region latency with Follower reads

At Cockroach Labs, we're focused on making data easy for our customers. CockroachDB is designed as a vendor-agnostic, cloud-native database for transactional workloads. We offer a number of benefits over traditional relational databases including serializable isolation, online schema changes, and high availability fault-tolerance. Today, we want to demonstrate another CockroachDB differentiator: multi-region support for global scale. In this blog post, we introduce Follower reads, a key feature for supporting multi-region reads with low latency when your use case can accept stale data.

Andy-Woods

Andy Woods

December 3, 2019

cross-cloud-deployment-by-zoe-van-dijk-1

Performance

Reproduction steps now available for the 2018 Cloud Report

CockroachDB is a cloud-neutral database, which means it eliminates dependencies on a particular cloud environment and gives you the flexibility and choice to run it anywhere you like. We are committed to this principle and in order to deliver on this promise, we systematically deploy and test CockroachDB clusters on the three leading US cloud providers: Amazon Web Services (AWS), Google Cloud Platform (GCP), and Microsoft Azure.

Andy-Woods

Andy Woods

February 7, 2019

cross-cloud-deployment-by-zoe-van-dijk-1

Performance

AWS outperforms GCP in the 2018 Cloud Report

Our customers rely on us to help them navigate the complexities of the increasingly competitive cloud wars. Should they use Amazon Web Services (AWS)? Google Cloud Platform (GCP)? Microsoft Azure? How should they tune their workload for different offerings? Which is more reliable?

Andy-Woods

Andy Woods

December 13, 2018

crl-sprint2023-blog-post-1

Performance

CockroachDB 2.1 is now 50x more scalable than Amazon Aurora

[For CockroachDB's most up-to-date performance benchmarks, please read our Performance Overview page] Correctness, stability, and performance are the foundations of CockroachDB. Today, we will demonstrate our rapid progress in performance and scalability with CockroachDB 2.1. CockroachDB is now 50x more scalable than Amazon Aurora at less than 2% of the price per tpmC. And unlike Aurora and other databases that selectively degrade isolation levels for performance, CockroachDB can achieve massive scale while maintaining serializable isolation, protecting your data from fraud and data loss. Read on to see benchmarked metrics that demonstrate that CockroachDB can provide customers an ultra-resilient and highly available database at massive scale.

Andy-Woods

Andy Woods

November 28, 2018

JSON Part2 WentingLi (1)

Practical applications of JSON: Why and where you should use it

CockroachDB provides scale without sacrificing SQL functionality. It offers fully-distributed ACID transactions, zero-downtime schema changes, and support for secondary indexes and foreign keys. But what about some of the additional benefits NoSQL databases provide such as the ability to use semi-structured data? CockroachDB listened to our customers and realized that we needed to provide options for managing rapid development, data without a clear schema or whose schema you do not control, and impedance mismatches. That’s why we are excited to support JSON in 2.0! Previously we’ve shown you how we implemented JSON and inverted indexes as well as a few examples. This blog post will explain when you might want to leverage these features.

Andy-Woods

Andy Woods

June 21, 2018

Performance-Part2-Dalbert-V-1

Performance

CockroachDB is 10x more scalable than Amazon Aurora for OLTP workloads

The three design principles of CockroachDB are correctness, stability, and performance. Having achieved our correctness and stability goals with CockroachDB 1.0 and 1.1, we focused heavily on performance with CockroachDB 2.0. For more information on which benchmarks matter, or to see a comparison between CockroachDB 1.1 and 2.0, you can read CockroachDB 2.0 Makes Significant Strides. Today we are releasing a comprehensive whitepaper that demonstrates how CockroachDB achieves high OLTP performance of over 128,000 tpmC on a TPC-C dataset over 2 terabytes in size. This OLTP performance is over 10x more TPC-C throughput than Amazon Aurora, in a 3x replicated deployment with single-digit seconds recovery time and zero-downtime migrations and upgrades. This far surpasses a typical active-passive database deployment with manual failure recovery. CockroachDB achieves this in serializable isolation, unlike competing databases that sacrifice isolation for performance. We’re very excited to talk about performance, and have taken care to make this more than just an announcement with vague numbers. In keeping with our open source philosophy, our whitepaper contains a step-by-step reproduction of instructions to verify all our performance claims, as well as context on our benchmarking philosophy and practices. We don’t just want you to take our word for our performance numbers, we’d like to arm you with all the tools you need to check it out for yourself! In this post, we’d like to cover some brief highlights, but do check out the whitepaper for more details and a fully reproducible test script.

Andy-Woods

Andy Woods

April 18, 2018

Page 2 of 3

Get started with CockroachDB

Start a free trial of CockroachDB or contact sales to learn more.