© 2009 VMware Inc. All rights reserved

Powering Database-as-a-Service for Your Cloud with vFabric Data Director

2

Agenda

VMware Confidential

What is vFabric Data Director and why do you care?

vFabric Data Director Overview

Summary

3

vFabric Director

A software solution that enable enterprise to provide their users the ability to self-service database provisioning and management needs on demand.

VMware Confidential

4

Customer Challenge 1: Control Database Sprawl

Untenable Growth

• 1,000s to 10,000s of databases within one company

• ~10-20% of all x86 servers run databases

Long Tail of Under-managed Databases

• Majority of the databases are lightly loaded and underutilized (typically <10% CPU)

• Under-protected – No backup, no HA

Shadow IT

• MySQL and MS Access databases under people’s desks

• Defecting to public cloud providers

Corporate IT Shadow IT

5

Customer Challenge 2: Improve Developer Agility

Frustrated Developer

• Long lead time for database provisioning and operations

Overworked DBAs

• Cloning DBs is a semi-manual process

• Backup/restore is complicated and semi-manual

• Time-consuming and error-prone manual processProvision &

Manage

Provision &

Manage

Databaseprovision or clone request

Lead time of weeks

6

Customer Challenge 3: Make the Most of Virtualization

Database technology has not caught up to virtualization

• Dedicated hardware with fixed resources

• DBA tunes databases to specific setup

• No resource pooling or sharing…

7

Journey to the Cloud

Early public cloud successes have established clear benefits of the cloud model:

• Self-service

• Elastic scalability

• Usage-based pricing

Demand and opportunity for Enterprise ITs to provide cloud benefits behind their firewalls

• Enterprise developers demands public cloud like service level

• Increase speed to innovation

• Maximize data center and resource utilization

• Lower operating cost by controlling the IT sprawl

• Protect IP and sensitive data from leaking to the public cloud

8

Database-as-a-Service is a Critical Component of Cloud Stack

PaaS

DBaaS

IaaSAmazon EC2

Amazon S3/EBS

Amazon RDS

Amazon Elastic Beanstalk

Amazon CloudFormation

vSphere

vCloud Director

vFabric Data Director

9

vFabric Data Director

vFabric Data Director

• Self-service database provisioning and cloud automation platform

• vSphere-optimized PostgreSQL database

• Built on vSphere Platform

Graphical User Interface/API

DBAs

Developers

Provision

Resource

Mgmt

Security

Mgmt

Backup Restore

& Clone

Availability

& Monitoring

Dashboard

& Reports

Notifications

& Alerts

Cloud

Operations

vSphere

App App AppAppApp App App App

Powering Database-as-a-Service for Your Cloud

10

Agenda

VMware Confidential

What is vFabric Data Director and why do you care?

vFabric Data Director Overview

Summary

11

Self-Service

• Just-in-time database provisioning

• Comprehensive database backup and recovery

• Innovative database cloning

IT Control

• Fine-grained resource management

• Robust role-based access control

• Convenient database templates

vSphere-Optimized

• Elastic database memory• One Click database-aware

high availability• Automatic database

configuration

Enhance Developer Agility Enforce policy over a secure environment

Extend virtualization benefits to database

vFabric Data Director Delivers…

12

Just in time Provisioning

Database provisioning and configuration can take weeks, slowing innovation cycles.

Solution: Self-Service Provisioning

• Provision fully configured databases in minutes

• Templates guarantee proper configuration

• Easy to use web interface• Point and click

• No database expertise needed

Benefits

• Faster development cycles

• More time on coding, less time on waiting

• IT controls policies, configuration, & resource consumption

13

Backup and Recovery

DBA’s have limited time to enable, monitor, and test backup and recovery policies for all databases.

Solution: Built-In Backup Policies

• Fully integrated backup & restore process (backup templates)• Automated scheduled backups

• Policy driven backup retention

• Self-service manual backups

• Dual backup techniques integrated into single policy• External Backups

• Resilient external backups

• Snapshots with Database Consistency

• Storage efficient

• Faster to take and restore

• Point-in-time-recovery

• Native Postgres WAL-archiving PITR

for External Backups and Snapshots

14

Innovative Database Cloning

The average production database has 6 clones (dev, qa) and each clone takes days to create.

Solution: Innovative Database Cloning

• Linked Database Clone• Clone created from parent snapshot

• Available for use instantly regardless of database size

• Storage efficiency

• Full Database Clone• Complete physical copy of parent

• Isolation between parent and clone

Benefit• More time coding, less time waiting

Dev QA Perf

Linked DB Clones

Full DB Clone

Staging

Production

15

Self-Service

• Just-in-time database provisioning

• Comprehensive database backup and recovery

• Innovative database cloning

IT Control

• Fine-grained resource management

• Robust role-based access control

• Convenient database templates

vSphere-Optimized

• Elastic database memory• Database-aware high

availability• Automatic database

configuration

Enable Developer Agility Enforce policy over a secure environment

Extend virtualization benefits to database

vFabric Data Director Delivers…

16

Organization

Data Director VMware vCenter Server

VMware vSphere

RA

MV

MF

SN

ET

Example Resource Bundle:

• 1,000 GHz CPU

• 1TB RAM

• VMFS Datastore for DB

• VMFS Datastore for Backup

• 2 Networks

Example Database Group:

• 500 GHz CPU Reservation

• 256 GB RAM Reservation

• High CPU & Memory Priority

• 100 GB Database Storage Allocation

• 50 GB Backup Storage Allocation

• 1 Network

CP

U

Database Group

Example Database:

• 2 GHz CPU Reservation

• 8 GB RAM Reservation

• High CPU & Memory Priority

• 20 GB Database Storage Allocation

• 10 GB Backup Storage Allocation

Resource Bundle

Fined Grained Resource Management

17

Flexible Database Templates

Solution: Flexible Database Templates

• Customize templates for database configuration and backup

• Robust role-based access control which templates users can access

• Search and browse templates

• Fast provisioning

Benefits

• Enforce IT standards and control

• Ease of use

• Ensure reliability and repeatability

Database provisioning and configuration requires sophisticated DBA with limited time.

18

Robust Role Based Access Control

Role Based Access Control

• Out-of-the-Box Roles• Cloud Administrator

• Organization Administrator

• Custom Roles

Fine-grained Security Privileges

• Over 30 different privileges• Create/Edit/Delete Database

• Backup/Restore/Clone Database

• Create/Edit/Delete Template

• Edit Template/Database settings

Benefits

• Robust security enables self-service

• Custom roles ease security management

19

Self-Service

• Just-in-time database provisioning

• Comprehensive database backup and recovery

• Innovative database cloning

IT Control

• Fine-grained resource management

• Robust role-based access control

• Convenient database templates

vSphere-Optimized

• Elastic database memory• Database-aware high

availability• Automatic database

configuration

Enable developer agility Enforce policy over a secure environment

Extend virtualization benefits to database

vFabric Data Director Delivers…

20

vFabric RelationalDB

Based on PostgreSQL 9.0

• Fully ACID compliant, ansi-SQL compliant relational database

• More than 15 years of active development

• Proven architecture known for reliability and data integrity

Virtualized database optimized for vSphere

• Performance

• Configuration

• High availability

• Easy upgrade

21

vmkernel

Guestkernel

Pages (PPNs)

BufferPool

XyzPool

Tmp Pool

Pages

ESX memory usage

Balloon Target

Inflate/targetPool Target

Aurora Database

Aurora Balloon Driver

KernelBalloon Driver

Total balloon target

#1 reason DBA’s don’t virtualize databases: inconsistent performance caused by dynamic resource allocation

Solution: Elastic Database Memory (Patent Pending)

• Database memory balloon driver understands page importance:

• Database memory pools

• Clean pages

• Database page free lists

Benefits

• Consistent database performance

• Flexible resource allocation

• Maximum resource utilization

Elastic Database Memory

22

Database-aware High Availability

Database HA solutions are expensive and complex to configure and manage.

Solution: Database-aware High Availability

• Zero data loss protection and automatic (admin-free) failover from:• Host, OS, and Database failures

• Enable HA with a single click

Benefits

• Much simpler to configure than “Microsoft MSCS + SQL Server”

• Completely automated failover

• Easy setup enables HA for all databases without administrator involvement

23

Automatic Database Configuration

Highly experienced DBA’s spend weeks configuring and tuning database systems

Solution: Automatic Database Configuration• User/administrator specifies virtual resources (cpu, memory)

• User inputs application workload characteristics

• Aurora automatically configures the optimal database configuration• Database memory pools

• Database processes and connections

Benefits• Optimally aligns resources and database configuration

• Minimizes valuable administrator time spent tuning and configuring database

24

Agenda

VMware Confidential

What is vFabric Data Director and why do you care?

vFabric Data Director Overview

Summary

25

Summary

vFabric Data Director delivers

• Self-service capability to DBAs and developers by automating common database operations

• Control to IT admins by enabling them to enforce IT policy and ensure compliance

• Full virtualization benefits to database tier

26

To Learn More

Try out our vSphere-optimized PostgreSQL database on Cloudfoundry.com

Talk to one of team members

27

Thank you!