Distributed SQL with Karthik Ranganathan and Sid Choudhury

Relational databases provide durable transactional systems for storing data. The relational model has existed for decades, but the requirements for a relational database have changed.

Modern applications have requirements for high volumes of data that do not fit onto a single machine. When a database gets too big to fit on a single machine, that database needs to be sharded into smaller subsets of the data. These database shards are spread across multiple machines, and as the database grows, the database can be resharded to scale to even more machines.

To ensure durability, a database needs to be replicated. The database needs to be able to survive any single machine losing power or getting destroyed.

Sharding and replication allow a relational database to be scalable, durable, and highly available. There are many ways to build sharding and replication into a database. Karthik Ranganathan and Sid Choudhury are engineers with YugabyteDB, a distributed SQL database.

In today’s episode, we discuss the modern requirements of a distributed SQL database, and compare the applications of distributed SQL to those of other systems such as Cassandra and Hadoop. We also talk through the competitive market of cloud-based distributed SQL providers such as Google Cloud Spanner and Amazon Aurora. YugabyteDB is an open source database that competes with these other relational databases. Full disclosure: YugabyteDB is a sponsor of Software Engineering Daily.

Sponsorship inquiries: sponsor@softwareengineeringdaily.com

Announcements

  • We are hiring a content writer and also an operations lead. Both of these are part-time positions working closely with Jeff and Erika. If you are interested in working with us, send an email to jeff@softwareengineeringdaily.com.
  • We will be at KubeCon San Diego 2019, and AWS re:Invent Las Vegas. We are planning a meetup at re:Invent on Wednesday December 4.

Transcript

Transcript provided by We Edit Podcasts. Software Engineering Daily listeners can go to weeditpodcasts.com/sed to get 20% off the first two months of audio editing and transcription services. Thanks to We Edit Podcasts for partnering with SE Daily. Please click here to view this show’s transcript.


Sponsors

Datadog unites metrics, traces, and logs in one platform so you can get full visibility into your infrastructure and applications. Check out new features like Trace Search & Analytics for rapid insights into high-cardinality data, and Watchdog, an auto-detection engine that alerts you to performance anomalies across your applications. Datadog makes it easy for teams to monitor every layer of their stack in one place, but don’t take our word for it—start a free trial today & Datadog will send you a T-shirt! softwareengineeringdaily.com/datadog

MongoDB is the most popular document-based database built for modern application developers and the cloud era. Try MongoDB today with Atlas, the global cloud database service that runs on AWS, Azure, and Google Cloud. Configure, deploy, and connect to your database in just a few minutes. Check it out at mongodb.com/atlas.

The O’Reilly Software Architecture Conference is coming to New York, February 23-26. Join other senior developers, engineers, and software architects in to learn new skills and technologies with a focus on microservices, cloud computing, and serverless—as well as emerging trends in AI, machine learning, and data analytics. SE Daily listeners can get 20% off of most passes with code SE20 during registration.

Software Engineering Daily is securing sponsorships for 2020. Reach our audience to promote your product or service today: softwareengineeringdaily.com/sponsor

Software Weekly

Software Weekly

Subscribe to Software Weekly, a curated weekly newsletter featuring the best and newest from the software engineering community.