Production Database Environment Setup

This chapter describes the necessary steps to configure the production database environment. The production database environment consists of a two-node DBMS cluster running a single, shared database instance. The underlying operating systems are deployed on bare-metal hosts. The design is not DBMS-specific or operating-system-specific and can be deployed using any combination of supported configurations. The goal of this Ready Stack solution is to demonstrate a mixed workload environment, from an operating system perspective (physical and virtual deployments), a DMBS workload perspective (OLTP and OLAP), and a storage perspective (production database instances combined with snapshot-based database instances). This highly mixed environment demonstrates the consolidation capabilities of the platform.

Deployment of the two-node production database in a physical environment consists of the following tasks:

1. Configure XtremIO storage:
   1. Create Initiator Groups.
   2. Create storage volumes.
   3. Map the storage volumes to database servers.

2. Set up the database servers:
   1. Prepare PowerEdge servers.
   2. Configure operating system, network, and storage volumes.
   3. Install the DBMS application, and create the database.