WHITEPAPER
Intelligent SQL Optimization
Heimdall Data is a transparent SQL platform that improves performance, reliability & visibility. Customers save up to 50% on their AWS, Azure, and SQL databases. How are we unique?
Heimdall caches SQL results on the client-side, removing network latency and database load. Installed on each application server, cache nodes synchronize to guarantee coherency.
Automates failover for any SQL database.
Identifies SQL bottlenecks on client or server.
APPLICATION SERVERS
- Requires no application-database changes.
Distributed Caching: Caching introduces data integrity risk. The Heimdall Data solution is scalable and safe. You choose the cache (e.g. Redis) and Heimdall provides the caching intelligence. We automated it without manual TTL or expiry configurations. Caches are synchronized across nodes, keeping all data fresh. User benefits:
INTELLIGENT AUTO-CACHING
AUTOMATED FAILOVER
!
!
- Save development costs vs. integrating and maintaining a cache interface.
Automated Failover: Heimdall is vendor neutral: An alternative to PGPool-II and MariaDB MaxScale, it also complements SQL Server AlwaysOn for faster failover.
- Caching is performed on the application server resulting in faster response times, and improved database scale as traffic is offloaded. Deployment is great for on-premise and a must for cloud deployments.
WHITEPAPER
Intelligent SQL Optimization
| Use Case | Feature | Customer Benefit |
|---|---|---|
| Performance & Scale | Intelligent auto-caching at the application tier, eliminating network latency and offloading database processing. | |
| SQL routing to optimal data sources | Improve application performance up to 20x | |
| Reduce AWS and SQL Server licensing costs by 50% | ||
| Increase revenues from: | ||
| 1. Higher customer satisfaction | ||
| 2. Higher Google SEO rankings | ||
| Auto Database Failover | Application-aware DB failover | |
| Out of the box solution for MySQL and PostgreSQL | Maintain 100% application uptime during failures and maintenance upgrades | |
| 5-minute installation | ||
| Visibility | Automated query plan extraction | |
| Application? Database? Network? | Provides developers safe access to production analytics | |
| Identifies the location of performance bottleneck | ||
| Data Protection | Auto-detects abnormal traffic patterns and filters | |
| Audit logs who, what, when | Prevents Zero-day attacks | |
| Helps to meet privacy compliance(e.g.GDPR, SOX,HIPPA) |
The Heimdall architecture was designed for ease of deployment without the need to modify the application or database. Configuration changes are updated at runtime without restarting the application. The net result is a platform that can be updated with 100% application uptime.