memsql

blog header

MemSQL 201: Tips & Tricks Webcast

In a recent webcast, we shared tips and tricks for understanding MemSQL, best practices for implementation, and demoed MemSQL with a real-world use case. Here are five top tips and tricks we shared: When moving an application to, or creating one on MemSQL, start by thinking about whether rowstore or columnstore storage (or both) is ideal If you have high throughput requirements, consider using MemSQL Pipelines Use EXPLAIN and PROFILE operators to identify query bottlenecks Take advantage of...


Machine Learning and MemSQL

What is Machine Learning? Machine learning (ML) is a method of analyzing data using an analytical model that is built automatically, or “learned”, from training data. The idea is that the model gets better as you feed it more data points, enabling your algorithm to automatically get better over time.   Machine learning has two distinct steps, training, and operationalization. Training takes a data set you know a lot about (known as a training set), then explores the data set to find...


A Brief Introduction to MemSQL

A Brief Introduction to MemSQL

We know choosing or evaluating a new database technology can be challenging due to the variety of choices available. In a recent webcast, we shared various use cases businesses face with traditional database and data warehouse technologies, key differentiators and architectures of MemSQL, sample applications and customer case studies, and a quick demo of MemSQL. MemSQL provides an adaptable database for real-time applications that unite transactions and analytics in a single high-performance...


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