Home > Blogs > Virtualize Business Critical Applications


Oracle 12c OLTP & DSS workloads on Virtual SAN 6.2 All Flash

Hey Oracle on VMware folks!!!

Earlier, we had blogged about Oracle RAC on VMware Virtual SAN Hybrid which is VMware software-defined storage solution for hyper-converged infrastructure and is available at Oracle RAC on Hybrid VSAN

In this blog post, we would like give you a glimpse of the “Oracle 12c OLTP workloads on VMware All Flash Virtual SAN 6.2”.

As some of you may know, in VMware Virtual SAN 6.2, we introduced a suite of new features for data integrity and space efficiency including Checksum, Erasure Coding, Deduplication and Compression. Using these features we developed an architecture for deploying and running Oracle 12c OLTP and DSS workloads on VMware All Flash Virtual SAN 6.2.

Before going into some of the results, let’s take a look as to why it is compelling to deploy heavy IO Oracle workloads on a VMware Virtual SAN All Flash solution.

  • Extreme Performance – Virtual SAN is built into the vSphere kernel which optimizes the I/O path to provide excellent performance.
  • Built in Data Reduction Technologies – Deduplication, Compression and Erasure Coding reduces data footprint and lowers cost, both capex and opex, further lowering the TCO of the solution.
  • Availability for Business Critical Applications – Minimizes downtime with features like vMotion, vSphere HA, Virtual SAN Stretched Clustering.
  • Redundancy for Business Critical Applications – Provides high level of redundancy thereby avoiding single point of failures (SPOF) with features like Failure to Tolerate (FTT), Fault Domain

Oracle 12c OLTP on Virtual SAN All Flash 6.2 Solution test environment

 We built out a 4-node All Flash Virtual SAN Cluster with two Virtual SAN disk groups in each ESXi host, 2 different VM sizes (Medium=4 vCPU/64GB RAM and Large=8 vCPU/96GB RAM) were used. Oracle Linux 7.0 operating system was used for database VMs with Oracle 12c Database (12.1.0.2.0) as the database version.

 OLTP Oracle workload using SLOB

This test focuses on extremely heavy Oracle OLTP like workload behavior on Virtual SAN.

SLOB was used to generate the OLTP workload against each of the 4 Oracle VMs for 60 minutes (2 Large VMs and 2 Medium VMs). Workload was a mix of 75% reads and 25% writes to mimic a transactional database workload.

A VM was placed on every ESXi host in the 4 node Virtual SAN cluster as shown in the figure below.

 

Oracle on vSAN AF

Several Virtual SAN configurations were tested to understand the IO performance and resource consumption using the new features in Virtual SAN 6.2.

For this blog, we’ve extracted 2 of those test configurations. First is the baseline R1; this is a configuration without any new features enabled.  The second configuration is (R15+C+SE) with several features enabled in 6.2.

 

The below table provides the details for these configurations.

 

Table

 

The below test results are specific to the configuration setup used in this solution and the SLOB workload deployed.

 

Figure 2

 

OLTP Baseline (R1) Performance:

Virtual SAN Configuration R1 is used as the baseline performance for the OLTP tests. In the baseline test, IOPS generated by the four oracle database VMs during the test reached a peak of 100,000 IOPS with average of 95,000 IOPS.

The total storage used was around 3.7TB without Space Efficiency features (Compression, Deduplication & Erasure Coding)

This shows that Virtual SAN storage provides a reliable performance for a business critical application like Oracle despite high intensity of the workload. R1 Configuration test shows the average read and write latency is 4ms and 17ms respectively. Latency is relatively low for this solution considering the extremely heavy IOs generated concurrently by four oracle databases.

OLTP R15+C+SE Performance:

This configuration is a common practice used in industry, where the log disk is mirrored using RAID 1 and data disks are configured for Raid 5. This provides substantial space savings offered by Erasure Coding.

Since Erasure coding is a storage policy it can be independently applied to different virtual machine objects providing simplicity and flexibility for configuring this type of workload. While erasure coding provides a predictable amount of space savings, deduplication and compression provides a varying amount savings. The space saving obtained due to deduplication and compression is highly dependent on the application workload and data set composition.

With the Space Efficiency Features enabled, VMware Virtual SAN is still able to deliver over 72,000 IOPS, a reduction of 24 percent with respect to the Baseline (R1).

However, this configuration provided the space efficiency of over 50% reducing the space consumed to 1.7TB which was contributed by Erasure Coding (R5), Deduplication and Compression.

Remember, the total storage used in the OLTP Baseline (R1) baseline test was around 3.7TB without Space Efficiency features (Compression, Deduplication & Erasure Coding)

The average read and write latency observed was 6.3ms and 23.6ms respectively. This test was run under peak IO utilization scenario with concurrent workload from 4 OLTP databases. Typical real-world environments should have lower I/O latencies. This Virtual SAN configuration (R15+C+SE) provided the best combination of performance and storage efficiency.

During this test

  • Resource overhead (CPU and Memory) observed due to space efficiency and checksum feature was minimal
  • Average ESXi CPU utilization increase in the R15+C+SE was minimal (3.1% percent)
  • Memory overhead was negligible

Figure 3

 

The above tests validate VMware Virtual SAN as a viable option for running Oracle workload using space efficiency features released in Virtual SAN 6.2 lowering the TCO.

The reference architecture also goes into Oracle DSS like workloads on All Flash Virtual SAN 6.2

The reference architecture paper can be found here

This entry was posted in ESXi, Oracle, Uncategorized, vSphere on by .
Sudhir Balasubramanian

About Sudhir Balasubramanian

I’m currently a Staff Solution Architect – Data Platforms working in the Global Field and Partner Readiness team at VMware focused on Oracle Technologies. I have 20+ years hands on experience with Oracle Technologies having worked as an Oracle DBA & Architect, Oracle RAC/Data Guard Expert . I am also experienced in EMC SAN Technologies having worked as an EMC SAN Administrator. Principal Oracle DBA/Oracle Architect (1995 – 2011) [ Sony Electronics, Teletech Corp, SAIC, Active Network, Sempra Energy Holdings] , VMware [2012-] Member of CTO Ambassador Program VMware vExpert VMware VCA – Cloud VMware vBCA Specialist I am also the Author of “Virtualize Oracle Business Critical Databases” which is a Comprehensive authority for Oracle DBA’s on the subject of Oracle & Linux on vSphere I am a recognized Speaker@ Oracle Open World, IOUG, VMworld, VMware Partner Exchange, EMC World, EMC Oracle Summit and various other Webinars. I am an Industry recognized expert in Oracle and Virtualization technologies I frequently blog at https://blogs.vmware.com/apps and http://virtualizingoracle.wordpress.com

5 thoughts on “Oracle 12c OLTP & DSS workloads on Virtual SAN 6.2 All Flash

  1. vikrant

    Great work Sudhir,Very well explained . Thanks for sharing this useful information. The way you explained each and everything is really great. Thanks once again.

    Reply
  2. Pingback: Oracle on VMware vSAN – Dispelling the Licensing myths - Virtualize Business Critical Applications - VMware Blogs

  3. Pingback: Oracle on VMware vSAN – Dispelling the Licensing myths | TekTribune

  4. Pingback: Oracle on VMware Collateral - One Stop Shop - Virtualize Business Critical Applications - VMware Blogs

Leave a Reply

Your email address will not be published. Required fields are marked *


*