VisualVM and JMX: Heimdall Data Proxy for Database Cache, Connection Pooling and Read Write Split

Heimdall Data Proxy provides advanced control and monitoring of JMX counters with VisualVM.
In this walk-through. Erik Brandsberg, Chief Architect explains how to configure VisualVM and how the Heimdall Data Proxy can provide this observability into the database and proxy traffic.

The Heimdall Proxy automates Database Query caching and Read/Write splitting with Strong Consistency to improve database cluster scale-out without code changes.
In addition the proxy provides connection pooling with Multi-Plex support which can reduce total connections to your database by 75%. Improve performance 20x and save DB costs up to 50%.

Chapters
0:00 Intro
0:45 Plugins - MBeans
1:10 Heimdall VDB Settings
1:55 credentials in visualVM
2:12 Initial Charts in visualVM
2:50 Java Thread Dump
3:09 Multiple Proxy Support
4:10 Mbeans / Global Sets
4:34 Java Metrics
4:45 Connection Pool Statistics
7:00 Cache Hits
7:50 Read / Write Splits to Replica Nodes
8:27 Disabling Cache Functionality
8:52 Forward Count for R/W Confirmed
9:05 Adding Concurrency Counter as Request Rule
9:45 Concurrency Count Confirmed
10:00 Console Logs and Periodic Updates
11:00 Running Total for Review
11:35 SNMP Roadmap Item
12:00 CloudWatch Export and Alerts
13:00 View Which Tables are Invalidated and the Unix Epoch

Download a free trial from the following Cloud Marketplaces now:

and learn how to deploy to your on-premise architecture today!

#sqlserver #postgresql #mysql #azure #caching #database #java #jvm #performance #visualvm #jmx #azure #gcp #aws #aurora #rds #babelfish