MemSQL 6.5 deliver fast database to improve performance, effortless scale, with new ingest and analysis features



MemSQL announced on Tuesday general availability of new version of its product MemSQL 6.5 that cements its position as the world’s fastest SQL database by advancing performance and adding capabilities to accelerate time to insight and simplify operations. With MemSQL, customers get a single database that can support real-time decision making and insight-driven customer experiences combining massively-scalable ingest, the ability to scan billions of rows per second across large number of users, and a familiar relational structure for user- and developer-friendly access.

MemSQL 6.5 delivers an integrated database for data capture, management, and operations that integrates seamlessly with existing systems, infrastructure, and employee skills. This allows customers to get faster time to value and reduces cost and complexity.

Customers demand modern applications and analytical systems that offer a flawless user experience, provide consistently fast insights, and easily scale with demand. This creates new requirements to both modernize legacy systems and introduce new ways of managing data.

MemSQL was designed with these demands in mind and the 6.5 release expands on its capabilities with several new features and improvements including queries are now up to four times faster than the previous MemSQL version (which was already ten times faster than legacy database providers), enabling insights in milliseconds across billions of rows; and automated workload optimization capabilities provide a consistent database response under ultra-high concurrency without the need for manual tuning or specialized DBA resources.

Additions to the MemSQL “transform-as-you-ingest” capabilities allow customers to use stored procedures for in-database transformations to easily build real-time data pipelines. Its resource optimization improvements for multi-tenant deployments deliver greater control and scalability for varied database sizes whether on-premises or in the cloud.

Additional features released with MemSQL 6.5 include full-text search built in, which eliminates the need for a separate specialized data store and allows developers to simplify architecture and improve overall performance. Now MemSQL allows developers to continuously ingest from Hadoop into a structured relational format to deliver faster analytics using the familiarity of ANSI SQL.

“To extract optimal insights from data, modern applications will require an integrated database that handles both transactions and analytics,” said Matt Aslett, Research Director, 451 Research. “As data growth and usage increases, so does the need for a more scalable database architecture. These new capabilities haven’t been possible with legacy databases.”

“Legacy databases aren’t capable of providing the scale, speed, and efficiency that NewSQL databases can,” said Nikita Shamgunov, CEO and co-founder of MemSQL. “With MemSQL 6.5, companies are getting a database that allows them to do more with the data that drives their business. All with familiar tools, faster than before, and at a fraction of the cost.”

MemSQL announced in March that it can scan over a trillion rows per second using standard hardware, making it one of the fastest databases on the market. Achievements of this magnitude push the technology industry forward, and it takes collaboration with partners. MemSQL leveraged the new Intel Xeon Platinum 8180 processors – part of the Intel Xeon Scalable platform – to scan 115.6 billion rows of synthetically-generated trade data in an average response time of 0.0991 seconds. That equates to a scan rate of 1.1 trillion rows per second.

MemSQL also announced in January that it has achieved Amazon Web Services (AWS) Big Data Competency status. This designation recognizes that MemSQL has demonstrated success helping customers evaluate and use the tools, techniques, and technologies of working with data productively, at any scale successfully achieving their big data goals on AWS.

Achieving the AWS Big Data Competency differentiates MemSQL as an AWS Partner Network (APN) member that possesses deep domain expertise in data management, having developed innovative technology and solutions that leverage AWS services. To receive the designation, APN Partners must possess AWS expertise and deliver solutions seamlessly on AWS.

 

Leave a Reply

WWPI – Covering the best in IT since 1980