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
Backup Strategies
Backup strategies center on your business requirements for protecting your data. Database backup strategies
vary according to business requirements and the database environment, such as production, development, or
QA.
For example, for a production database with a high transaction volume and business rules that require the
highest possible database resiliency, you might define the following backups:
n
Take full external backups twice a day.
n
Take database snapshots every hour.
n
Enable point-in-time recovery to keep a continuous log of all transactions as they occur on the running
database.
n
Retain your full backups for a month or more.
If your business rules state that you must preserve every transaction, you can specify that the database must
shut down if the point-in-time recovery's write-ahead log runs out of space. For a development database where
data loss is not a concern, you might take full external backups every week with daily snapshot backups and
point-in-time recovery disabled.
You can initiate backups manually (one-time backups) or automatically (recurring backups). Backup methods
are snapshots and external (full database backup). You can enable point-in-time recovery. Depending on your
business rules, you can set up automated backups and use a combination of backup methods to safeguard
data.
You set up automated backups by attaching a database backup template to your database. Backup templates
contain backup and recovery settings. You can select a database backup template during database creation or
attach a template at a later time. You can also attach a different backup template at any time. If you have
sufficient privileges, you can modify the template settings or create custom backup templates. The backup
process picks up the latest settings the next time it runs. The modified settings do not affect backups that are
in progress.
Using database backup templates ensures that you can take consistent database backups, meet recovery goals,
and enforce your business rules. Data Director provides preconfigured database backup templates that provide
a range of backup and recovery settings. If you are not sure how much storage your backups will require, start
with the most conservative settings. You cannot decrease the backup storage allocation, but you can increase
it. Monitor the database activity and the backup size until you have a good idea of the workload and backup
space needed, and then adjust the storage amount.
Backup Types
You manage backups and recover data using Data Director snapshot backups, external backups, and point-
in-time recovery.
n
External Backups on page 151
External backups are full copies of the database saved to a datastore separate from the database. This
section describes the pros and cons of using external backups.
n
Snapshot Backups on page 151
Snapshot backups capture the changes to the database after the snapshot is taken. Snapshots initially use
less storage than external backup files and take just a few minutes regardless of database size.
n
Point-In-Time Recovery on page 151
If point-in-time recovery (PITR) is enabled, a write-ahead log (WAL) continuously records every change
made to the database while the database is running. In the event of a failure, you can replay the WAL to
restore the database to its state at a point in time within the retention period of the database backups.
VMware vFabric Data Director Administrator and User Guide
150 VMware, Inc.