SingleStore Database on High Performance IBM Spectrum Scale Filesystem with Red Hat OpenShift and IBM Cloud Pak for Data

Blueprint

thumbnail 

Published on 14 September 2022, updated 15 September 2022

  1. .EPUB (1.5 MB)
  2. .PDF (1.9 MB)

Apple BooksGoogle Play Books
Share this page:   

ISBN-10: 0738460818
ISBN-13: 9780738460819
IBM Form #: REDP-5689-00


Authors: Nilesh Suryawanshi, Hemant Kantak and Tan-Long Siau

    menu icon

    Abstract

    This IBM® blueprint describes the SingleStoreDB that is running on Red Hat OpenShift in a containerized environment. The SingleStoreDB deployment uses the IBM Spectrum® Scale container native access storage class to create persistent volumes (PVs) for the SingleStoreDB pods deployment.

    This document also describes the process that is used to expand a SingleStoreDB volume on IBM Spectrum Scale and an IBM Spectrum Scale PV on a Red Hat OpenShift cluster for IBM Spectrum Scale to verify that the SingleStoreDB remained intact after the volume is expanded.

    The procedure to create a sample database that is named stockDB, and the data analytical stats for reading and writing the data also are included. The sample data was captured for comparison statistics for SingleStoreDB that is deployed on the IBM Spectrum Scale Cluster File System and local storage. These comparison statistics emphasize the notable difference between the sample data sets.

    Finally, this document also explains the procedure that is used to create the same sample database with the unlimited storage feature in SingleStore by using IBM Cloud® Object Storage.

    Table of Contents

    About this document

    Executive summary

    Scope

    IntroductionPrerequisites

    IBM Global Data Platform with SingleStore

    Use Case 1: Lab setup

    Use Case 2: Lab setup

    Other prerequisites

    Summary