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.