Author: Carlos Bueno

Lambda Stream

The Lambda Architecture Isn’t

The surest sign you have invented something worthwhile is when several other people invent it too. That means the creative pressure that gave birth to the idea is more general than your particular situation. Even when faced with the same pressures, people will approach an idea in different ways. When Jay Kreps was developing Kafka at LinkedIn, he called it The Log. Facebook (being Facebook) created several independent implementations of “stream-oriented processing”, including Puma and...


SQL

Why MemSQL Placed a Bet on SQL

In the technology industry, when products or innovations last for a long period of time, they are often here to stay. SQL is a great example of this – it has been around for over 30 years and is not going away anytime soon. When Eric Frenkiel and Nikita Shamgunov founded MemSQL in 2011, they were confident in choosing the SQL relational model as the foundation for their database. But the database industry during that era was clamoring around NoSQL, lauding it as the next great innovation,...


Digital Ocean MemSQL Tutorial

Digital Ocean Tutorial Gets You Up and Running in Minutes

As fun as it is to squirrel around inside the guts of some new technology, it’s sometimes nice to follow a recipe and end up with something that Just Works. For years, Digital Ocean, an up and coming cloud provider, has been producing quality tutorials on how to set up cool software on their virtual machines. Today Ian Hansen published an in-depth tutorial on setting up a three-node MemSQL cluster. Check it out here. Go to the Digital Ocean tutorial and learn how to install MemSQL in...


MemSQL on AWS and Azure Marketplaces

MemSQL Community Edition Available on AWS and Azure Marketplaces

Good news, everyone! Today we’re releasing MemSQL Community Edition on the Amazon AWS and Microsoft Azure Marketplaces. Many of our customers run MemSQL in the cloud, and often their entire infrastructure. An even larger number try MemSQL first on the cloud before pulling it into their production systems. A great example is VCare, currently using MemSQL deployed on AWS cloud instances to power its online, real-time charging platform. VCare supports Mobile Virtual Network Operators (MVNOs),...


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...


database capacity planning

Finding and Solving Bottlenecks in Your System

Read data in, write data out. In their purest form, this is what computers accomplish. Building a high performance data processing system requires accounting for how much data must move, to where, and the computational tasks needed. The trick is to establish the size and heft of your data, and focus on its flow. Identifying and correcting bottlenecks in the flow will help you build a low latency system that scales over time. Characterizing your system Before taking action, characterize your...


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...


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 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...