Nytro Acceleration Card Performance Of An Oracle NoSQL Big Data Database

Twitter Facebook Google Plus Linked in

Rick Stehno Principle Product Marketing Engineer / DBA

What is an Oracle NoSQL Database?

According to Oracle, “The Oracle NoSQL Database is a distributed key-value database. It is designed to provide highly reliable, scalable, and available data storage across a configurable set of systems that function as storage nodes.” 1

Oracle is not new at creating databases. The company’s foundation was laid with the development of its relational database back in the late 1970s and 1980s. Since the mid-2000s, Oracle started acquiring software companies and revamping the software in order to deliver a NoSQL database that would meet the enterprise standards that Oracle applied to its other database and application offerings. The Berkeley DB is used as the core of the NoSQL database. The Berkeley DB library provides a building block (made up of application program interfaces or APIs) of database features and functionality that C, C++, Perl, Python, Ruby XML, and Java programmers can embed into their applications. Many open source projects such as Linux, BSD, Apache web server, OpenLDAP, and many others embed Berkeley DB technology.

Most big data databases don’t offer ACID (atomic, consistent, isolated, durable) compliance, but offer BASE (basically available, soft state, eventually consistent) compliance. The Oracle NoSQL database provides ACID transactions fault recovery, high concurrency, and replication for highly available (HA) applications.

In deploying an Oracle NoSQL Database, the application makes simple database function calls to interact with the storage layer instead of writing complicated queries in the business layer. The following figu e provides a high-level illustration of an Oracle NoSQL implementation:

http://www.oracle.com/technetwork/products/nosqldb/learnmore/nosql-wp-1436762.pdf

1. http://www.oracle.com/technetwork/products/nosqldb/overview/index.html

What is a Nytro acceleration card?

The Nytro application acceleration cards are designed to offer high performance with exceptionally low latency with a low CPU burden. The Nytro cards help accelerate applications such as web serving, data warehousing, data mining, online transaction processing and high-performance computing. Their PCIe® host interface, industry standard drivers, and small form factor make them more flexible and easier to integrate into today’s low profile, high performance system chassis.

The Nytro cards are built on the latest enterprise level solid state technologies and include sophisticated advanced features to help deliver consistently high levels of performance, endurance, and reliability under some of the most demanding conditions. In addition, the SandForce DuraWrite™ technology helps optimize the number of program cycles to the flash storage effectively extending the rated write endurance of the flash storage by up to 8x or more when compared to some other controllers.

Other sophisticated algorithms and dedicated onboard hardware resources handle complex flash management tasks like garbage collection and wear leveling. These advanced features make the Nytro cards an excellent choice for accelerating your business applications.1

Test Configuration

The following benchmark tests were run on a single shard consisting of three server storage nodes, with one of these storage server nodes acting as both a storage node and an administrative node. Server specifics are defined below.

The benchmark used was the Yahoo Cloud Systems Benchmark (YCSB)2. The YCSB framework is intended to facilitate performance comparisons of the new generation of cloud data serving systems, employing a defined core set of benchmarks and report results for widely used database systems. In addition to making it easier to benchmark new systems, the YCSB framework is extensible in that it supports easier definition of new workloads.

2. http://labs.yahoo.com/news/yahoo-cloud-serving-benchmark/

Each server storage node consisted of the following hardware/soft-ware

Server Platform:
Supermicro: Dual 6 Core Xeon 5650 2.67Ghz

32GB 1333Mhz Memeory
PCIe 3x8
10G Enet

Operating System:

Oracle Unbreakable Enterprise Kernel (UEK) 2.6.39-300

Oracle NoSQL Database:

NoSQL DB 11gR2.2.0.23 2012-11-26

Storage:

For the HDD baseline test, single 300G capacity

Nytro Acceleration Card:

200G capacity

Admin Server:

Storage Node 2 was also used as the Admin Node

Note: Total throughput was limited for the Nytro ard because of swapping issues on the storage/admin node. The other two (2) storage nodes did not have swap issues and were only 25% busy during these benchmarks.

YCSB Configuration Parameters:

Topology transformation from current deployed topology to MyStoreLayout:
Create 1 shard
Create 3 RNs
Create 10 partitions
RECORDCOUNT_PER_SHARD=100000000 # 100,000,000 (100M)
YCSB_LOB_SIZE=1000000 # 1,000,000 (1M)

Test Results

YCSB StatsHDD – 300GNytro CardPerformance Gains w/Nytro
Throughput Mixed Operations/sec 2069 96589 4668%
Read (ms) Average
95%
99%
50.51
217
390
1.0
2
4
5051%
1085%
970%
Update (ms) Average
95%
99%
51.31
218
391
4.15
6
48
1236%
3633%
814%

Single hdd

File: ycsb-1.out
Throughput: 21182 insert ops/sec 2069 mixed ops/sec
[INSERT] insert count:99999960 latency (av/95%/99%):5.65/8/67 ms
[READ] read count:9499445 latency (av/95%/99%):50.51/217/390 ms
[UPDATE] update count:500545 latency (av/95%/99%):51.31/218/391 ms

NWD

File: ycsb-1.out
Throughput: 27803 insert ops/sec 96589 mixed ops/sec
[INSERT] insert count:99999900 latency (av/95%/99%):5.38/8/11 ms
[READ] read count:9500689 latency (av/95%/99%):1.00/2/4 ms
[UPDATE] update count:499271 latency (av/95%/99%):4.15/6/48 ms

IOSTAT Report During Mixed Operations

 

What Do These Statistics Point Out?

The hardware and software were originally set up similar to a typical enterprise installation. To establish the baseline, a single 300GB HDD was used. The goal of the benchmark was to capture any performance improvement that resulted when a customer with an existing running system implemented the Nytro acceleration card..

Overall, the benchmark results show an average of 10x performance gains throughout, with some statistics showing over a 50x gain in performance.

 

Throughput results:

 

Read Results:

 

Update Results:

 

Conclusion:

Overall, the performance gains were impressive when implementing the Nytro acceleration card, even with no other modifications. With very little effort from the Oracle NoSQL Database administrator or developer, it is possible to achieve large performance gains by implementing a Nytro acceleration card into an existing Oracle NoSQL Database infrastructure.

The combination of the Nytro acceleration card and Oracle NoSQL Database can provide enterprises with a great solution for increasing the performance of a big data deployment. With such a solution, one can achieve optimized performance without the large costs and manual effort typically associated when implementing such a configuration.

Twitter Facebook Google Plus Linked in

What do you need space for?

Seagate is helping the world's biggest game changers solve their toughest business and technical challenges through data storage innovation.

Hide form

See what we can do for you.

Register to receive the latest Seagate customer case studies, industry insights, trend information and more.

All fields are required

Please fill all fields before submitting the form