Author: Alec Powell

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


Database Multi-Tenancy in the Cloud and Beyond

In today’s wave of Enterprise Cloud applications, having trust in a data store behind your software-as-a-service (SaaS) application is a must. Thus, multi-tenancy support is a critical feature for any enterprise-grade database. This blog post will cover the ways to implement multi-tenancy, and best practices for doing so in MemSQL. As customer table sizes grow, you will need to scale out your multi-tenant database across dozens of machines. To support rich analytics about your customers or...