Databases on Nutanix – Reference Architecture

Because organizations store their information, including their most critical data, in databases (DBs), it’s vital that these DBs meet the requirements for availability, manageability, resilience, and performance. To provide the needed database functionality, you must carefully design and maintain both the infrastructure layer and the DB engines, typically following a multistep process for each area:

  • Infrastructure: Plan, design, implement, validate, operate (patch, upgrade, tune), improve.
  • Database: Plan, design, provision, operate (patch, upgrade, tune, back up, restore, refresh, clone), improve, decommission.

The above is the main reason why me and a few colleagues has created the asset Database Workloads On Nutanix which includes the following sections:

  • Nutanix Architectural Overview
  • Database Solutions
    • Databases on Nutanix – Logical overview presented below.
    • Database as a Service for DBAs – Logical overview presented below.
    • Database as a Service for End Users – Logical overview presented below.
  • Availability and Resilience – Failure scenarios and resilience solutions including:
    • Physical server failure
    • VM failures
    • Storage failures
    • Site failure: Remote backup
    • Administrative failure (intentional and unintentional logical errors including data deletion, storage container deletion, malware, sabotage)
    • Database failure
  • Scalability – What to think about and known limitations around:
    • Nutanix Cluster Scalability

    • Era Management Plane Scalability

    • Database Workload Scalability

  • Performance – Benchmark results including configuration, HW and SW setup.
  • Solution Packs and Bill of Material – Building block (Nutanix node including specification) guidance.
  • Recommendations and Requirements – Including the following sections:
    • Virtual Hardware Requirements for Era Management Plane VMs
    • Minimum and Recommended Hardware for Databases on Nutanix
    • Recommended Nutanix Cluster Configuration
    • Era Limitations and Requirements

    • Licenses

In addition to the above there is also a DBaaS for End Users Design Example including:

  • Requirements
  • Conditions and Contraints
  • Design Decisions
  • Logical solution according to the below figure

Click the link to get your copy of the Database Workloads on Nutanix asset.