Skip to content
CockroachDB In Depth with Peter Mattis - Episode 35 episode artwork

Jun 11, 2018 43 min

CockroachDB In Depth with Peter Mattis - Episode 35

from Data Engineering Podcast Hosted by Tobias Macey

Summary With the increased ease of gaining access to servers in data centers across the world has come the need for supporting globally distributed data storage. With the first wave of cloud era databases the ability to replicate information geographically came at the expense of transactions and familiar query languages. To address these shortcomings the engineers at Cockroach Labs have built a globally distributed SQL database with full ACID semantics in Cockroach DB. In this episode Peter Mattis, the co-founder and VP of Engineering at Cockroach Labs, describes the architecture that underlies the database, the challenges they have faced along the way, and the ways that you can use it in your own environments today. Preamble Hello and welcome to the Data Engineering Podcast, the show about modern data management When you’re ready to build your next pipeline you’ll need somewhere to deploy it, so check out Linode. With private networking, shared block storage, node balancers, and a 40Gbit network, all controlled by a brand new API you’ve got everything you need to run a bullet-proof data platform. Go to dataengineeringpodcast.com/linode to get a $20 credit and launch a new server in under a minute. For complete visibility into the health of your pipeline, including deployment tracking, and powerful alerting driven by machine-learning, DataDog has got you covered. With their monitoring, metrics, and log collection agent, including extensive integrations and distributed tracing, you’ll have everything you need to find and fix performance bottlenecks in no time. Go to dataengineeringpodcast.com/datadog today to start your free 14 day trial and get a sweet new T-Shirt. Go to dataengineeringpodcast.com to subscribe to the show, sign up for the mailing list, read the show notes, and get in touch. Your host is Tobias Macey and today I’m interviewing Peter Mattis about CockroachDB, the SQL database for global cloud services Interview Introduction How did you get involved in the area of data management? What was the motivation for creating CockroachDB and building a business around it? Can you describe the architecture of CockroachDB and how it supports distributed ACID transactions? What are some of the tradeoffs that are necessary to allow for georeplicated data with distributed transactions? What are some of the problems that you have had to work around in the RAFT protocol to provide reliable operation of the clustering mechanism? Go is an unconventional language for building a database. What are the pros and cons of that choice? What are some of the common points of confusion that users of CockroachDB have when operating or interacting with it? What are the edge cases and failure modes that users should be aware of? I know that your SQL syntax is PostGreSQL compatible, so is it possible to use existing ORMs unmodified with CockroachDB? What are some examples of extensions that are specific to CockroachDB? What are some of the most interesting uses of CockroachDB that you have seen? When is CockroachDB the wrong choice? What do you have planned for the future of CockroachDB? Contact Info Peter LinkedIn petermattis on GitHub @petermattis on Twitter Cockroach Labs @CockroackDB on Twitter Website cockroachdb on GitHub Parting Question From your perspective, what is the biggest gap in the tooling or technology for data management today? Links CockroachDB Cockroach Labs SQL Google Bigtable Spanner NoSQL RDBMS (Relational Database Management System) “Big Iron” (colloquial term for mainframe computers) RAFT Consensus Algorithm Consensus MVCC (Multiversion Concurrency Control) Isolation Etcd GDPR Golang C++ Garbage Collection Metaprogramming Rust Static Linking Docker Kubernetes CAP Theorem PostGreSQL ORM (Object Relational Mapping) Information Schema PG Catalog Interleaved Tables Vertica Spark Change Data Capture The intro and outro music is from The Hug by The Freak Fandango Orchestra / CC BY-SA Support Data Engineering Podcast

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

CockroachDB In Depth with Peter Mattis - Episode 35

0:00 43:41

Chapters

  1. 0:43 Introduction to Peter Mattis and CockroachDB
  2. 2:20 Motivation Behind CockroachDB
  3. 6:30 CockroachDB Architecture and Distributed Transactions
  4. 9:59 Geo-Replication and Latency Challenges
  5. 18:07 Optimizations for Geographic Distributions
  6. 22:15 Building CockroachDB in Go
  7. 27:24 Deployment and Kubernetes Integration
  8. 28:37 Consistency and Availability in CockroachDB
  9. 33:03 SQL Interface and ORM Compatibility
  10. 37:06 Interesting Use Cases and GDPR
  11. 40:02 When Not to Use CockroachDB
  12. 41:04 Future Directions and Features
  13. 42:07 Challenges in Building and Maintaining CockroachDB

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of Data Engineering Podcast?

This episode is 43 minutes long.

When was this Data Engineering Podcast episode published?

This episode was published on June 11, 2018.

Is there a transcript available for this episode?

Yes, a full transcript is available for this episode. You can read the complete transcript on the episode page.

Can I download this Data Engineering Podcast episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.