The DBA’s challenge: Simplify administration of complex workloads to achieve scale and agility.
John Mishriky does a great job describing the converged database and, in this webinar, he asked me to talk about the managing aspects of converged workloads. Oracle has made a point of simplifying the database landscape for DBAs by incorporating new datatypes into one architecture. That means you are not standing up a myriad of different database types, each with their own tools and process, then figuring out how to integrate the data together, not to mention managing the new implementations along with everything else you’re doing.
The challenge of single-purpose databases is the overhead.
Innovations in The Oracle Database
This webinar is about innovations in the Oracle database as well as database management in the new world. It is a part of the Oracle Converged Database Virtual Event Series focused on Oracle’s strategy to converge new database workloads into a single database.
Database Administration Strategies
In this session, we’ll focus on administrative strategies to simplify the work, scale efforts and minimize human error and security vulnerabilities all while improving availability and performance.
This figure helps show how the converged database solves the integration and maintenance sprawl of single datatype or single-purpose databases with the converged database. Integration and simplified operations are built into the converged database.
Unlike the requirement for an application with multiple single-purpose databases, developers don’t have to address the integration of datatypes with a converged database. Instead, they can directly focus on application logic, which means they can develop more services and deliver them faster.
Microservice-based applications access their required datastore via PDBs which are all isolated from each other. The PDB is housed in the CDB where the multitenant database can be managed as one.
Managing Converged Workloads
Oracle Enterprise Manager is, in effect, the management tool for the Oracle Database and Engineered Systems. It is deeply integrated in the Oracle Database providing extensive automation capabilities and visibility across all variations of deployment on premises or cloud. Its unique integrated design enables DBAs to conduct entire workflows within a single tool. Additionally, the architecture is designed to be implemented incrementally, adding functionality based on the maturity of the DBA team, and the scope and pace of the work required. Much of what DBAs find valuable about Enterprise Manager is using automation to do more work, faster, with less risk.
When looking at managing a typical workload for a DBA, common tasks include:
Typical Database Management Use Cases
The first use case focuses on improving performance and availability which entails quickly diagnosing problems or potential problems, tuning them out, then validating the resulting fix before pushing to production
Find, Fix, Validate
Managing performance and availability means monitoring for issues, then troubleshooting to find the root cause. Enterprise Manager enables this with interactive dashboards automatically highlighting areas of concern. Automation plays a role in providing recommended fixes with tools like SQL Tuning Advisor. Finally, validation is an important step, ensuring the predicted fix actually delivers the expected results. Enterprise Manager Real Application Testing DBA Heroes Validate Performance Before Committing Updates, Upgrades, and Migrations can record a production database workload, then replay that workload against the updated or patched database, ensuring low risk when pushing updates to production.
To achieve the pace, the scale, the repeatability required to manage a fleet of databases requires a lot of hands or automation. While most teams struggle to hire additional headcount, the advantage DBAs turn to is automation built into Enterprise Manager How to Patch and Upgrade Your Databases at Scale .
Database Lifecycle Management Automation
While DBAs react to performance or availability issues, there are many operations that can be planned and facilitated. These often go better with Enterprise Manager automation. Automation for steps including security and compliance checks, provisioning, patching, and managing configurations Turbocharge Your Database Provisioning: Use Enterprise Manager Lifecycle Management to Increase Efficiency, Consolidation and Standardization . Supporting the database environment for development teams has become more important than ever, as releases move faster and faster. Enterprise Manager can be leveraged for delivering a self-service database portal for development teams to control their own ability to stand up and tear down development environments using DBaaS capabilities Database Automation Using Self-Service Database Provisioning
Bringing It All Together
While the engineering technology each component is impressive individually, then when you look at all these components together, you really see the synergy of the overall design. Here, we’re talking about the confluence of Multitenant databases running on Exadata and all orchestrated and managed from Enterprise Manager automation. The best platform to consolidate the Oracle Database is using the Multitenant database running on Exadata (all managed with Enterprise Manager) is designed to deliver the highest performance at the lowest cost. That means customers can deliver new updates and move rapidly in their market, all while being efficient and effective and secure. Securing Your Oracle Databases To Industry Standard CIS Benchmark
Enterprise Manager itself is built on a monthly release update schedule. New features are added monthly. One way to get a quick look at the latest version is to use the Oracle Cloud Marketplacep. From here, DBAs can be running with full instances of Enterprise Manager in under an hour. There are many choices for implementation from simple single instance to full HA configurations.
The blogs and webcast series are technical deep dives if you want the detailed how-to descriptions and uses.
Oracle Database: https://blogs.oracle.com/database/
Enterprise Manager: https://blogs.oracle.com/oem/
Webcast and Streaming Series
LiveLabs Workshop Series