Schrödinger’s dNFS: The Empty Row Mystery

You will end up here: v$dnfs_servers returns no rows. You’ve checked everything. The library is linked. The alert log shows dNFS loaded. Your oranfstab is syntactically perfect. The NFS mounts are there. And you’re convinced it’s broken, I was too. I spent three hours proving dNFS was configured correctly while simultaneously proving it wasn’t working. […]

Schrödinger’s dNFS: The Empty Row Mystery Read More »

Stress Testing Consolidated Platforms with Database Workloads

Your storage vendor claims 500K IOPS. Your server vendor promises 128 cores of “enterprise-grade performance.” Your hypervisor can “easily handle” 50 VMs. Your network fabric has “plenty of headroom.” Then you consolidate eight production databases onto the platform and everything falls over at 3 AM on a Tuesday. What happened? Nobody actually tested what happens

Stress Testing Consolidated Platforms with Database Workloads Read More »

city with high rise buildings under white sky during daytime

Evaluating Storage Read Cache for Different Database Designs

This blog post is focused on the different datasets I have designed to evaluate Pure Storage® DirectMemory Cache with various databases like SAP HANA, MySQL and MariaDB. More information on the results can be found in the blog posts Reducing costs for SAP HANA with Pure’s DirectMemory Cache and Accelerate MySQL Read Scale with DirectMemory

Evaluating Storage Read Cache for Different Database Designs Read More »

photo of 5-story library building

MySQL Backup and Recovery

There are a number of ways in which data protection/data mobility can be done with MySQL. The documentation splits backups into two categories. Physical Backups – Raw copies of directories and files which store database contents Logical backups – Logical backups save information in the form of reproducing the database object structure  to the point

MySQL Backup and Recovery Read More »