Our database proxy improves SQL scale and reduce costs up to 50%

Deployment requires no code changes; support for any SQL database

Read/Write Split with Strong Consistency

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.

Query Caching

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

The Heimdall proxy supports true multi-user pooling. Operators can safely scale without overwhelming database resources. Techniques that reduce connection overhead include:

  • 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

Automated Persistent Connection Failover

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.

Case Studies