June 19, 2013 12:00 ET

MemSQL Enables Enterprises to Compare Real-Time Data Against Historical Trends

New Features Enable Easy Exploration at Real-Time Speeds on Large Data Sets With the Fastest Ingestion and Analytical Query Capabilities Available

SAN FRANCISCO, CA--(Marketwired - Jun 19, 2013) - MemSQL, the leader in real-time analytics, today announced the upcoming availability of MemSQL 2.1, which includes new features and enhancements to enable customers to access, explore and increase the value of data, regardless of size or file format. As organizations amass increasing amounts of data, maximizing the value of each data type is key. To meet these demands, MemSQL updated its analytics platform to enable customers to unleash the full potential of Big Data and receive real-time results on analytical queries across both real-time and historical data sets.

"For years, organizations have been bogged down loading data in batches and sacrificing real-time analytical capabilities. With MemSQL, it's now possible to consume real-time events and simultaneously compare that against historical operational data sets. Moreover, the ability to load data stored as flat files on disk into memory has created an ideal experimentation platform by dramatically increasing query performance," said Eric Frenkiel, CEO. "From ingestion to exploration, MemSQL makes deployment simple, increasing reliability and, most importantly, delivering increased value from the data to customers. We are changing the world of Big Data for the better by redefining the in-memory real-time distributed database market, and this product update is yet another proof point."

As the speed at which data is analyzed increases, so does the quality of insight. To increase competitive advantage, organizations must access, explore and attain the greatest value possible from their data. With a real-time database, users can access and explore data instantly, greatly appreciating the value of the data itself. MemSQL is the only database that allows companies to manage the velocity of Big Data transactions without sacrificing the ability to interact with and analyze all data in the system.

New and enhanced features and functionalities include:

  • Multithreaded Load of CSV files: CSV is one of the most commonly used file formats for exchanging data between applications. Users can setup ondemand or scheduled uploads of CSV files to MemSQL, allowing them to harness the power of an inmemory distributed database for subsecond query response times on hundreds of millions of rows of data;
  • Distributed Joins: The ability to perform distributed joins on tables with primary key to foreign key relationships is critical to accelerating many types of analyses. MemSQL 2.1 unlocks this functionality to accelerate analytics use cases by allowing users to choose the column(s) on which they shard, making MemSQL smart and flexible on schema design;
  • Linux-Based Package Manager: With MemSQL 2.1, users now have the ability to download, install, and upgrade MemSQL via a package manager on major Linux distributions. Users can now easily install, upgrade, and manage MemSQL using common Linux workflows;
  • Node Management: The ability to manage nodes efficiently is key in database cluster management. With MemSQL 2.1, failed nodes are more easily tracked in the MemSQL Watch dashboard and can be reattached to the cluster without re-provisioning. The entire experience of backing up, restoring, shutting down, and managing failures is optimized for DBAs. MemSQL built these features based on extensive collaboration with DBAs to ensure its solution is the easiest platform to manage.

"Every Big Data customer wants a solution that will grow and evolve with their changing landscape. The new features from MemSQL provide just that by opening up a variety of use cases for developers," said Mark Horton, Director, Product Marketing, MemSQL. 

MemSQL's real-time analytics platform is built on the world's fastest, most scalable in-memory database, capable of simultaneously handling real-time transactions and analytic workloads. The company's distributed version of its database, which provides the combination of in-memory speed and a massively scalable relational DBMS, enables customers to take full advantage of real-time and historical data to make informed decisions, better engage customers, and identify competitive advantages.

For more information about MemSQL, visit MemSQL 2.1 will be available at in July 2013. You can also hear about MemSQL when CEO Eric Frenkiel speaks today at GigaOM Structure in San Francisco.

About MemSQL
MemSQL is the leader in real-time Big Data analytics, empowering organizations to make data-driven decisions, better engage customers, and gain a competitive advantage. The in-memory distributed database at the heart of MemSQL's real-time analytics platform is proven in production environments across hundreds of nodes in the most high-velocity Big Data environments in the world. Based in San Francisco, MemSQL is a Y Combinator company funded by prominent venture capitalists and angel investors, including First Round Capital and New Enterprise Associates. For more information, please visit

Contact Information

  • Media Contact:
    Stacey C. Burbach
    Point Communications Group for MemSQL
    Email: Email Contact
    Phone: (415) 310-9767