2.7
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
- Storage Resources and Data Director
- 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
- User Management Overview
- Authenticating Users
- Role-Based Access Control
- Predefined Roles
- Privileges
- Propagation of Permissions and Roles
- Organization Privileges and Permissions
- Add Users to Your Organization
- Add Roles to an Organization
- Grant a Permission to a User
- Modify Organization Security Settings
- About vCenter Single Sign-On
- Register vFabric Data Director with the vCenter Single Sign-On Service
- Import vCenter Single Sign-On Service Users
- Remove vCenter Single Sign-On Registration Before Uninstalling vFabric Data Director
- Building DBVMs and Base DB Templates
- Database Virtual Machine OVA Files
- Deploy a DBVM OVA File
- Disk Configuration for DBVMs and DB Templates
- Build an Oracle, SQL Server, or Empty Base DBVM
- Build a MySQL Base DBVM
- Build an Oracle and SUSE Linux Base DBVM
- Build an Oracle DBVM with a Custom Linux Operating System
- Requirements for the Kickstart File
- Build a Base DBVM with a Custom Operating System
- Create and Validate a Base DB Template
- 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
- Create a Database Snapshot
- Recover a Database from Backup
- Import Backups
- Recover a Database from Last State
- 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
- High Availability and Replication
- 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
- vCenter Server Stops Responding
- Disk Usage Exceeds Acceptable Levels
- Resource Bundles Become Unusable Because DRS Is Disabled
- Missing Resource Pool
- Troubleshooting for SSL Communication
- Database Cannot Be Connected Using the JDBC Connection String
- Unable to Import or Login Users of the Single Sign-On Service
- Index
Ingest external
databases into Data
Director
Ingest a backup of an external database into Data Director. You can ingest a
one time clone, or you can refresh an existing database from an external
database. Ingested databases are accessible only from the organization
database catalog and can be refreshed only by an additional backup from the
source database. You cannot use ingested databases directly in Data Director.
Perform common
operations and schedule
tasks in batches
Perform common tasks and schedule database operations to run on multiple
databases in a database group, for example, run restart, stop, repair, enable,
and add whitelists tasks, and schedule upgrade and backup operations on
multiple databases.
Every database requires an administrator account that can perform all schema management operations. This
account is specific to the database and cannot log in to Data Director. You can add database owner accounts
after database creation. Data Director database users must log in with their database-specific credentials to
view the database, its entities, and its data or to perform database management tasks.
Database administrators and application developers can manage databases only if they have appropriate
permissions and roles granted to them by the organization administrator. The administrator must grant
permissions and roles on the database group or on the database. These permissions and roles apply only within
the organization in which they are granted.
Requirements for Creating Databases
You must have certain permissions to create databases, and you must calculate the storage needed for database
and related data.
Permissions Required for Creating Databases
To create databases, you need Create Databases permission on the database group that will contain the
database, Use Templates permission on at least one database template, and permission to at least one resource
template and one backup template.
It is useful to have the following permissions on the database group and on the database.
n
Create snapshots.
n
Create external backups.
n
Delete snapshots, including editing their retention time.
n
Clone the database.
n
Recover the database from a backup or snapshot.
n
Manage IP Whitelists
The organization administrator can create a role with these permissions and assign organization users to the
role.
Calculating Database Storage Allocation
During the database creation process, you specify database storage allocation, point-in-time recovery storage
allocation, and the database group for the database. The database group provides the CPU, memory, storage,
and network resources required to run the database. The storage and point-in-time recovery allocations specify
how much of the database group's resources to use for this database. See “Storage Reservation,” on page 89.
When you calculate the amount of storage to allocate to the database, proceed as follows.
n
Estimate how much data will be stored in the database.
n
Consider the number of users and average expected number of transactions in a particular time period
and allow for the number to increase.
Chapter 9 Managing Databases
VMware, Inc. 101