SOURCE: MemSQL

MemSQL

September 24, 2014 09:30 ET

MemSQL's New Tiered Database Platform Now Available for Download

Latest Release Delivers Hybrid Transactional and Analytical Processing for Deep Analysis of Real-Time and Historical Data

SAN FRANCISCO, CA--(Marketwired - Sep 24, 2014) - MemSQL, the leader in distributed in-memory database technology, today announced the availability of MemSQL v3, which combines the world's fastest in-memory row store with a flash-optimized column store. With the addition of the column store and features such as automatic cross-datacenter replication, this release further cements MemSQL's status as an industry leader that is bringing Hybrid Transaction/Analytic Processing (HTAP) to the enterprise.

HTAP refers to the practice of simultaneously carrying out transaction processing and real-time analytic reporting in a true operational database. Real-time applications for HTAP include operational analytics, anomaly detection and automated real-time decision making. To date, technological limitations and inertia in IT departments have prevented widespread adoption of HTAP. MemSQL is the first database company to bring a truly enterprise-ready HTAP solution to market.

MemSQL's column store is designed to complement the in-memory row store, allowing users to access both real-time and historical data in a single database. Advanced data compression techniques and the use of flash, SSD or disk as a storage medium allow MemSQL's column store to offer exceptional price performance while maintaining MemSQL's best-in-class data loading, concurrency and query execution speed. Traditionally, businesses have kept operational and historical data siloed in separate data stores, and required additional time and computing power to transfer data between them. MemSQL v3 offers an integrated platform that makes all data easily accessible and eliminates the need for slow and error-prone extract, transform and load (ETL) processes.

"Our customers' top data analysis priorities are speed and scalability. Our number-one reason for developing a column store is to deliver on these priorities and enable customers to speed processing and analysis of even more data," said Eric Frenkiel, co-founder and CEO of MemSQL. "Unifying a row store and a column store minimizes latency and provides added flexibility that helps customers extract the full value of their data."

In addition to the release of the column store, MemSQL v3 includes several enterprise reliability features. Among these is automated cross-datacenter replication, which allows businesses to easily maintain a backup copy of data for disaster recovery or for use in read-heavy operations. MemSQL is designed for reliability and simple administration so businesses can stay online and produce revenue.

Key Features
MemSQL v3 features an integrated tiered storage architecture that consists of a transactional in-memory row store and highly compressed flash- or disk-based column stores. This architecture allows organizations to query incoming real-time data and historical data within the same database. Highlights include:

  • Automatic cross-datacenter replication, provisioned with just a single command.
  • Support for views as well as table-, column- and row-level security.
  • High-performance, transactional bulk data loading from a file system or from Amazon S3.
  • Performance improvements in the flash-optimized compressed column store.

For more information regarding an enterprise license including full support and services, please contact sales@memsql.com or (855) 4-MEMSQL (463-6775).

About MemSQL
MemSQL is the database for fast data processing. Within a single platform, companies can converge live data with their data warehouse to accelerate applications and power real-time operational analytics. MemSQL's Big Data platform brings speed, scale, and simplicity to enterprise customers worldwide. Based in San Francisco, MemSQL is a Y Combinator company funded by prominent venture capitalists and angel investors, including Accel Partners, Khosla Ventures, Data Collective, First Round Capital, and IA Ventures.