Choosing the Right Database
Artifactory supports the following pluggable database implementations allowing you to change the default to use other popular databases:
- Derby (the default embedded database, no additional configuration needed)
- MySQL v5.5 to v5.7 with InnoDB
- Oracle version 11g (11.2) to 19c (19.3)
- Microsoft SQL Server 2008 (10.5) and above
- PostgreSQL v9.5 and above
- MariaDB v10.2.9 and above
For each of the supported databases you can find the corresponding example values in the system.yaml configuration file.
As the default database, Derby provides good performance since it runs in the same process as Artifactory, however, under intensive usage or high load, performance may be degraded since Artifactory and the database compete for shared JVM resources such as caches and memory. Therefore, for Artifactory servers that need to support heavy load, you may consider using an external database such as MySQL or PostgreSQL which are very common choices in many Artifactory installations.
Any of the other supported databases is also a fair choice and may be the practical choice to make if your organization is already using one of them.
Artifactory uniquely stores artifacts using checksum-based storage. For details, please refer to Checksum-Based Storage.
Modes of Operation
Artifactory supports two modes of operation:
- Metadata in the database and binaries stored on the file system (This is the default and recommended configuration).
- Metadata and binaries stored as BLOBs in the database