Thought Leadership

Cache is the new RAM

One of the (few) advantages of being in technology for a long time is that you get to see multiple tech cycles beginning to end. You get to see how breakthroughs actually propagate. If all you have seen is a part of the curve, it’s hard to extrapolate correctly. You either overshoot the short-term progress or undershoot the long. What’s surprising is not how quickly the facts on the ground change, but how slowly engineering practice changes in response. This is a Strowger switch, an...


The Internet of Furbies

At MemSQL engineering there are few things we love as much as building great products. One, however, is a good laugh. This past weekend a team from MemSQL set out to make our mothers proud at Cultivated Wit’s Comedy Hack Day, an event for comedians and hackers to get together in attempt to make the funniest hack. And drink whiskey. I’m very excited to share with you our product today, the grand prize winner, and the future of wearable technology. Engineering at MemSQL goes to great lengths...


Running MemSQL's 107 Node Test Infrastructure on CoreOS

At a recent CoreOS meetup, I gave a presentation on the design and implementation of Psyduck, which is the name for MemSQL’s test infrastructure.  In this talk, I’ll explain how MemSQL runs over 60,000 tests every day on our 107 machine cluster running CoreOS.


The Write Stuff

Tell me if this sounds familiar. Once upon a time a company ran its operations on The Database Server, a single machine that talked SQL. It was tricked out with fast hard drives and cool blue lights. As the business grew it became harder for The Database to keep up. So they bought an identical server as a hot spare and set up replication, at first only for backups and failover. That machine was too tempting to leave sitting idle, of course. The business analysts asked for access so they could...


How MemSQL Distributes Data

The world is moving toward highly-parallel, distributed systems up and down the stack. It started with the app servers on the front lines. Now it’s happening at the data layer. This is generally a good thing, but these kinds of systems can sometimes feel like a foreign country. In this article we’ll talk about how MemSQL spreads the work around a cluster of servers without sacrificing ease of use. There are two kinds of machines in a MemSQL cluster: aggregators and leaves. The same...


The Size & Shape of Your Tables

If you ever catch yourself doing mental arithmetic, or writing complex queries while trying to debug a capacity or performance problem, it’s a sign that your database is missing a feature. The information you need may exist, but it’s scattered. One of the most frequent feature requests from our users was more detailed statistics about memory use. In the current version of MemSQL tables are stored in memory (hence the name), so memory management and storage capacity planning are essentially...


The Need for Speed Webinar: Take Big Data Real-Time

“The trickiest part of speeding up a program is not doing it, but deciding whether it’s worth doing at all,” says Carlos Bueno, a former Facebook engineer and award-winning author of the Mature Optimization Handbook. He’s now a senior engineer at MemSQL, helping to create in-memory database solutions that create significant value by leveraging Big Data analytics. Register Now. Carl Wright, a former CSO/CTO of the United States Marine Corps, will join Carlos as they discuss how...


Big Data Holds Big Benefits for National Security Programs

The Intelligence Community Information Technology Enterprise (ICITE) initiative, one of the federal government’s most complex and sensitive technology projects, aims to transform the current 17-member U.S. Intelligence Community from agency-specific IT silos to an enterprise environment of shared services and systems. The goal of the project is to cut federal costs and to improve information sharing and data security across intelligence agencies. Join us for an in-depth discussion. Register...


Exploring Big Data Technology with MemSQL

We are taking our message of blazing speed and real-time Big Data analytics on the road. Will you join us? We’ve hosted developer meetups at our headquarters in San Francisco, and we are now an official sponsors of Data Science DC. The developer community is very important to us — as we are developers ourselves — and we are excited to have the opportunity to collaboratively explore modern business issues and build evolving theories around database technology and the future of real-time...


Unsexy Database Features That Matter: Part 2

In the previous post, we talked about how you should focus on how people derive value from your product. Today we will focus on database management — your goal should always be 24/7 100% uptime. How People Manage A Database Product Deployment (time to get the system up and running) How much time does it take to get your product up and running? People have talked about barriers to entry for a long long time. The worst one is, “I couldn’t install your product so I gave up.” This is simply...