The Heimdall proxy intelligently routes queries to the appropriate database instances without code changes. We load balance across replicas for better utilization.  Users receive the most up-to-date  data with our replication lag detection.

Automated Query Caching: Removes latency to the database. Result sets are cached to the storage of your choice: 1) Local memory, 2) Redis, or 3) Both. Automated invalidation is supported. Deployment requires zero code changes.

• Connection Pooling: Multiple client connections are associated to a database connection. Users can limit connections to the backend in 2-tiers: per user and per database. 

• Connection Multiplexing: An extension of pooling, multiplexing creates a backend connection for active queries. The net result is lower total memory, and reduced database costs.

Connection Pooling and LDAP/Active Directory Video

Our proxy detects database health and performs a failover to the standby from an application approach. Upon a failure, we queue up the connection and transparently creates a new connection at the backend to the standby instance. This greatly reduces and/or eliminates application errors and exceptions. Hence, failover is transparent to the application and user; not so, with a DNS or IP based failover solution.