Choosing the Right Database
Artifactory uses Derby as the default database, which requires no additional configuration. Derby provides good performance for small to medium size loads. However, if you expect intensive usage or high load, high availability setup, and better tooling, we recommend that you use PostgreSQL(PostgreSQL v10.x to v13.x). Since other JFrog products support only PostgreSQL, choosing PostgreSQL for Artifactory will allow you to use the same database for the entire JFrog Platform.
Additionally, Artifactory supports the following pluggable database implementations:
- MySQL v5.7 and 8.x
- Oracle versions v.12.2, v.18, and v.19
- Microsoft SQL Server 2008 (10.5) and above
- MariaDB versions 10.2.9-10.4 and version 10.5.9
For each of the supported databases you can find the corresponding example values in the
system.yaml configuration file.
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