New MemSQL 5 Release Achieves Breakthrough Analytics Performance

Print Friendly, PDF & Email

MemSQL_logo_NEW_20150502MemSQL, a leader in real-time databases for transactions and analytics, announced the release of MemSQL 5, delivering breakthrough performance on database, data warehouse, and streaming workloads. MemSQL 5 removes data latency barriers across queries, enabling real-time analytics so businesses can anticipate problems before they occur and adapt to changes as they happen. In the race to the digital enterprise, companies must move as fast as the world changes. MemSQL 5 makes that possible.

MemSQL shares our mission to help people see and understand their data,” said Dan Kogan, Director Product Marketing, Tableau. “MemSQL 5 will help to bring advanced query performance and real-time analytics to our customers.”

The Digital Economy

The business landscape is going through an extreme cultural shift. Companies that can adapt and learn in real time will thrive while those that cannot will fade. Built on the mature, enterprise-ready, distributed MemSQL database, MemSQL 5 ushers in a new era of capturing and querying data simultaneously for real-time analytics. Companies benefit by ingesting and serving critical workloads simultaneously, and enabling interactivity on live data for the most popular Business Intelligence (BI) tools. Combining BI tools with an operational database provides a window into business as it happens, accurate to the last transaction.

A real-time dashboard is no longer simply a competitive advantage, it is an absolute necessity,” said Eric Frenkiel, CEO and co-founder, MemSQL. “Enterprises achieving peak performance have their finger on the pulse of real-time data to win in the digital economy. With MemSQL 5, we help companies innovate, make every moment work for them, and pave the way for predictive applications.”

From Datacenter to Cloud

Modern databases should meet hybrid cloud requirements. MemSQL 5 delivers unprecedented flexibility from datacenter to cloud through multi-cloud and on-premises deployments. With design architectures for high availability, disaster recovery, and cloud independence, users have the agility to fulfill hybrid cloud strategies for peak database performance.

Modernizing BI

MemSQL 5 sets a new standard for how enterprises use BI tools, allowing for full granularity that brings data to life. The in-memory capabilities of MemSQL transform BI data access by enabling interactivity on live data for Tableau, Zoomdata, Looker, and other BI solutions, in ways that traditional databases simply cannot.

As the pace of business accelerates, businesses increasingly need to see and analyze information in real time,” said Nick Halsey, Chief Marketing Officer, Zoomdata. “Zoomdata’s Smart Connectors are optimized for the MemSQL database, and with the query advancements in MemSQL 5, we can hasten our customers’ access to real-time and historical data.”

MemSQL 5 Technology Highlights:

  • New LLVM-based code generation architecture: MemSQL 5 delivers deterministic, low-latency query compilation and maximum performance for interactive data exploration through an advanced LLVM-based MemSQL Byte Code Compilation Architecture.
  • Breakthrough analytics performance: perform real-time queries under heavy write load with MemSQL for stellar results. Merge transactions and analytics into a single database through Hybrid Transaction/Analytical Processing (HTAP) with concurrent support for OLTP and OLAP queries.
  • Streamliner: with one-click deployment of integrated Apache Spark through MemSQL Streamliner, users can create real-time data pipelines through a graphical UI and eliminate batch ETL.
  • PAM-based authentication: MemSQL 5 includes Pluggable Authentication Module (PAM) based authentication with tools like Kerberos for advanced security.

Big data now powers new markets, driving more value for business intelligence dashboards, and making insights actionable. Forward-thinking organizations use real-time data to power emerging digital platforms. This proficiency will set leading companies ahead and CxOs should look for vendors that enable these key capabilities,” noted Holger Mueller, VP and principal analyst, Constellation Research.


MemSQL 5 is available today at Users can choose from the community edition which has unlimited scale and capacity, or the enterprise edition which also includes high availability, security, and support. MemSQL licenses software based on the cluster RAM capacity. Customer installations range from gigabytes to terabytes of memory. With the MemSQL columnstore, SSD or disk-storage is free.


Sign up for the free insideAI News newsletter.

Speak Your Mind