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. VisualVM: https://visualvm.github.io/ 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: Amazon: https://aws.amazon.com/marketplace/pp/prodview-hxzbeov5mcl7o Azure: https://azuremarketplace.microsoft.com/en-us/marketplace/apps/heimdall-data.heimdall-data?src=tazure&tab=Overview Google: https://console.cloud.google.com/marketplace/product/heimdall-data-public/undefined?pli=1 Or, visit to the Heimdall Data home page: https://www.heimdalldata.com/ 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