memsql

design blog

Designing for a Database: What’s Beyond the Query?

Even the most technically-minded companies need to think about design. Working on a database product at a startup is no different. But this comes with challenges, such as figuring out how to implement the human-centered design methodology at a technical company, but also contribute to building a design process that everyone agrees with across the organization. This blog will detail how product design is done at MemSQL as well as highlight how to design enterprise products at a startup.   How do...


Five Sessions to Attend at Join Conference in San Francisco

Join Conference in San Francisco brings together thousands of companies across the globe that build their businesses with Looker. The developers responsible for this revolution need a place to share their experiences on this journey. This year, Join will offer even more breakout sessions led by Looker subject matter experts and top customers. This informative mixture of lectures, demonstrations, and guest speakers is geared towards keeping attendees informed on technical content, customer...


Five Sessions to Attend at Kafka Summit San Francisco

Kafka Summit San Francisco brings together thousands of companies across the globe that build their businesses on top of Apache Kafka. The developers responsible for this revolution need a place to share their experiences on this journey. This year, Kafka Summit San Francisco will offer even more breakout sessions led by Kafka subject matter experts and top Kafka customers. This informative mixture of lectures, demonstrations, and guest speakers is geared towards keeping attendees informed on...


A Deeper Look at MemSQL Cloud

What’s new with MemSQL? First, we announced the general availability of MemSQL Cloud, our managed service offering. Second, we are fulfilling our plans to be the world’s leading real-time data warehouse. Now Chief Information, Data, and Analytics officers can make a strategic choice for the future: Freedom to choose a managed service for fast execution and convenience Deploy on any public or private cloud Or mitigate expensive appliances with a scale-out on-premises solution Where did the...


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