Interactive Introduction To MemSQL
Webinar Presentation | 40 Pages
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 [email protected] 2
MemSQL at a Glance Mission Deliver speed and scale for critical data infrastructure Product Top-ranked database and data warehouse Customers 3
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
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
What is MemSQL 6
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
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
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
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
MemSQL Architecture 12
MemSQL is a Distributed Relational Database 13
MemSQL uses Aggregator Nodes and Leaf Nodes Aggregator Aggregator Leaf Leaf Leaf Leaf 14
MAggrasteergator AAggggregator Aggregator Aggregator LLeeaaff LLeeaaff LLeeaaff LLeeaaff PARTITIONS PARTITIONS PARTITIONS PARTITIONS Leaf Nodes Store Data in Partitions 15
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
Application / Database Client MMaasstteerr Agg AAggggregator Aggregator Aggregator LLeeaaff LLeeaaff LLeeaaff LLeeaaff PARTITIONS PARTITIONS PARTITIONS PARTITIONS Applications Connect to an Aggregator 17
MMaasstteerr Agg AAggggregator Aggregator Aggregator LLeeaaff LLeeaaff LLeeaaff LLeeaaff PARTITIONS PARTITIONS PARTITIONS PARTITIONS Pipelines Ingest Across all Leaf Nodes 18
MemSQL Capabilities 19
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
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
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
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
Enterprise-Grade Security ● Role-Based Access Control (RBAC) ● Encryption ● Authentication ● Audit logging ● Strict mode 24
Easy to Manage and Tune ● Monitor performance and capacity ● API-based deployment and config ● Full administration and scaling ● Query profiler ● Visual query plans 25
Customer Examples 26
How Fanatics Powered Their Way to a Better Simplified Future 27
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
Event-Driven Architecture For responsiveness, reliability, and scalability Place Image Here 29
Before MemSQL: Event-Driven Analytics Architecture Place Image Here 30
With MemSQL: Consolidation, Simplification, and Performance Place Image Here 31
With MemSQL: Consolidation, Simplification, and Performance Place Image Here
+ 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
+ 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
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
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
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
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
• 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
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 [email protected] 40
