---
title: "Interactive Introduction To MemSQL"
description: "Webinar Presentation | 40 Pages"
canonical: "https://memsql.relayto.com/e/interactive-introduction-to-memsql-l0d4xtyywfb3w"
last_updated: "2023-12-17"
---

# Interactive Introduction To MemSQL

> Webinar Presentation | 40 Pages

- Interactive version: https://memsql.relayto.com/e/interactive-introduction-to-memsql-l0d4xtyywfb3w
- Format: PDF document, 40 pages
- Published by: [memSQL](https://memsql.relayto.com/)
- Last updated: 2023-12-17
- More from this site: https://memsql.relayto.com/llms.txt

## Page 3

Today’s Agenda
● Company Overview
(1) Import image to
● Common Use Cases
presentation (2) Go to
crop tool, click down
arrow (3) Select circle
● Product Architecture
shape (4) Adjust image
size using handles and
● Customer Examples
place over this text
● Q&A
Mike Boyarski
Sr Director, Product Marketing
Submit questions in the Question Box
boyarski@memsql.com
2

## Page 4

MemSQL at a Glance
Mission Deliver speed and scale for critical data infrastructure
Product Top-ranked database and data warehouse
Customers
3

## Page 5

Latency Holding Back the Enterprise
Slow Data Loading Lengthy Queries
Batch processing Slow query responses
Hours to load Billion to trillion row tables
Sampled data views No real-time response
Limited User Access
Single-threaded operations
Data silos for mixed workloads
Single-node performance
4

## Page 6

The Enterprise Requires Performance
Live Loading Fast Queries
Stream and bulk data Scalable ANSI SQL
On-the-fly transformations Petabyte scale
Multiple sources Real-time and historical insights
Scalable User Access
Scale-out for performance
Converged transactions and analytics
Powerful workload management
5

## Page 7

What is MemSQL
6

## Page 8

TM
MemSQL: The No-Limits Database
● Scale-out relational database
● Extreme performance at scale
● Lock-free ingest
● High concurrency
● Deploy anywhere
10x faster and 3x more cost effective
than legacy database providers
7

## Page 9

Common Use Cases
Modernize Legacy Workloads Enable New Workloads
● Enable real-time analytics for ● Streaming and IoT analytics
operational systems ● Augment and accelerate Hadoop
● Accelerate performance of ● Real-time machine learning
single-node RDBMS like Oracle ● Replace and consolidate single-use
RAC/Exadata, SQL Server, MySQL, databases like MongoDB, Redis, and
Greenplum, Netezza, Vertica Elastic
9

## Page 10

Unified Platform
High-Speed Ingest Memory-Optimized Tables Disk-Optimized Tables
Fast bulk load or stream data Ultra-low latency for Petabyte scale analytics with
with built-in pipelines transactions and analytics compression and performance
10

## Page 11

Ecosystem Overview
Modern Applications
CDC
Real-Time Data
Kafka Attunity
ETL/ELT
Transforms
Informatica,
Spark
Talend, Alooma
DBMS
BI Dashboards
Relational Data
Data Warehouse
Disk
Streaming Memory
Optimized
Ingest Optimized
Tables
Tables
Data Lakes
Looker Microstrategy Tableau
Hadoop Amazon S3
Bare Metal, Virtual Machines, Containers On-Premises, Cloud, As a Service
11

## Page 12

MemSQL Architecture
12

## Page 13

MemSQL is a Distributed Relational Database
13

## Page 14

MemSQL uses Aggregator Nodes
and Leaf Nodes
Aggregator Aggregator
Leaf Leaf Leaf Leaf
14

## Page 15

MAggrasteergator AAggggregator
Aggregator Aggregator
LLeeaaff LLeeaaff LLeeaaff LLeeaaff
PARTITIONS PARTITIONS PARTITIONS PARTITIONS
Leaf Nodes Store Data in Partitions
15

## Page 16

Every Cluster has at Least One Master
Aggregator and One Leaf Node
MMaasstteerr Agg AAggggregator
Aggregator Aggregator
LLeeaaff LLeeaaff LLeeaaff LLeeaaff
PARTITIONS PARTITIONS PARTITIONS PARTITIONS
16

## Page 17

Application / Database Client
MMaasstteerr Agg AAggggregator
Aggregator Aggregator
LLeeaaff LLeeaaff LLeeaaff LLeeaaff
PARTITIONS PARTITIONS PARTITIONS PARTITIONS
Applications Connect to an Aggregator
17

## Page 18

MMaasstteerr Agg AAggggregator
Aggregator Aggregator
LLeeaaff LLeeaaff LLeeaaff LLeeaaff
PARTITIONS PARTITIONS PARTITIONS PARTITIONS
Pipelines Ingest Across all Leaf Nodes
18

## Page 19

MemSQL Capabilities
19

## Page 20

High-Speed Ingestion
● Stream ingestion
● Fast parallel bulk loading
● Built-in Create Pipeline
● Transactional ACID Consistency
● Exactly-Once Semantics
● Native integrations with Kafka,
AWS S3, Azure Blob, HDFS
20

## Page 21

Durable Distributed Storage
Distributed and Durable Big Data Capacity Highly Available
Store and process on clusters Petabyte scale with up to Online replication ensures
of machines for performance 10x compression and instant data consistency and protects
and persistence query retrieval against outages
21

## Page 22

Ultra-Fast Insights
● Scalable ANSI SQL
● Support for JSON, Geospatial, and
Full-Text Search
● Fast Query Vectorization and
Compilation
● Extensibility with Stored Procedures,
UDFs, UDAs
22

## Page 23

Built for Enterprise Demands
● Interoperable with existing tools & skills
● Deploy on-premises or cloud
● Run on bare metal, VMs, or containers
● Simplified management
● Comprehensive security
23

## Page 24

Enterprise-Grade Security
● Role-Based Access Control (RBAC)
● Encryption
● Authentication
● Audit logging
● Strict mode
24

## Page 25

Easy to Manage and Tune
● Monitor performance and capacity
● API-based deployment and config
● Full administration and scaling
● Query profiler
● Visual query plans
25

## Page 26

Customer Examples
26

## Page 27

How Fanatics Powered Their Way
to a Better Simplified Future
27

## Page 28

Company Profile
• The global leader in licensed sports merchandise
• $2 billion revenue
• Run online stores of all major North American sports
leagues, more than 200 professional and collegiate teams
28

## Page 29

Event-Driven Architecture
For responsiveness, reliability, and scalability
Place Image Here
29

## Page 30

Before MemSQL: Event-Driven Analytics Architecture
Place Image Here
30

## Page 31

With MemSQL: Consolidation, Simplification, and Performance
Place Image Here
31

## Page 32

With MemSQL: Consolidation, Simplification, and Performance
Place Image Here

## Page 33

+ Leading Wireless Provider in the US
● Migrated from to
● Worked great in the beginning
● Unfortunately, ran into:
○ Scalability issues as the workload increased
○ Significant increase in overall cost
○ Support challenges
○ Outages on Tier 1 workloads impacted visibility of network
health
33

## Page 34

+ Leading Wireless Provider in the US
High Speed Operational Analytics - Call Quality Analysis
Business Benefits:
Technical Benefits:
▪ Collect and process KPIs about wireless
▪ Consolidate ~100 TB, ~50K tables, ~55K reports,
network
~1K concurrent users from 4 Exadatas into 2
▪ Reports on health of the wireless network
MemSQL Clusters
▪ Significant cost savings over Oracle - 2.3x
▪ Simpler and easier to manage compared to Oracle
times less
▪ 80-100x faster than Exadata
▪ No change to reporting front-end
▪ Run Oracle queries as-is
34

## Page 35

Financial Services
Real-Time Decision Making
Risk Management, Algorithmic
Trading, and Fraud Detection
A top five financial institution uses MemSQL to
power its real-time customer dashboard to show
the most up-to-date (millisecond) portfolio
summaries
3355

## Page 36

Energy & Utilities
IOT Analytics
Predictive Maintenance, Supply
Chain Analytics, and Utility Grid
Management
Using MemSQL, a top energy provider ingests
drill bit data and reports back key indicators within
minutes, allowing operators to respond
to live conditions and preventing costly drill
failures and outages
3366

## Page 37

High Technology
Operational Analytics
Real-time dashboards, geospatial
analytics, and customer 360
At Uber, MemSQL provides a live operational view
into activity for millions of drivers and customers
every day, delivering geospatial views for
optimizing service delivery and managing
day-to-day operations
3377

## Page 38

Media &
Communication
Ad Analytics, Personalization, and
Streaming Media Analytics
Comcast uses MemSQL to deliver analytics on
data from millions of DVR boxes in real time,
helping Comcast to provide superior customer
experience with proactive service alerts and user
insights for optimizing advertising programs
3388

## Page 39

• Distributed, ANSI SQL, database • Geospatial and JSON
MemSQL
• Full ACID transactions • In-memory and on-disk
Recap
• Lock free, shared nothing • MySQL wire protocol
• Compiled queries • Comprehensive security
• Massively parallel • Rowstore & columnstore tables
Place Image Here
39

## Page 40

Thank You! Questions?
Try at memsql.com/download
● No time limit
● Deploy to production
● Full featured
● Up to 128GB of RAM, unlimited disk
● Get support at forum.memsql.com
Learn more at memsql.com/product
Questions? Email us at team@memsql.com
40
