memsql

High-Speed Ingest

Guest Post: Real-Time Big Data Ingestion with Meterial

This post originally appeared on the Myntra Engineering Blog. Learn how Myntra gained real-time insights on rapidly growing data using their new processing and reporting framework. Background I got an opportunity to work extensively with big data and analytics in Myntra. Data Driven Intelligence being one of the core values at Myntra, so crunching and processing data and reporting meaningful insights for the company is of utmost importance. Everyday millions of users visit Myntra on our App...


MemSQL Performance Benchmark

New Performance Benchmark for Live Dashboards and Fast Updates

Newest Upsert Benchmark showcases critical use case for internet billing with telcos, ISPs, and CDNs MemSQL achieves 7.9 million upserts per second, 6x faster than Cassandra Benchmark details and scripts now available on GitHub The business need for fast updates and live dashboards Businesses want insights from their data and they want it sooner rather than later. For fast-changing data, companies must rapidly glean insights in order to make the right decisions. Industry applications like IoT...


Moving to MemSQL

Tapjoy: Moving to MemSQL

Sean Kelly, Staff Engineer at Tapjoy, has published an engineering blog post about the Tapjoy migration of a large high velocity ACID data set to MemSQL: http://eng.tapjoy.com/blog-list/moving-to-memsql Tapjoy wanted a horizontally scalable, ACID compliant, MySQL-compatible database and MemSQL turned out to be the right solution for the problem. “MemSQL had everything we wanted, and after an initial pilot, we confirmed it would meet our stated requirements. But the proof is in the pudding. We...


Should You Use a Rowstore or a Columnstore?

This is a repost of an article by Ankur Goyal, VP of Engineering, published on Medium ⇒ The terms rowstore and columnstore have become household names for database users. The general consensus is that rowstores are superior for online transaction processing (OLTP) workloads and columnstores are superior for online analytical processing (OLAP) workloads. This is close but not quite right — we’ll dig into why in this article and provide a more fundamental way to reason about when...


Oracle and MemSQL Together

Using Oracle and MemSQL Together

Photo: Martin Taylor We often hear “How can I use MemSQL together with my Oracle database?” As a relational database, MemSQL is similar to an Oracle database, and can serve as an alternative to Oracle in certain scenarios. Here is what sets MemSQL apart: MemSQL is a distributed system, designed to run on multiple machines with a massively parallel processing architecture. An Oracle database, on the other hand, resides in a single, large machine, or a smaller fixed cluster size. MemSQL has...


Case Study: How Tradelab Enables Real-Time Bidding with MemSQL

Tradelab, a programmatic marketing platform company based in France, uses MemSQL to process and analyze real-time bidding data for hundreds of customers. Challenge: NoSQL Data Latency The Tradelab real-time ad serving platform requires a heavy mixed read/write workload, and the NoSQL database they had in place was introducing unnecessary data latency into the ad-bidding process. The company began searching for a replacement – a true real-time data management solution with two key...


Douglas Butler MemSQL

Everyone Deserves Nice Things

Software is eating the world! It’s a data explosion! The Internet is now of Things! Scratch that, even better – it is of Everything! Did Big Data just call out IoT on Twitter? Click here to find out. [1] I kid the Internet. In all seriousness, what a magical time we live in. Moore’s Law means cheap hardware, then next thing you know, Cloud. Internet ubiquity invites the globe to the party. Feats of software engineering that were impossible for nation-states to pull off a...


Coinalytics Taps MemSQL to Fuel Blockchain Analytics

Bitcoin has occupied headlines of technology and business publications over the past several years. The concept of digital currency, or cryptocurrency, rocked the financial industry, and public opinion about the applications of Bitcoin continues to ebb and flow. Today, Bitcoin is being overshadowed by another technology: blockchain. Blockchain is a public ledger for Bitcoin and other cryptocurrencies. This is where the real money is, say payment industry experts. Blockchain is a distributed...


Market Making with MemSQL: Simulating Billions of Stock Trades in Real Time

I woke up around 7:30 AM on Monday August 24th, checked my phone while lying in bed, and saw that I had lost thousands of dollars in my sleep. Great way to start the week… I was not alone – few investors escaped “Black Monday” unscathed. The past several months have been full of sudden surges and declines in stock prices, and extreme volatility is apparently the “new normal” for global financial markets. Frequent and dramatic market swings put a high premium on access to...


Technical Deep Dive into MemSQL Streamliner

MemSQL Streamliner, an open source tool available on GitHub, is an integrated solution for building real-time data pipelines using Apache Spark. With Streamliner, you can stream data from real-time data sources (e.g. Apache Kafka), perform data transformations within Apache Spark, and ultimately load data into MemSQL for persistence and application serving. Streamliner is great tool for developers and data scientists since little to no code is required – users can instantly build their...