The Heimdall Data proxy is a software platform for application and infrastructure owners. Whether on-premise or cloud, Heimdall helps organizations deliver faster, more reliable, and secure content generation. Heimdall Data is a distributed Database Proxy that improves database performance from an application perspective. We give users visibility and control over their SQL environment.

Use cases for the software

The key use cases for Heimdall database proxy include:

Heimdall supports Postgres and Postgres based databases (AWS Aurora, Redshift and Greenplum), MySQL and SQL Server databases. For caching, it supports Hazelcast, Redis, Gemfire/Apache Geode and Gridgain/Apache Ignite.

Caching Architecture

Heimdall optimally operates via a two-layer cache system. The first layer (L1) is an in-heap cache, the size of which is controlled by the cache size in the VDB settings. The second layer (L2) is used as secondary storage and as a means of communication amongst the deployed proxies. The user will choose any of the supported cache engines to provide a distributed cache between nodes.

Prerequisites and Requirements

In order to install and use Heimdall, the following will be needed:

Deployment Models

Heimdall can install either as a proxy (most common) and supports Postgres (including Amazon RDS, Aurora, Redshift and Pivotal Greenplum), MySQL and SQL Server databases in this manner:

Alternatively, it can be installed as a JDBC Driver (only for Java Applications) and can support other JDBC data sources as well:

For most customers, it is advisable to start with a simple proxy deployment on a single node, and once tested, to work with Heimdall support more advanced configurations.

Deployment Methods

In order to install Heimdall, one of several methods can be used:

One note of importance--all the install methods will by default pull our newest version of code from our S3 file distribution site at the time of install. When installing, make sure that security groups or ACLs do not block this out-bound request. Once installed and online, the system can be locked down if desired (see security). Please contact Heimdall support if this is not acceptable in your environments, as we can guide you through a manual install that doesn't require access to the Internet.

Additionally, the deployment model will impact pricing. In the cloud marketplace images, purchase is based on the size of instance and time used, although they offer a free 30 day trial for testing. In on-prem, pricing will be direct from Heimdall, and negotiated based on the number of instances used.

Initial Configuration

Once deployed, connect to the server on port 8087. It is recommended that all users leverage the configuration wizard once logged in, in order to do the initial install, as it guides the configuration via a series of questions and prompts in order to build a valid configuration. Please see the AWS specific instructions for information on setting an IAM role for AWS configuration auto-detection.

Once setup, the data source tab provides a test source button to validate access to the database. Likewise, a test VDB option is available on the VDB to pass some basic traffic to the VDB. Note: When using the test VDB option, it requires access to create a new schema or database (named Heimdall) and tables within it. If the data source is not configured with a user that has access to do this, then the test VDB option will fail, even if everything is configured properly for application access.