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
resource bundles to organizations. Organization administrators must enable
at least one base database template in their organization resource bundle(s) to
allow organization users to create databases. See Chapter 4, “Building DBVMs
and Base DB Templates,” on page 45.
Create databases
Create and allocate resources to a new database using base database templates,
database resource templates, and parameter groups. Database resource
templates specify resource limits. Parameter groups specify sets of database
parameters, such as maximum connections allowed, encoding, and checkpoint
timeout. Application developers can perform do-it-yourself database creation
using the predefined base database templates, resource templates, and
parameter groups. See “Requirements for Creating Databases,” on page 101.
Administrators can grant permissions to their users to create databases from
resource templates, but not allow users to modify the resource templates or
change the default resource allocations. This restriction provides resource limit
enforcement and allows administrators to retain control of resource and
security policies. See Chapter 8, “Managing Database Templates,” on page 91.
Manage schema
Manage vFabric Postgres database schemas and add data. You can create
tables, designate primary and foreign keys and indexes, and create views,
sequences, triggers, and other database entities.
NOTE Data Director supports managing schemas for vFabric Postgres
databases only.
Backup and restore
Safeguard your data by taking regular backups and testing your backups. See
Chapter 12, “Safeguarding Data,” on page 149.
Update database
Choose the database version to update within Data Director to meet IT policies
or application requirements.
Clone
Ensure access to consistent, yet isolated databases by cloning the database for
specific purposes such as development or quality assurance. See Chapter 10,
“Cloning Databases,” on page 127.
Scale up
Dynamically increase the database size as required during the development,
test, and production phases.
Monitor performance
and usage
Use the Data Director user interface to monitor resource usages, recent alarms,
tasks and events. See Chapter 14, “Monitoring the Data Director
Environment,” on page 167.
Stop and restart the
database
Stop and restart, for example, to perform maintenance tasks.
Decommission the
database
Disable and then delete databases. Free up the resources when they are no
longer needed.
Add databases to the
organization catalog
Add any Data Director database to the organization catalog. Organization
users can create databases using the catalog databases when they need a
database with known characteristics and preloaded data, for example, for
testing SQL scripts or usage scenarios.
VMware vFabric Data Director Administrator and User Guide
100 VMware, Inc.