VMware vFabric Data Director Administrator and User Guide vFabric Data Director 1.0 This document supports the version of each product listed and supports all subsequent versions until the document is replaced by a new edition. To check for more recent editions of this document, see http://www.vmware.com/support/pubs.
VMware vFabric Data Director Administrator and User Guide You can find the most up-to-date technical documentation on the VMware Web site at: http://www.vmware.com/support/ The VMware Web site also provides the latest product updates. If you have comments about this documentation, submit your feedback to: docfeedback@vmware.com Copyright © 2012 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws.
Contents About VMware vFabric Data Director 7 Updated Information 9 1 VMware vFabric Data Director and vFabric Postgres Overview 11 VMware vFabric Data Director System Architecture VMware vFabric Data Director Components 11 Data Director User Management Modes 12 About Data Director Administration 13 vFabric Postgres Databases 14 11 2 Managing Data Director Resources 15 Resource Management Overview 15 Resource Bundles and Resource Pools 16 Resource Assignment 17 vSphere Resource Pools and Data Director
VMware vFabric Data Director Administrator and User Guide Create an Organization 38 5 Managing Database Groups 41 Database Group Management Overview 41 Managing Resources for Database Groups 42 Database Groups and Security 43 Create a Database Group 43 6 Managing Database Templates 45 Introduction to Database Templates 45 Create a Database Configuration Template 46 Modify a Database Configuration Template 47 Create a Backup Template 48 Modify a Backup Template 49 7 Managing Databases 51 Database Lif
Contents Working with Alarms 100 12 Managing Licenses 103 License Management Overview 103 Counting Data Director Licenses 104 About Evaluation Licenses 105 Add License Keys 105 View License Information 106 Change the Database Usage Type 106 Remove License Keys 107 13 Reconfiguring Data Director Networks 109 Change the vCenter IP Address 109 Reconfigure the Web Console Network Mapping or Network Adapter 110 Reconfigure the vCenter Network Mapping 111 Reconfigure the vCenter Network Adapter Settings 111
VMware vFabric Data Director Administrator and User Guide 6 VMware, Inc.
About VMware vFabric Data Director The VMware vFabric Data Director Administrator and User Guide provides information about administering ® VMware vFabric Data Director. Administration tasks include creating organizations and database groups, managing users and roles, resource allocation, database and backup configuration, cloning databases, safeguarding data, and monitoring your system.
VMware vFabric Data Director Administrator and User Guide 8 VMware, Inc.
Updated Information This vFabric Data Director Administrator and User Guide is updated with each release of the product or when necessary. This table provides the update history of the vFabric Data Director Administrator and User Guide. Revision Description EN-000709-01 n n n n EN-000709-00 VMware, Inc. The topic Chapter 1, “VMware vFabric Data Director and vFabric Postgres Overview,” on page 11 clarifies information about user management modes.
VMware vFabric Data Director Administrator and User Guide 10 VMware, Inc.
VMware vFabric Data Director and vFabric Postgres Overview 1 The VMware vFabric Data Director and vFabric Postgres software solutions enable you to provide on-site selfservice database provisioning and automation to database administrators and application developers.
VMware vFabric Data Director Administrator and User Guide n Organizations n Database groups n Databases (vPostgres databases) System administrators perform management tasks at the system level, which is the top level of the hierarchy. To edit system-level settings you must have system privileges, but having system privileges does not allow you to make changes to the other levels. A system can contain multiple organizations. An organization can contain multiple database groups.
Chapter 1 VMware vFabric Data Director and vFabric Postgres Overview n All Data Director users are visible to all organizations within Data Director. n Organization administrators contact users to invite them to the organization or grant access directly from the system user list. You configure the Data Director user management modes during installation. User management mode cannot be changed.
VMware vFabric Data Director Administrator and User Guide By default, Data Director system administrators do not have access to organizations. Organization administrators have access only to their own organization, can create organization users, and can grant access to existing Data Director users. Data Director system administrators can create users, but only organization administrators can grant those users access to organizations.
Managing Data Director Resources 2 System administrators manage CPU, memory, storage, and networking resources for different organizations. Organization administrators manage resources for database groups and for databases.
VMware vFabric Data Director Administrator and User Guide System administrators can assign resources when they create an organization (see “Create an Organization,” on page 38) or assign resources to an existing organization (see “Assign a Resource Bundle to an Organization,” on page 22). Organization administrators can assign resources when they create a database group or assign resources to existing database groups.
Chapter 2 Managing Data Director Resources Figure 2-1. Resources in vSphere and Data Director vSphere Data Director resource bundle source RPs CPU & memory database storage backup storage network resource bundle source datastores CPU & memory database storage backup storage network source port groups “Resource Assignment,” on page 17 explains how resource assignment differs for the different levels of the hierarchy.
VMware vFabric Data Director Administrator and User Guide Resource Assignment for Databases A database consumes the resources assigned to its database group. n You can specify the number of virtual CPUs, the memory size, and CPU and memory priority for each database that you create. n You cannot specify storage allocation. All databases consume the data and the backup storage allocated to their parent database group. n Each database uses the network assigned to the database group.
Chapter 2 Managing Data Director Resources See “Create a Resource Pool,” on page 20 and “Create a Resource Bundle,” on page 21. Allocating CPU and Memory Resources to Database Groups When you create a database group and set its CPU and memory allocation, Data Director creates a child resource pool of the resource pool you select. Data Director configures the resource pool with the allocation you specify.
VMware vFabric Data Director Administrator and User Guide Monitor Resource Usage System administrators can view usage information for resource bundles and datastores and can reassign resource bundles from the Manage & Monitor tab. The focus of this task is on monitoring, not on changing current settings. Prerequisites n Log in to Data Director as a user with system administrator privileges. n Verify that one or more organizations exist in your environment.
Chapter 2 Managing Data Director Resources 3 Specify the settings in the following table for the resource pool. Option Description Name Name of the resource pool. CPU Shares Do not specify CPU shares. Instead, specify the CPU reservation. CPU Reservation CPU resources to allocate to this resource pool. Expandable Reservation Checked or unchecked. CPU Limit Maximum CPU resources available to this resource pool. Set Limit to be equal to CPU Reservation. Unlimited Unchecked.
VMware vFabric Data Director Administrator and User Guide 2 Select System, and click Manage & Monitor. 3 Click Resource Bundles in the left pane. 4 Click the plus (+) icon. 5 Specify the following information about the resource bundle in the wizard. Wizard screen Action Name and Description Type a name and optional description and click Next. CPU and Memory Select the resource pool from which you want to assign CPU and memory resources and click Next.
Chapter 2 Managing Data Director Resources Not all changes that you can make to a vSphere cluster are compatible with Data Director. You must make sure that the cluster settings remain compatible with Data Director. Data Director checks the following settings. n DRS must be enabled. DRS automation level can be any of the supported options. Partially automated works best with Data Director in most situations. n Admission control must be enabled.
VMware vFabric Data Director Administrator and User Guide 24 VMware, Inc.
Managing Users and Roles 3 User management controls the users that can log in to Data Director and what they can see and do after they log in.
VMware vFabric Data Director Administrator and User Guide Roles apply only to the organization in which they are created. For example, an organization administrator creates a database administrator role that includes permission to add and remove database users, start and stop databases, and perform backups for a specific database in that organization. Users that are granted the database administrator role in that organization can perform database administrator tasks only within that organization.
Chapter 3 Managing Users and Roles Data Director encrypts the password and stores it with the user information. When the user logs in, that user's credentials are stored in an HTTP session. Data Director uses the credentials to validate that the user is authorized to view organization objects (database groups and databases) and to perform tasks.
VMware vFabric Data Director Administrator and User Guide Predefined Roles Data Director provides the predefined roles of system administrator, user administrator, and organization administrator. Predefined roles provide a starting point for administering Data Director users and roles and for defining custom roles. You can also create custom roles. Organization administrator role Organization adminstrators manage their organizations.
Chapter 3 Managing Users and Roles Privileges Privileges define the allowable actions on objects in vFabric Data Director. You associate privileges with a user login and a Data Director object to define permissions. For example, the Start and Stop Database privilege indicates that in general, Data Director users can start and stop databases. But the privilege by itself does not indicate which users can start and stop databases, or the databases that they can start and stop.
VMware vFabric Data Director Administrator and User Guide Propagation of Permissions and Roles How permissions and roles propagate through an organization depends on where and on what types of objects they are granted. Understanding how permissions and roles propagate can help you to assign them to users appropriately. Permission and role propagation stops at the organization boundary. Permissions granted within an organization propagate only within that organization.
Chapter 3 Managing Users and Roles Add Users to Your Organization Users can self-register to login to Data Director, but cannot access Data Director organizations, database groups, or databases until organization administrators grant access to them. You must add the users to your organization to grant them access. Prerequisites n Verify that you have Manage Registration permission for the organization. n Verify that the system setting Allow Public Registration is on.
VMware vFabric Data Director Administrator and User Guide 6 7 Right-click Status. n Select Enable to activate the role. n Select Disable to deactivate the role. In the Permissions section, select the permissions to grant to this role. You can grant permissions to the role on the organization, database groups within the organization, databases within the organization's database groups, and on organization templates. 8 Click OK. The new role appears in the Roles list.
Chapter 3 Managing Users and Roles Procedure 1 Click the Administration tab. 2 Click Settings, then click Security. 3 Choose one of the following Allow public registration settings. 4 5 VMware, Inc. Setting Description No User registration is by invitation only. Yes Users can see the organization and register themselves. Choose one of the following Allow System Administrator to log into Org settings.
VMware vFabric Data Director Administrator and User Guide 34 VMware, Inc.
Managing Organizations 4 The basic component of Data Director is the organization. Data Director system administrators create organizations, assign the initial organization administrator, and allocate resources to the organization.
VMware vFabric Data Director Administrator and User Guide Figure 4-1. Data Director Organization Structure system organization database group organization database group database database Organization names must be unique within Data Director. Organizations cannot be nested. Organization roles, policies, and templates apply only within that organization.
Chapter 4 Managing Organizations n Implement organization security and backup policies n Define roles n Define database configuration and database backup templates n Monitor organization performance, resource usage, and alarms Managing Resources For Organizations Organizations get their resources from vSphere resource pools and from networking and storage resources. These resources are allocated to the organization by Data Director system administrators.
VMware vFabric Data Director Administrator and User Guide Managing Organization Users Organization administrators control user access, roles, permissions, and privileges within their organizations. Organization administrators control which users can access their organizations and what those users can do. Only organization administrators can grant access to their organizations and assign roles to users within their organizations.
Chapter 4 Managing Organizations 3 Click the plus (+) icon to create an organization and specify the organization information in the wizard. Wizard screen Action Name and Description Specify a name and optional description and click Next. Organization Administrator To create a new organization administrator user, perform the following tasks. a Click Create a new user. b Specify the user name, password, first and last name, and optionally, phone number. c Click Next.
VMware vFabric Data Director Administrator and User Guide 40 VMware, Inc.
Managing Database Groups 5 Database groups contain sets of databases within organizations. Database groups allow organization administrators to provide the resources for operating and provisioning databases and to apply access and authorization rules (security policies) to those databases. Grouping databases enables subdivision of resources from the organization's allocated resources.
VMware vFabric Data Director Administrator and User Guide Figure 5-1. Database Groups in the Data Director Architecture Cloud resource bundle org database resource bundle resource bundle org database group database resource bundle org database group templates database backup database database Managing Resources for Database Groups Database groups require CPU, memory, storage, and networking resources to enable database operation, provisioning, and backup.
Chapter 5 Managing Database Groups Database Groups and Security Role-based access control and direct user permissions form the security policies that determine which users can access particular database groups and the actions that the users can perform. Database groups inherit security policies from their organizations. Organization administrators define the security policies for their organization, including user roles, permissions, and privileges.
VMware vFabric Data Director Administrator and User Guide What to do next Click the database group name to open the database group and view and edit its properties. 44 VMware, Inc.
Managing Database Templates 6 Data Director database templates allow organization administrators to standardize databases and their backup policies. Templates also impose limits on resource consumption. Database administrators can create and back up databases consistently by using templates and can create, clone, and customize templates.
VMware vFabric Data Director Administrator and User Guide If you make changes to a template, databases that are already created from the template are not affected. Database Settings Specify connection, memory, IO, WAL, checkpoint, logging, and other information. When you create a template, the wizard includes defaults for each value. The wizard also includes a database settings calculator.
Chapter 6 Managing Database Templates 6 7 Enter resource settings for the template and click Next. Option Description vCPUs Number of virtual CPUs the database virtual machine will use. High availability Select Enable to protect the database with vSphere High Availability. See the vSphere Availability documentation. Memory size Amount of memory the database virtual machine will use. Recommended database storage allocation Recommended storage allocation for this database.
VMware vFabric Data Director Administrator and User Guide You can create databases with the new settings from the modified template. Databases you previously created from the template do not change. Create a Backup Template Backup templates include frequently used backup settings. You can use one of the existing templates, clone and customize a template, or create a template. You can then associate the backup template with a database that you create.
Chapter 6 Managing Database Templates 7 Specify the general backup settings. Option Action Point in time recovery Enable or disable point-in-time recovery. Point-in-time recovery ensures that each database transaction is recorded and enables you to revert the database to any point in time within a certain time range. The start time for point-in-time recovery is right after point-in-time recovery is enabled, when the system creates a baseline backup or snapshot. You cannot remove the baseline backup.
VMware vFabric Data Director Administrator and User Guide Action Description Edit Permissions Allows you to change the permissions for an existing user, to remove an existing user, and to add a role. Properties Allows you to modify the settings you specified when you created the template. You can create databases with the new settings from the modified template. Databases you previously created from the template do not change. 50 VMware, Inc.
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.
VMware vFabric Data Director Administrator and User Guide Monitor performance and usage Use the Data Director user interface to monitor tasks and events. See Chapter 11, “Monitoring the Data Director Environment,” on page 89. 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.
Chapter 7 Managing Databases Database storage allocation is for the database data only. It does not include overhead for the operating system, database software, swap space, or snapshots. You must have enough resources available to cover both 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 complete if you do not have enough resources for the overhead.
VMware vFabric Data Director Administrator and User Guide 5 Text Box Action Point-in-Time Recovery allocation Select the number of gigabytes to allocate for point-in-time recovery operations. The minimum is 1GB. Encoding Select the encoding for the database from the drop-down menu. The default is UTF8. Tags (Optional) Select one or more tags for this database.
Chapter 7 Managing Databases Associate a Tag with an Existing Database Tags support searches for databases. You can associate a tag with a database to help with searches for databases. Procedure 1 Log in to Data Director as an organization administrator or as a user with Edit Database Info permission. 2 Click the Manage & Monitor tab. 3 Click the Databases tab. 4 Right-click a database to display the Actions menu and select Properties.
VMware vFabric Data Director Administrator and User Guide 56 VMware, Inc.
Cloning Databases 8 In Data Director, cloning a database is easy to configure and to perform. You have a choice of cloning operations that include full database clone, linked database clone, and schema only clone. You can customize the clone's database settings and backup settings during clone creation.
VMware vFabric Data Director Administrator and User Guide Figure 8-1. Full Database Clone production full database clone staging Linked Clones Linked clones are two or more databases that share storage. The linked clone technology supports efficient sharing of duplicate data. Linked clones use delta disk backings. A delta disk backing is a virtual disk file that is located on top of a standard virtual disk backing file.
Chapter 8 Cloning Databases Figure 8-3. Using a Full Clone as a Staging Clone full database clone production staging dev QA linked database clones perf Cloning Customizations You can customize a clone when you create it. You can specify new database configuration settings and backup settings for the clone, choose the clone point, set an immediate backup, and set an expiration date for the clone. When you clone an existing database, you can customize the clone to suit your needs.
VMware vFabric Data Director Administrator and User Guide 2 Configure the Database Settings of the Clone on page 61 When you clone a database, you can customize database attributes for the clone as part of clone creation. 3 Configure the Clone Point Settings on page 61 Data Director allows you to clone the current state of the database, clone a specific point in time, or clone a backup of the database.
Chapter 8 Cloning Databases What to do next Specify the database settings information, or click Back to return to the Clone Type panel for modifications. Configure the Database Settings of the Clone When you clone a database, you can customize database attributes for the clone as part of clone creation. Prerequisites Complete the Clone Type panel of the Clone Database wizard described in “Configure the Clone Type,” on page 60.
VMware vFabric Data Director Administrator and User Guide Table 8-1. Clone Point Options Clone Type Now Specific Point In Time (Snapshot) From Backup Full Yes Yes Yes Linked Yes Yes No Schema only Yes No No If you create a schema only clone, the database must be powered on. If you clone from a backup, see Chapter 10, “Safeguarding Data,” on page 77. Prerequisites Complete the Clone Type and Database Settings panels of the Clone Database wizard.
Chapter 8 Cloning Databases What to do next Monitor the creation progress in the task bar on the right, or check the database list for the database group to verify that the clone is created. VMware, Inc.
VMware vFabric Data Director Administrator and User Guide 64 VMware, Inc.
Managing Database Entities 9 Managing vFabric Postgres database entities includes managing schemas and tables, administering the database, and performing SQL management tasks. To manage databases, you need database management and database operations permissions on the database. Your organization administrator can create a role that grants the necessary permissions, and grant that role to you.
VMware vFabric Data Director Administrator and User Guide n SQL Management Backing up databases. SQL management tasks include SQL profiling, query plan analysis, running ad-hoc queries or SQL scripts. After you log in to an organization in Data Director, click the Manage & Monitor tab to view your database groups and databases. You see a list of database groups to which you have access and the list of databases within that database group.
Chapter 9 Managing Database Entities Create a Schema After you create a database, you set up its entities, starting with the database schema. You create vPostgres database schemas from the Data Director Manage & Monitor tab. Prerequisites n Verify that a database exists in which you can create schema. n Log in to Data Director as a user with database privileges. Procedure 1 Click the Manage & Monitor tab. 2 Click your database group. 3 Double-click your database to select it.
VMware vFabric Data Director Administrator and User Guide 5 6 You can now configure columns or exit the wizard. n Click Next to configure columns. n Click Finish to create the table. (Optional) In the Columns tab, click Add to add a column, and complete the column fields. a Type the column name. b Select the column type. Depending on the column type, you can specify a length or precision, and you can specify a default value for the column.
Chapter 9 Managing Database Entities 4 Enter the view properties. a Enter a unique name in the Name field. If the name is case-sensitive, select the Case sensitive check box. b (Optional) To restrict who can modify the view, use the drop-down menu to select an owner for the view definition. c Enter a SQL query to define the view.
VMware vFabric Data Director Administrator and User Guide n You expanded the schema in the left pane, then selected Tables. n The middle pane shows the Tables pane. Procedure 1 In the left navigation pane, expand the schema that contains the table for which you want to create a constraint. 2 Click Tables. The Tables page appears in the middle pane with a list of the schema's tables. 3 Click the table to select it, then click the gear icon. The Actions drop-down menu appears.
Chapter 9 Managing Database Entities Manage Database Properties DBAs and application developers with appropriate privileges manage database properties such as storage allocation, database name, and backup and configuration templates, and manage settings such as autovacuum, write-ahead log (WAL), and checkpoint frequency. Database properties and settings control how the database operates.
VMware vFabric Data Director Administrator and User Guide 6 7 To add a new database owner account, select the New owner account checkbox, and click Edit. a Type the database owner account name and password . b Type the password in the Confirm password field. c Click OK to accept the new owner account. Click OK to accept your changes. Upgrade a Database Upgrade your database to benefit from enhancements to vPostgres.
Chapter 9 Managing Database Entities 4 Click Edit. The top section of the dialog box shows the database configuration templates. Some settings have dropdown menus from which you select new values, while others allow you to enter new values in text fields. A restart icon marks the settings that require restarting the database to take effect. n To change resource settings, click the Resource Settings tab, and select the check box in the Override column.
VMware vFabric Data Director Administrator and User Guide Monitor Database Group Statistics You can view resource usage, allocation, alarms, tasks and events, get reports, view permissions, and view a statistics breakdown for databases within the database group. Monitoring database group statistics helps to ensure that your database groups run efficiently, and lets you identify and troubleshoot problems that can affect performance, such as resource availability.
Chapter 9 Managing Database Entities 2 Click the Databases tab, and click the database you want. 3 Click the appropriate tab to view database-specific statistics. n In the Backup & Recovery tab, monitor backups and perform recovery operations. n In the Alarms tab, view warnings and alarms, such as health check and application status alarms. n In the Tasks & Events tab, view tasks, events, and their status.
VMware vFabric Data Director Administrator and User Guide View a Query Plan Viewing a SQL query execution plan enables you to analyze query run time and cost to ensure that your queries run as efficiently as possible. Prerequisites n You are logged in to Data Director as a user with appropriate privileges on the database or schema. n You know how to enter and run a SQL query. See “Enter and Run a SQL Query,” on page 75.
Safeguarding Data 10 Data Director provides several options for managing backups and recovering databases. Taking regular backups of your databases is essential to safeguarding your data. Data Director tracks and stores changes for each database on a virtual disk associated with that database. Back up your database to capture the changes, preserves the database, and enables recovering the database and restoring its data after a failure.
VMware vFabric Data Director Administrator and User Guide 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.
Chapter 10 Safeguarding Data External Backups 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. External backups use about the same amount of storage as the database itself. Because they reside on a separate disk from the database, external backups provide resiliency and benefits such as the following.
VMware vFabric Data Director Administrator and User Guide When you enable PITR, Data Director creates a baseline external backup. The default retention period is forever. You can change the baseline backup's retention period from the database Properties dialog box's Backup tab. Backup Template Settings Data Director backup templates contain backup settings that use a combination of methods to safeguard data, provide consistent database backups, and enforce limits on resource consumption.
Chapter 10 Safeguarding Data Point-In-Time Recovery (PITR) Settings Enabled or disabled Enable point-in-time recovery to continuously record each change to the database in a write-ahead log (WAL) 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 n Create Snapshots n Create External Backups Procedure 1 Navigate to your database's Properties window. a In your organization, click the Manage & Monitor tab. b Select your database group, and click the down arrow to display the list of databases. c Right-click your database name and select Properties. 2 Click the Backup tab, and click Edit. 3 Click the name of the backup template to associate it with your database.
Chapter 10 Safeguarding Data 4 c (Optional) Enable or disable point-in-time recovery. d (Optional) Specify a backup label. Review your backup settings and click OK to confirm. What to do next To view a list of backups and the status of each backup, open the database by double-clicking the database name in the Manage & Monitor tab. Click the Backup & Recovery tab in the middle pane. The list of database backups appears in the Backup List section.
VMware vFabric Data Director Administrator and User Guide Import Backups If the retention period of a backup set has expired, the backup set is no longer in the Data Director backup storage archive. Data Director has no record of such a backup set and does not recognize it. To use an expired backup set, you must import it into Data Director and associate it with a database. For example, suppose that you archive backup sets to tape just before they expire as part of your disaster recovery policies.
Chapter 10 Safeguarding Data 3 Restore a VMware Data Recovery Backup on page 86 Before you can import a VMware Data Recovery (VDR) backup, you must restore the backup in vSphere Client. 4 Import VMware Data Recovery Backups on page 86 After you restore a VMware Data Recovery backup, you can import that backup into Data Director. Install and Connect to the VMware Data Recovery (VDR) Appliance The VDR appliance is an optional appliance that may not be installed in your vSphere system.
VMware vFabric Data Director Administrator and User Guide Restore a VMware Data Recovery Backup Before you can import a VMware Data Recovery (VDR) backup, you must restore the backup in vSphere Client. Prerequisites Log in to the vSphere Client with administrator privileges and connect to the vCenter Server system where you installed VDR. Procedure 1 In vSphere Client, connect to VDR and click the VDR Restore tab. 2 Click the Restore link. 3 Select the database backup to restore.
Chapter 10 Safeguarding Data Database End of Life and Backups When you decommission and delete a database, you decide whether to retain its backup files. The decision is based on your site's policies and whether you might need the database in the future. When you delete a database, you can retain all external backups. The backups expire at the end of the normal retention period.
VMware vFabric Data Director Administrator and User Guide 88 VMware, Inc.
Monitoring the Data Director Environment 11 System administrators can examine current resource usage, monitor events and alarms, view and download reports about their environment, and create diagnostic packages for individual databases and for the system itself. Organization administrators can examine how different database groups and databases use resources, and can view and monitor events and alarms for their organization.
VMware vFabric Data Director Administrator and User Guide 3 Explore the Filter text box in the right corner. a Type a search term to search the current items. For example, search all tasks for the term Delete. The search includes the currently displayed items and the list of available items. b To filter which columns are searched, click the down-triangle, deselect checked boxes for columns you do not want to search, and click OK. When you perform the next search, only the selected columns are searched.
Chapter 11 Monitoring the Data Director Environment dashboard includes information about the top five consumers of resources. Administrators can customize the Dashboard to change the sampling and to add or remove the information displayed. See “Explore System Dashboard Customizations,” on page 91. Manage & Monitor Tab In the Manage & Monitor tab, system administrators can view alarms and define new alarms, view tasks and events, and configure, display, and download reports.
VMware vFabric Data Director Administrator and User Guide 7 Change the sampling by choosing from the Sampling drop-down menu. Option Description Average Average value for the sampling period. Minimum Minimum value for the sampling period. Maximum Maximum value for the sampling period. What to do next Customize the dashboard to meet your needs. Explore Monitoring Customizations for System Administrators Explore monitoring customizations to learn about available options.
Chapter 11 Monitoring the Data Director Environment 4 Click Tasks & Events in the panel on the left, and click either Tasks or Events. Option Description Tasks Tasks are scheduled system activities requested by the system or a user, for example, Create database and Repair database. A task can succeed or fail. The Tasks tab includes information about the target and the user who initiated the task. Information such as related events appear in the Details panel below the Tasks table.
VMware vFabric Data Director Administrator and User Guide Create, Download, and Delete Diagnostics Packages Diagnostic packages are sometimes requested by VMware Support to help resolve a problem. System administrators can create diagnostics packages, download them for analysis, and delete them to save storage space. Prerequisites Log in to Data Director with system administrator privileges. Procedure 1 Click the Administration tab and click Diagnostics. By default, the diagnostics page is empty.
Chapter 11 Monitoring the Data Director Environment Data Director also generates an alarm if a vSphere administrator makes the following changes to the cluster. n Admission control for the cluster is disabled. n The cluster's default VM monitoring settings are changed to be too low. n Heartbeat failure time less than 30 seconds. n Minimum uptime less than 120 seconds. n Maximum number of resets less than 3. n Time window for maximum number of resets less than 3600 seconds (1 hour).
VMware vFabric Data Director Administrator and User Guide Table 11-1. Manage and Monitor Tab (Continued) Tab Description Tasks and Events tab Allows organization administrators to display information about all tasks and information about all events. You can display events of only a certain type, and you can filter tasks and events to drill down to information you really need. See “Explore Monitoring Customizations for Organization Administrators,” on page 97.
Chapter 11 Monitoring the Data Director Environment 3 Explore one of the panels that includes lines or histogram bars, for example the %CPU Utilization panel or the Database Storage Breakdown panel. a Customize the view to show information for 1 hour, 24 hours, 3 days, or 1 week. b Move the cursor over a histogram bar or a line to view information, and click the item for details. What to do next Customize the dashboard to meet your needs.
VMware vFabric Data Director Administrator and User Guide 5 6 Panel Description Database Storage Breakdown, Backup Storage Breakdown Pie charts that show the current state of storage and backup storage, including storage that is allocated, storage that is used, and storage that is allocated but not used. Placing the cursor inside a field of the pie chart displays information about that field.
Chapter 11 Monitoring the Data Director Environment Explore Database Monitoring The main organization dashboard allows administrators and other privileged users to monitor the organization and its database groups. Administrators can also monitor databases from the Manage & Monitor tab. Database information provided by Data Director allows administrators to check whether a database is in use, check on the backup status of the database, see errors and alarms, and check resource allocation.
VMware vFabric Data Director Administrator and User Guide Working with Alarms Data Director displays system-defined alarms to system administrators and organization administrators. Data Director also allows administrators to create custom alarms and to delete and disable alarms. Create a Custom Alarm Custom alarms allow you to display information in the Alarms panel or to send email if certain conditions are met. For each alarm, you can specify a name and description and a trigger.
Chapter 11 Monitoring the Data Director Environment Example: Custom Alarm that Monitors Resource Bundles The following example illustrates how you can create a custom alarm that monitors resource bundles. The alarm sends an email when free space is below a certain threshold. Log in as the system administrator and 1 Select the System tab. 2 Start the Create Alarm Definition wizard. a Click the Manage & Monitor tab. b Click Alarms in the left pane. c Click Definitions. d Click the plus sign.
VMware vFabric Data Director Administrator and User Guide 2 102 Disable or delete an alarm. n To delete an alarm, right-click that alarm and select Delete. n To disable an alarm, right-click that alarm and select Disable. VMware, Inc.
Managing Licenses 12 Data Director offers evaluation and permanent product licenses. System administrators have fine-grained control of licenses and license assignment using the Data Director Administration tab's License pane.
VMware vFabric Data Director Administrator and User Guide You cannot remove the last remaining permanent or evaluation license. Data Director provides vPostgres NonProduction Use licenses by default. The Non-Production Use licenses cannot be removed. Purchasing Support You can optionally purchase vFabric Developer Support for Production Use and Non-Production Use vPostgres databases. SnS licenses are required for Data Director. SnS licenses are also required for vPostgres: Production Use databases.
Chapter 12 Managing Licenses Table 12-2. Licenses Required for a Single vPostgres Virtual Machine Number of vCPUs for a Virtual Machine Number of Licenses 1-2 1 3-4 2 5-6 3 7-8 4 You can view the total number of vPostgres virtual machines and vCPUs in the Licensing pane of the Data Director Administration tab. About Evaluation Licenses Evaluation licenses offer full use of Data Director and vPostgres databases at no cost for a limited period of time (usually 90 days).
VMware vFabric Data Director Administrator and User Guide 4 Enter product license keys in the License keys text box (one per line), and click Add License Keys. 5 (Optional) Enter a label for your license keys in the Optional label for license keys text box. 6 Click OK. The licenses appear in the license key list. View License Information You can view information about your Data Director and vPostgres licenses in the Licensing pane of the Administration tab.
Chapter 12 Managing Licenses The updates appear in the Type column and the Summary pane. Remove License Keys To reallocate licenses in the Data Director environment, system administrators can remove license keys in the Licensing pane of the Administration tab. Procedure 1 Log in to Data Director as a system administrator and click the Administration tab. 2 In the left pane, expand Settings and click Licensing. 3 In the License Keys section, click the license you want to remove.
VMware vFabric Data Director Administrator and User Guide 108 VMware, Inc.
Reconfiguring Data Director Networks 13 During installation, you set up the networks that carry the different types of Data Director network traffic. You can reconfigure Data Director networks, for example, to improve throughput or provide better isolation for certain types of traffic, using vSphere Client. You can reconfigure certain network adapter settings in Data Director. Data Director has the following types of network traffic.
VMware vFabric Data Director Administrator and User Guide Procedure 1 Log in to vSphere Client as an administrator. 2 Right-click the Data Director vApp and select Power Off. 3 Select Administration > vCenter Server Settings. 4 Click Runtime Settings. 5 Update the IP address in the Managed IP Address field. 6 Remove the vCenter Extension Service and add it back. 7 a Right-click the Management Server virtual machine, select Edit Settings, and click the vServices tab.
Chapter 13 Reconfiguring Data Director Networks 6 c Change the settings for FQDN, static IP address, netmask, DNS Server 1, or DNS Server 2. d Click OK. Right-click the Management Server virtual machine and select Power > Power On. What to do next Verify the settings from the Data Director UI. See “Verify Network Settings in Data Director,” on page 113.
VMware vFabric Data Director Administrator and User Guide 4 In the Network Adapters section, edit the network adapter text boxes, and click Next. 5 Click Next again. 6 Click Finish to confirm and save the changes. The changes take effect immediately. 7 Verify the IP address change in the vSphere Client. a Log in to vSphere Client as an administrator. b Select the Management Server virtual machine. c Click the Summary tab, and examine the IP Addresses line.
Chapter 13 Reconfiguring Data Director Networks Reconfigure the Internal Network or Internal Network Adapter Mapping You can reconfigure the Internal Network or the Internal Network Adapter by editing the settings in the Data Director UI. You can change Internal Network and Internal Network Adapter settings only when all database virtual machines are powered down. Prerequisites Review the information about network settings in Data Director in the vFabric Data Director Installation Guide.
VMware vFabric Data Director Administrator and User Guide Prerequisites Procedure 114 1 Log in to Data Director as system administrator and ignore any warning that might appear. 2 Click the Administration tab, and click Network Setup. 3 Click Edit Network Setup and verify that the changes you made in vSphere Client are reflected in Data Director. 4 In the Network Settings wizard, check the network settings and reenter them if necessary. 5 Click Next and click Finish.
Data Director Troubleshooting 14 Troubleshooting information helps you when you encounter problems with your Data Director environment. See the Release Notes for discussions of known issues and for corresponding workarounds.
VMware vFabric Data Director Administrator and User Guide Resource Bundles Become Unusable Because DRS Is Disabled When a vSphere administrator disables DRS for the cluster that Data Director uses, all resource pools become unavailable. Problem If a vSphere administrators disables DRS functionality for the Data Director cluster from the vSphere Client, all resource pools become unavailable and the installation is unusable.
Chapter 14 Data Director Troubleshooting Solution 1 To display the resource pool, uncheck Show only compatible clusters and RPs. If the resource pool is displayed but is dimmed, it is incompatible. 2 In Data Director, verify that the resource pool is not in use by Data Director by checking the resource bundle list. 3 In the vSphere Client, verify that the resource pool meets the requirements. 4 n Resource pool settings are correct (limit equal to reservation, expandable checked, and so on.
VMware vFabric Data Director Administrator and User Guide 118 VMware, Inc.
Index A ACID properties 14 Add database owner account 71 adding users 31 administer SQL 75 Administration tab 90, 95 alarms custom 100 database 74 delete 101 disabling 101 Alarms side bar 89 analyze SQL query plan 76 authentication 25, 26, 38 authorization 25 auto-vacuum 67, 71 auto-vacuum settings 72 B backup settings, for clone 60 backup strategies 78 backup template, creating 48 backup template settings 80 backup template, selecting 81 backup templates, modifying 49 backups cloning 61 monitoring 74 bas
VMware vFabric Data Director Administrator and User Guide database creator permissions 52 database end of life 87 database group, assign resource bundle 22 database group privileges 29 database groups and resource management 42 creating 43 resource assignment 17 resource isolation 42 security 43 database lifecycle 51 database management 51, 65 database performance statistics, monitoring 73 database privileges 29 database properties 71 database property settings 72 database recovery 77 database resource all
Index O organization administrator, vFabric Data Director 28 organization dashboard 97 organization operations 36 organization permissions 30 organization privileges 29, 30 organization resources 37 organization security settings 32 organization user access 38 organization user authentication 38 organization-level operations 13 organization, create 38 organizations monitoring 95 resource assignment 17 P password encryption 26 permanent licenses 103 permissions, propagation of 30 PITR 78 point-in-time reco
VMware vFabric Data Director Administrator and User Guide test network setup 113 troubleshooting 115 U update database version 71 updated information 9 upgrade database 71, 72 user access 38 user authentication 38 user logins 27 user management 25 user management modes 12 user permissions 32 users, adding 31 V vacuum configuration 72 vCenter network adapter reconfiguration 111 vCenter Network mapping reconfiguration 111 vCenter Server IP address 109 vCenter Server troubleshooting 115 VDR external backups
