IBM Open Platform for DBaaS on IBM Power Systems

IBM Open Platform for DBaaS on IBM Power Systems

by Dino Quintero, Fabio Martins, Eduardo Luis Cerdas Moya, Rafael Camarda Silva Folco
Released March 2018
Publisher(s): IBM Redbooks
ISBN: 9780738442792

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Abstract

This IBM Redbooks publication describes how to implement an Open Platform for Database as a Service (DBaaS) on IBM Power Systems environment for Linux, and demonstrate the open source tools, optimization and best practices guidelines for it. Open Platform for DBaaS on Power Systems is an on-demand, secure, and scalable self-service database platform that automates provisioning and administration of databases to support new business applications and information insights.

This publication addresses topics to help sellers, architects, brand specialists, distributors, resellers and anyone offering secure and scalable Open Platform for DBaaS on Power Systems solution with APIs that are consistent across heterogeneous open database types. An Open Platform for DBaaS on Power Systems solution has the capability to accelerate business success by providing an infrastructure, and tools leveraging Open Source and OpenStack software engineered to optimize hardware and software between workloads and resources so you have a responsive, and an adaptive environment. Moreover, this publication provides documentation to transfer the how-to-skills for cloud oriented operational management of Open Platform for DBaaS on Power Systems service and underlying infrastructure to the technical teams.

Open Platform for DBaaS on Power Systems mission is to provide scalable and reliable cloud database as a service provisioning functionality for both relational and non-relational database engines, and to continue to improve its fully-featured and extensible open source framework. For example, Trove is a database as a service for OpenStack. It is designed to run entirely on OpenStack, with the goal of allowing users to quickly and easily utilize the features of a relational or non-relational database without the burden of handling complex administrative tasks. Cloud users and database administrators can provision and manage multiple database instances as needed. Initially, the service focuses on providing resource isolation at high performance while automating complex administrative tasks including deployment, configuration, patching, backups, restores, and monitoring.

In the context of this publication, the monitoring tool implemented is Nagios Core which is an open source monitoring tool. Hence, when you see a reference of Nagios in this book, Nagios Core is the open source monitoring solution implemented. Also note that the implementation of Open Platform for DBaaS on IBM Power Systems is based on open source solutions.

This book is targeted toward sellers, architects, brand specialists, distributors, resellers and anyone developing and implementing Open Platform for DBaaS on Power Systems solutions.

Table of contents

  1. Front cover
  2. Notices
    1. Trademarks
  3. Preface
    1. Authors
    2. Now you can become a published author, too!
    3. Comments welcome
    4. Stay connected to IBM Redbooks
  4. Chapter 1. Overview of the Open Platform for Database as a Service on IBM Power Systems solution
    1. 1.1 Introduction to the Open Platform for DBaaS on Power Systems solution
      1. 1.1.1 What is the Open Platform for DBaaS on Power Systems solution
      2. 1.1.2 Why use the Open Platform for DBaaS on Power Systems solution
      3. 1.1.3 Benefits of using the Open Platform for DBaaS on Power Systems solution
    2. 1.2 Open Platform for DBaaS on Power Systems components
      1. 1.2.1 The Open Platform for DBaaS on Power Systems hardware infrastructure
      2. 1.2.2 DBaaS elastic cloud infrastructure
    3. 1.3 Open Platform for DBaaS on Power Systems product delivery and support flow
  5. Chapter 2. IBM DevOps concepts
    1. 2.1 IBM DevOps
      1. 2.1.1 DevOps lifecycle phases
      2. 2.1.2 DevOps practices
      3. 2.1.3 Cloud Infrastructure as a Service and DevOps
      4. 2.1.4 Infrastructure as code
    2. 2.2 Infrastructure as a Service+
      1. 2.2.1 Open Platform for Database as a Service on Power Systems
      2. 2.2.2 Trove
    3. 2.3 Supported databases
  6. Chapter 3. Architecture
    1. 3.1 Planning for the Open Platform for DBaaS on Power Systems solution
      1. 3.1.1 Physical integration with the customer’s infrastructure
      2. 3.1.2 Security integration (LDAP and Keystone)
      3. 3.1.3 Custom database images
    2. 3.2 Hardware and software requirements
    3. 3.3 Infrastructure sizing
      1. 3.3.1 Starter
      2. 3.3.2 Entry (small)
      3. 3.3.3 Cloud scale (medium)
      4. 3.3.4 Performance (large)
    4. 3.4 Networking
      1. 3.4.1 General requirements
    5. 3.5 Solution components and roles
      1. 3.5.1 Compute nodes
      2. 3.5.2 Controller nodes
      3. 3.5.3 Block storage nodes
      4. 3.5.4 Object storage nodes
  7. Chapter 4. Usage
    1. 4.1 Get and build images
    2. 4.2 Deploying and maintaining instances
      1. 4.2.1 Launching an instance
      2. 4.2.2 Checking the instance information
      3. 4.2.3 Maintaining an instance
      4. 4.2.4 Restarting an instance
      5. 4.2.5 Resizing an instance
      6. 4.2.6 Deleting an instance
      7. 4.2.7 Resizing a volume
      8. 4.2.8 Renaming an instance
      9. 4.2.9 Creating a database
      10. 4.2.10 Deleting a database
    3. 4.3 Backup and recovery
      1. 4.3.1 Creating a backup
      2. 4.3.2 Restoring from backup
      3. 4.3.3 Deleting a backup
      4. 4.3.4 Backup containers
    4. 4.4 Security
      1. 4.4.1 Creating a user
      2. 4.4.2 Deleting a user
      3. 4.4.3 Managing root access
      4. 4.4.4 Managing user access
  8. Chapter 5. Monitoring and troubleshooting
    1. 5.1 Introduction to cluster monitoring and troubleshooting
    2. 5.2 Accessing the operations management tools
    3. 5.3 Nagios
      1. 5.3.1 Nagios Core basic monitoring concepts
      2. 5.3.2 Nagios Core deployment in Open Platform for DBaaS on Power Systems
      3. 5.3.3 Nagios Core configuration files
      4. 5.3.4 Nagios Core usage examples
    4. 5.4 Elastic stack (Kibana)
      1. 5.4.1 Using the Kibana Dashboard
      2. 5.4.2 Selecting other Dashboards that are available in the Open Platform for DBaaS on Power Systems solution
      3. 5.4.3 Performing searches with Kibana
      4. 5.4.4 Viewing saved searches
      5. 5.4.5 Using Kibana to create a graph that is based on a search
      6. 5.4.6 Viewing saved visualizations
      7. 5.4.7 Adding the graph visualization to the Dashboard
      8. 5.4.8 Using Kibana to view metrics
      9. 5.4.9 Using Kibana for troubleshooting
  9. Chapter 6. Scaling
    1. 6.1 Scaling up your cluster
      1. 6.1.1 Adding a compute node
      2. 6.1.2 Adding a storage node
    2. 6.2 Horizontal scaling
  10. Appendix A. Servers provisioning and deployment
    1. Baremetal provisioning
    2. OpenStack deployment
    3. Alternative deployment
    4. Image building
  11. Related publications
    1. IBM Redbooks
    2. Online resources
    3. Help from IBM
  12. Back cover

Product information

  • Title: IBM Open Platform for DBaaS on IBM Power Systems
  • Author(s): Dino Quintero, Fabio Martins, Eduardo Luis Cerdas Moya, Rafael Camarda Silva Folco
  • Release date: March 2018
  • Publisher(s): IBM Redbooks
  • ISBN: 9780738442792