🗄️

Morpheus Tech Brief on Database as a Service

Jul 1, 2024

Morpheus Tech Brief on Database as a Service

Introduction

Speaker: Martz Reed, Director of Technical Marketing, Morpheus Data

Overview

  • Database as a Service (DBaaS): Strategy to outsource or simplify database management.
    • Examples: Infrastructure as a Service (IaaS), Platform as a Service (PaaS), Software as a Service (SaaS)
    • Goal: Minimize operational management burden.

Types of DBaaS

Self-Managed Database

  • Involves substantial user management.
    • User manages installation, configuration, ongoing management of the database.
    • Example: Leveraging cloud infrastructure but managing up to the virtualization layer.
  • Pro: Offers higher control over database configuration.
  • Con: Requires extensive management and resources from the user side.

Managed Database

  • Managed by a provider (e.g., cloud service provider or internal team).
    • Provider handles installation, configuration, updating, and patching.
  • Pro: Reduces user burden in management tasks.
  • Con: Less control over database settings and possibly higher costs.
  • **Serverless Database: ** Higher abstraction level where user interacts only with data input/output.

Morpheus Platform Capabilities

Infrastructure Provisioning

  • Orchestrates initial installation and configuration of the database.
    • Supports multiple hypervisors (e.g., VMware, OpenStack, Hyper-V).
    • Supports public cloud environments (AWS, Azure, GCP, Oracle).

Example Process: Install PostgreSQL

  • Provisioning a virtual machine instance.
    • Setup includes logging agents, monitoring agents, security agents.
    • Installation and configuration of the database.

Constructing Catalog Items

  • Expose various parameters to the user, such as engine version, plan size, password, and maintenance window.

Example: PostgreSQL Instance

  • User selections include version (e.g., PostgreSQL 15, 14, 13), service plan (resource allocation), password, and maintenance window.

Automation and Integration

  • Utilizing automation capabilities (e.g., Ansible Playbooks) to manage installation and configuration.
  • Custom UI Tab: Provides connection details easily accessible to the user.

Extensibility and Customization

Plug-in Architecture

  • Enables extensibility for specific use cases.
    • Example: Custom UI tabs for connection details.
  • Integration with third-party monitoring systems (e.g., DataDog, Prometheus).
    • Provides additional operational context and metrics.

Multi-Tenant Deployments

  • MSPs can expose similar mechanisms to sub-tenants.

Ongoing Management

  • Automation of OS and database patching using platform-defined schedules.
  • Integration with monitoring tools to manage performance metrics.

Recap and Q&A

  • Addressing various database needs within Morpheus platform.
  • Diverse range of automation and integration capabilities.
  • Enhanced user experience through customizability and extensibility.
  • Efficient architecture for both self-managed and managed DBaaS solutions.

**Questions discussed: **

  • Examples of DBaaS with multiple database instances on a machine.
    • Integration and functionality for monitoring solutions.
    • Lifecycle management, cost metering, and specific database support (e.g., MSSQL, Oracle).

Thank you for attending, and appreciate the questions.

Full transcript