Follow Datanami:
April 29, 2014

MemSQL Ops Announced

SAN FRANCISCO, Calif., April 29 — MemSQL, the leader in real-time big data analytics technology, today announced the release of MemSQL Ops. MemSQL Ops provides real-time insight for performance monitoring, capacity planning and problem diagnosis of a cluster. The out-of-box dashboards highlight the critical key metrics while allowing DBAs to easily modify for their needs. This latest release allows companies to take advantage of the full speed, scale and simplicity of MemSQL, the world’s fastest distributed in-memory SQL database.

“At Shutterstock, we have thousands of nodes storing millions of metrics every minute. In order to perform real time analysis on this data we chose MemSQL Ops to be the platform on which we perform these crucial systems analytics. Because this data is about real-time site performance, a delay even as short as five minutes isn’t acceptable,” states Chris Fisher, VP of Technical Operations at Shutterstock. “MemSQL is the right platform to handle our scale and provide real-time insights, allowing us to effectively manage our infrastructure and prevent anomalies.”

MemSQL Ops dashboards allow DBAs to continuously see the consumption of cluster resources with convenient drilldowns to fine grain utilization metrics. Key metrics and alerts are highlighted for easy problem diagnosis, such as zeroing in on the most active tables in each cluster. MemSQL Ops delivers out-of-box dashboards to answer key questions that seasoned DBAs typically ask; it also delivers the ability to fully customize or create new dashboards.

“In-memory databases continue to rapidly gain market acceptance as more organizations aim to deal simultaneously with both the volume and velocity aspects of big data. MemSQL delivers extreme performance at scale with its distributed and optimized NewSQL offering, whether it is running on commodity hardware or in a cloud,” said Enterprise Strategy Group analyst Nik Rouda. “This release makes it much easier for database administrators to manage clusters of any size; it quickly finds hot spots or resource issues through an intuitive, visual dashboard and enables users to better tune the environment for best results.”

In just a second, DBAs can examine CPU and memory usage and know which queries run longest or most often. This tool eliminates the guesswork from capacity planning and makes query analysis a simple point-and-click task. Problem diagnosis is expedited with the dashboards that identify hot spots and trends using real-time usage for every CPU core, memory and disk along with the network performance of each individual node. This eliminates the typical time-intensive guesswork involved in problem diagnosis.

“Real-time operational control for clusters has been a void in the market. MemSQL Ops delivers simple, easy-to-use real-time operational dashboards that answer the most pressing questions of seasoned DBAs,” said Eric Frenkiel, co-founder and CEO of MemSQL. “Our customers are elated to finally have a real-time view of their entire cluster — from small clusters up to hundreds of machines — that allows them to proactively plan their growth and maximize their cluster performance.”

Datanami