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

Sudhir Balasubramanian is a Staff Solution Architect specializing in all Oracle Technologies on VMware SDDC stack.

Prior to joining VMware in 2012 , Sudhir has worked for close to 20 years as a Principal Oracle Database Administrator (DBA) / Architect in Oracle Technologies for fortune 100 companies including Tata Consultancy Services (TCS) , Sony Electronics, Epsilon Marketing (Aspen/Newgen), Teletech Corp, SAIC, Active Network and Sempra Energy Holdings before joining VMware PSO before moving into the Global Field and Partner Readiness (GFPR).

Sudhir is also experienced in EMC SAN Technologies & Unix/Linux Operating Systems along with being a VMware vBCA Specialist , VMware vExpert and VMware VCA – Cloud certified. Sudhir is also a Member of the CTO Ambassador Program , run by the VMware Office of the CTO. Sudhir is a recognized Speaker having presented at Oracle Open World, IOUG, VMworld, VMware Partner Exchange, EMC World, EMC Oracle Summit and various Webinars and is an Industry recognized expert in Oracle Virtualization technologies.

Sudhir has also co-authored a book “Virtualizing Oracle Business Critical Databases on VMware SDDC” which is a comprehensive authority for Oracle DBA ’s on the subject of Oracle & Linux on vSphere.
https://www.amazon.com/Virtualize-Oracle-Business-Critical-Databases/dp/1500135127/ref=sr_1_1?s=books&ie=UTF8&qid=1493001047&sr=1-1&keywords=Virtualize+Oracle+Business+Critical+Databases

Sudhir regularly blogs at the official VMware Application blog site
https://blogs.vmware.com/apps

Sudhir also blogs on his personal website
http://vracdba.com

Sudhir holds a degree in Master of Computer Science from San Diego State University (SDSU) graduating in 2011. Sudhir also holds a Bachelor Degree in Computer Science Engineering from Bangalore University.

Twitter @vracdba

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 *

*