Find Communities by: Category | Product

 

facebook_button-30.png

twitter_button-25.png

email_button-30.png

linkedin_button-30.png

 

I was discussing about different features of FEHC3.1 software and solution in the last few blogs. They were


Overview of Key Components of FEHC 3.1 for Oracle

Overview of Oracle DBaaS Solution in FEHC 3.1

Oracle DBaaS Day 2 Operations

Monitoring Oracle DBaaS

 

After writing the above blogs, I felt that a summary is required to appreciate the good features of the solution. Hence, I planned for this blog.

 

The solution uses the best of EMC and VMware products and services to deliver on the following principles:

  • Self-service and automation
  • Multitenancy and secure separation of tenants
  • Workload-optimized storage
  • Security and compliance
  • Monitoring and service assurance

 

This solution enables the deployment of Oracle DBaaS in a dedicated business group running on Federation Enterprise Hybrid Cloud. The key findings of this solution are as follows:

 

Compliance - Designing Federation Enterprise Hybrid Cloud with a dedicated Workload Pod for Oracle DBaaS improves management of Oracle licensing compliance.

 

Self-Service - Application developers and service users can provision an Oracle Database, with monitoring and data protection (backup and DR), directly from the vRealize Automation Service Catalog for Day 1 operations.

 

DBaaS Day 2 Operations - The solution offers elasticity and support for Day 2 operations. Resources, services, and maintenance operations can be managed from vRealize Automation. For example, through the vRealize Automation portal, service users can:

  • Increase vCPU or memory or storage
  • Add and remove Oracle DBaaS monitoring
  • Add, remove and schedule backup services for Oracle DBaaS
  • Backup and recover an Oracle Database 11g or 12c

 

Automation - vCenter Orchestrator enables process automation throughout the machine provisioning lifecycle in vRealize Automation.

Rapid Deployment - Using vRealize Automation Application Services, DBAs and application architects can quickly build and publish blueprints with a drag-and-drop interface to automate the deployment of simple and multitier applications.

 

 

 

ll1.png

Figure 1. Federation Enterprise Hybrid Cloud dual-site CA topology

 

Continuous Availability - Figure 1 depicts the conceptual configuration of the Federation Enterprise Hybrid Cloud CA dual-site/single vCenter topology. This topology hosts the same components within each of the pods, but enhances the single-site topology by including EMC VPLEX and vSphere metro storage cluster technologies to protect all the management and workload across data centers.

This Federation Enterprise Hybrid Cloud solution enables customers to build an enterprise-class multitenant, scalable, platform for complete infrastructure service lifecycle management. This solution provides on-demand access and control of infrastructure resources and security while enabling customers to maximize asset utilization. Specifically, the solution integrates all of the key functionality that customers demand of a hybrid cloud and provides a framework and foundation for adding other services in the DBaaS environment.

 

Lastly from the DBA perspective, it has fulfilled the following purposes which are very much beneficial to the DBAs:-

  • Complete management of the database service lifecycle.
  • On-demand access to and control of network bandwidth, servers, storage, and security which are very critical to any database operations.
  • Provisioning, monitoring, protection, and management of the database services by the line of business users, without IT administrator involvement.
  • Provisioning from application blueprints with associated infrastructure resources by line-of-business application owners without IT administrator involvement.
  • Provisioning of backup, continuous availability (CA), and DR services as part of the database service provisioning process in the cloud environment.
  • Maximum, effective and optimal usage of the infrastructure assets.

 

 

Follow us on Twitter:
EMCOracle.png

Tweet this document:

Want to learn about the summary of good features & functionalities of FEHC 3.1 from DBaaS perspective?Click here-->http://bit.ly/1OAgH17

Click here to learn more:

store_open.png

 

facebook_button-30.pngtwitter_button-25.pnglinkedin_button-30.pngemail_button-30.png

Indranil

Oracle DBaaS Day 2 Operations

Posted by Indranil Dec 31, 2015

 

facebook_button-30.png

twitter_button-25.png

email_button-30.png

linkedin_button-30.png

 

In my previous blog I was talking of the initial provisioning operation for setting up the DBaaS. This is a day 1 activity. In the Day 2 activity of the DBaaS setup operation we will be performing some more different activities as we discuss below.


Oracle DBaaS Day 2 operations

 

After the Oracle Database and virtual machine are provisioned, environmental and configuration changes are required. These post- Day 1 provisioning activities, which are known as Day 2 operations, include routine maintenance tasks and changes to the virtual infrastructure and application services. This can be as simple as restarting the virtual machine, but also include changes that can affect the availability or cost of the service, such as adding vCPUs, memory, or disks.

These post-provisioning operations were developed as vCenter Orchestrator workflows which are then published to the vRealize Automation service catalog as resource actions . Where the resource actions impact service availability and/or cost, an approval policy was applied. For this solution, the operations include:

  • Add vCPU to a virtual machine
  • Add memory to a virtual machine
  • Add storage to a virtual machine
    • The average tenant resource virtual machine specification is 1 vCPU, 2 GB RAM, and 100 GB disk.
  • Add/Remove Oracle DBaaS Backup
    • Using EMC customizations for VMware vCenter Orchestrator workflows, DBAs can quickly and easily define multitier data protection policies that users can assign when provisioning their virtual machines. The backup infrastructure takes advantage of EMC Avamar and Data Domain features such as deduplication, compression and VMware integration.
  • Add/Remove Oracle Enterprise Manager monitoring

OEM12c Agent which is the principal components to gather statistics and the status of the target objects needs to be added to the vCenter Orchestrator workflow by “Add OEM 12c Agent” operation and then published to the vRealize Automation portal where the same will be available as an action on the context menu for an Oracle DBaaS VM as demonstrated in Figure 1.

ll1.png

Figure 1. vCenter Orchestrator workflow Add OEM 12c Agent published as a vRealize Automation resource action

 

 

 

  • Add/Remove Oracle Startup Service
    • This starts and stops the oracle startup/shutdown services automatically.

 

 

 

Summary

 

 

Day2 operations for the setting up of Oracle DBaaS is the most important part as the tuning of the above constituent parts are responsible for the better database performance, scalability ,protection, availability and robustness. EMC technologies along with the VMWARE products like vCenter Orchestrator make this solution cost effective, automated and self-monitored.

 

Pls. read my blog on Summary of FEHC 3.1 for Oracle.

 

 

Follow us on Twitter:
EMCOracle.png

Tweet this document:

Many activities happen on Day 2 of Federation Enterprise Hybrid Cloud Solution. Learn more here --> http://bit.ly/1RU1JTS

Click here to learn more:

store_open.png

 

facebook_button-30.pngtwitter_button-25.pnglinkedin_button-30.pngemail_button-30.png

Indranil

Monitoring Oracle DBaaS

Posted by Indranil Dec 31, 2015

 

facebook_button-30.png

twitter_button-25.png

email_button-30.png

linkedin_button-30.png

 

In my last blog I was talking about the DBaaS as a service in the Enterprise Hybrid Cloud perspective. Here in this blog, I would like to highlight how we can monitor this particular solution via Oracle Enterprise manager cloud control 12c or some other related tools. Let us now do a deep dive to understand how monitoring is performed and implemented for the Federation Enterprise Hybrid Cloud Solutions(FEHC).

 

A number of monitoring options are available when deploying Oracle DBaaS:

 

The vRealize Operations Management Pack for Oracle Enterprise Manager from Blue Medora uses Oracle OEM data to monitor Oracle environments and workloads through vRealize Operations Manager, providing visibility of the full stack from the database down.As shown in Figure 1, heat maps and colored badges help us to immediately identify the status of the database, virtual machine, OEM , ESXi hosts, and VMFS datastores in the Oracle OEM environment.

ll1.png

Figure 1. Dashboard view of OEM environment in vRealize Operations Manager

 

 

 

This solution features automated monitoring capabilities that provide IT administrators with a comprehensive view of the cloud environment to enable intelligent decision making for resource provisioning and allocation of databases. These capabilities are based on a combination of VMware vRealize Operations Manager dashboards, alerts, and analytics, using extensive storage detail provided through EMC analytics adapters for ViPR, VNX, and VMAX and EMC VPLEX.

 

vRealize Operations Manager provides pre-built and configurable dashboards for real-time performance, capacity, and configuration management. Performance data is interpreted and assigned a health risk value, and efficiency metrics that enable IT administrators to easily identify evolving performance problems.

 

The ViPR Analytics and EMC Storage Analytics (ESA) management packs are presented through the vRealize Operations Manager custom interface. This enables administrators to quickly identify the health of EMC ViPR virtual arrays as well as VMAX, VNX, XtremIO, and VPLEX storage systems using customized EMC dashboards for vRealize Operations Manager, such as the EMC ViPR dashboard, as shown in Figure 2.

 

ll2.png

Figure 2. EMC ViPR Analytics with VMware vRealize Operations Manager

 

EMC ViPR SRM offers comprehensive monitoring and reporting for this hybrid cloud with DBaaS solution that helps DBA visualize, analyze, and optimize their DBaaS infrastructure. Cloud administrators can use EMC ViPR SRM to understand and manage the impact that storage has on their applications and view the topologies of their hybrid cloud from application to storage. Capacity and consumption of database storage and SLA issues can be identified through real-time dashboards and reports in order to meet the needs of the wide range of oracle DBA requirements. In addition, VMware vRealize Log Insight provides the ability for centralization and aggregation. When configured with VMware vRealize Log Insight, EMC content packs for VNX and VMAX provide customizable dashboards and user-defined fields that enable DBAs to conduct problem analysis and analytics on the storage array and backup infrastructure.

 

 

 

In summary, there are many monitoring tools to supervise the Federation Enterprise Hybrid Cloud Solutions (FEHC). Dashboards provide us different configuration and performance information which enable DBAs to take proactive actions in the DBaaS setup. The most important piece is the one-stop-window monitoring of the entire infrastructure stack that enables DBAs to troubleshoot the performance and administration issues in a smooth, holistic and informative manner.  In a single sentence we can say that by few clicks we can get the control of the whole FEHC landscape by better GUI, advisory and user-friendly facilities.

 

Pls. read my blog on Summary of FEHC 3.1 for Oracle.

 

Follow us on Twitter:
EMCOracle.png

Tweet this document:

Learn about different monitoring options for  Federation Enterprise Hybrid Cloud Solution(FEHC) .Click here --> http://bit.ly/1mTA9cL

Click here to learn more:

store_open.png

 

facebook_button-30.pngtwitter_button-25.pnglinkedin_button-30.pngemail_button-30.png

 

facebook_button-30.png

twitter_button-25.png

email_button-30.png

linkedin_button-30.png

 

In my last blog I discussed the different components of Federation Enterprise Hybrid Cloud 3.1(FEHC). In this blog, I will look into the issue of DB Provisioning, Disaster Recovery (DR), Backup and the Recovery of the Oracle DB via DBaaS solution in FEHC 3.1. In recent times, we see many organizations are moving towards Database as a Service (DBaaS) model which facilitates and empowers many IT organizations to become leaner, more nimble and cost effective in terms of manageability, agility and scalability of its services. EMC’s hybrid cloud DBaaS solution delivers deep management and automation capabilities that span across the entire Database cloud lifecycle— right from configuration and change management to performance diagnostics and tuning. Additionally, it lets DBAs identify and consolidate pooled resources, setup role-based access & control, define its service methodologies and related chargeback plans for its operation, compliance and reporting purposes.

 

Under the above context of FEHC 3.1, let us now begin our discussion on a basic DBaas service --> Provisioning of the Oracle database.

 

In this solution, below are the services blueprints which are available for provisioning of an Oracle Database (also demonstrated  in Figure 1 below):

  • A service to mount an NFS share to serve Oracle binaries and custom scripts
  • A service to install the Oracle Software and configure an Oracle Database.
  • A service to ensure the Oracle Database starts and shuts down with the virtual machine
  • A service to install an agent to register the Oracle Database with OEM Cloud Control 12c
  • A service to unmount the NFS share
  • A logical template that defines a cloud virtual machine hardware and assigns a guest operating system

 

The above services are taken care by vRealize Application Services which enables IT Administrators and Application Architects to construct application blueprints by using a drag and drop GUI(Figure 1). An application blueprint defines the logical topology of an application for deployment in a virtual cloud. It combines the mapping of a virtual machine and operating system with the linking and ordering of predefined application services and components.

 

ll1.png

Figure 1. vRealize Application Services’ Application Blueprint

 

The completed application blueprint has been published and made available for consumption in the vRealize Automation Service Catalog as shown in Figure 2

 

ll2.png

Figure 2. Published application blueprints for Oracle DBaaS in vRealize Automation Service Catalog

 

 

Federation Enterprise Hybrid Cloud for DBaaS DR

 

Let us now look into the next DBaaS service --> Disaster Recovery(DR).

 

Disaster Recovery (DR) topology is an important component for any Oracle DB’s production environment as it guarantees continuous availability and “any point in time” recovery. By including EMC RecoverPoint and VMware Site Recovery Manager Technology, the solution enhances the single-site topology across data centers to protect the relevant management and workload pods which is defined as a physically distinct vSphere cluster with its own servers, network, and storage resources - separate from all others. The complete architecture has been demonstrated in Figure 3.

ll3.png

Figure 3. Federation Enterprise Hybrid Cloud dual-site DR topology

 

In this configuration, each site has its own distinct Core and NEI Pods. However, the Automation Pod that supports the cloud workloads, and the cloud workloads themselves, can be recovered on the secondary site through the VMware Site Recovery Manager framework.


Oracle DBaaS backup and recovery

 

Let us now look into the next DBaaS service --> Oracle DBaaS Backup and Recovery(DR).

 

Consistent backup and recovery are a key requirement for Oracle DBaaS on FEHC. Oracle Recovery Manager (RMAN) is the standard mechanism for backup and recovery of Oracle Database. The EMC Avamar Plug-in for Oracle works with RMAN to deliver fast, space-efficient backup for each EMC Avamar tenant backed by Data Domain.

 

The Federation Enterprise Hybrid Cloud 3.1 Oracle DBaaS solution Application Blueprint includes a backup and recovery service that configures an automatic, scheduled backup of the Oracle database to an Avamar backup server or cluster. In addition, vRealize Automation Resource Actions are included to provide the following functionality:

  • Add and remove a scheduled full RMAN backup with a standard retention period for Oracle DBaaS as part of Day 2 operations
  • Request an on demand full RMAN backup of Oracle DBaaS to EMC Avamar backed by Data Domain
  • Request a point-in-time restore of the Oracle database based on backup time

 

All of these actions are implemented as vCenter Orchestrator Workflows published to vRealize Automation as resource actions. These are requested from the vRealize Automation portal “as actions” from the dropdown menu as shown in Figure 4.

ll4.png

Figure 4. On Demand backup of an Oracle database Resource Action

 

A point-in-time restore of the Oracle database, based on the backup time, is available as a Resource Action and is shown in Figure 5

 

ll5.png

Figure 5. Restore Oracle database backup from vRealize Automation Portal

 

In summary, implementation of DBaaS via FEHC 3.1 is very much simple, fast, integrated and indispensable solution in today’s IT (Database) landscape. With this solution we derive a plethora of benefits in terms of database provisioning, administration, DR, backup, and recovery via self-explanatory GUIs which effectively shields the complexities of the above database operations. Additionally, it makes each database operation nimble, fast, cost-effective and user-friendly.

Please read my next blog on monitoring FEHC 3.1.

Also, a blog on Day 2 operation for FEHC 3.1 provisioning

Pls. read my blog on Summary of FEHC 3.1 for Oracle.

 

Follow us on Twitter:
EMCOracle.png

Tweet this document:

Want to learn about different DBaaS functionality offered via Federated Enterprise Hybrid Cloud Solution 3.1? Click  http://bit.ly/1QZ4TpH

Click here to learn more:

store_open.png

 

facebook_button-30.pngtwitter_button-25.pnglinkedin_button-30.pngemail_button-30.png

FEHC

 

facebook_button-30.png

twitter_button-25.png

email_button-30.png

linkedin_button-30.png

 

On Sept. 25, 2015, EMC released the new version of the Federation’s Enterprise Hybrid Cloud (EHC) solution. EHC is a wonderful invention and joint collaboration among VMware, EMC, RSA, VCE, Virtualstream and Pivotal to accelerate the adoption of a cloud services model for both private and hybrid clouds. It is an antidote to many current days’ challenges mentioned below:-

  • Inefficiency and inflexibility
  • Slow, reactive responses to customer requests
  • Inadequate visibility into the cost of the requested infrastructure
  • Limited choice of availability and protection services

 

The difficulty in overcoming these challenges has given rise to public cloud providers who have built technology and business models catering to the requirements of DBAs agility and control. Many organizations like banking sectors are under pressure to provide these same service levels of DBs within the secure and compliant confines of the on-premises data center within the shrinking budget. As a result, DBAs and IT department need to think of alternative cloud solutions from database perspective that are cost effective and do not compromise database requirements such as data protection, disaster recovery, and guaranteed service levels.

 

VMware products and services, and provides customers with increased agility, reduced OPEX to deliver database as a Service (DBaaS) in a jiffy.As a DBA we can get the following benefits from this solution (also demonstrated in Figure 1):

 

  • Automation and self-service provisioning thereby bringing down the database provisioning time.
  • To provide Multitenant architecture similar to 12c database.
  • Workload-optimized storage with special focus to IOPS.
  • Monitoring and resource management with EM 12c monitoring tools.
  • Metering and chargeback as a part of DBaaS.
  • EMC and VMware integration so as to provide infrastructure for database virtualization.

ll1.png

Figure 1 : Federation Enterprise Hybrid Cloud features and Functionality-


In this and in the subsequent blogs I am going to discuss about this solution which consists of the following components:-

  1. VMware vRealize Suite.
  2. VMware vSphere ESXi and VMware vCenter Server. (DB Virtualization Control).
  3. VMware vCloud Networking and Security networking (DB Security)
  4. VMware NSX for vSphere. (Networking Virtualization).
  5. VMware vCenter Site Recovery Manager (Database DR only)
  6. EMC ViPR software-defined storage
  7. EMC VNX, VMAX, ScaleIO, VPLEX, Isilon, and XtremIO storage platforms
  8. EMC RecoverPoint (Database DR only)
  9. EMC Avamar and Data Domain data protection platforms (DB Backups)
  10. EMC ViPR SRM and Data Protection Advisor.

ll2.png

 

Figure 2 : Federation Enterprise Hybrid Cloud solution components

 

In this solution we have a special case where this solution can be used Database as a Service(DBaaS) as demonstrated in Figure 2. In summary, we get the following features of the Federation Enterprise Hybrid Cloud when using Oracle Database 11g and/or 12c with the ITaaS platform to deliver the following DB functionalities (Database as a Service):

  • Provisioning, Backup and recovery of Oracle DBaaS through the vRealize Automation portal using vRealize Automation Application Services and, optionally, vCenter Orchestrator packages to configure external services
  • Monitoring the Oracle DBaaS using OEM Cloud Control 12c Release 2 is optional and can be integrated with VMware vRealize Operations Manager using a third party plugin for full stack monitoring.
  • Service maintenance (Day 2 Operations) through the vRealize Automation portal VMware vCenter Orchestrator packages
  • A Linux virtual machine, residing within the Oracle Workload Pod, acts as an NFS share and artifact repository for required Oracle Database binaries, custom scripts, and component files.

 

 

I will be talking on the above functionalities in the next blogs.

Pls. read my blog on Summary of FEHC 3.1 for Oracle.


 

 


 

Follow us on Twitter:
EMCOracle.png

Tweet this document:

Want to learn about the components of Hybrid Cloud Solutions for OracleDBaaS? Read here --> http://bit.ly/1mevFO0

Click here to learn more:

store_open.png

 

facebook_button-30.pngtwitter_button-25.pnglinkedin_button-30.pngemail_button-30.png

Filter Blog

By date:
By tag: