MemSQL is a highly scalable, distributed database that pairs an in-memory rowstore with an analytics-oriented columnstore on disk. This ability to act as both a row store and a column store concurrently, combined with lock-free data structures, multiversion concurrency control, and lock-free skiplists, allows MemSQL to support real-time analytics, eliminating the need for an additional data warehouse and ETL processes.