Author: MemSQL Support

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

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 Docker. We tell you how in this blog post. The combination of free use of the software, 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 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 ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. How does a major technology services company equip itself to compete in the digital age – and provide services so outstanding that they can significantly advance the business prospects of their customers? All while reducing complexity, cutting costs, and tightening SLAs – in some cases, by 10x or more? For one such company, the solution is to deliver real-time, operational analytics with Kafka and MemSQL. In this company, data flowed through several data stores, and from a relational, SQL database, into NoSQL data stores for batch query processing, and back into SQL for BI, ... Read More

Feed: MemSQL Blog. Author: Mark Lochbihler. On Tuesday, November 12th, MemSQL will be presenting a workshop at AWS Partner Developer Day. (Click here to join, or here for the Presentation and Student Guide on Github.) The workshop will be held at the AWS office at 350 West Broadway in New York City. The workshop will be focused on teaching customers how to enable real-time, data-driven insights. In the workshop, Amazon Sagemaker, the AWS managed service for deploying machine learning models quickly, will be shown working with MemSQL, a highly performant, cloud-native database. MemSQL supports streaming data analytics and the ability ... Read More

Feed: MemSQL Blog. Author: Micah Bhakti. Our new database-as-a-service offering, MemSQL Helios, was relatively easy to create – and will be easier to maintain – thanks to Kubernetes. The cloud-native container management software has been updated to more fully support stateful applications. This has made it particularly useful for creating and deploying MemSQL Helios, as we describe here. From Cloud-Native to Cloud Service MemSQL is a distributed, cloud-native SQL database that provides in-memory rowstore and on-disk columnstore to meet the needs of transactional and analytic workloads. MemSQL was designed to be run in the cloud from the start. More than ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. SME Solutions Group helps institutions manage risks and improve operations, and they’ve chosen MemSQL as a database partner. Their premier services include data analytics and business intelligence (BI) tools integration, areas where MemSQL adds tremendous value. In this webinar, SME Solutions Group describes how they use MemSQL to solve a wide range of problems, including big data and fast data needs for utilities. How MemSQL Fits SME Mike Czabator, a systems engineer with MemSQL, describes MemSQL as a fully relational, fully distributed, memory-first database. It loads data live; scales out to support arbitrarily large ... Read More

Feed: MemSQL Blog. Author: Rick Negrin. MemSQL VP of Product Rick Negrin describes the upcoming MemSQL 7. 0 in depth. He describes crucial features such as fast synchronous replication, for transaction resilience, and SingleStore, which leads to lower total cost of ownership (TCO) and more operational flexibility, at both the architectural and operational levels. Negrin also describes new tools for deploying and managing MemSQL and new features in MemSQL Studio for monitoring, investigating active processes, and editing SQL. This blog post focuses on MemSQL 7.0 and the new features in MemSQL Studio. It’s based on the third part of our ... Read More