24.5 C
New York
Thursday, September 16, 2021

Oracle’s HeatWave database query accelerator gives MySQL a turbo boost

Must read

When Oracle Corp. acquired Sun Microsystems for $7.5 billion in 2009, there was some concern expressed in the tech community that the company would view Sun’s open-source database – MySQL – as a troublesome competitor, destined for oblivion.

Instead, Oracle has taken the MySQL car into the garage, added a new engine, fine-tuned the steering, and rolled out an in-memory database query accelerator, which the company claims is faster than anything else on the cloud market today.

The new service, which Oracle introduced last year under the name HeatWave, offers an intriguing new spin on a technology that made its first appearance over 25 years ago.

“We enhanced MySQL significantly and wrote a whole bunch of new code, which is optimized for the cloud,” said Nipun Agarwal (pictured), vice president of MySQL, HeatWave and advanced development at Oracle. “If you take the MySQL Database Service in HeatWave in Oracle Cloud and compare it with MySQL service in any other cloud, looking at data sizes which are half a terabyte or so, HeatWave is 400 times faster in terms of latency. It offers improved performance and very good scale at a lower cost.”

Agarwal spoke with Dave Vellante, host of SiliconANGLE Media’s livestreaming video studio theCUBE. They discussed Oracle’s pursuit of a unified approach for transactions and analytics, leveraging cloud and processor technologies to improve performance, how the company re-architected MySQL, and what the future holds for HeatWave.

Support for analytics

Oracle’s HeatWave solution is geared to address what the company saw as a weakness in MySQL for modern enterprise use. It was great for handling transactions, but it came up short when having to deploy analytics workloads.

“MySQL has been optimized for transaction processing, but when customers need to run analytics, they need to move the data out of MySQL into some other database,” Agarwal said. “We are the only vendor offering this unified solution for both transactional processing and analytics.”

How exactly did Oracle re-architect MySQL to be scalable, fast, and inexpensive? At a basic level, the company made a decision to drive HeatWave’s affordable cost by leveraging cloud and processor technologies.

“We are using commodity cloud services in such a manner that it’s optimized for both performance and performance per dollar,” Agarwal explained. “We are working with chips which provide the cheapest cost per terabyte of memory. We’re not using any locally attached solid state drives, we use ObjectStore because it’s very inexpensive.”

Adding new algorithms

There was still the not-so-trivial matter of re-designing MySQL’s architecture to be scalable and fast. Oracle boosted scalability by creating new algorithms that can overlap computation with communication time as data is channeled across nodes, according to Agarwal.

Speed was handled by also designing algorithms for distributed query processing within HeatWave’s in-memory engine.

“HeatWave has a massively parallel architecture, which is enabled by a massively partitioned architecture,” Agarwal said. “We read the data from MySQL into the memory of HeatWave and we massively partition this data. The sizes of these partitions are such that they fit into the cache of the underlying processor and then we’re able to consume these partitions really, really fast.”

Agarwal pointed out that HeatWave is an Oracle service, not open source, but the company has made its SQL scripts available in a GitHub repository for benchmarking. Further enhancements are planned.

“As you add more compute, as you add more service, the system continues to scale almost perfectly linearly,” Agarwal said. “Over the next few months, you will see announcements where we’re adding machine learning and data-driven based automation, which we believe is critical for the cloud.”

Watch the complete video interview below, and be sure to check out more of SiliconANGLE’s and theCUBE’s CUBE Conversations.

Photo: SiliconANGLE

Since you’re here …

Show your support for our mission with our one-click subscription to our YouTube channel (below). The more subscribers we have, the more YouTube will suggest relevant enterprise and emerging technology content to you. Thanks!

Support our mission:    >>>>>>  SUBSCRIBE NOW >>>>>>  to our YouTube channel.

… We’d also like to tell you about our mission and how you can help us fulfill it. SiliconANGLE Media Inc.’s business model is based on the intrinsic value of the content, not advertising. Unlike many online publications, we don’t have a paywall or run banner advertising, because we want to keep our journalism open, without influence or the need to chase traffic.The journalism, reporting and commentary on SiliconANGLE — along with live, unscripted video from our Silicon Valley studio and globe-trotting video teams at theCUBE — take a lot of hard work, time and money. Keeping the quality high requires the support of sponsors who are aligned with our vision of ad-free journalism content.

If you like the reporting, video interviews and other ad-free content here, please take a moment to check out a sample of the video content supported by our sponsors, tweet your support, and keep coming back to SiliconANGLE.

- Advertisement -spot_img

More articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement -spot_img

Latest article