SQL Challenges
● Keeping within CPU instance limits
● Duplicate queries
● Slow response times
● Caching requires application changes
The Intelligent Database Proxy
Auto-Caching Logic
- For any cache (e.g. ElastiCache)
- Automatic cache invalidation
- Removes network latency
- No code changes
Traffic Management
- Read/Write split
- Advanced Connection Pooling
- Fast database failover
- Amazon RDS & Redshift
Database Security
- Active Directory w/ Authorization
- Blocks malicious data attacks
- Audits data access (e.g. GDPR)
“I recommend Heimdall Data to anyone troubleshooting SQL performance issues. The icing on the cake is that Heimdall Data can optimize the database traffic as well.–This is a serious issue to consider when dealing with closed source or complex schema.”
Kenneth Hunt
“We implemented Heimdall primarily as a caching layer in front of both a standard PostgreSQL datastore…It was very easy to get set up and get started. It was reasonably well integrated with AWS.”
Craig Connell
“Heimdall Data’s SQL caching software was easy to install and provided an immediate increase in performance. But their analytic tools gave us insight what was really happening with our queries allowing us to optimize our code. Once optimized, not only was the raw SQL faster but the number of cache hits increased giving us even more performance. If you are serious about performance, you need to start with Heimdall.”
Paul Nerger
“We first tested Pgpool and very quickly realized that it would require extensive work to update, maintain and scale. When we began testing with Heimdall Data we were able to see huge improvements, about 5-7x what original performance tests had shown. We learned all about the rules engine, explain plans, and analytics which allowed us to identify several places for optimization. The level of monitoring and analytics that Heimdall Data provides allowed us to identify issues that only a seasoned DBA would be able to gather previously.”
Brian Davis
“The Heimdall Proxy optimized our Magento e-commerce platform by:
1) Scaling down Amazon RDS instance by 66%
2) Reducing database connections by 66%
3) Achieving an 80% cache rate for Amazon ElastiCache We improved response times and reduced Amazon RDS costs.”
“Amazon RDS was the most expensive line item in our infrastructure. We reduced our database costs by over 50% with Heimdall Data’s analytics and caching.”
Ka Chan
Get help with installation and receive product updates!
