Storage for DBAs
This page contains an index to an extended blog series I have been writing called Storage for DBAs. As a long-time database guy entering the murky world of storage, I found three were a lot of lessons to learn and myths to debunk.
It’s not a great name for a blog series because it’s not just aimed at DBAs but also architects, developers, administrators of any kind, managers, buyers and anyone with an interested in modern storage. However, in these Twitter-friendly times, the name Storage For Architects, Developers, Administrators of Any Kind, Managers, Buyers and Anyone with an Interest in Modern Storage didn’t seem very catchy.
Performance: It’s All About Balance
The Fundamental Characteristics of Storage
Understanding I/O: Random vs Sequential (The Sushi Effect!)
Does My Database Need Flash?
The Most Important Thing You Need To Know About Flash
Storage Myths: IOPS Matter
Storage Myths: Put Oracle Redo on SSD
Storage Myths: Dedupe for Databases
Storage Myths: Storage Compression Has No Downside
Playing The Data Reduction Lottery
The Real Cost of Enterprise Database Software
The Real Cost of Oracle RAC
The Most Expensive CPUs You Own
Understanding Disk: Superpowers
Understanding Disk: Mechanical Limitations
Understanding Disk: Over-Provisioning
Understanding Disk: Caching and Tiering
Understanding Flash: What Is NAND Flash?
Understanding Flash: Blocks, Pages and Program / Erases
Understanding Flash: SLC, MLC and TLC
Understanding Flash: The Flash Translation Layer
Understanding Flash: Garbage Collection Matters
Understanding Flash: The Write Cliff
Understanding Flash: Unpredictable Write Performance
Understanding Flash: Floating Gates and Wear
<more coming soon>