Episode 1

Introduction to YugabyteDB

Yugabyte co-founders: Kannan Muthukkaruppan, Karthik Ranganathan, and Mikhail Bautin speak with developer advocate Franck Pachot about the history of Yugabyte and the decisions they made to bring their database to life. They also discuss the challenges of building a distributed database that has the same feature set as the most popular relational databases, and the use cases that work best with YugabyteDB.

  • Distributed Database ,Distributed Transaction, Distributed SQL, Relational Database, OLTP
  • Application Developer, Architect, Database Administrator
Shape

Episode 2

YugabyteDB’s SQL Layer

Yugabyte co-founder Karthik Ranganathan introduces Mihnea Iancu, a founding engineer at Yugabyte. The discuss YugabyteDB's SQL layer, and the why and how behind the decision to reuse rather than reimplement PostgreSQL's query layer code.

  • Architecture, DocDB, Distributed Document Store, Stateless Postgres, Tablet, Sharding, Table, Index, Distributed Transaction, Full Table Scan, Write Path, YSQL
  • Application Developer, Architect, Database Administrator
View PDF
Shape

Episode 3

YugabyteDB Sharding Strategies

DocYugabyte co-founder Kannan Muthukkaruppan discusses automatic sharding and the various sharding strategies available in YugabyteDB with Bogdan Matican, Yugabyte founding engineer.

  • Architecture, DocDB, Tablet, Sharding,
  • Primary Key, Partition Key, Clustering Key, Consistent Hash Sharding, Range Sharding, Tablet Splitting
  • Architect, Database Administrator, Application Developer
View PDF
Shape

Episode 4

Continuous Availability with YugabyteDB

"Failures are the norm in cloud environments. So, how does YugabyteDB ensure applications are online when failures occur? What about software upgrades or security patching?

Yugabyte co-founder Karthik Ranganathan discusses continuous availability and resilience with Rob Sami, a Yugabyte distributed systems engineer."

  • Architecture, Auto-Rebalance, Cluster, Consensus, Consistency, Follower, High Availability, Leader, Multi-Region, Multi-Zone, Node, Raft, Replica, Replication, Resilience, Self-Balancing, Topology
  • dministrator
View PDF
Shape

Episode 5

PostgreSQL-Compatible “Smart” Drivers

Yugabyte Director of Engineering Neeraj Kumar and co-founder Kannan Muthukkaruppan, discuss how YugabyteDB's cluster and topology-aware "Smart" drivers help leverage the distributed nature of YugabyteDB without the need for an HA proxy or load balancer between the client and database.

  • YSQL, Java, JDBC, PGJDBC, Smart Driver
  • Cluster Aware Data Source, Hikari Pool
  • Application Developers, Architects
View PDF
Shape

Episode 6

Multi-Region Deployment Options

Listen to Yugabyte Developer Advocate Franck Pachot and co-founder Karthik Ranganathan, discuss YugabyteDB's multi-region deployment options and the consistency, performance, and availability/DR tradeoffs involved.

  • Universe, Cluster, Deployment, Multi-Zone, Multi-Region, Multi-Cloud, Topology
  • High Availability, HA, Disaster Recovery, DR, Replication, Raft, Consensus
  • Application Developer, Architect, Database Administrator
View PDF
Shape

Episode 7

YSQL Follower Reads

Listen to Yugabyte Founding Engineer Amitanand Aiyer, and co-founder Kannan Muthukkaruppan, discuss how "YSQL follower reads" can help applications that can tolerate a bounded amount of staleness to achieve much lower latencies, especially in multi-region deployment configurations.

  • Deployment, Universe, Cluster, YSQL, Tablet, Leader, Follower, Multi-Region,G-Flag
  • Architect, Database Administrator, Application Developer
View PDF
Shape

Episode 8

Generalized Inverted Indexes in YugabyteDB

Watch Yugabyte Software Engineer Jason Kim, and co-founder Karthik Ranganathan, as they talk about generalized inverted indexes (GIN) in YugabyteDB, and show you how to build a powerful search engine that can index JSONB documents and text across a variety of languages.

  • Index, Generalized Inverted Index, GIN, JSON, JSONB
  • Application Developer, Database Administrator
View PDF
Shape

Episode 9

yb_hash_code() built-in function in YSQL

Watch Yugabyte Software Engineer Tanuj Nayak and co-founder Kannan Muthukkaruppan as they give an overview of table partitioning in YSQL and how to smartly access table partitions using the “yb_hash_code” built-in function.

  • YSQL, Table, Tablet, Table Partition, Query, Sharding, Consistent Hash, Built-in Function, yb_hash_code
  • Application Developers, Architects
View PDF
Shape

Episode 10

YSQL Collation Support

The comparison and sort order of characters can change for international languages. Databases expose controls on how to handle such data through a very important feature set called “collation” support.

Listen to Yugabyte Software Engineer Minghui Yang and co-founder Karthik Ranganathan as they discuss collation support in YugabyteDB.

  • YSQL, Collation, Query, Order By, Sort, Multi-Lingual, Multi-Language
  • Application Developer, Architect, Database Administrator
View PDF
Shape

Episode 11

Backup and Restore in YugabyteDB

Join Yugabyte Distinguished Engineer Alan Caldera and co-founder Kannan Muthukkaruppan, in part one of this special two-part YFTT presentation as they give an overview of Backup/Restore operations in YugabyteDB.

The second part of this presentation will be presented by Yugabyte expert Sergei Politov will cover PITR (Point-in-Time Recovery) operations.

  • Backup, Restore, Disaster Recovery, Business Continuity
  • Architect, Database Administrator
View PDF
Shape

Episode 12

Indexes in YugabyteDB

Watch to Yugabyte Developer Advocate Franck Pachot and co-founder Karthik Ranganathan discuss how indexing in YugabyteDB works and why it is important.

  • YSQL, DocDB, Index, Tablet,Table Partition, Tablespace, Sharding, Execution Plan, Query Plan
  • Application Developer, Architect, Database Administrator
View PDF
Shape

Episode 13

Point-in-Time Recovery in YugabyteDB

Watch Yugabyte Engineer Sergei Politov and co-founder Kannan Muthukkaruppan as they give an overview of YugabyteDB's Point-in-Time Recovery capability, which allows you to restore the state of a cluster from a specific point in time.

  • Business Continuity, Disaster Recovery, Point-in-Time Recovery, PITR
  • Architect, Database Administrator, Application Developer
View PDF
Shape

Episode 14

Partial Indexes & Expression Based Indexes

Listen to Yugabyte Developer Advocate Franck Pachot and co-founder Karthik Ranganathan as they discuss more features to shape the indexes to fit the access patterns such as partial indexes and indexes on expressions and functions.

  • YSQL, Index, Partial Index, Expression Based Indexes, Tablet, Table, DocDB, Sharding, Execution Plan, Query Plan
  • Application Developer, Database Administrator
Shape

Episode 15

Optimizing Queries Using the pg_hint_plan PostgreSQL Extension

Listen to Yugabyte Engineer Ram Kannan and Co-Founder Kannan Muthukkaruppan discuss how the pg_hint_plan PostgreSQL extension can be used to optimize the query execution plan using "hints" to tweak things such as the join order, join methods, or access paths.

  • YSQL, Index, Table, Tablet, Query Plan, Access Pattern, Execution Plan, Tuning, Optimization, Hints, PostgreSQL, Extension
  • Application Developers, Database Administrators
View PDF
Shape

Episode 16

Supporting Savepoints in YSQL

Watch Yugabyte Engineer Rob Sami and Co-Founder Karthik Ranganathan discuss how we built support for savepoints into YSQL, why it's important, and what's next.

  • Savepoint, Transaction, Stored Procedure, PostgreSQL, YSQL
  • Application Developer, Architect, Database Administrator
View PDF
Shape

Episode 17

xCluster Replication

Listen to Yugabyte Engineer Rahul Desirazu and Co-Founder Kannan Muthukkaruppan discuss using cross-cluster replication to support highly available and fault tolerant disaster recovery and multi-write setups.

  • Deployment, Universe, Cluster, YSQL, Multi-Region, Replication
  • Architect, Database Administrator
View PDF
Shape

Episode 18

Using the Orafce Extension in YugabyteDB

Listen to Yugabyte Developer Advocate Frits Hoogland and Co-Founder Karthik Ranganathan as they discuss how the orafce PostgreSQL extension can be used to help with moving Oracle database data to YugabyteDB. Outside of orafce’s function as a migration aid, it also contains some hidden gems that can be used outside of the Oracle migration scenario.

  • Oraface, PostgreSQL, Extension, YSQL
  • Application Developer, Database Administrator
Shape

Episode 19

YSQL Materialized Views

A materialized view is a 'persistent' view that stores the result of a query and can be refreshed periodically. Listen to Yugabyte Engineer Fizaa Luthra and co-founder Karthik Ranganathan discuss materialized views in YSQL, and how these can be used to speed up query execution time.

  • YSQL, Table, View, Materialized, Materialized View, PostgreSQL
  • Application Developers, Database Administrator
View PDF
Shape

Episode 20

YCQL – Automatic Deletion of Data Using Time-To-Live (TTL)

Watch Yugabyte Field Engineer Aravind Nallan and Co-Founder Karthik Ranganathan discuss how to use YCQL’s TTL feature, which allows data to be deleted automatically. They also discuss a dependent feature that can be used for managing time-series data, where data that expires together can be deleted without going through the usual compaction process.

  • YSQL, Time-to-Live, TTL, Data Modeling, Upsert, Compaction, Time Series
  • Application Developer, Architect, Database Administrator
View PDF
Shape

Episode 21

Spotlight on YSQL JSON

Watch to Yugabyte’s Technical Product Manager Bryn Llewellyn and Co-Founder Kannan Muthukkaruppan discuss YSQL’s JSON functionality and some use cases that benefit from this.

  • YSQL, JSON, JSONB
  • Application Developer, Architect, Database Administrator
View PDF
Shape

Episode 22

Change Data Capture in YugabyteDB

Listen to Yugabyte Director of Engineering Suranjan Kumar and Co-Founder Kannan Muthukkaruppan give an overview of YugabyteDB's Change Data Capture (CDC) capability. CDC enables applications to subscribe to changes in YugabyteDB and stream them to other applications and services in a real-time and scalable manner.

  • Architecture, Change Data Capture , CDC, DocDB, Distributed Document Store, Stateless Postgres, Tablet, YSQL
  • Application Developer, Architect, Database Administrator
View PDF
Shape

Episode 23

Transaction Isolation Levels

Listen to Yugabyte Engineer Piyush Jain and Co-Founder Kannan Muthukkaruppan discuss the different isolation levels in YSQL and how closely they match PostgreSQL's isolation levels, including the recently added READ-COMMITTED isolation, and the ongoing work to match PostgreSQL's transaction semantics.

  • YSQL, PostgreSQL, ACID, Isolation Level, Read Committed, Transaction
  • Application Developer, Database Administrator,
View PDF
Shape

Episode 24

Partitioning Tables in YugabyteDB

Listen to Yugabyte Head of Developer Relations Denis Magda and Co-Founder Kannan Muthukkaruppan discuss various table partitioning types supported in YugabyteDB.

By following sample examples, they will review hash, list, and range partitioning techniques inherited from PostgreSQL and enhanced for YugabyteDB's distributed storage layer.

  • YSQL, PostgreSQL, Data Model, Table, Sharding, Tablet, Table Partitioning, Hash Partitioning
  • List Partitioning, Range Partitioning, Multilevel Partitioning, Geo-partitioning
  • Architect, Application Developer, Database Administrator
View PDF
Shape

Episode 25

Optimistic & Pessimistic Locking in YugabyteDB

Listen to Yugabyte Engineer Rob Sami and Co-Founder and CTO Karthik Ranganathan discuss optimistic versus pessimistic locking, why some workloads may benefit from one or the other, and the challenges with supporting pessimistic locking in a distributed database.

  • YSQL, Distributed SQL ,PostgreSQL, Locks, Locking, Optimistic, Pessimistic
  • Database AdministratorsArchitects
View PDF
Shape

Episode 26

Managing Your YugabyteDB Cluster with yugabyted

Listen to Yugabyte Engineer Nikhil Chandrappa and Co-Founder Kannan Muthukkaruppan discuss yugabyted, a user-friendly daemon service for starting, configuring, and monitoring your YugabyteDB cluster. Tune in to discover how to deploy a YugabyteDB cluster for single zone, multi-zone, and multi-region configurations using yugabyted.

  • yugabyted, Cluster, Deployment, Single-Zone, Multi-Zone, Multi-Region, Multi-Cloud
  • Application Developer, Architect, Database Administrator
View PDF
Shape

Episode 27

Are Stored Procedures a Good Thing?

Listen to Yugabyte’s Technical Product Manager Bryn Llewellyn and Co-Founder Karthik Ranganathan discuss why, three decades ago, RDBMSs introduced support for stored procedures – and why, despite all the radical changes that the industry has seen since then, there are still good reasons for running user-defined procedural code in a distributed SQL database like YugabyteDB.

  • YSQL, PostgreSQL, Stored Procedure, Trigger, Function,
  • Architect, Database Administrator, Application Developer
View PDF
Shape

Episode 28

YugabyteDB Performance Advisor

Listen to Yugabyte LRT team member Sushant Mishra and Co-Founder Karthik Ranganathan discuss YugabyteDB Performance Advisor, which auto detects performance issues in the YugabyteDB cluster and provides recommendations to improve the running workload.

  • YugabyteDB Managed, Performance Advisor, YSQL, YCQL, Query
  • Application Developer, Database Administrator
View PDF
Shape

Episode 29

YugabyteDB Voyager – Data Migration Simplified

Listen to Yugabyte product expert Prasad Radhakrishnan and Co-Founder Karthik Ranganathan discuss newly-launched YugabyteDB Voyager, which enables enterprises to easily and securely migrate their data from traditional relational databases like Oracle, MySQL, and PostgreSQL to YugabyteDB, a cloud native RDBMS.

  • Migration, PostgreSQL, Oracle, MySQL, YugabyteDB, YSQL, YugabyteDB Voyager
  • Architects, Database Administrators
View PDF
Shape

Episode 30

Encryption at Rest in YugabyteDB

Watch to Yugabyte Engineer Rahul Desirazu and Co-Founder Kannan Muthukkaruppan discuss how encryption keys are stored, used, and rotated to secure data at rest.

  • Encryption at Rest, Security, Keys
  • Architect, Database Administrator
View PDF
Shape

Episode 31

yb_stats in YugabyteDB

Watch Yugabyte Developer Advocate Frits Hoogland and Co-Founder Kannan Muthakkaruppan discuss yb_stats, a tool to obtain YugabyteDB cluster status for troubleshooting, investigation, and support. yb_stats can be used for ad-hoc analysis and to build a history using snapshots.

  • yb_stats, YCQL, YSQL, YugabyteDB, Metrics, Observability, Workload, Troubleshooting
  • Database Administrator
View PDF
Shape

Episode 32

Packed Row Storage Format in YugabyteDB

Listen to Yugabyte Director of Engineering, Raghavendra T.K. and Co-Founder, Kannan Muthukkaruppan discuss YugabyteDB's new packed row storage format, which improves the performance of many workloads like inserts, scans and bulk load.

  • YSQL, DocDB, Tablet, RocksDB, Packed Row Storage
  • Database Administrator
View PDF
Shape

Episode 33

Postgres TABLESPACE in a Cloud Native World

Watch Yugabyte Developer Advocate Franck Pachot and Co-Founder Kannan Muthukkaruppan, discuss how the PostgreSQL tablespaces are used in a cloud native world to define data residency placement and reduce latency in a geo-distributed SQL database.

  • YSQL, Data Residency, Index, Table, Tablet, Table Partition, Tablespace, Geo-Distributed, GDPR
  • Architect, Database Administrator, Application Developer
Shape

Episode 48

Network and On-Disk Compression in YugabyteDB

Watch Yugabyte Director of Engineering, Raghavendra T. K. and Co-Founder, Kannan Muthukkaruppan discuss Yugabyte’s compression options that help optimize network and storage costs.

  • Cluster, Universe, Cluster Topology, RPC, Storage, Network, Compression, GZIP, LZ4, ZLIB, Snappy, RocksDB, SST
  • Architect, Database Administrator
Shape

Episode 49

Auto ID Generation in PostgreSQL & YugabyteDB

Watch Yugabyte Senior Full Stack Engineer Brett Hoyer and Co-Founder Karthik Ranganathan discuss strategies for handling automatic ID generation in PostgreSQL and show how this decision can impact performance in distributed SQL.

  • YSQL, PostgreSQL, Sequence, Primary Key, Auto ID
  • Application Developers, Database Administrators
View PDF
Shape

Episode 50

Full Compactions in YB & How to Schedule Them

Listen to Yugabyte Engineer John Meehan and Co-Founder Kannan Muthukkaruppan discuss how background compactions work at the storage level of YugabyteDB, and demonstrate the benefits of scheduling full compactions for update-and delete-heavy workloads.

  • Tablet, DocDB, RocksDB, LSM, SST, Universal, Size Amplification, Read Amplification, Compaction, Time-to-Live, TTL
  • Database Administrator
View PDF
Shape

Episode 51

Batched Nested Loop Joins

Watch Yugabyte Engineer Tanuj Nayak and Co-Founder Karthik Ranganathan as they discuss batched nested loop joins, a distributed-friendly version of Nested Loop Joins.

  • YSQL, PostgreSQL, Query, Execution Plan, Query Plan, Query Optimizer, Merge, Hash, Nested Loop
  • Application Developer, Database Administrator
View PDF
Shape

Episode 52

Disaster Recovery in YugabyteDB

Watch Yugabyte Product Manager Val Kulichenko and Co-Founder Kannan Muthukkaruppan discuss how the latest additions to YugabyteDB xCluster can help to build a comprehensive business continuity and disaster recovery strategy.

  • Business Continuity, Disaster Recovery, Point-in-Time Recovery, Failover, xCluster Replication, Standby, Cluster Topology, Multi-Zone, Recovery Point Objective, RPO
  • Architect, Database Administrator
View PDF
Shape

Episode 53

TAQO - Testing Accuracy of Query Optimizer

Listen to Yugabyte Engineer Dmitry Sherstobitov and Co-Founder Karthik Ranganathan discuss a solution for testing query optimizer accuracy and performance in a distributed world.

  • YSQL, Execution Plan, Query Plan, Query Optimizer, Cost Based
  • Application Developers, Database Administrator
View PDF
Shape

Episode 54

Don't Let Tombstones Affect Scan Performance

Listen to Yugabyte Technical Evangelist Premkumar Thangamani and Co-Founder Kannan Muthukkaruppan discuss how deletes or overwrites can affect scan performance and strategies for optimizing such workloads.

  • Compaction, DocDB, RocksDB, Storage, SST, Log Structured Merge-Tree, LSM, Multi Version Concurrency Control
  • MVCC, Tombstone
  • Architect, Database Administrator
View PDF
Shape