I installed Oracle RAC 19c on a two-node cluster with Pure Storage FlashArray backend. Four 32Gb Fibre Channel HBAs per node. 24 paths per LUN. Hardware capable of 12+ GB/s throughput. Yet my benchmarks topped out at 3.2 GB/s. This post explains the mistake I made, how I found it, and how I fixed it. […]
How to Avoid Misconfiguring Oracle ASM with Multipath SAN Storage Read More »
I recently built a two-node Oracle RAC 19c cluster on Oracle Linux 8.10 with Pure Storage FlashArray backend. The hardware was solid, the network was configured, the storage was presented. What should have been a straightforward installation turned into a four-hour troubleshooting session because of issues that aren’t documented in Oracle’s installation guides. This post
Installing Oracle Database 19c RAC on OEL 8: Four Traps Read More »
This is the third in my series analyzing data-centric markets. See also: Demystifying the Database Market in 2025 and Demystifying the Data Governance Market in 2025. It’s interesting how major vendors position themselves now, none of them lead with “analytics”. Databricks calls itself “the Data and AI company.” Snowflake is “the AI Data Cloud.” dbt
Demystifying the Analytics Market in 2025 Read More »
Oracle ranks #1 on the DB-Engines database popularity ranking, ahead of MySQL, SQL Server, and PostgreSQL. Running Oracle benchmarks alongside SQL Server in my day-to-day testing made perfect sense from the start, but HammerDB-Scale v1.0 focused on getting SQL Server working properly first. Version 1.1 adds Oracle support with the same parallel orchestration framework that
Oracle Database Support for HammerDB-Scale Read More »
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 »
The Economics of Data Gravity In 2010, Dave McCrory introduced the concept of “data gravity” to describe a phenomenon IT professionals were increasingly experiencing: as data accumulates in one location, it becomes harder to move, and the systems that depend on it tend to cluster nearby. The metaphor suggested that data, like physical mass, exerts
The Economics of Data Gravity Read More »
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 »
This is the second in my series analyzing data centirc markets. Read part one: Demystifying the Database Market in 2025. According to Gartner (2024), by 2027, 80% of data and analytics governance initiatives will fail due to a lack of a real or manufactured crisis. This is a pretty loaded statement, because it tells us
Demystifying the Data Governance Market in 2025 Read More »
This is the unmanaged experience of Apache Spark in 2025, and it is a Screen Play in length, you were warned! P.s. – Netflix greenlight me! A few weeks ago, I dove deep into Apache Spark through hands-on implementation of a Customer 360 use case, using the medallion pipeline processing architecture (Bronze → Silver →
Apache Spark in 2025: Handle with Gloves Read More »
The Database Management System Market in Plain Language Your job, unfortunately, depends on a database doing what it’s supposed to: record the firm’s relationship to money in a structured format. If that database went away the world would absolutely collapse. I wish I was kidding, but think about it: if your corporate ERP system goes
Demystifying the Database Market in 2025 Read More »
I first began working with databases when I was an undergrad doing Computer Science. There was a module that ran tutorials for data manipulation against an Oracle database using SQL. I remember what I was thinking when trying to figure out how to get the correct output : “I don’t understand, why won’t it work!”.
A history of myself, DOES and data Read More »
There are many database benchmarking and testing tools that can be used to understand how a system might behave under specific circumstances. Each one of these has a specialism, some of them are designed for unit testing while others are workload oriented. After several years working towards this goal I am excited to announce my
Simple Database Testing with D.O.E.S Read More »
Recently while doing some bits and pieces around the containerization of various databases I found myself deploying RedHat® OpenShift®. I found in my case there were a number of caveats to make everything work as intended and so I decided to see if a step by step of my experience could be helpful to others.
Deploying an OpenShift Cluster on VMware vSphere Read More »
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 »
Caching is used in hardware and software to shorten operational response times for data with a high usage frequency. CPU’s implement caching through the use of smaller and faster memory on or close to the processing unit where data can be retrieved and processed more quickly than in main memory. For persistent storage like hard
Introduction to Storage Caching Read More »
MySQL and MariaDB are two very popular database engines (Source – DB-Engines Ranking). Both are open source (licensed as GPLv2 or proprietary for MySQL or LGPL for some scenarios with MariaDB) which allows for abundant support , lower software costs and no vendor lock-in. There are many reasons an organization would want to make use
MySQL and MariaDB Replication Read More »
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 »
