Engineering

How to Deploy MemSQL on the Mesosphere DCOS

The Mesosphere Datacenter Operating System (DCOS) is a distributed operating system designed to span all machines in a datacenter. It provides mechanisms for deploying applications across the entire system with a few simple commands. MemSQL is a great fit for deployment on DCOS because of its distributed, memory-optimized design. For example, users can scale computation and storage capacity by simply adding nodes. MemSQL deploys across commodity hardware and cloud, giving users the flexibility...


Big Data Scala by the Bay

The Resurgence of Scala for Big Data

Big Data Scala by the Bay, Aug 16-18, is shaping up to be an engaging event, and will bring together top data engineers, data scientists, developers, and data managers who use the Scala language to build big data pipelines. At the MemSQL booth, we will showcase how enterprises can streamline this process by building their own real-time data pipelines using Apache Kafka, Apache Spark and operational databases. Many of our customers are moving to this real-time data pipeline: a simplified Lambda...


MemSQL Ops

Download the New and Improved MemSQL Ops

The latest release of MemSQL Ops – version 4.0.34 – is now available for download! In this release, we are offering MemSQL users new features to accelerate productivity. Download MemSQL Ops to get up and running on MemSQL Community Edition or MemSQL Enterprise Edition today. MemSQL Ops downloads and upgrades are available for free to all MemSQL Community and Enterprise users. Here are some of the features in the new MemSQL Ops release: Ops Superusers The new MemSQL Ops comes with...


believable benchmark

How to Make a Believable Benchmark

Albrecht Dürer, ‘Man drawing a Lute’, woodcut, 1525 A benchmark asks a specific question, makes a guess about the expected result, and confirms or denies it with experiment. If it compares anything, it compares like to like and discloses enough details so that others can plausibly repeat it. If your benchmark does not do all of these things, it is not a benchmark. Today’s question comes from one of our engineers, who was talking to a customer about new features in MemSQL 4. We...


How We Hire Engineers

How We Hire Remarkable Engineers

To achieve our vision of building the next great database company, we seek the highest caliber engineers. Each team member brings expertise in areas like storage systems, code generation, query optimization, infrastructure testing, and more to MemSQL, with previous roles at companies like Facebook, Microsoft, Oracle, and Google. Our engineering team includes graduates of top university programs, including MIT, Stanford, and Carnegie Mellon University, and highly-rated competition programmers...


MemSQL and Docker

Run MemSQL in Minutes with Docker

Evaluating software infrastructure is important, but it should not be difficult. You should be able to try and see quickly whether a piece of core software suits your needs. This is one of the many helpful use cases for Docker. Of course Docker has many more uses, including helping run a 107 node cluster with CoreOS, but this post focuses on the quick start scenario. With an install of boot2docker.io for Mac or Windows, and a pre-configured ‘cluster-in-a-box’ Docker container, you can be on...


overlap targeting

Boost Conversions with Overlap Ad Targeting

Digital advertising is a numbers game played out over billions of interactions. Advertisers and publishers build predictive models for buying and selling traffic, then apply those models over and over again. Even small changes to a model, changes that alter conversion rates by fractions of a percent, can have a profound impact on revenue over the course of a billion transactions. Serving targeted ads requires a database of users segmented by interests and demographic information. Granular...


high-speed-counters

Turn Up the Volume With High-Speed Counters

Scaling tends to make even simple things, like counting, seem difficult. In the past, businesses used specialized databases for particular tasks, including high-speed, high-throughput event counters. Due to the constraints of legacy systems, some people still assume that relational databases cannot  handle high-throughput tasks at scale. However, due to advances like in-memory storage, high-throughput counting no longer requires a specialized, single-purpose database. Why do we even need...


geospatial intelligence database

Geospatial Intelligence Coming to MemSQL

This week at the Esri Developers Summit in Palm Springs, our friends at Esri are previewing upcoming features for the next release of MemSQL, using a huge real-world geospatial dataset. Esri develops geographic information systems (GIS) that function as an integral component in nearly every type of organization. In a recent report by the ARC Advisory Group, the Geographic Information System Global Market Research Study, the authors stated, “Esri is, without a doubt, the dominant player in...


MemSQL at AMP Lab

MemSQL at the AMP Lab

Please join us next week as two members of the MemSQL engineering team present at the AMPLab at Berkeley on Wednesday March 11th from 12:00pm to 1:00pm. AMP SEMINAR Ankur Goyal and Anders Papitto, MemSQL, A Distributed In-Memory SQL Database Wednesday 3/11, Noon, 405 Soda Hall, Berkeley Talk Abstract This talk will cover the major architectural design decisions with discussion on specific technical details as well as the motivation behind the big decisions. We will cover lockfree,...