1.0
Table Of Contents
- VMware vFabric Data Director Administrator and User Guide
- Contents
- About VMware vFabric Data Director
- Updated Information
- VMware vFabric Data Director and vFabric Postgres Overview
- Managing Data Director Resources
- Managing Users and Roles
- Managing Organizations
- Managing Database Groups
- Managing Database Templates
- Managing Databases
- Cloning Databases
- Managing Database Entities
- Safeguarding Data
- Monitoring the Data Director Environment
- Managing Licenses
- 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
- Data Director Troubleshooting
- Index
Managing Databases 7
Database administrators and application developers manage databases from creation to decommissioning and
deletion. The tasks include managing database entities and data, scheduling backups, and performing
recovery.
This chapter includes the following topics:
n
“Database Lifecycle,” on page 51
n
“Requirements for Creating Databases,” on page 52
n
“Create a Database,” on page 53
n
“Using Tags,” on page 54
Database Lifecycle
The database lifecycle includes database creation and resource allocation, managing the database schema and
data, performing backup and recovery tasks, and decommissioning databases. Database administrators and
application developers perform the database lifecycle tasks.
Create
Create and allocate resources to a new database using database configuration
templates. Database templates specify sets of database parameters, including
resource limits. Application developers can perform do-it-yourself database
creation using the templates. See “Requirements for Creating Databases,” on
page 52.
Administrators can grant permissions to their users that enable the users to
create databases from templates, but do not allow them to modify the 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 6, “Managing Database Templates,” on page 45.
Manage schema
Manage the database schema and add data. You can create tables, designate
primary and foreign keys and indexes, and create views, sequences, triggers,
and other database entities.
Backup and restore
Safeguard your data by taking regular backups and testing your backups. See
Chapter 10, “Safeguarding Data,” on page 77.
Clone
Ensure access to consistent, yet isolated databases by cloning the database for
specific purposes such as development or quality assurance. See Chapter 8,
“Cloning Databases,” on page 57.
Scale up
Dynamically increase the database size as required, during the development,
test, and production phases.
VMware, Inc. 51