As businesses become more and more data intensive, the cost per transaction becomes an important metric. There are two ways to lower cost per transaction. The first is to lower the cost of data infrastructure; and the second is to increase hardware efficiency. With MariaDB* and Intel, organizations can do both by using an enterprise subscription to reduce database costs and multi-core processors to increase performance with existing servers.
Introducing MariaDB* Server
MariaDB* Server is an open source database, and the foundation of MariaDB* TX, an enterprise open source solution for transactional workloads. MariaDB* Server is engineered for flexibility, efficiency, and reliability. By implementing an extensible architecture and supporting contributions from leading internet and technology companies, including Alibaba, Facebook, Google and Tencent, MariaDB* Server meets modern enterprise requirements with community innovation.
“MyRocks* is a storage engine that adds the RocksDB flash-storage-optimized database to MariaDB* Server. Even while under development, it shows good performance and scalability, close to mature storage engines like InnoDB. We ran our pre-release MariaDB* Server 10.2.9 with the built-in MyRocks* engine under the Sysbench read-only multi-table test on the newest Intel® Xeon® Platinum 8180 processors. They delivered up to 1.78x more throughput with 1.18x reduction of the average response time compared to the previous generation Intel® Xeon® processors E5-2699 v4”
MariaDB* Server, engineered to scale on standard modern hardware, can be deployed on bare metal servers, virtual machines, cloud instances, and/or containers. MariaDB* Server is now the default database on leading Linux distributions, including Red Hat Enterprise Linux* and SUSE Enterprise Linux*, as well as leading infrastructure platforms, including OpenStack*.
In addition, MariaDB* Server uses Intel® Advanced Encryption Standard New Instructions (Intel® AES-NI) to improve encryption performance, both in motion and at rest.
The modern and extensible architecture of MariaDB* Server provides the foundation for businesses to continuously innovate with new applications and modernize legacy systems.
One of the strengths of MariaDB* Server is that it allows users to choose their own storage engine. InnoDB is the default. It was designed primarily to work with hard disks, but new storage media have since emerged including non-volatile memory (NVM) and solid state drives (SSDs). MyRocks*, developed by Facebook, is a storage engine that is optimized for newer media, and aims to offer greater compression and faster performance. While currently available as a preview, MyRocks* will be fully supported in the next major release of MariaDB* Server.
Testing the new processor
In advance of the official support for MyRocks*, MariaDB* and Intel worked together to assess the possible performance gains using the latest generation Intel® processor. Intel engineers compared the performance of MariaDB* Server 10.2.9 running on two Intel® Xeon® processors E5-2699 v4 against MariaDB* Server 10.2.9 running on two Intel® Xeon® Platinum 8180 processors. In both cases, MyRocks* was chosen as the storage engine. The team used the Sysbench OLTP benchmark,1 a multi-threaded benchmark tool for evaluating database performance under intensive load. To confirm there were no bottlenecks in the performance, Intel® VTune™ Amplifier 2017 and a modified version of the open source Processor Counter Monitor were used.
The results showed a 78 percent increase in read-only throughput with the Intel® Xeon® Platinum processors when compared to the previous generation v4 processors.1 In addition, average response times at peak throughput were cut by 18 percent.1
Optimizing the software
A collaboration with Intel, using Intel® VTune™ Amplifier 2017, part of the Intel® Parallel Studio XE 2017 suite, led MariaDB* to identify performance optimizations for Intel® processors. The result is MariaDB* Server taking advantage of the additional cores in Intel® Xeon® Platinum processors, scaling to two sockets and 112 hardware threads in this performance comparison.1