Test demonstrates low latency, increased economy for Oracle databases
OceanStor Dorado is the next generation all-flash array (AFA) from Huawei. The Dorado uses five intelligent chips and a multitude of efficient algorithms to deliver 20 million input/output operations per second (IOPS), 100-microsecond latency, and hundreds of gigabytes of bandwidth. It more than satisfies the requirements of online transaction processing (OLTP) and online analytical processing (OLAP) in mainstream databases for the finance and carrier industries. In addition, OceanStor Dorado has adapted and enhanced algorithms for virtualization and supports ecosystem plug-ins for a variety of virtualization platforms to greatly improve VM efficiency and advance the all-flash era across industries.
Database acceleration is a critical mainstream application that benefits greatly from the use of OceanStor Dorado technology. Oracle is the most common database for large enterprises, holding the key data of ERP systems. However, the data explosion in the 5G/AI era has greatly challenged Oracle performance and has increased the operating costs of Oracle deployments.
Oracle Database Challenges
Storage performance from building-block expansion
Banks and large e-commerce companies now process over 100 million daily transactions. The IOPS of core service systems exceeds 200,000 and requires a latency of around 1 ms. Traditional storage systems cannot satisfy these new requirements through building-block expansion.
Business continuity
Service continuity is vital for Oracle OLTP, which manages mission-critical businesses for enterprises.
Oracle license costs increase annually
Oracle license fees have always consumed a large proportion of IT budgets. For example, the Oracle license fees for a 10 TB database account for 50% of annual operations and maintenance costs and increase as the data volume grows. Cutting Oracle license fees is a critical challenge for many companies.
All-Flash Solution for Oracle Databases
The Oracle database all-flash solution uses the powerful performance of Huawei OceanStor Dorado for a 5x service scale for online transactions. In addition, low latency of 0.5-ms reduces the I/O waiting time, improves storage and server resource utilization, and significantly reduces Oracle license fees. The innovative HyperCDP high-density snapshot provides the highest data protection frequency in the industry and lossless performance during snapshot creation.
To demonstrate OceanStor Dorado performance for Oracle databases, a test was run with 12 hosts delivering I/O to the storage array for a stable 500-μs latency (see Fig. 1).
6x faster than the industry benchmark Dell EMC VMAX-F
The SwingBench tool simulated an online transaction system. The performance of the 4-controller OceanStor Dorado 18000 reached 840,000 IOPS at 0.5-ms latency, 50x that of traditional storage systems, and 6x that of Dell EMC VMAX250F. In addition, OceanStor Dorado supports scale-out and linear performance growth.
| Storage Device | Test Tool | Workload Model | IOPS |
| OceanStor Dorado 18000 | SwingBench (OE2) | 7:3, 8 KB, random | 840,000@0.5 ms |
| Dell EMC VMAX250F | SwingBench (OE2) | 7:3, 8 KB, random | 133,000@1 ms |
Table 1. Results comparison of Oracle test
100-μs latency, 10x faster than the industry average
Huawei OceanStor Dorado not only provides high IOPS, but can also reduce the latency to 100 μs in scenarios with a high cache hit ratio. For example, a test was performed with the SLOB tool. The 4-controller OceanStor Dorado 18000 achieved a 75% read cache hit ratio, 220,000 IOPS, and less than 100-μs latency in the 25% update and 8:2 read/write ratio scenario (the most typical database I/O model). Even if the IOPS of the core service system reaches 200,000, OceanStor Dorado can still keep the latency at about 100 μs. This is 10x the 1 ms latency of the all-flash storage of other vendors and far exceeds the requirements of mission-critical applications.
HyperCDP without compromising performance
Service continuity and data reliability are critical for Oracle databases because they manage mission-critical applications for enterprises. OceanStor Dorado safeguards mission-critical applications using high-density snapshots with the highest protection frequency in the industry for a shortened snapshot interval of 3 seconds and lossless performance during snapshot creation.
In a snapshot test for four-controller OceanStor Dorado 18000 and HDS F1500 all-flash storage, Huawei OceanStor Dorado far exceeded the competing products in snapshot density and activation impact.
OceanStor Dorado supports a minimum snapshot interval of 3 seconds. In contrast, HDS snapshots are only configurable for 15-minute intervals through APIs.
Fig. 2 shows the impact on OceanStor Dorado and HDS F1500 when snapshots are created, activated, and then mapped to hosts. OceanStor Dorado performance is uncompromised since a snapshot is created and activated within several seconds. Conversely, HDS F1500 took 75 seconds to create and activate a snapshot, greatly increasing latency.
Fig. 2. Snapshot performance impact
Oracle license fees slashed by 30% or more
The ultra-low latency of OceanStor Dorado reduces the I/O waiting time and host CPU usage. Fewer CPU resources are needed to handle the same service pressure, greatly reducing costs for Oracle license procurement.
In addition, test results were obtained for traditional storage and OceanStor Dorado when SwingBench OE2 was used to simulate online transactions. Under the same service pressure (800 TPS), the host CPU usage of OceanStor Dorado was 38.7%, while traditional storage usage was 60% or more. As a result, storage arrays are no longer a service bottleneck. Fewer host CPU resources perform the same services, reducing Oracle license and host purchasing costs. At 800 TPS, the Oracle license fees are reduced by 31.3%.
To learn about OceanStor Dorado performance on two other critical applications – virtual desktop infrastructure (VDI) and server virtualization – please see “Huawei OceanStor All-Flash Storage” (page 44).
For more information about Huawei’s OceanStor Dorado All-Flash Storage, please participate in Huawei Tech Summit on March 18,2021.
