Hands-on technical implementation and testing
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 »
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 »
This is the final part of the blog series about moving seamlessly between SAP HANA hosting types using storage where the concepts and scenarios in Part 2 : pHANA on-premises migration techniques and Part 3 : pHANA to vHANA and vHANA to pHANA will be applied to showcase how a truly hybrid cloud environment could
SAP HANA Data Mobility Part 4 : Hybrid Cloud Read More »
SAP® Migrations are a daily part of any SAP BASIS administrator’s life and possibly one of the most meticulously planned processes which can happen in the lifecycle of an SAP landscape. The migration alone could be to move one or all of the SAP applications , data and technology to either the same or totally
SAP HANA Data Mobility Part 1 : Introduction Read More »
In this part of the blog series about moving seamlessly between SAP HANA hosting types using storage the following data mobility scenarios are explored: SAP HANA deployed on bare-metal server(s) (pHANA) being migrated or copied to a virtual machine(vHANA) using VMware Virtual Volumes(vVols) SAP HANA deployed on a VMware virtual machine being migrated to bare-metal
SAP HANA Data Mobility Part 3 : pHANA to vHANA and vHANA to pHANA Read More »
