Extreme Performance and SmartScaling MySQL with Storage Class Memory Servers
summary
Green Cloud Server for MySQL uses on-board storage class memory (NOR‑flash based SCM) with a memory-class interface and an InnoDB buffer‑pool aware stack, delivering DRAM‑like access to persistent data. Hardware: 1–4 quad‑core x86 CPUs, 16–64 GB DRAM, up to 0.5 TB SCM. On a 90/10 read‑heavy web workload it reports 70x on 90/10 web workload versus 15k RPM SAS and about 5x versus high‑end PCIe SSDs, achieved by avoiding block‑stack transfers and loading only the needed rows. Customer tests push 90% DB load onto one box.
AI-written summary · about
chapters (9)
- 0:00Intro
- 1:16Virident Background and Talk Outline
- 3:18Scaling MySQL Deployments - Lessons
- 5:21What Limits the Performance of a MySQL Server?
- 7:41Bridging the Performance-Persistence Gap
- 10:11GreenCloud Architectures Bringing SCM into Servers
- 15:42Virident GreenCloud Server for MySQL-Benefits
- 17:26Virident GreenCloud Family
- 17:46Stepping Back: What Does This Mean for Scale-Out?
related talks
09mThe DNA of Next-generation Data C
30mSolving MySQL Scalability with Adaptive IO
15mImproving Performance of Flash Based Key-Value Stores Using Storage Class Memory...
06mScaling your applications with Cloud SQL for MySQL
31mReimagining the Future: Where the Market is Evolving
25mData in the Cloud
37mMySQL Database Scalability
28mHow Can Databases Capitalize on Computational Storage?