VMware vFabric Data Director – Powering Database-as-a-Service

1. VMware vFabric Data Director Powering Database-as-a-Service for Oracle, SQL Server, Hadoop and vFabric Postgres

2. Traditional IT System Admin Storage Admin Network Admin Application Team DBA Days - weeks to provision a development environment

3. Database Infrastructure Challenges UAT Development Production Test Postgre Postgre Postgre Postgre Shadow IT Enterprise DBA Security Routine Tasks Compliance

4. vFabric Data Director Powers Database-as-a-Service for your Cloud Enables database-aware virtualization on VMware vSphere and provides database-as-a-servicefor heterogeneousdatabases and Hadoop Reduce capex through database-aware virtualization Save cost through database and Hadoop virtualization Increase IT agility Automate database and Hadoop lifecycle management Accelerate analytics and application development Through self-service and automation

5. vFabric Data Director Platform Architecture vFabric Data Director Enterprise Services Integration Gateway (API) vCloud Director Provisioning Backup/Restore Clone Database Catalog One click HA Database Ingestion LifecycleServices App Dev DBA Application Director ResourceMgmt Security Mgmt Template Mgmt PatchMgmt Monitor InfrastructureServices Cloud Foundry IT Admin DBA EMC Chorus vPostgres … EMCData Domain ... … Cloud Infrastructure Platform Cloud Infrastructure Platform

6. Supported Data Engines • Oracle 10gR2, 11gR2 • SQL Server 2008R2, SQL Server 2012 • Postgres 9.1.6 • Hadoop 1.0 based distributions: • Apache Hadoop 1.0.x • Cloudera CDH3 • Greenplum HD 1.1 and 1.2 • Hortonworks Data Platform 1.0 • MapR - Soon

7. SQL Server Support - New • Data Director now supports SQL Server database • Supports provisioning of SQL Server 2008 R2 and SQL Server 2012 databases • Key features include • Create SQL Server templates easily with built-in configurations • Size VMs and configure database settings through a single UI • Join VMs to domain as part of provisioning • Compatibility with existing tools

8. Provision Any Database from Same Web Portal

9. Provision and Manage Any Hadoop Distribution with One Click

10. Hadoop Support Powered by Serengeti • Open source project launched in June, 2012 • To learn more - projectserengeti.org Serengeti

11. Elasticity & Multi-tenancy High Availability Operational Simplicity Why VirtualizeHadoop? • Rapid deployment • One stop command center • Easy to configure/reconfigure • Shrink and expand cluster on demand • Independent scaling of Compute and data • Strong multi-tenancy • High availability for entire Hadoop stack • One click to setup • Battle-tested

12. Data Director Benefits • Reduce Costs by > 50% • Consolidate servers by 10–15X • Save on Hardware, Software, Power and Cooling Double Your DBAs Don’t Let Your DBAs Hit the 40 DB Ceiling • Automate provisioning and management • Enforce policies and best practices automatically Stretch Your Servers Use the Right Database for the Job • Use the most cost-effective licensing for your application • Leverage low-cost HA and clustering with vSphere Liberate Your Licenses Keep Your Data Secure With Automation • Make security a holistic part of the database lifecycle. • Help admins keep systems patched and up-to-date. Secure Your Stuff

13. vFabric Data Director Data Director will help you: • Stretch Your Servers • Liberate Your Licenses • Double Your DBA Productivity • Secure Your Stuff

14. vFabric Data Director Data Director will help you: • Stretch Your Servers • Liberate Your Licenses • Double Your DBA Productivity • Secure Your Stuff

15. We Looked at 700,000 Servers The average PRODUCTION Oracle Database Instance uses: • 4% of CPU • 2MB/second of Network • 1200 IOPS The average SQL Server database only does slightly better (about 5% CPU). This does not strain a modern server in any way.

16. How Can We Do Better? Virtual Server Physical Server You can consolidate 10-15 databases on a single server without affecting overall performance.

17. vFabric Data Director Data Director will help you: • Stretch Your Servers • Liberate Your Licenses • Double Your DBA Productivity • Secure Your Stuff

18. How Can We Use fewer Licenses? Virtual Server Physical Server Oracle and SQL Server are typically licensed by core. If you consolidate by a factor of 10-15x you will need far fewer licenses.

19. How Can I Virtualize a Physical Database Data Director Application Shell Virtual Machines Oracle 11.1 Template Oracle 11.1 DB Management Server Monitoring Agents Linux Linux Physical DB Server Empty DBVM Clone of Physical DB Oracle 11.1 T TEMP TEMP SWAP SWAP LOG LOG DATA DATA Monitoring Agents Linux

20. A Single License Management Pane Don’t get a million dollar surprise because you couldn’t track your database licenses.

21. A Real World Example EMC is one of the largest Oracle shops in the world and it runs on VMware. EMC was able to: • Consolidate their servers by a factor of 13:1 • Reduce RAC to Single Instance databases • Convert Enterprise to Standard Edition databases • Add HA to single instance databases. • Realize millions of dollars in cost savings See Whitepaper “EMC IT’s Virtual Oracle Deployment Framework”, November 2011

22. vFabric Data Director Data Director will help you: • Stretch Your Servers • Liberate Your Licenses • Double Your DBA Productivity • Secure Your Stuff

23. How Many Databases Can a DBA Manage? 40

24. Data Director Accelerates Productivity After Before Self Service Policy Foundation Developers Developers/Administrators Database Team DBAs IT Tickets IT

25. Data Director Architecture Data Director Application Database Template Library Shell Virtual Machines Database Database Database DB Management Server Monitoring Agents Monitoring Agents Monitoring Agents Operating System Operating System Operating System Linux vCenter ESXi T TEMP SWAP LOG DATA

26. Create Your Own Databases, Virtually Data Director Application Shell Virtual Machines Database Template Library Database DB Management Server Monitoring Agents Operating System Linux New Database Based Linked to Parent Template Database T TEMP TEMP SWAP SWAP LOG LOG DATA DATA Monitoring Agents Operating System

27. A Data Director Database Uses binaries from linked clone disks on the parent template Has a unique ID and IP address Database Monitoring Agents Operating System Runs software and database processes locally (in the VM) Stores data locally (inside the VM)

28. Upgrading or Patching a Database Data Director Application Oracle 11.1 Template Oracle 11.2 Template Oracle 11.1 Oracle 11.2 DB Management Server Monitoring Agents Monitoring Agents Linux Linux Linux DB Based on Oracle 11.2 Template DB Based on Oracle 11.1 Template Oracle 11.2 Oracle 11.1 Monitoring Agents Monitoring Agents Linux Linux

29. Cloning a Database Data Director Application Shell Virtual Machines Oracle 11.1 Template Oracle 11.1 DB Management Server Monitoring Agents Linux Linux DB Based on Oracle 11.1 Template Empty DBVM Exact Clone of DB Oracle 11.1 Oracle 11.1 T TEMP TEMP SWAP SWAP LOG LOG DATA DATA Monitoring Agents Monitoring Agents Linux Linux

30. Complex Operations Made Simple Creating or cloning a database takes about 5 minutes.

31. Administrators Are Still In Control Standards and Best Practices are automatically enforced.

32. Users Still Get What They Need Users can still configure some options and parameters, guided by policy and best practices.

33. Why You Should Care Using Data Director, complex database operations are automated and simplified. • Database Creation • Database Cloning • Data Movement • Backup and Recovery • Load Balancing • Database Retirement Developers and Analysts can create their own databases without an administrator.

34. How Many Databases Can a DBA Manage with Data Director? 80? We break the direct relationship between DBAs and the number of databases under management.

35. vFabric Data Director Data Director will help you: • Stretch Your Servers • Liberate Your Licenses • Double Your DBA Productivity • Secure Your Stuff

36. Database Security is Baked In Concepts like database expiration are built into the provisioning process.

37. Network Security is Baked In Network Security is built into the provisioning process as well.

38. Centralized DBaaS monitoring All service level actions are closely monitored, logged, and tracked.

39. A Real World Use Case A Production Finance Database has data quality problems and an analyst needs to examine some highly sensitive data. This is a very difficult challenge for: • Security • Compliance • Database Operations • System Administration

40. Linked Clones of a Database Data Director Application Shell Virtual Machines Oracle 11.1 Template Oracle 11.1 DB Management Server Monitoring Agents Linux Linux DB Based on Oracle 11.1 Template Empty DBVM Linked Clone of DB Oracle 11.1 Oracle 11.1 ∆ T TEMP TEMP SWAP SWAP LOG LOG DATA DATA Monitoring Agents Monitoring Agents Linux Linux The linked clone is a separate DB that shares the original storage and keeps a local copy of disk block changes.

41. A Real World Use Case Data Director can: • Create a linked clone of the original database that has an identical O/S and DB configuration. • Ensure changes do not impact original DB. • Automatically discover and mask sensitive data. • Expire and delete the linked clone after 7 days. • Automatically remove any backups or snapshots. • Quickly create and apply a patch any databases with a similar configuration. • Security • Compliance • Database Operations • System Administration

42. Summary vFabric Data Director enables database-aware virtualization on VMware vSphere and provides database-as-a-service for heterogeneousdatabases and Hadoop • Reduce cost through database-aware virtualization • Increase IT agility • Accelerate analytics and application development