Accelerate Database-as-a-Service for DevOps across on-premises and cloud

January 29, 2024 | 3 minute read
Sravanth Mouli
Senior Product Manager - Enterprise Manager
Text Size 100%:

The traditional approach to database management created silos between database administrators and developers and is no longer relevant. The DevOps model of database management, known as Database-as-a-Service, helps break down these silos by creating a streamlined and efficient agile model. The flexibility, scalability, and simplicity of this self-service model are key in the world of DevOps.

Oracle Enterprise Manager (EM), a feature-rich monitoring and management solution, provides hybrid multi-cloud capabilities. EM allows you to consolidate resources across hybrid environments that range from on-premises, Exadata Cloud, Oracle Cloud, and other public clouds, to build a dedicated secure and private hybrid database-as-a-service.

With EM, a DevOps user, like a developer, and QA can deploy a secure database on-demand without dependence on database administrators. This is accomplished either via a self-service user interface or automated using comprehensive REST APIs. For automation, use any of the tools like Ansible, Terraform, or Chef, in addition to orchestration engines like ServiceNow Orchestration.

EM Model
Figure 1:  Oracle Enterprise Manager Monitoring and Management solution

 

Key benefits of database management in the DevOps model 

  • Enhanced security and compliance: Enable users to deploy secure databases on-demand by default, thus reducing vulnerabilities 
  • Reduced costs: Maximize resource utilization spanning on-premises, Exadata Cloud, and cloud
  • Ease of use: Self-service interface for rapid deployment and reducing administrative overhead

 

It is easy to deploy Hybrid Database-as-a-Service. Here is a quick insight.

A Cloud Administrator is responsible for setting up the backend for Database-as-a-Service. Typical steps are:

  1. Create Infrastructure zones and database pools.
  2. Build standardized secure service templates to provision or clone.
  3. Integrate chargeback to manage usage costs.
  4. Add approval layers using 'Request settings', if required

 

Sravanth GIf

 

As a DevOps user, you can: 

  • Provision or clone secure template from the service catalog
  • Patch, backup, restore, and delete databases.
  • Create a profile of the database, and restore with data on-demand based on requirements.
  • Rapidly clone large databases with significant space saving using Snap Clone functionality. 
  • Monitor performance and utilization of the database, scale up and scale down based on demand. 

Gif2

 

 

Enterprise Manager plays a crucial role in many customers' infrastructure and database operations. There has been a broad adoption of the DevOps-centric model in recent years, resulting in agility and fast time-to-market. This blog showcases how Comcast has enabled a developer-centric ecosystem by leveraging a Database-as-a-Service solution. Also, check out this session “Safeguarding Databases: Comprehensive Monitoring and Vulnerability Assessment” which we co-presented with Comcast in Oracle Cloud World 2023 explaining their use cases and implemented solutions using Enterprise Manager.

Resources

Sravanth Mouli

Senior Product Manager - Enterprise Manager


Previous Post

Reduce Database patching effort and elevate security posture with Enterprise Manager

Romit Acharya | 3 min read

Next Post


Optimize the user experience in real-time using OCI Application Performance Monitoring - Real User Monitoring

Daniela Hansell | 2 min read