MemSQL Introduces dbbench for Active Database Benchmarking
New Load Generation Tool Fosters Testing to Match Modern Data-Intensive Workloads
San Francisco, CA - January 21, 2016 - MemSQL, the leader in real-time databases for transactions and analytics, today introduced a new open source benchmarking tool that generates continuous loads defined by a flexible configuration. Unlike many other tools that run for a fixed period and then complete, dbbench maintains an ongoing specified workload upon which additional performance tests and measurements can be conducted, so users can find bottlenecks quickly through active benchmarking. This approach fits today’s modern workloads that combine continuous data ingest with concurrent queries.
MemSQL Introduces dbbench for Active Database Benchmarking - Click to Tweet
“As we pursue real-time solutions with our customers, we have seen the need to benchmark use cases with continuous load and stress testing,” said Ankur Goyal, VP of Engineering, MemSQL. “dbbench allows us to model these intensive environments and ensure MemSQL achieves the highest performance possible on any given deployment platform.”
“While there are many great database benchmarking tools out there, we found that modern engineering requires a more robust, active benchmarking approach to match the flow of real-time data,” added Alex Reece, performance engineer, MemSQL, and the creator of dbbench. “dbbench runs continuously, allowing developers to ask difficult questions about how their system performs under heavy load and identify bottlenecks, a necessity for today’s complex workloads that combine transactions and analytics.”
The Internet of Things (IoT) is a perfect example where companies need to capture an ongoing stream of data and deliver insights and action based on querying that data. As IoT expands, greater volumes of data from disparate sources engender more questions about the meaning and value of that data. Performance engineers can use a question-driven methodology with dbbench to investigate these large, continuously running workloads. In just a few simple lines of configuration code, engineers can define and run a complicated workload with a wide range of concurrent reads and writes. This flexibility enables quick iteration and improvisation of new workloads for deeper analysis. Overall, dbbench reflects a shift in performance benchmarking towards a more active approach.
With dbbench, MemSQL continues its efforts in making other tools available as open source such as MemSQL Streamliner, an integrated Apache Spark solution for real-time streaming, and MemSQL Loader for natively importing data from HDFS and S3.
To download dbbench, visit github.com/memsql/dbbench
Read the technical blog post at blog.memsql.com/dbbench-active-benchmarking
MemSQL is the leader in real-time databases for transactions and analytics. As a purpose built database for instant access to real-time and historical data, MemSQL uses a familiar SQL interface and a horizontally scalable distributed architecture that runs on commodity hardware or in the cloud. Innovative enterprises use MemSQL to better predict and react to opportunities by extracting previously untapped value in their data to drive new revenue. MemSQL is deployed across hundreds of nodes in high velocity big data environments. Based in San Francisco, MemSQL is a Y Combinator company funded by prominent investors including Accel Partners, Khosla Ventures, First Round Capital and Data Collective. Follow us @MemSQL or visit at www.memsql.com.
Director of Communications