Virtualized Oracle Databases on Datrium DVX Solution Brief

Oracle Database environments run better with Datrium DVX Open Convergence platform

HIGHLIGHTS

  • Simpler administration of virtualized Oracle instances, simpler scalability as needs grow
  • Insane performance – deploy production level, virtualized Oracle database solutions – easily support mixed workloads (OLTP/OLAP)
  • Improve time to market by accelerating development and test related tasks through better copy data management
  • Better infrastructure economics – more choices and optimal use of compute and storage resources

THE CHALLENGE

Virtualizing Oracle database solutions may help leverage utilization of system resources but often does not simplify administration and can adversely affect the performance of the end solution. With traditional storage solutions, IT and database administrators still face challenges with tuning or troubleshooting as the application VM, ESXi host and storage are typically managed separately. Managing data growth or consolidation of databases is often more problematic with LUN-based solutions that need to account for sizing, placement and performance considerations. The dependencies between VM, host and storage are difficult to isolate and manage – even with HCI based systems. The key components of an Oracle environment including production and dev/test, might look something like Figure 1.

Figure 1

 

THE SOLUTION

Virtualizing an Oracle database solution on Datrium DVX can help simplify the administration of the overall system, accelerate performance through proper placement of resources and leverage robust integrated backup capabilities which complement Oracle RMAN and Data Guard. Take advantage of Split Provisioning allowing for processing horsepower and database capacity to be addressed and scaled independently but within the same integrated DVX system. Moving flash to the host for active data improves performance at the same time protecting the data on a shared platform between the database hosts provides resiliency, security and sharing in a cost effective package. With Open Convergence, each host operates its own workloads independently from the others and can be constructed to meet the task requirements of the VMs deployed – for example production OLTP, data warehouse, development/test or reporting.

 

KEY BENEFITS

Simple to manage, simple to grow

With DVX, Oracle VMs are managed at the VM level – storage is managed along with the VM as vdisks – no RAID, LUNs, or volumes to deal with. Easily add hosts (Compute Nodes) to the DVX to run more Oracle VMs if needed. Add bigger hosts if more database performance is desired. Database I/O is local on host flash and this in turn increases performance and reduces latency. With data services like erasure coding, compression and deduplication always on, there is zero cluster configuration so adding new hosts and workloads into the DVX is effortless. If more database capacity is needed, simply add more flash to the Compute Node(s) for the local instances or add more Data Nodes to the DVX to get more overall capacity shared by all hosts. The Datrium User Interface is integrated into vCenter so you can focus on managing your VMs and database applications instead of managing the storage. Monitor the I/O at the VM, hypervisor host or entire cluster level just like other resources to ensure optimal use.

 

Insane performance – deploy production level, virtualized Oracle database solutions

With the Datrium DVX solution, hypervisor I/O performance is accelerated and latency is reduced through the leverage of abundant and affordable local flash on the host. Running databases on flash is a key way to modernize and improve results. Moving the flash storage onto the host and avoiding network latencies and host VM I/O queue depths improves performance even more. With DVX, I/O processing and active data resources are server-based. Servers provide I/O processing resources and reads stay local on host flash for maximum speed. VM performance benefits from flash-resident transactions that now have 50%-80% lower latency and up to 5x faster database queries than traditional SAN based alternatives.  Easily consolidate virtualized Oracle OLTP (transactional) and OLAP (analytical) databases onto hosts in a single virtualized solution and never deal with LUN provisioning or LUN tuning again.

 

Improve time to market

In addition to simpler management and better performing databases, software development cycles can be accelerated through better copy data management. Datrium DVX built-in snapshot and replication capabilities can be exploited beyond basic backup / protection use cases and provide faster and simpler methods to share or move database content within the environment. Snapshots and clones can be leveraged to reduce data handling time and capacity as development and test activities bridge into production and reporting tasks. Snapshots are quick and simple and clones are available immediately to other users without physically moving any data from one server to another. Less time spent moving data results in faster cycle times in development. Working beyond a single DVX site to another DVX, either on premise or in a public cloud, can be facilitated with replication features.

 

Better infrastructure economics

Flexibility on host side (Compute Node) selection is reinforced with the Open Convergence model letting organizations deploy host resource from existing properly equipped systems or new systems to meet performance objectives. Database license savings are possible by combining lower core count, higher frequency servers with the flash-based DVX to achieve necessary performance on fewer cores (and therefore software licenses). The Datrium DVX system utilizes always-on compression, data deduplication and erasure coding for an incredibly efficient data storage platform both on the host flash and within the Data Node backup copy.  This data reduction handling also spans into the replication between sites saving bandwidth.

 

CONCLUSION

With Datrium DVX Open Convergence platform along with virtualized Oracle applications, IT and Oracle administrators can rest assured that they have the right mix of better performance, higher availability, simpler manageability and infrastructure economics to meet the demanding database application needs of today’s modern virtualized data centers.

For More Information:

Datrium Technology Partners: https://www.datrium.com/partners/technology-partners/

 

Download Solution Brief

y:inline;"> line;">