In this episode, we discuss cloud innovations that power MySQL HeatWave Lakehouse, allowing customers to process and query half a petabyte of data in object storage with record performance and cost savings. Read the announcement: https://social.ora.cl/60065kt76
00:00 Introduction
01:10 MySQL HeatWave Overview
02:25 Massively Partitioned Architecture
04:07 Transaction Processing in MySQL HeatWave
05:27 MySQL HeatWave Lakehouse
07:10 Loading Half a Petabyte in Lakehouse
08:43 Schema Inference by MySQL Autopilot
09:47 Adaptive Data Sampling
11:07 Adaptive Data Flow
13:07 Same Performance for Query on Object Store
13:57 MySQL Autopilot Powers Query Performance
16:11 Smart Scheduler's Compute and Communication Overlap
17:45 Handling Query Plan Outliers
19:45 Takeaways
Like what you learned about MySQL HeatWave Lakehouse? Subscribe now https://social.ora.cl/60063aboY
For more architectural breakdowns, catch up on more First Principles videos:
First Principles: making Kubernetes serverless with OCI's Virtual Nodes:
https://www.youtube.com/watch?v=Bvn_2o-h2Ec&t=0s
First Principles: inside Container Instances:
https://www.youtube.com/watch?v=Bvn_2o-h2Ec&t=0s
First Principles: using redundancy and recovery to achieve high durability in OCI Object Storage:
https://www.youtube.com/watch?v=TbxpIBfr9Zw&t=0s
First Principles: building a high performance network in the public cloud:
https://www.youtube.com/watch?v=ca_OGqCVHDM&t=0s
First Principles: superclusters with RDMA—Ultra-high performance at massive scale:
https://www.youtube.com/watch?v=_qJIVJ9YmL0&t=0s
First Principles: L2 Virtual Networking for Cloud Lift-and-Shift:
https://www.youtube.com/watch?v=DLj98lZJe68&t=0s
Contact Cloud Platform Sales: https://social.ora.cl/6004zuD5G
Oracle Cloud Infrastructure (OCI) - https://social.ora.cl/6005PnzTH
Join us at Oracle CloudWorld - https://social.ora.cl/6007PuGg5
Cloud Storage - https://social.ora.cl/6006Pnzn8
Cloud Compute - https://social.ora.cl/6009Pnzk5
Cloud Networking - https://social.ora.cl/6007Pnzwc
Multicloud - https://social.ora.cl/6003Pnzjb
Cloud Economics - https://social.ora.cl/6003PnzoX
Cloud Computing Defined - https://social.ora.cl/6004PnzSm
Follow us here:
LinkedIn: https://social.ora.cl/60013ab3t
Facebook: https://social.ora.cl/60003abOn
Instagram: https://social.ora.cl/60083abPj
Twitter: https://social.ora.cl/60003abur
#OracleCloud #MySQL #datalakehouse