620 likes | 842 Views
Deployment Best Practices for Private Cloud. Fast Track to DBaaS and MWaaS. Nilesh Agrawal , Consulting Technical Lead, Oracle Neelima Bawa , Consulting Technical Lead, Oracle James Anthony, Technology Director, e-DBA October 1, 2014.
E N D
Deployment Best Practices for Private Cloud Fast Track to DBaaS and MWaaS NileshAgrawal, Consulting Technical Lead, Oracle NeelimaBawa, Consulting Technical Lead, Oracle James Anthony, Technology Director, e-DBA October 1, 2014
Program Agenda - Best Practices for Private CloudDBaaS/MWaaS Design Optimize Objectives Design Deploy Manage Optimize Case Study: e-DBA 1 2 3 4 Manage 5 Deploy 6
Total Cloud Control Expanded Cloud Stack Management Superior Enterprise-Grade Management Accelerated Automation for Broader Cloud Services | | Scalable, Secure Agile, Automated Optimized, Efficient
Objectives DBaaS/MWaaS Deployment Lifecycle • Design • What are the first steps to take? • Identify right candidate Apps • Standardize and Consolidate • Capacity Planning • Plan Access and Governance • Design Service Catalog • Optimize • How do I Optimize ? • Monitor Cloud Infrastructure • Measure Service • Meter and Chargeback/Showback • Deploy • How do I Setup DBaaS/MWaaS in Fast track mode? • Deploy Options • Setup EM 12c and SSA Portal • DBaaS/MWaaS deployment Steps • Rapid Start Kit and REST APIs • Snap Clone Setup • Manage • How do I Manage the Cloud platform? • Patch and Upgrade • Platform Administration • Maintain PaaS Infrastructure
Design Designing Private Cloud Deployment
Design Design Goals • Identify Candidate Applications – align with business goals • New applications, UAT applications, Applications that need on-demand capacity • Standardize and Consolidate • Standardize to Simplify job of Administrators, Consolidate to gain Efficiency • Standardize from • OS - AIX 6.1, 5.1, Linux 5.1, 5.2 • DB Oracle Home 11.2.0.2.0, 11.2.0.4, 12.1.0.1/MW Home 10.3.6, 12.1.2 • Consolidate to • Small –Linux 6.1 running 11.2.0.4 PSU 3 DB with 2 GB SGA/MW 12.1.2 with 1 GB Heap • Large –Linux 6.1 running 11.2.0.4 PSU 3 DB with 8 GB SGA/MW 12.1.2 with 4 GB Heap
Design Design Goals • Planning DBaaS/MWaaS Infrastructure • Sizing – Calculate Required Infrastructure • CPU, Memory , Storage Requirement of all DB/MW in the Cloud • Buffer Requirement • Access Control • Prepare PaaS platform - Cloud Administrators should get required control • Minimal Privilege for End Users • Design Service Catalog • Service Catalog is collection of service templates • Along with Resource Pools Helps Drive Standardization
Design DesignService Catalog Example * Real World Customer Example
Deploy and Configure Configure For Best Practices
Deployment OptionsDBaaS/MWaaS Deploy • Self Service User Interface • Rapid Start Kit for DBaaS • Rest APIs Rapid Start Cloud Setup http://docs.oracle.com/cd/E24628_01/doc.121/e28814/cloud_rap.htm Database as a Service REST APIs docs.oracle.com/cd/E24628_01/doc.121/e28814/dbaas_api.htm Middleware as a Service REST APIs http://docs.oracle.com/cd/E24628_01/doc.121/e28814/jaas_api.htm
Deployment Flow Deploy Ref FMW Create Profile Ref DB Host A Host A 12c WLS 11.2.0.3 DB OH Access Service catalog Create Service Catalog PaaSZone 4 PaaS Zone 1 Pool4 Pool1 10.3.6 WLS 12c DB PaaS Zone 3 PaaS Zone 2 Pool3 Pool2 Management Server RepositoryDatabase Self Service Users Pool5 Pool6 Configure Quota and Request Settings Host An Host An Roles/Users
EM12c Setup Required plug-ins Deploy • Install EM12c with following Plug-ins • Oracle Database • Oracle Fusion Middleware • Oracle Cloud Framework • Oracle Cloud Application • Oracle Storage Management Framework (Only when Snap Clone based Solution) Recommended Readings MoS Note 1900943.1 https://support.oracle.com/epmos/faces/DocumentDisplay?id=1900943.1 MoS Note 1549855.1 https://support.oracle.com/epmos/faces/DocumentDisplay?id=1549855.1
Configure Resource PoolsStandardize using Pools Deploy • PaaS Infrastructure Zone • One Host can be part of Only One Zone • Pool • Homogeneous collection of OH/DB/CDB w.r.t. PaaS Infra Zone, Platform, Database/FMW Configuration and Version • Targets within same member of a pool should share the same downtime 11.2.0.3 DB OH Pool 10.2.0.4 DB Pool Finance Zone 12c CDB Pool 11.2.0.2 RAC DB Pool HRMS Zone 10.2.0.5 DB Pool 11.2.0.2 RAC DB Pool Mfg Zone Delivering Database as a Service (DBaaS) using Oracle Enterprise Manager 12c http://www.oracle.com/technetwork/oem/cloud-mgmt/dbaas-overview-wp-1915651.pdf
Configure Load Balancer (Recommended)MWaaS Deploy • Using this option one can configure Oracle HTTP Server/Oracle Traffic Director/any Third Party Load Balancer
Configure Quota and PolicyQuota Management Deploy • Applies to only Databases/MWs provisioned through Self Service Portal • Although defined for Role, Quota applies to each user assigned to that role • Impacts adding users to a role • User is having multiple SSA roles • Quota for a resource is max of individual Quota for Resource for each SSA role • Counts Databases/MW instances provisioned • Down instances as well • Still using Resources
Configure Quota and PolicyDBaaS Placement Policy Deploy • Workload Management • Enable Resource Manager for SCaaS/PDBaaS • Manages the CPU resource and ensures that SSA user will not exceed allocated value • Specify Workloads Associated with Service Requests • Enable CPU_COUNT init.ora parameter for Snap Clone/ RMAN backup/DBCA template based profile • Ensures that database will NOT use CPUs more than given CPU_COUNT
Configure Quota and PolicyMWaaS Placement Policy Deploy • MWaaS Placement Policy Parameters are part of Service Template • Expected Memory Consumption • Expected CPU Utilization • Distribute Java Servers on Available Hosts
Configure Service CatalogCreate Profiles Deploy • Captures Source Database/MW Information • Configuration/Metadata • Data • DB/MW Profile Options • Snapshots - Weblogic Domain Provisioning Profile • RMAN Backups • Database Template • Export Schema Objects • Clone DB
Configure Service Catalog Create Service Template Deploy DBaaS MWaaS
Configure Chargeback Deploy • Use PaaS Infrastructure Zones as Top level Target for Assigning Charge Plan and Cost Center • All Child Instances inherits the plan of its nearest ancestor unless explicit Charge Plan and Cost Center are assigned
Rapid Start KitSingle Command Starter kit (DBaaS) Deploy • Create Cloud Admin, SSA Admin and SSA User custom roles • Create Cloud Admin, SSA Admin and SSA Users • Grant Quota to SSA User custom roles • Setup Zones with Placement Policy Constraints • Setup Pools with Placement Constraints • Setup Service Template/Catalog and grant SSA User custom roles
Rapid Start KitSetup and Usage Deploy • Location <MW Home>/ plugins/oracle.sysman.ssa.oms.plugin_12.1.0.8.0/dbaas/setup • Use dbaas/setup/exadata_cloud_setup.py for Exadata • Use dbaas/setup/database_cloud_setup.py for other platforms • Input files • cloud_boundary XML - defines the cloud topology of zones and pools along with host name and oracle home location • Cloud_input XML – defines users, roles, profiles, service templates, etc • Invoke the script • emcli @database_cloud_setup.py -pdbaas -cloud_boundary=/tmp/boundary.xml -cloud_input=/tmp/inputs.xml
Snap Clone Architecture Deploy Host A /clone1 [nfs] PaaS Infrastructure Zone /clone2 [nfs] pool1 zfshost:/pool1/vol1 Host An zfshost Solaris 11.1 host Storage Management Framework (SMF) 12.1.0.4.0 - Best Practices & Troubleshooting Guide https://support.oracle.com/epmos/faces/DocumentDisplay?id=1918255.1 LUN grouped and mounted as Pool
Manage and Optimize Management and Monitoring of Platform
Management of Platform Patch/Upgrade Manage • All Provisioned Targets within a Resource Pool should be patched together • SSA Admin Driven • CPUs, PSUs, Bundle Patches and other Interim (one-off) Patches • Does not update DB release version information • Adopt the latest GI PSU patch • Use EM Patch Plan and apply PSU patch in rolling mode 12c: Patching Recommendation Guide for DBaaS Pool(s) https://support.oracle.com/epmos/faces/DocumentDisplay?id=1625014.1
Optimize Monitor and Optimize PlatformZones/Pools/Meter Resource Utilization • Monitor Zones/Resource Pool for Resource Utilization using Enterprise -> Cloud -> Middleware and Database Home -> Select Zone/Resource Pool
References • Documentation • Enterprise Manager 12c Cloud Administration Guide • Screenwatches • Cloud Management EM 12c Screenwatches • White papers • Oracle Cloud Management Pack for Oracle Database • Delivering DBaaS using Oracle Enterprise Manager 12c • Blogs • Planning Database as a Service Implementation Project • What is EM 12c DBaaS Snap Clone? • Limit Self Service User Access to Database Self Service Portal • EM12c Release 4: Database as a Service Enhancements • Database as a Service: Glad that you asked these! • Steps to Fast Track your Database Cloud implementation on Exadata
Enterprise Manager One Hour Hands-On LabsMonday 9/29 at Hotel Nikko
Enterprise Manager One Hour Hands-On LabsTuesday 9/30 at Hotel Nikko
Enterprise Manager One Hour Hands-On LabsWednesday 10/1 at Hotel Nikko
Enterprise Manager One Hour Hands-On LabsThursday 10/2 at Hotel Nikko
Patch Manage • Patch Categories • Type ‘A’: CPUs, PSUs, Bundle Patches and other Interim (one-off) Patches • Type ‘B’: Patchsets