Manage Relational Databases
Learn how to connect and manage databases in Humanitec.
Humanitec supports a range of Relational Database Management Systems (RDBMS) out of the box. In all of these systems there is a distinction between the database and the RDBMS server or instance.
From a resource perspective, Humanitec works with the databases in an already provisioned and running instance.
The access method refers to how Humanitec connects to an RDBMS instance. Currently, 3 access methods are supported out of the box:
A direct connection is where Humanitec connects directly to the RDBMS instance. The instance must be accessible on the public internet for this to be possible. This is the default configuration when using Aiven managed databases, or public Amazon RDS and Azure Databases.
When connecting over SSH, Humanitec first connects to bastion host or jump server and then makes an onward connection from that server to the instance itself. This is a common way of administering private RDBMS instances, for example a private Amazon RDS instance running inside a private VPC.
Google provides their own proxy which can be used to securely connect to private Cloud SQL instances without the need of a dedicated bastion host.
The supported databases along with their access methods are summarised here:
Text | PostgreSQL | MySQL | MariaDB | SQL Server |
---|---|---|---|---|
Direct | ✓ | ✓ | ✓ | coming soon |
Over SSH | ✓ | ✓ | ✓ | coming soon |
Google Cloud SQL Proxy | ✓ | ✓ | ✓ | coming soon |
Last modified 17d ago