oracle timesten scaleout –world’s fastest oltp db … · -timesten demo booth. title: intel...
TRANSCRIPT
![Page 1: Oracle TimesTen Scaleout –World’s Fastest OLTP DB … · -Timesten Demo Booth. Title: Intel NVRAM Demo Slides v11 - Dark copy Created Date: 20190528165119Z](https://reader035.vdocuments.us/reader035/viewer/2022081517/5fd47d64853705100e76d27b/html5/thumbnails/1.jpg)
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Oracle TimesTen Scaleout – World’s Fastest OLTP DB
Doug Hood @ScalableDBDougConsulting Member of Technical Staff Product Manager for Oracle TimesTen, Oracle InMemory and Oracle NoSQLNov 29, 2018
![Page 2: Oracle TimesTen Scaleout –World’s Fastest OLTP DB … · -Timesten Demo Booth. Title: Intel NVRAM Demo Slides v11 - Dark copy Created Date: 20190528165119Z](https://reader035.vdocuments.us/reader035/viewer/2022081517/5fd47d64853705100e76d27b/html5/thumbnails/2.jpg)
TimesTen In-Memory DB using Intel Optane DC Persistent Memory
![Page 3: Oracle TimesTen Scaleout –World’s Fastest OLTP DB … · -Timesten Demo Booth. Title: Intel NVRAM Demo Slides v11 - Dark copy Created Date: 20190528165119Z](https://reader035.vdocuments.us/reader035/viewer/2022081517/5fd47d64853705100e76d27b/html5/thumbnails/3.jpg)
§ Pure in-memory§ ACID compliant§ Standard SQL§ Entire database in
RAM
§ Database and transaction logs persisted on local storage
§ Automatic recovery after failure
§ Microseconds response time§ 10s of millions of TPS§ Billions of queries per second
§ High performance replication
§ Elastic scalability with K-safety
TimesTen: World’s Fastest OLTP Database
In-Memory Relational Database
Extremely Fast
Persistent and Recoverable
Highly Available, Extremely Scalable
![Page 4: Oracle TimesTen Scaleout –World’s Fastest OLTP DB … · -Timesten Demo Booth. Title: Intel NVRAM Demo Slides v11 - Dark copy Created Date: 20190528165119Z](https://reader035.vdocuments.us/reader035/viewer/2022081517/5fd47d64853705100e76d27b/html5/thumbnails/4.jpg)
In-Memory Database Startup
Today
- Copy database image from persistent storage into volatile DRAM
- 1.35 TB database
With Intel persistent memory- Different implementation- Database in Intel persistent memory
is the persistent storage- ‘Startup’ is instantaneous - 2.7 TB database
![Page 5: Oracle TimesTen Scaleout –World’s Fastest OLTP DB … · -Timesten Demo Booth. Title: Intel NVRAM Demo Slides v11 - Dark copy Created Date: 20190528165119Z](https://reader035.vdocuments.us/reader035/viewer/2022081517/5fd47d64853705100e76d27b/html5/thumbnails/5.jpg)
In-Memory Database Startup
Today
- Copy database image from persistent storage into volatile DRAM
- 1.35 TB database → 13m 20s
With Intel persistent memory- Different implementation- Database in Intel persistent memory
is the persistent storage- ‘Startup’ is instantaneous - 2.7 TB database → 0.4s
4000x improvement!
![Page 6: Oracle TimesTen Scaleout –World’s Fastest OLTP DB … · -Timesten Demo Booth. Title: Intel NVRAM Demo Slides v11 - Dark copy Created Date: 20190528165119Z](https://reader035.vdocuments.us/reader035/viewer/2022081517/5fd47d64853705100e76d27b/html5/thumbnails/6.jpg)
Transaction Durability
Today
- Log buffer in volatile DRAM
- Transactions commit to buffer…
- … then buffer written synchronously to storage
- Peak throughput
With Intel persistent memory- Different implementation- Log buffer is in Intel persistent
memory- Persistence is immediate on commit
- No need to wait for write to storage - Peak throughput
![Page 7: Oracle TimesTen Scaleout –World’s Fastest OLTP DB … · -Timesten Demo Booth. Title: Intel NVRAM Demo Slides v11 - Dark copy Created Date: 20190528165119Z](https://reader035.vdocuments.us/reader035/viewer/2022081517/5fd47d64853705100e76d27b/html5/thumbnails/7.jpg)
Transaction Durability
Today
- Log buffer in volatile DRAM
- Transactions commit to buffer…
- … then buffer written synchronously to storage
- Peak throughput → 170 K TPS
With Intel persistent memory- Different implementation- Log buffer is in Intel persistent
memory- Persistence is immediate on commit
- No need to wait for write to storage - Peak throughput→ 1.1 M TPS
6.5x improvement!
![Page 8: Oracle TimesTen Scaleout –World’s Fastest OLTP DB … · -Timesten Demo Booth. Title: Intel NVRAM Demo Slides v11 - Dark copy Created Date: 20190528165119Z](https://reader035.vdocuments.us/reader035/viewer/2022081517/5fd47d64853705100e76d27b/html5/thumbnails/8.jpg)
Summary
Intel persistent memory enables new capabilities and enhanced performance for In-Memory Databases
- 4000x faster database startup
- 6.5x faster durable transaction performance
- Timesten Info:- Hands On Lab: 10/23 5:15pm, 10/24 12:45pm- Timesten Session: 10/24 11:15 am - Timesten Demo Booth