Data Director includes database templates to help administrators streamline resource allocation and standardize database setup and backup setup. Templates help database administrators to quickly provision a database and to select a backup process.

Data Director supports database configuration templates and backup templates. Included with Data Director are several optimized templates. When you create an organization, Data Director copies the system-defined templates to the new organization. Organization administrators can modify the organization-specific template instances or configure new templates.

You can create database templates and publish them immediately or publish them later. When a template is not published, it can be viewed or managed, but cannot be used for provisioning or other purposes.

Database configuration templates define the computing and storage resources for creating a database, the database settings, and the high availability settings. Each template defines resource settings and database settings.

Resource Settings

When you create a template, you can specify the number of virtual CPUs, memory size, and recommended database storage allocation. You can enable high availability for the template and all corresponding databases. You can also choose the CPU and memory priority, which affects the allocation of resources for all databases in the database group. The levels (high, medium, and low) give certain databases higher priority than other databases in the same database group. The CPU reservation and Memory reservation fields let you explicitly reserve resources for each database you create from the template.

If you make changes to a template, databases that are already created from the template are not affected.

Database Settings

Specify connection, memory, IO, WAL, checkpoint, logging, and other information. When you create a template, the wizard includes defaults for each value. The wizard also includes a database settings calculator. The calculator prompts for usage information and changes the default based on that information and the resource settings you specified on the first wizard pane.

You can create different templates for different situations. For example, you can define a configuration template for engineering with a small memory size and have high availability disabled. The configuration template for QA can be defined with a larger memory size and with high availability enabled.

Backup templates define backup settings for databases. You can associate a backup template with a database when you create the database, or you can associate a backup template with a database at a later time. See Select a Database Backup Template.

You can use one of the predefined backup templates for consistency across your organization. See Backup Template Settings.

You can also clone and customize an existing template and associate the custom template with your database. You can customize frequency, start time, and retention for snapshots and for external backup. You can also enable and customize point-in-time recovery, and you can specify a backup label. See Create a Backup Template.