2.5

ManualsBrandsVMware ManualsApplicationsvFabric Data Director

Table Of Contents

VMware vFabric Data Director Administrator and User Guide

VMware vFabric Data Director

Administrator and User Guide

vFabric Data Director 2.5

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.

EN- 001078-00

Summary of content (196 pages)

PAGE 1
VMware vFabric Data Director Administrator and User Guide vFabric Data Director 2.5 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.
PAGE 2
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.
PAGE 3
Contents About VMware vFabric Data Director Administrator and User Guide 7 1 VMware vFabric Data Director Overview 9 Data Director System Architecture 9 VMware Data Director Components 10 Data Director User Management Modes 10 About Data Director Administration 11 Data Director Supported Databases 12 2 Managing Data Director Resources 15 Resource Management Overview 15 Resource Bundles and Resource Pools 16 System Resource Bundle 17 Resource Assignment 17 vSphere Resource Pools and Data Director 18 View
PAGE 4
VMware vFabric Data Director Administrator and User Guide Build a Custom RHEL and Oracle Database Template 44 Install the Operating System and Database Software in a Blank DBVM Requirements for the Kickstart File 49 Database Update Configuration 52 Configure a vFabric Postgres Update Chain 53 Update an Oracle Database 54 49 5 Managing Organizations 61 Organization Structure 61 Operating Organizations 62 Managing Resources For Organizations 63 Managing Organization Users 64 Create a Data Director Organiz
PAGE 5
Contents Cloning Customizations 109 Clone a Database 109 Managing Post-Clone Scripts 113 Managing a Cloned Database Refresh 117 11 Managing Database Entities 121 Database Entity Management SQL Management 126 121 12 Safeguarding Data 129 Backup Strategies 130 Backup Types 130 Backup Template Settings 132 Preconfigured Backup Templates 133 Select a Database Backup Template 133 Schedule Regular Database Backups 134 Recover a Database 135 Import Backups 136 Use VMware Data Recovery to Back Up Data Director
PAGE 6
VMware vFabric Data Director Administrator and User Guide 16 VMware vCloud Director Integration 169 Enable vCloud Director Integration in Setup 170 Enable vCloud Director Integration after Setup 170 Edit or Disable vCloud Director Integration 171 Add a vCloud Director Organization Administrator 171 17 Reconfiguring Data Director Networks 173 Change the vCenter IP Address 173 Reconfigure the Web Console Network Mapping or Network Adapter 174 Reconfigure the vCenter Network Mapping 175 Reconfigure the vCe
PAGE 7
About VMware vFabric Data Director Administrator and User Guide ® The VMware vFabric Data Director Administrator and User Guide describes the features of VMware vFabric Data Director. VMware vFabric Data Director is an enterprise class database-as-a-service (DBaaS) solution on VMware vSphere that provides self-service lifecycle management for heterogeneous databases. The solution includes the following features. n Database creation, cloning, backup, and restore.
PAGE 8
VMware vFabric Data Director Administrator and User Guide 8 n Application developers use this document to learn how to create, manage and monitor databases. n Application developers, QA and production engineers, and others use this document to learn how to perform functions for which they have been granted permissions. VMware, Inc.
PAGE 9
VMware vFabric Data Director Overview 1 VMware vFabric Data Director is a software solution that powers Database-as-a-service in your cloud. It enables you to implement database-aware virtualization on vSphere and provides self-service lifecycle management for heterogeneous databases.
PAGE 10
VMware vFabric Data Director Administrator and User Guide VMware Data Director Components The Data Director hierarchy consists of organizations, each with its own discrete database groups and databases. Currently supported databases include vFabric Postgres, Microsoft SQL Server, and Oracle. System administrators perform management tasks at the system level, which is the top level of the hierarchy.
PAGE 11
Chapter 1 VMware vFabric Data Director Overview Global user management mode has the following characteristics. n Organizations are set up as separate departments, business units, or groups within one enterprise, such as a corporation's HR and Finance departments. n All Data Director users are visible to all organizations within Data Director. n Organization administrators grant access to users to the organization or grant access directly from the system user list.
PAGE 12
VMware vFabric Data Director Administrator and User Guide Table 1-2. Organization-Level Operations Operation Type Examples Resource management operations n Creating database groups. n Enabling base database templates in resource bundles. Creating resource templates. Creating backup templates. Allocating resources to database groups within the organization. n n n User management operations n n n n n Creating and managing organization users.
PAGE 13
Chapter 1 VMware vFabric Data Director Overview Oracle databases As a system administrator, you upload, test, and manage the Oracle base database templates that organization administrators, DBAs, and application developers use to create Oracle databases. The recommended practice for using Oracle with Data Director is to set up a dedicated vSphere ESXi cluster for hosting Oracle resources, including operating system, Oracle database server, and client tools.
PAGE 14
VMware vFabric Data Director Administrator and User Guide n If the DBVM does not join a domain, Data Director uses mixed authentication, and prompts for the SQL Server System Administrator (SA) password. n No user databases are created when provisioning within Data Director. Data Director Support for SQL Server Data Director supports the creation of new, empty SQL Server databases. To learn more about creating a SQL Server database, see “Create an Empty SQL Server Database,” on page 88.
PAGE 15
Managing Data Director Resources 2 System administrators manage CPU, memory, storage, and networking resources, as well as system-wide database and backup configuration templates. Organization administrators manage resources for database groups and for databases and enable database templates for their organizations.
PAGE 16
VMware vFabric Data Director Administrator and User Guide Data Director provides the following types of resource bundles. n System resource bundle. Data Director system administrators create one system resource bundle at the Data Director system level. In addition to providing virtual resources, the system resource bundle contains the database virtual machines (DBVMs) and base database templates that support creating and provisioning databases. See “System Resource Bundle,” on page 17.
PAGE 17
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.
PAGE 18
VMware vFabric Data Director Administrator and User Guide If you chose the Express installation and enabled Create defaults in the Data Director Setup wizard, a system resource bundle and Default resource bundle are created during setup. A Default organization with a Default database group within that organization is also created, and the Default resource bundle is assigned to the Default organization.
PAGE 19
Chapter 2 Managing Data Director Resources You can also enable expandable CPU and memory. See “Create the System Resource Pool,” on page 21. CAUTION Data Director can use only resource pools for creating databases if the corresponding cluster is enabled for DRS and HA. Do not disable DRS. If you do, Data Director cannot use the resource pools even if you reenable DRS. See “Resource Bundles Become Unusable Because DRS Is Disabled,” on page 188.
PAGE 20
VMware vFabric Data Director Administrator and User Guide 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 that you select. Data Director configures the resource pool with the allocation that you specify. Having a different resource pool for each database group isolates the database group's allocation and makes different groups independent.
PAGE 21
Chapter 2 Managing Data Director Resources Create the System Resource Pool vSphere administrators create one system resource pool from a vSphere Client connected to a vCenter Server system. vSphere Administrators deploy the Data Director database virtual machine (DBVM) OVAs to the system resource pool. Prerequisites n Connect to the vCenter Server system by using a vSphere Client. You cannot create resource pools if the client is connected directly to a host.
PAGE 22
VMware vFabric Data Director Administrator and User Guide Create the System Resource Bundle The system resource bundle resides at the Data Director system level, and enables you to create, test, and run base database virtual machines. Prerequisites n Create a resource pool to use for allocating CPU and memory resources. See “Create a Resource Pool,” on page 23. n Determine the storage resources that you want to include in the system resource bundle.
PAGE 23
Chapter 2 Managing Data Director Resources n Verify that one or more organizations exist in your environment. n Verify that resource bundles and datastores have been assigned to the organizations. Procedure 1 In Data Director, click the System tab, and click the Manage & Monitor tab. The Organizations panel displays resource allocation information about each organization. 2 Click one of the columns, for example Total Memory, to reorder the rows of the table.
PAGE 24
VMware vFabric Data Director Administrator and User Guide Option Description Expandable Reservation Checked or Unchecked. Memory Limit Maximum memory resources available to this resource pool. Set Limit to be equal to Memory Reservation. Unlimited Unchecked. After you create and configure the resource pool, you can point to the resource pool when you create the Data Director resource bundle. What to do next Create a resource bundle. See “Create a Resource Bundle,” on page 24.
PAGE 25
Chapter 2 Managing Data Director Resources 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. Resource Pool Select the resource pool from which you want to assign CPU and memory resources and click Next. Storage a b Click Edit to select a Datastore, and allocate the number of gigabytes to use with Data Director, or allocate all unallocated space.
PAGE 26
VMware vFabric Data Director Administrator and User Guide Perform Advanced Cluster Configuration During installation, you configure the Data Director cluster with vSphere DRS and vSphere HA enabled, and with certain monitoring settings. You can later edit the Data Director cluster configuration to change the monitoring sensitivity for virtual machines. As part of the installation process, you configure the Data Director cluster. See the vFabric Data Director Installation Guide.
PAGE 27
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.
PAGE 28
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.
PAGE 29
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.
PAGE 30
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.
PAGE 31
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.
PAGE 32
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.
PAGE 33
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.
PAGE 34
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.
PAGE 35
Chapter 3 Managing Users and Roles Procedure 1 Click the Organization Settings tab. 2 Click Settings, then click Security. 3 (By Organization user management mode only) 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.
PAGE 36
VMware vFabric Data Director Administrator and User Guide 36 VMware, Inc.
PAGE 37
Building DBVMs and Base DB Templates 4 Data Director enables administrators to quickly provision databases, such as Oracle and vFabric Postgres, using database templates. Administrators prepare templates that let users create databases in Data Director. Data Director uses base database templates (base DB templates) to create databases. A base DB template is a virtual machine that contains all the required software to create a database.
PAGE 38
VMware vFabric Data Director Administrator and User Guide Figure 4-1.
PAGE 39
Chapter 4 Building DBVMs and Base DB Templates This chapter includes the following topics: n “Database Virtual Machine OVA Files,” on page 39 n “Deploy a DBVM OVA File,” on page 39 n “Build a SLES and Oracle Base Database Virtual Machine,” on page 40 n “Build a Custom RHEL and Oracle Database Template,” on page 44 n “Install the Operating System and Database Software in a Blank DBVM,” on page 49 n “Requirements for the Kickstart File,” on page 49 n “Database Update Configuration,” on page 52
PAGE 40
VMware vFabric Data Director Administrator and User Guide n Verify that Data Director is installed. n Verify that the Data Director DBVM template OVA files are downloaded to a directory that you can access from vSphere. n Verify that the system resource pool is created in vSphere. n Verify the network mapping or determine how to map the networks configured for Data Director to the DBVM template's networks. See the vFabric Data Director Installation Guide and the vFabric Data Director Worksheets.
PAGE 41
Chapter 4 Building DBVMs and Base DB Templates 3 Convert a Base DBVM into a Base DB Template on page 42 Data Director system administrators convert base DBVMs into base DB templates to provide the blueprints for creating databases. 4 Validate a Base DB Template on page 43 As a Data Director system administrator, you can validate a base DB template to confirm that it built correctly. You can validate a base DB template at any time.
PAGE 42
VMware vFabric Data Director Administrator and User Guide 2 In the System tab, click Manage and Monitor. 3 Expand Templates and select Base DBVMs. 4 Click the plus (+) icon to start the Create Base DBVM wizard and enter the appropriate information. Option Description Name Enter a unique name for the base DBVM. Database type Select a database type, or select Empty to create a blank base DBVM. Database version Select a version.
PAGE 43
Chapter 4 Building DBVMs and Base DB Templates What to do next For Oracle and vFabric Postgres BDVMs, go to “Validate a Base DB Template,” on page 43. Template validation is optional. Validation is not supported for SQL Server. Validate a Base DB Template As a Data Director system administrator, you can validate a base DB template to confirm that it built correctly. You can validate a base DB template at any time. Prerequisites Complete the step “Convert a Base DBVM into a Base DB Template,” on page 42.
PAGE 44
VMware vFabric Data Director Administrator and User Guide Build a Custom RHEL and Oracle Database Template Data Director system administrators can build custom DBVMs to enable organization users to create databases with a specific operating system and database combination. To build a template that includes RHEL 5.5 and Oracle 11gR2, you must meet Oracle and Data Director prerequisites. Prerequisites n Verify that Data Director is installed and the system resource bundle is set up.
PAGE 45
Chapter 4 Building DBVMs and Base DB Templates Procedure 1 Log in to vSphere Client as a system administrator and connect to the vCenter server. 2 2. Deploy the VMware-Data-Director-Blank-Base-DBVM-.ova file into the system resource pool. When deployment completes, the virtual machine appears in the system resource pool. This virtual machine is known as the base VM. 3 Power on the base VM.
PAGE 46
VMware vFabric Data Director Administrator and User Guide A CDROM device containing the database binary ISO. A CDROM device containing the initialized ISO. Procedure 1 In the vSphere Client, select the blank virtual machine that you deployed. 2 Click Edit Settings. 3 Click the Hardware tab, and select CD/DVD drive in the hardware list. 4 In the right panel, click Datastore ISO file and click Browse. 5 Enter the path of the repackaged Linux ISO image.
PAGE 47
Chapter 4 Building DBVMs and Base DB Templates Install Oracle 11g R2 Software You can use a provided script that will install Oracle Home in the correct disk. Prerequisites Verify that you have initialized the virtual machine to make it Oracle and Data Director compliant. Procedure 1 Log in to the OS as root. 2 Type the following command to install Oracle. /opt/aurora/installation/install.
PAGE 48
VMware vFabric Data Director Administrator and User Guide When conversion is finished, the base DB template appears in the Base DB Templates list. What to do next For Oracle and vFabric Postgres BDVMs, go to “Validate a Base DB Template,” on page 43. Template validation is optional. Validation is not supported for SQL Server. Validate a Base DB Template As a Data Director system administrator, you can validate a base DB template to confirm that it built correctly.
PAGE 49
Chapter 4 Building DBVMs and Base DB Templates Install the Operating System and Database Software in a Blank DBVM vSphere users with access to the Data Director DBVMs, install the operating system and database software in the blank DBVM as part of building a custom base DBVM template. Prerequisites n Verify that you can log in to vSphere as an administrator. n Verify that Data Director is installed. n Verify that the blank DBVM is deployed to the system resource pool in vSphere.
PAGE 50
VMware vFabric Data Director Administrator and User Guide 5. 6. 7. 8. 9. 10. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. --ondisk=sdc --size=1 part /var --bytes-per-inode=4096 --fstype="ext3" --grow --ondisk=sdd --size=1 part /opt/aurora/dbg --bytes-per-inode=4096 --fstype="ext3" --grow \ --ondisk=sde --size=1 %packages @core @base @development-tools @legacy-software-development @editors unixODBC libaio-devel libXtst-devel libXp-d
PAGE 51
Chapter 4 Building DBVMs and Base DB Templates text # Firewall configuration firewall --disabled # Run the Setup Agent on first boot firstboot --disable # System keyboard keyboard us # System language lang en_US # Installation logging level logging --level=info # Use CDROM installation media # Network information cdrom network --bootproto dhcp --device eth0 network --bootproto dhcp --device eth1 # Reboot after installation reboot #Root password rootpw --iscrypted $1$X0Hs3tQw$Zw7.vM.
PAGE 52
VMware vFabric Data Director Administrator and User Guide VMware-Data-Director-Install.log." /root/firstboot.sh #FIRSTBOOT_END# EOF %packages @core @base @development-tools @legacy-software-development @development-libs @editors sysstat iptables* openldap-clients unixODBC libaio-devel httpd mod_ssl libXtst-devel libXp-devel libXau-devel Database Update Configuration You update databases to take advantage of features in new releases or upgrades of database software.
PAGE 53
Chapter 4 Building DBVMs and Base DB Templates User Defined Upgrade Scripts for Oracle databases In the update process, Data Director attempts to run two user defined scripts, the source base DB template preupgrade script, and the target base DB template postupgrade script. To achieve customization in the update process, you must upload a script to the base DBVM before converting it to a base DB template. Table 4-1.
PAGE 54
VMware vFabric Data Director Administrator and User Guide 3 Click the Base DB Templates in the left pane. 4 Right-click vPostgres 9.1, and select Properties. 5 Click the Update From tab. 6 Check the box for a vFabric Postgres 9.0 template, and select dump-restore. 7 Click OK.
PAGE 55
Chapter 4 Building DBVMs and Base DB Templates Identify Existing Target DBVM To create a template with the required patches, determine whether a base database virtual machine of the Oracle database that you intend to patch is available. Prerequisites Verify that you have Oracle databases that required upgrading in Data Director. Procedure 1 Log in to Data Director as an organization administrator. 2 Click the Manage and Monitor tab. 3 Double-click a database group in the left pane.
PAGE 56
VMware vFabric Data Director Administrator and User Guide Prerequisites Verify that a base database virtual machine of the Oracle database is available. Configure the update chain. Procedure 1 Connect to the Base DBVM console. You can connect from the vSphere client or other SSH terminals. 2 Download the PSU 12419378 package from the Oracle Web site. 3 Upload p5880880_112000_Linux-x86-64.zip to the /tmp directory in the database virtual machine. 4 Upgrade the patch according to README.txt.
PAGE 57
Chapter 4 Building DBVMs and Base DB Templates 6 7 In the Convert to Base DB Template wizard, provide the appropriate information. Option Action Name Enter a unique name for the base DB template. Description (Optional) Enter a description of the base DB template. Save the source DBVM (clone before converting) Click the checkbox to retain the source base DBVM for future use. Click OK. When conversion is finished, the base DB template appears in the Base DB Templates list.
PAGE 58
VMware vFabric Data Director Administrator and User Guide 5 Click OK. The base DB template is available to the resource bundle. What to do next Assign the resource bundle to an organization. See “Assign a Resource Bundle to an Organization,” on page 25. Enable a Base DB Template Organization administrators enable a base DB template on the underlying resource bundles so that organization users can provision databases based on the base DB template.
PAGE 59
Chapter 4 Building DBVMs and Base DB Templates Update a Database You can update a database to apply enhancements or software upgrades. Prerequisites Verify that the following conditions are met. n The system administrator has built and converted a base DBVM with proper update scripts and binary updates, such as new third-party tools or database software upgrades.
PAGE 60
VMware vFabric Data Director Administrator and User Guide 60 VMware, Inc.
PAGE 61
Managing Organizations 5 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.
PAGE 62
VMware vFabric Data Director Administrator and User Guide Organizations contain one or more database groups (DBGs) that in turn contain one or more databases, as shown in the following figure. Figure 5-1. Data Director Organization Structure Organization names must be unique within Data Director. Organizations cannot be nested. Organization roles, policies, and templates apply only within that organization.
PAGE 63
Chapter 5 Managing Organizations By default, system administrators cannot access organizations. Organization administrators can grant access to system administrators by modifying a security setting for their organization. Organization administrators perform tasks such as the following.
PAGE 64
VMware vFabric Data Director Administrator and User Guide One or more resource bundles can be assigned to an organization, but a resource bundle cannot be shared across organizations. This restriction provides resource isolation, enhances security, and helps to ensure compliance with Oracle licensing requirements by enabling organizations with Oracle databases to use only the vSphere resources dedicated for Oracle use.
PAGE 65
Chapter 5 Managing Organizations 2 Click Organizations in the left pane. 3 Click the plus (+) icon to start the Create Organization wizard. 4 Click Create New Data Director Organization. 5 Enter the organization information. 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.
PAGE 66
VMware vFabric Data Director Administrator and User Guide 6 Enter the appropriate information. Wizard screen Action Organization Administrator Select the vCloud Director organization administrator. Resource Bundles You can assign resource bundles at any time after binding the organization. To skip the assign resource bundles step, click Assign resource bundles later. To select a resource bundle now, click Choose an existing resource bundle and select a resource bundle from the list. Click Finish.
PAGE 67
6 IP Whitelists Organization administrators and users with appropriate permissions can add a level of security to database connection requests by creating IP whitelists and applying them to individual databases. By default, all users with valid credentials can connect to a database. By applying one or more IP whitelists to a database, you ensure that only connection requests from trusted IP addresses are accepted by that database.
PAGE 68
VMware vFabric Data Director Administrator and User Guide 5 Click OK. The IP whitelist appears in the IP Whitelist list. Apply IP Whitelists to Databases You can apply IP whitelists to a database to ensure that the database accepts connection requests only from trusted IP addresses. Prerequisites n Verify that your organization administrator or user with Manage IP Whitelist and Edit information and storage permissions has created IP whitelists.
PAGE 69
Chapter 6 IP Whitelists Option Description IP Range (Default) Enter a range of trusted IP addresses. Enter a beginning and ending IP address. Description (Optional) A description of the custom IP whitelist. 8 Repeat Step 7 to continue adding custom IP whitelists. 9 Click OK. Data Director reconfigures the database to accept connections from the custom IP whitelists' IP addresses. What to do next Click the IP Whitelists tab to modify or delete custom IP whitelists. VMware, Inc.
PAGE 70
VMware vFabric Data Director Administrator and User Guide 70 VMware, Inc.
PAGE 71
Managing Database Groups 7 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.
PAGE 72
VMware vFabric Data Director Administrator and User Guide Figure 7-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.
PAGE 73
Chapter 7 Managing Database Groups n Determine the size of the backup storage allocation to support the external backups for each database in the database group plus the Point-in-Time Recovery allocation for each database. Storage Reservation Organization administrators use storage reservation to control whether they can allocate more storage than is available to databases in a database group. Administrators set a limit on how much storage can be overallocated.
PAGE 74
VMware vFabric Data Director Administrator and User Guide 4 Specify the following information in the Create Database Group wizard. Wizard page Action Name and Description Type a name and optional description and click Next. Resource Bundle Select a resource bundle from the list and click Next. If no base DB template is enabled on the resource bundle, you must enable one. a Click Next, and select one or more base DB templates. b Click Enable. c When Status is refreshed to Enabled, click Next.
PAGE 75
Managing Database Templates 8 Data Director database templates allow organization administrators to enable database templates, and to standardize database creations and their backup policies. Database templates in Data Director 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.
PAGE 76
VMware vFabric Data Director Administrator and User Guide DB parameter groups are associated with base DB templates and contain the database configuration settings used to provision database instances. DB parameter groups specify database configurations that vary from db engines. For vFabric Postgres, this includes parameters such as connection, memory, IO, WAL, checkpoint, logging, and so on.
PAGE 77
Chapter 8 Managing Database Templates Procedure 1 Click the Organization Settings tab. 2 In the left pane, click Base DB Templates. 3 In the center pane, right-click a base DB template and select Enable on Resource Bundles. 4 Click Enable. Wait for the base DB template to be enabled. 5 Click Close. Create a DB Parameter Group Organization administrators and users with Manage base DB templates privileges can configure the DB parameter group for base DB templates.
PAGE 78
VMware vFabric Data Director Administrator and User Guide 3 Create a template or clone a template. Creation Method Action New template Click the green plus icon above the menu bar. Clone Right-click an existing template and choose Clone. 4 In the Create Resource Template wizard, type a name and description. 5 Specify whether you want to publish the template, and click Next. When a template is not published, you can view or manage it, but you cannot use it to create databases.
PAGE 79
Chapter 8 Managing Database Templates Action Description Edit Permissions Allows you to specify who can use this template, and what each user can do. You can change the permissions for an existing user, remove an existing user, and add a role. Users who can create a database from the template do not automatically have permissions to modify the template. Properties Allows you to modify the settings that you specified when you created the template.
PAGE 80
VMware vFabric Data Director Administrator and User Guide 7 8 Specify the external backup settings. Option Action Frequency Select one of the options from the menu. Select Never if you do not want backups for databases that use this backup template. Start Time Select Automatic to allow the system to control the start time, or enter a start time. The system initiates a backup within two minutes of the target start time, depending on system load.
PAGE 81
Chapter 8 Managing Database Templates 3 Right-click the template that you want to modify and perform one of the supported actions. Action Description Clone Creates a copy of this template. When you clone a template, the Create Backup Template wizard opens and you can configure the backup settings for the clone. Delete Deletes the selected template. Unpublish Disables provisioning and other capabilities for this template.
PAGE 82
VMware vFabric Data Director Administrator and User Guide 82 VMware, Inc.
PAGE 83
Managing Databases 9 Database administrators and application developers manage database lifecycles from creation to decommissioning. Database administrators manage databases from a central management perspective. Application developers focus on how databases can help with application development as a service.
PAGE 84
VMware vFabric Data Director Administrator and User Guide 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 37. Create databases Create and allocate resources to a new database using base database templates, database resource templates, and parameter groups.
PAGE 85
Chapter 9 Managing Databases 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.
PAGE 86
VMware vFabric Data Director Administrator and User Guide n If you plan to enable point-in-time recovery, calculate additional storage to accommodate the point-intime recovery write-ahead logs (WALs). The size of the allocation depends on the expected volume of transactions on the database. Every database requires a certain amount of storage overhead for the operating system, database software, swap space, log files, snapshots, and so on.
PAGE 87
Chapter 9 Managing Databases n “Ingest an External Database,” on page 93. Use this method to reproduce a state from a production or other type of environment. With ingestion, you can create a one-time clone, create a "golden clone", which cannot be modified within Data Director, or refresh a database from an external database, also known as in-place refresh. A golden clone can be refreshed only by an additional backup from the source database. You can make clones of a golden clone within Data Director.
PAGE 88
VMware vFabric Data Director Administrator and User Guide Field Option Expiration Select a date and time at which the database expires. Then select an action upon expiration, or no expiration. Tags (Optional) Select one or more tags for this database. Use tags to filter the list of databases that you view in an organization's Databases tab, for example, all your customer relationship databases can have a tag called CRM.
PAGE 89
Chapter 9 Managing Databases 6 Option Description Administrator If you joined the machine to a domain, type a domain user name for the SQL Server administration. If you did not join the machine to a domain, enter a password for the builtin SQL Server Administrator account, and a password for the Local Windows Administrator. Options Click No expiration, or click Expires on and select an expiration date and time and an action upon expiration. Tags (Optional) Select one or more tags for this database.
PAGE 90
VMware vFabric Data Director Administrator and User Guide 8 Option Action Database parameters Click Clone from source database and, optionally edit the parameters, or select a parameter group from the drop-down menu. Backup template Click Clone from source database and, optionally, view the settings, or select a backup template from the drop-down menu. PITR disk allocation You cannot change this value when creating a database from the catalog. Click Next.
PAGE 91
Chapter 9 Managing Databases Otherwise, do not include an archive log in the backup. If the database is in nonarchive mode, the refresh from external database feature does not support point in time refresh. The absolute path of any control files, data files, redo log files, or temporary files of source database cannot contain any space, tab, carriage return, asterisk, question mark, backslash, quote or line feed characters. n The database must be included in the backup.
PAGE 92
VMware vFabric Data Director Administrator and User Guide File Based Conventions During the ingestion and refresh process, coordinate your operations with external programs, such as third party backup software, or with manual operations. Familiarize yourself with the backup files, and observe these file based conventions. n Backup files for each ingestion or refresh operation should have their own directory. The directory should be beneath the exported directory.
PAGE 93
Chapter 9 Managing Databases Ingest an External Database You ingest a database to reproduce a production environment and create a one-time (golden) clone. The imported database is a clone of a physical database that exists outside of Data Director. Prerequisites n Verify that you have access to the organization and database group in which to create the new database. n Verify that you have Ingest databases permission on the database group in which you create the new database.
PAGE 94
VMware vFabric Data Director Administrator and User Guide 3 (Optional) If you selectGolden clone in catalog, you can select Take a snapshot before refreshing, and select Automatic refresh and specify a refresh frequency and start time. What to do next Click Next to configure Ingestion Process Settings or click Back to make changes.
PAGE 95
Chapter 9 Managing Databases Enter General Database Information Specify general information about the database, including name, database type and template, parameter group, Point-In-Time Recovery allocation, and whether to take a snapshot backup after database creation completes. Procedure 1 Enter the following information. Field Option Name and Description Type a name and, optionally, a description of the database. Database Type Select a database type from the drop-down menu.
PAGE 96
VMware vFabric Data Director Administrator and User Guide 2 Right-click a database and select Refresh. 3 Enter the following information. 4 Field Option NFS share name (Required) NFS share containing the RMAN backup of the source database. Catalog start Root folder that contains the RMAN backup set. This is the relative path to NFS Share. All backups under this directory are used for ingestion and refresh.
PAGE 97
Chapter 9 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 information and storage 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.
PAGE 98
VMware vFabric Data Director Administrator and User Guide 5 6 In the Add Databases to Catalog window, enter the following information. Option Description Source Database The default is the database that you selected . To add a different database to the catalog, click Edit and select a database from the list. Name Type a name for the catalog database. The default is the name of the database that you entered earlier. Description (Optional) Type a description of the catalog database.
PAGE 99
Chapter 9 Managing Databases Procedure 1 Log in as an organization administrator or user with organization and database privileges. 2 In the organization Manage & Monitor tab, select Catalog. 3 Right-click the database and select Delete. The database is removed from the organization catalog.
PAGE 100
VMware vFabric Data Director Administrator and User Guide Schedule Actions Organization administrators and users with appropriate privileges can schedule actions to run on one or more databases. Prerequisites Verify that you have appropriate database operations and management privileges for the tasks that you plan to schedule. Procedure 1 Log in to Data Director. 2 In the Manage & Monitor tab, select the database group.
PAGE 101
Chapter 9 Managing Databases 2 Click the Manage and Monitor tab. 3 On the Databases tab, right-click one or more databases and select Update. The Update page shows the current base DB template and its version. 4 On the Update page, provide the following information. Option Description Update to The new template from which to update the database. DB parameter group Database configuration parameters to apply to the updated database.
PAGE 102
VMware vFabric Data Director Administrator and User Guide Managing Database Properties DBAs and application developers with appropriate privileges manage database properties, such as storage allocation, database name, backup and resource templates, and database parameter groups. Database properties and settings control how the database operates. You can manage and adjust certain settings, such as resource allocation, database connection limits, and whether and how often to perform automatic tasks.
PAGE 103
Chapter 9 Managing Databases n You have Manage Administrator Accounts privileges and can add administrator accounts and configure OS remote access. n Verify that the database is running. Procedure 1 In the organization, click the Manage and Monitor tab and select the database group. 2 Right-click the database name, and select Properties. 3 Click the General tab and view the properties.
PAGE 104
VMware vFabric Data Director Administrator and User Guide Procedure 1 On the organization Manage and Monitor tab, select the database group. 2 Right-click the database name, and select Properties. 3 Click the Resources tab and view the current settings, using the scroll bar as necessary. 4 Click Edit. 5 To change a resource setting, click the corresponding check box in the Override column and modify the value.
PAGE 105
Chapter 9 Managing Databases Monitor Database Group Statistics You can view resource use, allocation, alarms, tasks and events, get reports, view permissions, and view a statistics breakdown for databases in 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.
PAGE 106
VMware vFabric Data Director Administrator and User Guide 106 VMware, Inc.
PAGE 107
Cloning Databases 10 In Data Director, you can clone a database. 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.
PAGE 108
VMware vFabric Data Director Administrator and User Guide Figure 10-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.
PAGE 109
Chapter 10 Cloning Databases Figure 10-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 resource settings, database parameter 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.
PAGE 110
VMware vFabric Data Director Administrator and User Guide 2 Configure the General Clone Settings on page 111 The general settings allow you to specify the name of the clone, a description, and to assign the clone to a database group. You can assign a database group only if the clone is not a linked clone. 3 Enter the Clone Configuration Settings on page 111 When you clone a database, you can configure the resource settings, database parameters, and backup settings for the clone.
PAGE 111
Chapter 10 Cloning Databases 3 4 Specify the point from which to create the clone. Option Description Now Creates the clone using the current state of the source database. Specific point in time Creates the clone at the specific date and time that you specify. Select a backup Uses the backup that you specify to create the clone. Click Next to continue to the General panel.
PAGE 112
VMware vFabric Data Director Administrator and User Guide 2 3 Select the database parameter group settings to use for the clone. Option Description Clone from source database Uses the database parameter group settings of the source database. Click Edit to modify the source settings. Use parameter group Allows you to select one of the available database parameter groups. Select Custom from the drop-down menu to override one or more values of the existing database parameter group.
PAGE 113
Chapter 10 Cloning Databases Configuring IP Whitelists Settings for the Clone You create IP whitelists to specify trusted IP addresses from which the clone accepts connection requests. Prerequisites Review information about IP Whitelists. See Chapter 6, “IP Whitelists,” on page 67. Procedure 1 (Optional) In your organization, click IP Whitelists, and select IP whitelists to use for the clone. 2 (Optional) Click Custom IP Whitelists, and click the plus (+) icon to create IP whitelists for the clone.
PAGE 114
VMware vFabric Data Director Administrator and User Guide When a post-clone script fails, Data Director logs an error event or a warning event against the source database. n If a user without the Clone Administration privilege attempts the clone operation or the clone administrator chooses to delete the clone if the post-clone script fails, the event is logged as an error.
PAGE 115
Chapter 10 Cloning Databases 6 Type SQL statements in the text box. 7 Click OK. The script appears in the list of scripts on the Cloning tab. Add an Existing Post-Clone Script to a Database Organization administrators and users with Clone Administration privileges can designate a SQL script to run after a database is cloned by adding a SQL script to a database's cloning properties.
PAGE 116
VMware vFabric Data Director Administrator and User Guide 5 In the Post-Clone Scripts section, click the plus (+) icon and enter the appropriate information. Option Description Name A unique name for the script. Description (Optional) A description of the script. 6 Select Open and browse to an existing SQL script. 7 Select the script. Its contents appear in the text box. 8 Edit the script. 9 Click OK. The script appears in the list of scripts on the Cloning tab.
PAGE 117
Chapter 10 Cloning Databases Choose the Default Post-Clone Script You can associate multiple post-clone scripts with a database, but only one can be active. Organization administrators and users with Clone Administration privileges can choose one post-clone script as the active (default) script. Prerequisites Verify that you have Clone Administration privileges on the database to which you are adding a post-clone script.
PAGE 118
VMware vFabric Data Director Administrator and User Guide The database or catalog a database is cloned from is the source of a cloned database. If the source is deleted, the cloned database becomes a regular database. When you refresh a cloned database, Data Director performs the following processes. 1 The schema and data is fetched from the source. 2 A post-clone script is run on the schema and data. 3 The schema and data generated by the post-clone script is applied to the cloned database.
PAGE 119
Chapter 10 Cloning Databases Procedure 1 Log in to Data Director as an organization administrator or user with the requisite privileges. 2 In your organization, click Manage and Monitor and select a database group. 3 On the Databases tab, right-click the database and select Properties. 4 Click the Automatic refresh tab. 5 Click the Automatic refresh checkbox, and select a refresh frequency and start time. 6 Click Apply. 7 Click OK. VMware, Inc.
PAGE 120
VMware vFabric Data Director Administrator and User Guide 120 VMware, Inc.
PAGE 121
Managing Database Entities 11 Managing database entities includes managing schemas and tables, and performing SQL management tasks. To manage database entities, you need view database permissions on the database. Your organization administrator can create a role that has the necessary permissions, and the administrator can grant that role to you. Permissions that you have on the organization apply to all database groups and databases in the organization.
PAGE 122
VMware vFabric Data Director Administrator and User Guide View Database Entities You can view database groups and databases in your organization, and the entities and objects of running databases. Prerequisites Verify that you have Organization management privileges, or View properties permissions to view databases in the organization. Procedure 1 Log in to Data Director. 2 If you have Organization management privileges, click the Manage and Monitor tab to view your database groups and databases.
PAGE 123
Chapter 11 Managing Database Entities 6 To perform the Vacuum and Analyze operations, click OK. 7 (Optional) To perform the Vacuum operation, uncheck the Analyze checkbox and click OK. To include the Full or Freeze operations with the Vacuum operation, check those checkboxes. 8 (Optional) To perform the Analyze operation, uncheck the Vacuum checkbox and click OK. Create a Schema After you create a database, you set up its entities, starting with the database schema.
PAGE 124
VMware vFabric Data Director Administrator and User Guide 6 (Optional) In Constraints, select the type of constraint, Foreign key, Unique, or Check, that applies to the new column. You can create foreign key constraints only if the schema has more than one table. 7 a Click Create. b Enter the conditions for the constraint, and click OK. c Click Next to continue, or click Finish to create the table.
PAGE 125
Chapter 11 Managing Database Entities Examine View Data A view is a subset of related table data. After you create a view, you can examine the data in the view. Prerequisites Verify that a view is available. See “Create a View,” on page 124. Procedure 1 In the left pane, click the Schemas arrow to expand it. 2 Click the arrow next to the schema to expand it. 3 Select Views in the left pane. All views under the schema appear in the list in the middle pane. 4 Right-click a view and select Open.
PAGE 126
VMware vFabric Data Director Administrator and User Guide Example: Create a Check Constraint A check constraint evaluates to a Boolean value. Use Check constraints to determine whether a value entered for a column meets a specific truth-type requirement. For example, suppose that you create a column that must be a positive integer, such as a product price. You can create a Check constraint to return TRUE when the product price is greater than 0, and to return FALSE when the product price is less than 0.
PAGE 127
Chapter 11 Managing Database Entities View a Query Plan Viewing a SQL query execution plan lets you 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 126. Procedure 1 Click the Manage and Monitor tab. 2 Right-click a database and select Open vPostgres Console.
PAGE 128
VMware vFabric Data Director Administrator and User Guide 128 VMware, Inc.
PAGE 129
Safeguarding Data 12 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.
PAGE 130
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.
PAGE 131
Chapter 12 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.
PAGE 132
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.
PAGE 133
Chapter 12 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.
PAGE 134
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.
PAGE 135
Chapter 12 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.
PAGE 136
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.
PAGE 137
Chapter 12 Safeguarding Data 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. Verify the VDR appliance installation, install the appliance if necessary, and then connect to VDR. You plan to take external backups of the Data Director virtual machines using VDR. Procedure 1 Log in to vSphere Client as an administrator. 2 Verify that VDR is installed. a Click Home.
PAGE 138
VMware vFabric Data Director Administrator and User Guide 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. a Expand your database group's resource pool. b Expand the Backup resource pool. c Select the check box next to the backup to be restored. d Click Next. 4 Click through the inventory list to select the location for the restored backup (the datastore of the virtual machine and the data.
PAGE 139
Chapter 12 Safeguarding Data Perform Point-in-time Recovery of Management Server Database You can perform a point-in-time recover of the Management Server database if you determine that the database is corrupted. Prerequisites n Verify that VMware Data Recovery (VDR) is deployed with vCenter and set up with the vSphere client. n Verify that regular backups are being performed on the Data Director vApp using VDR.
PAGE 140
VMware vFabric Data Director Administrator and User Guide Procedure 1 Create a pre-action or post-action script in the following format. u Pre-action script. pre_${lower_class_name}_${lower_method_name} u Post-action script. post_${lower_class_name}_${lower_method_name} 2 u For a post-action script to create a database, the script name must be post_dbctl_createdb. u For a post-action script to restore, clone, repair, and import a database, the script name is post_dbctl_recover.
PAGE 141
Monitoring the Data Director Environment 13 System administrators can examine 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 resource use for the different database groups and databases, and can view and monitor events and alarms for their organization.
PAGE 142
VMware vFabric Data Director Administrator and User Guide 3 Explore the Filter box in the upper right. a Type a search keyword to search the current items. The search result includes the currently displayed items and the list of available items. 4 5 b To select the columns to filter on, click the down-triangle.. c Clear the boxes for columns that you do not want to search, and click OK. To view a panel, select an action.
PAGE 143
Chapter 13 Monitoring the Data Director Environment System Settings Tab In the System Settings tab, system administrators can create a diagnostic package for one or more databases and for the system itself. Diagnostics packages provide valuable information for VMware Support. Tasks and Alarms Side Bar The tasks and alarms side bar, in the right panel of the main page by default, displays recent tasks and alarms. The Manage & Monitor tab includes more details about tasks and alarms.
PAGE 144
VMware vFabric Data Director Administrator and User Guide 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. You can then customize the Manage and Monitor tab. The system administrator Manage and Monitor tab differs from the organization administrator Manage and Monitor tab.
PAGE 145
Chapter 13 Monitoring the Data Director Environment 6 Use the filter options to customize what the system displays. The customization steps depend on the report type. Report type Action Summary Report a b c d e f Time Interval Reports a b c d e f g h 7 Select Resource bundle or Organization from the Type drop-down menu and click Choose. Select a resource bundle or organization. By default, all objects are selected. Select a time range, or click Customize to configure a custom time range.
PAGE 146
VMware vFabric Data Director Administrator and User Guide 4 To download the package, select Download from the Actions menu, and specify the download location. 5 To delete a package, right-click the package and select Delete. What to do next Send the diagnostic package to VMware Support for analysis. Understanding Cluster Alarms The vSphere Cluster on which Data Director is installed must meet several configuration requirements.
PAGE 147
Chapter 13 Monitoring the Data Director Environment When you select an item in the hierarchy, the right panel displays information about it if you have permission to view the information. Organization administrators use the following tabs and panels to monitor the organization. Dashboard Tab In the Dashboard tab, you can customize resource usage information displayed, close any of the panels, and click Customize to include the panel in the dashboard again.
PAGE 148
VMware vFabric Data Director Administrator and User Guide Explore Organization Administrator Dashboard Exploring organization administrator dashboard customizations lets you see available options. You can customize the dashboard to suit your needs. The organization administrator dashboard differs from the system administrator dashboard. See “Explore System Dashboard Customizations,” on page 143 if you are a system administrator.
PAGE 149
Chapter 13 Monitoring the Data Director Environment 4 Click the Dashboard tab to display the Organization Resource Usage dashboard. You can customize the dashboard by clicking the Customize button, or customize individual panels on the dashboard. By default, the following information is included. 5 6 Panel Description Resource Bundles Displays the databases, associated resource bundles, currently allocated CPU and memory reservations, and currently allocated and free storage.
PAGE 150
VMware vFabric Data Director Administrator and User Guide e Click the Filter button to filter the report. f Click the Action icon to download the report. What to do next To monitor specific databases, see “Explore Database Monitoring,” on page 150. 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 and Monitor tab.
PAGE 151
Chapter 13 Monitoring the Data Director Environment Working with Alarms Data Director displays system-defined alarms to system administrators and organization administrators. Data Director also allows administrators to create custom alarm ruless and to delete or disable alarm rules. 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.
PAGE 152
VMware vFabric Data Director Administrator and User Guide The alarm appears in the Alarms panel when it is triggered even if you leave Do nothing selected. If you select Send email, an email is sent. 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.
PAGE 153
Chapter 13 Monitoring the Data Director Environment Procedure 1 2 Open the Alarm Definitions table. n If you are a system administrator, click the Manage and Monitor tab, click Alarms, and click Definitions. n If you are an organization administrator, click the organization or click the resource group that you want to delete and alarm for, click the Alarms tab, and click Definitions. Disable or delete an alarm rule. n To delete an alarm, right-click that alarm and select Delete.
PAGE 154
VMware vFabric Data Director Administrator and User Guide At the highest level, you configure parameters to enable aurora_mon to start, stop, and monitor applications. You specify the start, stop, and monitor commands as shell scripts or operating system executable files that aurora_mon can invoke. Application developers can implement these commands according to the needs of their environment. Other parameters enable you to specify how often to monitor an application and what action to take.
PAGE 155
Chapter 13 Monitoring the Data Director Environment Table 13-2. Aurora_mon Parameters (Continued) Parameter Description app_stop_cmd (required) Command you use, such as any program, script, or executable file, to stop the application. You use this command typically during system shutdown or when restarting applications. The stop command is successful if it exits with a zero exit code.
PAGE 156
VMware vFabric Data Director Administrator and User Guide Manage the aurora_mon Monitoring Agent You can stop, start, and verify the status of the aurora_mon monitoring agent. Prerequisites Refer to “aurora_mon Configuration Parameters,” on page 154 before modifying parameters. Procedure 1 In vSphere, navigate to the Data Director vApp. 2 Select the Management Server, and click the Console tab. 3 Press the Enter key on your keyboard to activate the console and log in as root.
PAGE 157
Chapter 13 Monitoring the Data Director Environment name=management_server_data_disk_usage_80_perc descr=Data disk usage monitor (1st threshold) heartbeat_check_cmd=opt/aurora/ha/bin/mon_disk_space.sh -m /opt/aurora/data -t 80 heartbeat_period_300 heartbeat_fail_action=JUST ALERT heartbeat_ignore_fail_count=0 app_start_cmd=/bin/true app_stop_cmd=/bin/true app_priority=99 ~ ~ ~ "mon_data_disk_1st_thresh.conf" [readonly] 10L, 352C 5,2 6 ALL Change the value of a key-value pair.
PAGE 158
VMware vFabric Data Director Administrator and User Guide 158 VMware, Inc.
PAGE 159
14 Managing Licenses Data Director offers evaluation and permanent product licenses. System administrators have fine-grained control of licenses and license assignment using the Data Director System Settings tab's Licensing pane.
PAGE 160
VMware vFabric Data Director Administrator and User Guide The following are the vFabric Postgres database usage types. vFabric Postgres NonProduction Use License For internal development, quality assurance, proof of concept, or other testing purposes. vFabric Postgres Production Use License Includes use of vFabric Postgres databases in any manner other than NonProduction Use. You can change the vFabric Postgres database usage type at any time.
PAGE 161
Chapter 14 Managing Licenses The license management tasks that you can perform depend on your role. Table 14-3.
PAGE 162
VMware vFabric Data Director Administrator and User Guide n Restart database n Restore database n Start database You can upgrade evaluation licenses to permanent ones. When you purchase permanent licenses, VMware issues one permanent license key per SKU. As a Data Director system administrator, you add the permanent license key(s) in the Manage & Monitor tab's Licensing pane. See “Add License Keys,” on page 162. Adding permanent licenses upgrades your evaluation licenses to permanent ones.
PAGE 163
Chapter 14 Managing Licenses 3 View the license information. User Description System administrator If you are a system administrator, view license information as follows. n Click the Licensing tab to view your product license and license key information. n Click the Usage tab to view database license usage. Other users If you are an organization administrator or a user with the View and Manage Licenses privilege, view license information as follows.
PAGE 164
VMware vFabric Data Director Administrator and User Guide 3 In the Databases section, select the database that you want to change. You can select multiple databases to change their usage types in one operation. 4 Right-click, and select the usage type. 5 Click Yes to confirm the change. The updates appear in the Type column and the Summary pane.
PAGE 165
IP Pool Management 15 Data Director supports DHCP and IP pool options for network configuration. An IP pool consists of blocks of IP addresses that Data Director can allocate to virtual machines on the Internal Network or DB Access Network. Data Director system administrators manage IP pools from the Network pane of the System Settings tab. Data Director networks are generally configured during installation.
PAGE 166
VMware vFabric Data Director Administrator and User Guide 2 In the System Settings tab, expand Other Settings and select Network. 3 Click the IP Pool tab. 4 Click the plus (+) icon to start the Create IP Pool wizard. 5 In the Network page, select the ESXi cluster and network for the IP pool, and click Next. 6 In the Edit IP Pool page, enter the Netmask and Gateway IP addresses. 7 (Optional) In the Edit IP Pool page, enter the IP addresses for DNS servers 1 and 2.
PAGE 167
Chapter 15 IP Pool Management 2 In the System Settings tab, expand Other Settings and select Network. 3 Click the IP Pool tab. 4 Right-click an IP pool and select Remove IP Pool. 5 At the prompt, click Yes. Data Director removes the IP pool. What to do next Restart the databases that were assigned to the deleted IP pool. VMware, Inc.
PAGE 168
VMware vFabric Data Director Administrator and User Guide 168 VMware, Inc.
PAGE 169
VMware vCloud Director Integration 16 If vCloud Director integration is enabled for Data Director, Data Director system administrators can import vCloud Director organizations and their users into Data Director and allow operations on vCloud Director organizations through the Data Director user interface. If the System Health panel of your system dashboard shows vCloud Director Connectivity status, vCloud Director integration is enabled. Consider the following points.
PAGE 170
VMware vFabric Data Director Administrator and User Guide Enable vCloud Director Integration in Setup Data Director system administrators can enable vCloud Director integration during system setup. Prerequisites n Verify that the Data Director vApp is deployed but not set up. n You must know the FQDN of the Management Server. n See the VMware vFrabric Data Director Installation Guide for information about the setup wizard.
PAGE 171
Chapter 16 VMware vCloud Director Integration 6 Click OK. The vCloud Director Integration section of the General page indicates that vCloud Director is integrated. Edit or Disable vCloud Director Integration Data Director system administrators can edit vCloud Director integration information, or disable vCloud integration. Prerequisites vCloud Director integration is enabled. Procedure 1 In the System tab, select System Settings. 2 Select General.
PAGE 172
VMware vFabric Data Director Administrator and User Guide 8 Click OK. The organization administrator user name appears in the Organization Administrators list. 9 172 Click OK to exit. VMware, Inc.
PAGE 173
Reconfiguring Data Director Networks 17 During installation, you set up the networks that carry the different types of Data Director network traffic. Data Director has the following types of network traffic.
PAGE 174
VMware vFabric Data Director Administrator and User Guide 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. b Select vCenter Extension Installation and click Edit. c Select .
PAGE 175
Chapter 17 Reconfiguring Data Director Networks 6 d Change the settings for FQDN, static IP address, netmask, DNS Server 1, or DNS Server 2, as appropriate. e 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 178.
PAGE 176
VMware vFabric Data Director Administrator and User Guide 4 If necessary, enable or disable DHCP or Static IP for the network used as the vCenter network. a Click Edit. b Select or deselect the DHCPcheck box to enable or disable DHCP. If the vCenter network and the Web console network map to the same network, you cannot disable the existing IP allocation scheme (DHCP or static IP). You can enable a new IP allocation scheme for the network used as vCenter network.
PAGE 177
Chapter 17 Reconfiguring Data Director Networks 6 To reconfigure the DB Name Service Network mapping, select the appropriate network mapping in the DB Name Service Network drop-down menu, and click Next. 7 Click Edit next to the network name to enable or disable DHCP or static IP on a network. 8 a Select the DHCP check box to enable DHCP. b Select the Static IP check box and enter a netmask to enable static IP. c Click OK.
PAGE 178
VMware vFabric Data Director Administrator and User Guide 9 To modify the internal network adapter settings for the Management Server - Internal Network Adapter, or the DB Name Server - Internal Network Adapter, select one of the following options. Option Description DHCP Check the DHCP box to enable DHCP, and enter a FQDN. Satic IP Check the Static IP box to enable static IP addressing, and enter the IP address and an FQDN.
PAGE 179
Chapter 17 Reconfiguring Data Director Networks 3 If the new vSphere network to be used as the database access network is not in the resource bundle used by the DBG, add the network to the Resource Bundle. a Click the System tab, and click Manage and Monitor. b Click Resource Bundles. c Right-click the resource bundle, and select Properties. d Click the Network tab, and click Edit. e Find the network to add to the resource bundle, and click DHCP or IP Pool.
PAGE 180
VMware vFabric Data Director Administrator and User Guide 180 VMware, Inc.
PAGE 181
Managing SSL Keys and Certificates 18 Data Director enables the Secure Sockets Layer (SSL) protocol for all components, including the Management Server, the DB Name Server, and the DBVM. SSL secures both internal communications among components and communications from customers who access the database externally. By default, Data Director generates an SSL key and certificate for all components.
PAGE 182
VMware vFabric Data Director Administrator and User Guide 3 Right-click Management Server and select Regenerate. A warning advises you that you must restart the Management Server to apply the new key after your regenerate it. 4 Click OK. Progress of the renewal of the automatically generated key and certificate for the Management Server, and of update tasks that distribute the Management Server root certificate authority (CA) to the DBVMs, appears in the right panel.
PAGE 183
Chapter 18 Managing SSL Keys and Certificates Edit Management Server Certificate System administrators can edit a custom Management Server SSL key and certificate to replace the certiticate before it expires. Prerequisites Verify that a custom key and certificate is applied to the Management Server. Procedure 1 Click System Settings. 2 Expand Other Settings and click Security. 3 Under SSL Configuration, right-click Management Server and select Edit Certificate.
PAGE 184
VMware vFabric Data Director Administrator and User Guide Import DB Name Server Key and Certificate System administrators can import a custom DB Name Server SSL key and certificate to replace the key and certificate automatically generated by Data Director. Prerequisites Verify that you have a custom SSL key and certificate available. Procedure 1 Click System Settings. 2 Expand Other Settings and click Security. 3 In the SSL Configuration section, right-click DB Name Server and select Import.
PAGE 185
Chapter 18 Managing SSL Keys and Certificates 5 (Optional) Use the Upload, Delete, down, and up buttons to edit the certificate chain. 6 Click OK. Progress of the custom certificate configuration for the DB Name Server, and of tasks that distribute the DB Name Server root CA to the DBVMs, appears in the right panel. The new certificate is applied.
PAGE 186
VMware vFabric Data Director Administrator and User Guide 6 Select a keystore type, and type a keystore password, a key alias, and a key password. 7 Click Browse and navigate to your custom keystore file. 8 Click Next and click the Custom Certificates tab. The text box shows the certificate chain imported from the key store for the selected key.
PAGE 187
Data Director Troubleshooting 19 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.
PAGE 188
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.
PAGE 189
Chapter 19 Data Director Troubleshooting 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. n The resource pool is empty. n The parent resource pool uses compatible vSphere HA and vSphere DRS settings.
PAGE 190
VMware vFabric Data Director Administrator and User Guide Cause Several conditions can cause the problem. n DB Name Server is powered off. n Database server is powered off. n Database service is stopped by management tools bypassing vFabric Data Director. n Database IP Whitelist is configured incorrectly. Solution 1 Verify that the DB Name Server status in System Health is green. If the status is not green, ask the vSphere administrator to power on the DB Name Server.
PAGE 191
Index A ACID properties 13 add catalog database 97 add custom IP whitelists 68 Add database owner account 102 add databases to the catalog 97 add IP pools 165 add organization administrator to vCloud Director organizations 171 add post-clone scripts 115 add pre-action and post-action scripts 139 adding databases to organization catalogs 97 adding users 33 administer SQL 126 Administration tab 142, 146 alarms custom 151 database 105 delete 152 disabling 152 Alarms side bar 141 analyze SQL query plan 127 app
PAGE 192
VMware vFabric Data Director Administrator and User Guide configure clone options settings 112 configure clone settings 111 configure database refresh profile 93 configure DB parameter group 77 configure Oracle update chain 58 configure tags for a clone 112 connect to VDR 137 constraint creation 125 convert base DBVM to base DB template 42, 47, 56 Create base database VM from template 55 create base DBVM 41 create check constraints 123 create column constraints 123 create constraints 125 create database fr
PAGE 193
Index delete custom IP whitelists 68 delete IP pools 166 delete post-clone scripts 117 deleting alarms 152 deploy base database VM 44 deploy DBVM template OVA files 39 DHCP 16 diagnostic packages 142 diagnostics package 145 disabling alarms 152 downloadable DBVM OVA files 39 DRS 18, 188 dump-restore update 52 E edit custom IP whitelists 68 edit database backup settings 104 edit DB name server SSL certificate 184 edit DBVM SSL certificate 186 edit IP pools 166 edit management server SSL certificate 183 Edi
PAGE 194
VMware vFabric Data Director Administrator and User Guide manage SSL keys and certificates 181 Management Server database, point-in-time recovery 139 managing cloned databases 117 managing databases 83 managing organizations 61 modes by organization 61 global 61 modify aurora_mon 156 modify IP Pool settings 179 modify security settings 34 modify SQL queries 126 monitor customizations 144 monitor database performance 104 monitor database resource use 104 monitor resource usage 22 monitoring 142, 146 monitor
PAGE 195
Index resource pools, missing 188 resource settings, templates 77 resource template, modifying 78 resources monitor usage 22 physical and virtual 15 viewing 20 resources for database groups 72 restore VDR backup 137 RHEL and Oracle Database templates 44 role-based access control 27, 29 roles add to an organization 33 propagation of 32 run basic batch operations 99 run batch database operations 99 regenerate DBVM key and certificate 185 regenerate management server key and certificate 181 SSL communication
PAGE 196
VMware vFabric Data Director Administrator and User Guide V vacuum analyze a database 122 vacuum configuration 103 validate base DB templates 43, 48, 57 vCenter network adapter reconfiguration 175 vCenter Network mapping reconfiguration 175 vCenter Server IP address 173 vCenter Server troubleshooting 187 vCloud Director 171 vCloud Director integration edit or disable 171 enable after setup 170 vCloud Director integration,enable in setup 170 VDR external backups 137 import backup 138 restore backup 137 VDR