I ntroducon to MemSQL Table of Contents Introducon 3 D ata Plaorm Landscape 3 H ow MemSQL Modernizes Data Plaorms 5 Core MemSQL Technical Concepts 7 Code Generaon and Compiled Plans 7 Lock-Free data structures 9 Mul-Version Concurrency Control 10 Disk-opmized columnstores and memory-opmized rowstore tables 11 Distributed Query Processing 13 Core Architecture 16 Key Components of a MemSQL Cluster 17 Database Parons and Sharding 18 Sharded and Reference tables 19 Parallel Data Ingest with Pipelines 20 Cluster Management 21 Dynamic Cluster resizing 22 Data Replicaon 22 Feedback-driven Workload Manager 23 MemSQL Security 24 MemSQL Studio 25 Cloud-nave Support and Managed Service 26 MemSQL Innovaon History 27 Conclusion 28 Appendix: MemSQL Capability Checklist 29 2