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 »
This post is focused on providing a foundation for the structures and designs of a relational database. Tables/entities The typical structure of a table is a set of rows , each with its own data in a specified column. This table is a list of customers with their first names ,last names , addresses and
A Brief Introduction To Database Structures and Design 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 »
