SLIDE 1
Automating Query Caching with Data Grids
Roland Lee VP of Product
2
- Intro to Database Proxy concept
- Query caching
- Other use cases
- Demo
Automating Query Caching with Data Grids Roland Lee VP of Product - - PowerPoint PPT Presentation
Automating Query Caching with Data Grids Roland Lee VP of Product - - PowerPoint PPT Presentation
Automating Query Caching with Data Grids Roland Lee VP of Product Agenda Intro to Database Proxy concept Query caching Other use cases Demo 2 Executive Summary Database Proxies: Improves SQL read/write
SLIDE 2
SLIDE 3
3
- Database Proxies:
- Improves SQL read/write performance and reliability
- Deployment requires no application changes
Executive Summary
SLIDE 4
4
Feature ProxySQL
Automated Failover Read/Write split Database Vendor Neutral Automated Cache invalidation Reduces network latency
✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓
Database Proxy Vendors
SLIDE 5
5
Amazon ElastiCache
- Best scale & performance
- Greenfield applications
- Requires code changes
- May be “good enough”
- Existing applications, small dev
- No code changes
ProxySQL
IMDG vs. Database Proxies
SLIDE 6
Transparent Database Proxy
Click to add text
SLIDE 7
7
Application
Heimdall Data Proxy Vendor Database Driver
Application Server
Runs as an agent
Application
Heimdall Data JDBC Vendor JDBC Driver
JDBC driver, .jar file Application Server Any JDBC data source
Software Package Options
SLIDE 8
8
QUERY CACHING AUTOMATED FAILOVER
BATCH PROCESSING
CONNECTION POOLING READ/WRITE SPLITS ACTIVE DIRECTORY HEIMDALL DATABASE PROXY PLATFORM APPLICATION
Aurora, RDS, Redshift
Database Proxy Platform
SLIDE 9
9
Heimdall DB Proxy
Application Server
Application
Heimdall DB Proxy
Database Proxy Tier
SQL Application
Application Server
Heimdall Central Console Heimdall DB Proxy
Heimdall Centralized Deployment
SLIDE 10
10
Application Server
Application
Heimdall Data
Heimdall Distributed Deployment
Application Servers
Application Server
Application
Heimdall Data
Application Server
Application
Heimdall Database Proxy
Application Server
Heimdall Central Console ElastiCache
SQL Analytics Audit Logging Amazon Aurora RDS, Redshift
SLIDE 11
Use Cases
SLIDE 12
12
Uses real-time analysis and statistics on:
- Query frequency and variability
- Relative performance of Cache vs. Database
Provides:
- Auto-cache only if there is a performance benefit
- Cache recommendations and benefits
How Caching Works
SLIDE 13
13
L2 Cache
Heimdall DB Proxy Local Cache Application SQL SQL Heimdall DB Proxy Application SQL SQL Local Cache
App VM 1 App VM 2 Write Read 1 Read 2
Caching and Read/Write Splits
SLIDE 14
14
Very cacheable. 700 µs per query
SQL Analytics
SLIDE 15
Demo
Click to add text
SLIDE 16
16
Amazon ElastiCache
- Best scale & performance
- Greenfield applications
- Requires code changes
- Good enough
- Existing applications, small dev
- No code changes
ProxySQL
IMDG vs. Database Proxies
SLIDE 17
17