Category: Column Stores

Feed: MemSQL Blog. Author: Floyd Smith. As interest in MemSQL increases, we get many questions about how MemSQL works, how to get started with it, and more. Performance reviews website G2.com has a MemSQL Q&A section where potential customers can ask questions. Here are some of the questions we hear most often – with answers – lightly edited, for context and clarity. Q. What is the advantage of MemSQL over other distributed databases? A. Compared to relational databases – those which support SQL – we believe that MemSQL is the fastest, most efficient SQL database. MemSQL features full, linear scalability, ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. MemSQL is garnering a lot of positive attention on business solutions review site G2.com (formerly known as G2 Crowd). Since our look at the site last July, dozens of new reviews have been posted, citing MemSQL’s speed, high capacity, and SQL compatibility, among other features. However, the most recent review was in December; now, some lucky MemSQL user has the chance to register the first comment of the new year. (Also, as most would say, of the new decade, though – as xkcd points out – this is a matter of some controversy.) G2.com ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Why did the world need MemSQL? In this blog post, updated from a few years ago, early MemSQL Product Manager Carlos Bueno explains why MemSQL works better, for a wide range of purposes, than a NoSQL setup. (Thanks, Carlos!) We’ve updated the blog post with new MemSQL product features, graphics, and relevant links. To wit, you should also see Rick Negrin’s famous blog post on NoSQL and our recent case study on replacing Hadoop with MemSQL. Tell us if this sounds familiar. Once upon a time a company ran its operations on The Database ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. SME Solutions Group is a MemSQL partner. An SME customer, a utility company, was installing a new meter network, comprising 2 million meters, generating far more data than the old meters. The volume of data coming in, and reporting needs, were set to overwhelm their existing, complex, Hadoop-based solution. The answer: replacing 10 different data processing components with a single MemSQL cluster. The result: outstanding performance, scalability for future requirements, the ability to use standard business intelligence tools via SQL, and low costs. SME Solutions Group (LinkedIn page here) helps institutions manage risks and ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. With the MemSQL 7. 0 release, MemSQL has added more special-purpose features, making it even easier to manage time series data within our best-of-breed operational database. These new features allow you to structure queries on time series data with far fewer lines of code and with less complexity. With time series features in MemSQL, we make it easier for any SQL user, or any tool that uses SQL, to work with time series data, while making expert users even more productive. In a recent webinar (view the recording here), Eric Hanson described the new ... Read More

Feed: MemSQL Blog. Author: Adam Prout. This blog post was originally published in January 2014, and it has long been the first blog post on the MemSQL blog – and one of the best. In this blog post, MemSQL ceo-founding engineer Adam Prout explains one of the key technical features that distinguishes MemSQL: its use of skiplist indexes over Btrees and similar structures. Adam has now revised and updated this blog post to include the recently released MemSQL 7.0 and MemSQL SingleStore™. The most popular data structure used for indexing in relational databases is the Btree (or its variant, the ... Read More

Feed: MemSQL Blog. Author: Peter Guagenti. MemSQL’s breakthrough new “SingleStore” data management, enhanced system of record capabilities, time series enhancements, and more, are now available instantly and on demand with MemSQL Helios. You can try MemSQL 7.0 and Helios for free, instantly. MemSQL is proud to announce the general availability of MemSQL 7.0, available first on MemSQL Helios, the company’s elastic cloud database available on public cloud providers around the globe. Fully managed and available on demand, MemSQL Helios delivers instant, effortless access to the world’s fastest, most scalable data platform for operational analytics, machine learning and AI. MemSQL 7.0 ... Read More

Feed: MemSQL Blog. Author: Eric Hanson. MemSQL is uniquely suited to real-time analytics, where data is being ingested, updated, and queried concurrently with aggregate queries. Real-time analytics use cases often are based on event data, where each separate event has a timestamp. It’s natural to interpret such a sequence of events as a time series. Prior to the 7.0 release, MemSQL delivered many capabilities that make it well-suited to time-series data management [Han19]. These include: a scaled-out, shared-nothing architecture that supports transactional and analytical workloads with a standard SQL interface, fast query execution via compilation and vectorization, combined with scale ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Thorn’s child sex trafficking investigations tool, Spotlight, gathers information from escort sites to provide law enforcement with a tool to help find trafficked children, fast. (A Special Agent for the Wisconsin Human Trafficking Task Force describes Spotlight this way: “It is the greatest tool we have in the fight against human trafficking.“) And using MemSQL is one of the ways they do it. MemSQL is a powerful solution that meets Thorn’s requirements, including SQL support; fast query response time; support for machine learning and AI; a large and scalable number of simultaneous users; and ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Even though MemSQL is a distributed system, you can run a minimal version of MemSQL on your laptop in Kubernetes. We tell you how in this blog post. The combination of free access, and being able to run MemSQL on your laptop, can be extremely convenient for demos, software testing, developer productivity, and general fooling around. In this post we’ll quickly build a single-instance MemSQL cluster running inside Kubernetes on Docker Desktop, on a laptop computer, for free. You’ll need a machine with at least 8GB RAM and four CPUs. This is ideal for ... Read More