Data Director enables administrators to quickly provision databases, such as Oracle and vFabric Postgres, using database templates. Administrators prepare templates that let users create databases in Data Director.

Data Director uses base database templates (base DB templates) to create databases. A base DB template is a virtual machine that contains all the required software to create a database. Required software includes the operating system (OS), database, and system software configurations. The base DB template can also contain third-party tools that are required for a particular environment.

You create a base database virtual machine (DBVM) and install the operating system and database software required to create databases.You create a base DB template from a base DBVM. A DBVM is a virtual machine with a disk layout that contains the seven virtual machine disks (VMDK) required for base DBVMs to work in Data Director.

Base DBVMs contain the virtual hardware, structure, and the required files and configuration information necessary to build base DB templates and to create and operate databases. Base DB templates provide the blueprints for creating databases in Data Director.

The DBVM workflow shows the roles for building a DBVM, preparing the base DB template, and creating databases.

DBVM Workflow
Database Virtual Machine Workflow

To prepare DBVMs for use, vSphere administrators perform the following tasks.

Download the DBVM template OVA files into a directory the vSphere Client can access.

Create a system resource pool to contain the DBVM templates. See Create the System Resource Pool.

Use vCenter to deploy each DBVM template OVA file into the system resource pool. Deploy the OVA files one at a time. See vSphere Virtual Machine Administration for information about deploying OVA files.

If required for your business environment, install the operating system and database software into a blank DBVM to customize a database template.

To prepare base DB templates for use, Data Director system administrators perform the following tasks.

Create one system resource bundle to contain base DBVM templates. See System Resource Bundle

Convert the DBVMs to base DB templates.

Assign the base DB templates to the resource bundle for an organization.

Optionally validate the base DB template to ensure it built successfully.

Organization administrators enable base DB templates in their resource bundles. After a base DB template is enabled, organization users can use the base DB template to create databases.

1

Data Director provides downloadable database virtual machine (DBVM) templates as OVA files.

2

As a vSphere administrator, you deploy the provided DBVM template OVA files to the system resource pool for Data Director.

3

You can create virtual disks on which to store your database's data and log files to improve performance. You can in turn create these virtual disks on datastores optimized for I/O performance, redundancy, or disk usage depending on the type of data you want to store on them.

4

You can create a base DBVM and install the operating system and database software required to provision databases.

5

You can create a base DBVM and DB template using Red Hat Linux with a supported version of the MySQL database.

6

Data Director provides a base DBVM with SUSE Linux Enterprise Server (SLES). You can install Oracle into the SLES DBVM to provide an environment for proof-of-concept projects or to allow non-Oracle database administrators to explore Oracle.

7

You can create a base DBVM and DB template using a customized version of Red Hat or Oracle Linux in combination with a supported version of the Oracle database. This allows you to deploy an operating system with configurations specifc to your IT environment.

8

The kickstart installation method is used primarily by Red Hat Enterprise Linux to automatically perform an operating system installation and configuration. To customize a base DB template, the kickstart file must be fully compliant with Data Director and the target database.

9

You can create a base DBVM for either Oracle or SQL Server databases using any operating system supported by Data Director with customizations specific to your IT environment. For example, if you want to install a database on a version of Linux with patches and security settings specific to your environment, you can create a base VM using this operating system, and then install the database within this to create a base DBVM using your preferred operating system configuration.

10

Data Director system administrators convert base DBVMs into base DB templates. The base DB template contains all of the software required to provision the operating environment and database for users of the system.

11

You update databases to take advantage of features in new releases or upgrades of database software. Also, to incorporate enhancements to a database virtual machine (DBVM) or to third party software tools. System administrators manage the base DB template update chain to ensure that users update databases based on templates that comply with defined update policies.

12

You configure an update chain to enable database users to update databases based on templates the comply with update policies.

13

You update an Oracle database to take advantage of features available in the latest release of the database software, or to incorporate enhancements to a database virtual machine (DBVM) or to third party software tools. Updating an Oracle database is referred to as patching.