Announcing MemSQL 6.7: The No-Limits Database Gets Even Faster, Easier, and Now Free to Use

Rick Negrin
Rick Negrin

Today, we announced the general availability of MemSQL 6.7. This latest release introduces features that provide faster query performance and improved usability with more robust monitoring, simplified deployment tooling, and a new free tier that anyone can use.

Data and the ability to analyze and act on it are the most critical capabilities of modern businesses. Leveraging data quickly and effectively is key to delivering new customer experiences, enabling competitive advantage, and optimizing operations.

Query performance, concurrency, and scalability are critical requirements for modern applications and analytical systems, yet legacy databases and big data systems struggle to keep up. MemSQL addresses all these challenges, and MemSQL 6.7 makes processing and analyzing data easier and faster for both streaming data and big data, while continuing to support familiar, standard SQL, and the broad ecosystem that uses it.

New advances include a free production license for MemSQL 6.7, within limits; dramatically faster queries; new tooling for monitoring and management; new native connections; and a new developer forum for tips and troubleshooting.

MemSQL 6.7 Now Free to Use, Making Maximum Performance Available to Everyone

MemSQL 6.7 can be used for free in production, up to a limit of 128GB of RAM capacity, with unlimited disk/solid state drive (SSD) usage.

Unlike many of our competitors, the free tier of MemSQL offers all the capabilities found in the Enterprise licensing tier of the database, including the full performance and security features.

The free tier offers tremendous value. Customers of legacy databases are paying $100,000 and more per year for similar capacity for operational systems, data warehouses, and data marts. Yet these existing systems have fundamental scalability limits that are not present with MemSQL.

The free tier is backed by extensive documentation and a community of users, but does not include professional MemSQL support. Companies looking for interactive, ticket-based support and guidance, or who want more than 128GB of RAM capacity (with no limits on disk/SSD usage), will need to upgrade to an Enterprise license. Contact MemSQL for more details.

Faster Queries Out of the Box

Getting excellent database performance often requires experimentation. Developers and analysts try various query hints and tuning steps as stop-gaps when query optimization, execution, or indexing don’t work fast enough. The result is more time spent tuning, and less time discovering and acting on new insights.

Star Joins are a type of query commonly used in data analytics, in which a large table is joined to one or more smaller tables. MemSQL 6.7 has made Star Joins faster – up to 100x faster, in some cases – by leveraging query vectorization and single instruction, multiple data (SIMD) technology, a kind of parallel processing. Queries will also execute faster at first run with improved sampling eliminating cumbersome hints and tuning often associated with new query development. You can read more about MemSQL 6.7 performance results.

New Monitoring and Management Tooling Simplifies Tuning and Deployment

MemSQL Studio gives users a simple way to visualize the health of MemSQL clusters across resources, events, and queries. The new query inspector, for example, enables immediate discovery and debugging of query bottlenecks across the spectrum of CPU, memory, disk, and IO, which enables faster tuning and improved integration with other management and DevOps tools.

The MemSQL Studio dashboard works with MemSQL as an in-memory database or memory-led database
MemSQL Studio and new tooling make it easier to monitor and manage MemSQL

Additional improvements include command line tooling that simplifies multi-node setup and cloud formation templates to automate cluster deployments and configuration. With these changes, the power of MemSQL, and the ability to optimize it as part of speeding data updating and access, becomes more accessible to everyone, from new users to established industry partners. We have a separate blog post where you can learn more about MemSQL Studio and the associated tooling.

Improved Loading and Backups

In MemSQL 6.7, we’ve added native ingest for the JavaScript Object Notation (JSON) and Avro data formats. (Avro is a protocol for remote procedure calls and data serialization that uses JSON format.) You can now load Avro or JSON from files or Apache Kafka directly into a relational schema or into a semi-structured JSON column. While MemSQL ingests both file types at high speed, Avro, being a modern binary format, provides the highest performance ingest possible. Both JSON and Avro allow for schema flexibility on ingest.

Developer Forums for Tips and Troubleshooting

For people who prefer to run our free tier, we have introduced a new developer forum for developers to post, research, and answer questions about MemSQL. Developers can learn best practices, engage with experts, and mature as a member of the No-Limits Database™ community. Check out our new forum.

Want to Learn More?

Join our MemSQL 6.7 webinar, where we’ll explain the new capabilities of MemSQL 6.7, the free tier, and deliver a live demo of our new monitoring and management tools.

For more information on MemSQL 6.7, see the press release and all eight blog posts on the new version: Product launch (this post); managing and monitoring MemSQL 6.7 (includes MemSQL Studio); the new free tier; performance improvements; the Areeba case study; the Wag! case study; the creation of the Visual Explain feature; and how we developed adaptive compression.

memsql rainbow wave
Live Webinar
See What’s New in MemSQL 6.7:
The No-Limits Database