Architecture Insight of OceanBase: A Distributed SQL Database - CMU Database Seminar

Explore the architecture and design of OceanBase, a distributed SQL database, in this comprehensive seminar talk by Charlie Yang. Delve into the system's ability to handle high-traffic scenarios, such as Alibaba's Double Eleven Day, and its use by over 500 customers in mission-critical systems. Examine OceanBase's design goals, TPC benchmark performance, and key architectural components including partitioning, Paxos-based replication, and distributed transactions. Learn about the database's approach to isolation levels, linearizability, and two-level compression. Investigate the challenges and solutions for Hybrid Transactional/Analytical Processing (HTAP), covering storage, resource isolation, query optimization, and execution. Analyze OceanBase's performance in TPC-C benchmarks, including configuration details, challenges faced, and results achieved. Gain insights into the storage engine and overall system architecture of this powerful distributed database solution.

Intro
Traffic Peak of Payment of Double Eleven Day
About OceanBase
OceanBase Alipay
Used by 500+ customers in Mission Critical Systems
Design Goals
TPC Benchmark
Architecture
Basic Concept
Partition
Paxos-based Replication
Distributed Transaction
Isolation Level
Linearizability
Two Level Compression
Online Schema Change
Introduction to HTAP
HTAP challenges for storage
HTAP challenges for resource isolation
HTAP challenges for optimizer
HTAP challenges for executor
Serial Execution
Parallel Execution
TPC-C benchmark
Benchmark Configuration
Challenges & Solution
Results-tpmC jitter
Results (D Test)
Storage Engine