1 Executive Summary Database Proxies: Improves SQL read/write - - PowerPoint PPT Presentation

▶
1 executive summary
SMART_READER_LITE
LIVE PREVIEW

1 Executive Summary Database Proxies: Improves SQL read/write - - PowerPoint PPT Presentation

Nov 02, 2022 148 likes •335 views

1 Executive Summary Database Proxies: Improves SQL read/write performance and reliability Deployment requires no application changes Demo 2 IMDG vs. Database Proxies Feature ProxySQL Automated Failover

slide-1
SLIDE 1

1

slide-2
SLIDE 2

2

  • Database Proxies:
  • Improves SQL read/write performance and reliability
  • Deployment requires no application changes
  • Demo

Executive Summary

slide-3
SLIDE 3

3

Feature ProxySQL

Automated Failover Query routing Database Vendor Neutral Automated Cache invalidation Reduces network latency

✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓

IMDG vs. Database Proxies

slide-4
SLIDE 4

4

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-5
SLIDE 5

Transparent Database Proxy

Click to add text

slide-6
SLIDE 6

6

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-7
SLIDE 7

7

SQL CACHING AUTOMATED FAILOVER

BATCH PROCESSING

CONNECTION POOLING READ/WRITE SPLITS HTAP HEIMDALL DATABASE PROXY PLATFORM APPLICATION

Aurora, RDS, Redshift

Database Proxy Platform

slide-8
SLIDE 8

8

Application Server

Application

Heimdall Data

Heimdall Transparent 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-9
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
SLIDE 10

Use Cases

slide-11
SLIDE 11

11

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-12
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
SLIDE 13

13 4 3 2 1

Data Generator DML Request

6 5 4 3 2 1

Queue

Batch Size 4 7 8 START TRANSACTION; DML 1; DML 2; DML 3; DML 4; COMMIT;

Exceptions are logged, removed from batch, and transaction restarted Benefits:

  • Lower CPU overhead due to fewer commits
  • Improved application response time
  • Improved DML scale

#1 #2 #3 #4

Batch Processing

slide-14
SLIDE 14

14

Data Consumers Heimdall Data SQL Traffic Manager OLTP Analytics

Materialized View management

HTAP: Intelligent OLTP/OLAP Routing

Amazon Redshift

slide-15
SLIDE 15

15

Very cacheable. 700 µs per query

SQL Analytics

slide-16
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
SLIDE 17

17