Database Configuration

Artifactory supports the following databases that you can use depending on your requirements:

Choose the Right Database

The JFrog Platform is a mission-critical tool. Compare database options and choose the right engine for your deployment.

Database Connection Settings

Configure database connection pool settings for JFrog Artifactory in system.yaml, including connection limits and timeout values.

Database Setup Workflow

Set up a database for JFrog Artifactory by creating an instance, a dedicated user, installing a JDBC driver, and configuring system.yaml.

Database Tuning for Heavy Loads

Tune JFrog Artifactory database performance under heavy loads by adjusting maxOpenConnections in system.yaml.

PostgreSQL

Recommended database for all JFrog products. Included with installers.

MariaDB

Configure MariaDB as the external database for Artifactory.

MySQL

Configure MySQL as the external database for Artifactory.

Microsoft SQL Server

Configure MS SQL Server as the external database for Artifactory.

Oracle

Configure Oracle as the external database for Artifactory.

⚠️
Warning
Due to restricted functionalities, the embedded Derby database can impact the performance and resilience of your Artifactory instance. Hence, JFrog highly recommends avoiding the usage of the Derby database for your Artifactory production environments.

For more information about the supported versions of the database, see Artifactory Database Requirements.

✅
JFrog Recommends Using PostgreSQL
JFrog recommends that you use an external PostgreSQL database in your production instances. JFrog also includes a PostgreSQL build along with the installers.
In addition, since all the other JFrog products support only PostgreSQL, you can use PostgreSQL with Artifactory to simplify your infrastructure.
Starting from Artifactory 7.84.7, new Artifactory installations support only PostgreSQL in the default installation mode. Artifactory will not start unless you configure the system.yaml file to support non-PostgreSQL database.
shared:
  database:
    allowNonPostgresql: true
    type: <database type>

Artifactory supports the following modes of operation:

Metadata is stored in the database, and the artifacts are stored on the file system (this is the default and recommended configuration).
Metadata and artifacts are stored as BLOBs in the database.

Artifactory uniquely stores artifacts using checksum-based storage. For more information, see Checksum-Based Storage.

Accessing a remote database

When using an external database, you need a reliable, stable, and low-latency network connection to ensure proper functioning of your system.

When using a full-DB configuration, we strongly recommend a high-bandwidth to accommodate the transfer of large BLOBs over the network.