blog header

Partner Guest Post: handytec Provides Fast Geoanalytics with MemSQL

By Jorge Jaramillo, Managing Partner – handytec Data is constantly being collected and analyzed. In business, we typically analyze that data with charts, graphs, or lists to create actionable insights. However, there is one element missing with traditional data analysis, and that is the “where” element. This is when geoanalytics becomes relevant. Geoanalytics is the correlation between data and its physical location. This means that more insights on the data can be created, such as...


blog header

Diversifying Your Enterprise Tech Stack

Companies are living organisms. As they mature they tend to slow down a bit and align to familiar routines. This pattern has the benefit of keeping the primary corporate economic engine stable and avoiding unintentional disruption. However, that same ‘disruption avoidance’ can cause companies to become so sedentary that they miss the next innovation wave. Conceptually, we understand the desire and need for large companies to stay innovative, and they try many different approaches to avoid...


blog header

The Database Guide for Spark+AI Summit 2018

Spark+AI Conference is in San Francisco June 4-6. It’s the preeminent conference covering all things Spark. Since 2013 the conference has helped developers learn and explore the possibilities of delivering modern data-driven applications at scale. The overarching theme of this years show is the unification of data and AI. New applications that include AI require massive amounts of constantly changing data, and Apache Spark is at the center of this data processing opportunity. Sessions of...


funding

Helping Enterprises Derive Value from Data with Our Series D

We are thrilled to share that we raised $30 million in our Series D. This round of fundraising was led by GV (formerly Google Ventures) and Glynn Capital, and brings our total fundraising to $110 million. Why are firms continuing to invest in MemSQL? Database technology sets the foundation for business leaders looking to derive value from data. Across the industries and companies we support, MemSQL is driving digital transformation for some of the world’s business giants including companies...


How Careful Engineering Led to Processing Over a Trillion Rows Per Second

On March 13, we published a blog demonstrating the performance of MemSQL in the context of ad hoc analytical queries. Specifically, we showed that the query SELECT stock_symbol, count(*) as c FROM trade GROUP BY stock_symbol ORDER BY c desc LIMIT 10; 12345 SELECT stock_symbol, count(*) as cFROM tradeGROUP BY stock_symbolORDER BY c descLIMIT 10; can process 1,280,625,752,550 rows per seconds on a MemSQL cluster...


Matching Modern Databases with ML and AI

Introduction Machine Learning (ML) and Artificial Intelligence (AI) have stirred the technology sector into a flurry of activity over the past couple of years. However, it is important to remember that it all comes back to data. As Hilary Mason, a prominent data scientist, noted in Harvard Business Review*, …you can’t do AI without machine learning. You also can’t do machine learning without analytics, and you can’t do analytics without data infrastructure. Over the last year we...


blog opener

Architecting Data in the AWS Ecosystem

Amazon Web Services (AWS) is a juggernaut of a platform, and many of today’s database solutions can run on AWS, including MemSQL. Recently, we held a meetup at our office in San Francisco during AWS Summit 2018 to discuss how customers can benefit from using MemSQL within the AWS ecosystem. In the talk, “Architecting Data in the AWS Ecosystem,” Seth Luersen from MemSQL took a look at the overall data landscape related to the purpose-built databases from Amazon Web Services. He illustrated...


Visual Takeaways from Gartner Data and Analytics 2018

We attended the Gartner Data and Analytics Summit in Grapevine, Texas in early March. This series is part of its global events schedule and similar conferences happen around the world. One fun hallway display was a series of animated summaries with key themes, tracks, and sessions of the conference. They were created by Katherine Torrini at Creative Catalyst. The first display covered the primary show themes of scaling the value of data and analytics: – Establishing Trust in the data...


Create a MemSQL Pipeline for Apache Kafka in 5 minutes

Creating an IoT Kafka Pipeline in Under Five Minutes

In a recent MemSQL webcast, we discussed how modern enterprises can easily adopt new data management tools to manage data size, growth, and complexity. Then we demonstrated how to use Apache Kafka and MemSQL to build interactive, real-time data pipelines. Data pipelines capture, process, and serve massive amounts of data to millions of users. During the webcast we also shared how to: Build new data pipelines with modern tools Enable data workflows to support machine learning and predictive...


Operationalizing MemSQL

In a recent webcast, we shared some tips and tricks on how you can operationalize MemSQL for configuring MemSQL Ops and MemSQL root user passwords; memory settings and health metrics; and how you can take backups and add nodes securely to your cluster. Here are the topics we covered: Permissioning a new cluster by adding a super-user to MemSQL Ops and via GRANT statements on the cluster itself   Best practices for configuring memory limits Best practices for basic cluster monitoring, and how...