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.
System
How to leverage geo-partitioning
As we’ve written about previously, geographically distributed databases like CockroachDB offer a number of benefits including reliability, security, and cost-effective deployments. We believe you shouldn’t have to sacrifice these upsides to realize impressive throughput and low latencies. That’s why we created geo-partitioning. This blog post defines two new features, geo-partitioning and archival-partitioning, as well as explains when you might want to leverage these features. We previously provided a sneak-peak walkthrough of geo-partitioning that can be found here.
Andy Woods
April 12, 2018
Product
CockroachDB 2.0 performance makes significant strides
Correctness, stability, and performance are the foundations of CockroachDB. We've invested tremendous resources into correctness and stability. Today, performance takes the spotlight as we will be publishing benchmarked metrics that demonstrate that you can achieve correctness, stability, and excellent performance within the same database.
Andy Woods
March 29, 2018
Product
Be flexible and consistent: JSON comes to CockroachDB
We are excited to announce support for JSON in our 2.0 release (coming in April) and available now via our most recent 2.0 Beta release. Now you can use both structured and semi-structured data within the same database. No longer will you need to sacrifice ACID guarantees, accuracy, or the ability to scale in order to use multiple data models within the same database. This post will explain how we implemented JSON and give you a few examples of how JSON can be used to model your data.
Andy Woods
March 22, 2018
System
Geo-partitioning: What global data actually looks like
\* *This blog from 2018 does not represent the most recent strategies for pinning data to locations at the row level in CockroachDB. And certain capabilities referenced, like interleaving, are no longer supported. This documentation about our multi-region capabilities is the best place to begin learning about the current best practices for scaling your database across multiple regions: https://www.cockroachlabs.com/docs/stable/multiregion-overview* ```
Andy Woods
March 15, 2018
System
Using “follow-the-workload” to beat the latency-survivability tradeoff in CockroachDB
Geographically distributed databases like CockroachDB offer a number of benefits including reliability, security, cost-effective deployments, and more. Critics often counter that distributed databases increase latency. What if a database could offer all of the benefits of distribution, but also provide low-latency? With this challenge in mind, we set out to minimize latency in CockroachDB, all the while providing exceptional reliability for mission-critical workloads. We built “follow-the-workload” to be a key feature to improve performance and provide additional control to database administrators (DBAs).
Andy Woods
December 5, 2017
Product
Using tunable controls for low latency in CockroachDB
Geographically distributed databases like CockroachDB offer a number of benefits including reliability, cost-effective deployments, and more. Critics often counter that distributed databases increase latency. What if a database could offer all of the benefits of distribution, but also provide low latency?
Andy Woods
November 30, 2017
Product
CockroachDB vs. Aurora: Who passes TPC-C at 100k warehouses?
Last fall we wrote about how CockroachDB was 50x more scalable than Amazon Aurora as evidenced on the industry-standard TPC-C benchmark. We’re pleased to announce that CockroachDB has doubled that performance benchmark by successfully passing TPC-C at 100,000 warehouses. And with a max throughput of 1.2m tpmC, CockroachDB can now process 100X the throughput of Amazon Aurora’s last published benchmark.
Andy Woods
March 13, 2024