I ntroducon to MemSQL Appendix: MemSQL Capability Checklist MemSQL Capabilies MemSQL ARCHITECTURE Distributed Shared Nothing Scale out Architecture ⬤ ACID transacons ⬤ High Availability and Disaster Recovery ⬤ Lock-free synchronizaon ⬤ Mul-version concurrency control ⬤ Distributed Query execuon ⬤ Deployment flexibility (Mul-Cloud and On-Premises) ⬤ Compressed columnar table format on disk ⬤ Row store in memory ⬤ QUERY SQL-92 ⬤ SQL-99 OLAP Extensions ⬤ SQL-2003 extensions ⬤ Mul-statement transacon ⬤ 29