2.5
Table Of Contents
- VMware vFabric Data Director Administrator and User Guide
- Contents
- About VMware vFabric Data Director Administrator and User Guide
- VMware vFabric Data Director Overview
- Managing Data Director Resources
- Resource Management Overview
- Resource Bundles and Resource Pools
- System Resource Bundle
- Resource Assignment
- vSphere Resource Pools and Data Director
- Viewing Resource Information
- Create the System Resource Pool
- Create the System Resource Bundle
- Monitor Resource Usage
- Create a Resource Pool
- Create a Resource Bundle
- Assign a Resource Bundle to an Organization
- Perform Advanced Cluster Configuration
- Managing Users and Roles
- Building DBVMs and Base DB Templates
- Database Virtual Machine OVA Files
- Deploy a DBVM OVA File
- Build a SLES and Oracle Base Database Virtual Machine
- Build a Custom RHEL and Oracle Database Template
- Deploy the base database VM into the System Resource Pool
- Repackage the Linux ISO Image
- Install Linux on a Blank Virtual Machine
- Initialize the Virtual Machine to Make It Oracle and Data Director Compliant
- Install Oracle 11g R2 Software
- Convert a Base DBVM into a Base DB Template
- Validate a Base DB Template
- Assign a Base DB Template to a Resource Bundle
- Install the Operating System and Database Software in a Blank DBVM
- Requirements for the Kickstart File
- Database Update Configuration
- Configure a vFabric Postgres Update Chain
- Update an Oracle Database
- Identify Existing Target DBVM
- Create a Base Database VM from an Existing Template
- Apply a Patch to the Base Database Virtual Machine
- Convert a Base DBVM into a Base DB Template
- Validate a Base DB Template
- Assign a Base DB Template to a Resource Bundle
- Enable a Base DB Template
- Configure an Oracle Update Chain
- Update a Database
- Managing Organizations
- IP Whitelists
- Managing Database Groups
- Managing Database Templates
- Managing Databases
- Database Lifecycle
- Requirements for Creating Databases
- Database Creation
- Using Tags
- Managing the Organization Catalog
- Batch Operations and Scheduled Tasks
- Updating Databases
- Database Administration
- Cloning Databases
- Managing Database Entities
- Safeguarding Data
- Backup Strategies
- Backup Types
- Backup Template Settings
- Preconfigured Backup Templates
- Select a Database Backup Template
- Schedule Regular Database Backups
- Recover a Database
- Import Backups
- Use VMware Data Recovery to Back Up Data Director
- Database End of Life and Backups
- Perform Point-in-time Recovery of Management Server Database
- Add Pre-Action and Post-Action Scripts to the DBVM for Selected Agents
- Monitoring the Data Director Environment
- Managing Licenses
- IP Pool Management
- VMware vCloud Director Integration
- Reconfiguring Data Director Networks
- Change the vCenter IP Address
- Reconfigure the Web Console Network Mapping or Network Adapter
- Reconfigure the vCenter Network Mapping
- Reconfigure the vCenter Network Adapter Settings
- Reconfigure the DB Name Service Network or DB Name Service Network Adapter
- Reconfigure the Internal Network or Internal Network Adapter Mapping
- Verify Network Settings in Data Director
- Reconfigure the Database Access Network Used by a Database Group
- Modify IP Pool Settings
- Managing SSL Keys and Certificates
- Regenerate Management Server Key and Certificate
- Import Management Server Key and Certificate
- Edit Management Server Certificate
- Regenerate DB Name Server Key and Certificate
- Import DB Name Server Key and Certificate
- Edit DB Name Server Certificate
- Regenerate DBVM Key and Certificate
- Import DBVM Key and Certificate
- Edit DBVM Certificate
- Data Director Troubleshooting
- Index
n
If you plan to enable point-in-time recovery, calculate additional storage to accommodate the point-in-
time recovery write-ahead logs (WALs). The size of the allocation depends on the expected volume of
transactions on the database.
Every database requires a certain amount of storage overhead for the operating system, database software,
swap space, log files, snapshots, and so on. The storage for overhead is explicitly allocated and does not count
against database storage allocation. Database storage allocation is for the database schema and data only. You
must have enough resources available to cover the database allocation and to cover any overhead.
Even if the database group has enough free space for creating a database, database creation does not finish if
you do not have enough resources for the overhead. If the free space is less than the following calculation, Data
Director cannot create the database.
(storage allocation * storage reservation %) + overhead
Database Creator Permissions
After database creation finishes, the following permissions on the new database are granted to the database
creator.
Edit information and
storage
Enables the database creator to edit database properties such as the name,
description, and size of the database.
Manage IP whitelists
Enables the database creator to assign IP whitelists to this database and to create
custom IP whitelists for this database.
Modify administrator
accounts
Enables the database creator to add or modify database users for this database.
Database users are granted full permission on this database.
Start database and Stop
database
Enables the database creator to start and stop.
View properties
Enables the database creator to view the database.
Edit settings
Enables database creators to edit database parameters, database ingestion, and
refresh settings and SSL certificates.
Monitor status
Enables database creators to monitor dashboards, events, tasks, reports, and
logs. You can also define, monitor, and acknowledge alarms.
Database Creation
As a DBA or application developer, you create databases to serve your project or application requirements.
Data Director provides several methods for creating and provisioning databases.
n
“Create an Empty vFabric Postgres or Oracle Database,” on page 87. Use a resource template to create
an empty database. Use this method when developing a new application or the database characteristics
or data are not important to the current phase of your project.
n
“Create a Database from a Catalog,” on page 89. Use this method when you require a database with
known characteristics and pre-loaded data. Catalog databases are read-only and cannot be modified or
powered on by users, though the data in the catalog database can be refreshed periodically from the source
database.
n
Create a database by cloning an existing database. Use this method to create a database in a pristine state,
with pre-loaded data and configuration settings, for testing and development purposes. See Chapter 10,
“Cloning Databases,” on page 107.
VMware vFabric Data Director Administrator and User Guide
86 VMware, Inc.