Databases

A database is a set of parameters used to connect to a database. A database instance refers to an active connection established to a database from these parameters.

You can add databases via the UI.

Only administrators can edit databases.

Database type

Databases of type Postgresql and Mysql are supported.

SSH Tunneling

If a firewall is blocking the connection port to the database, you can try to connect through a node (the latter will be used to create an SSH tunnel).

What involves using databases

SQL script tasks will execute a SQL script on a set of databases.

A good use case is the weekly launch of an SQL script to reclaims unused space, reorganizes indexes and tables, and defragments data files.