SQL Database Options
Only available in Nexus Repository Pro. Interested in a free trial? Start here.
Database Options for Nexus Repository Pro
Nexus Repository Pro now has two new database options:
- An external PostgreSQL database
- An embedded H2 database
This page and its subpages explain the benefits of the new database options and how to use them.
Choosing a Database Mode
Before migrating to a new database, review Feature Availability for PostgreSQL and H2 Databases to ensure your selected database will meet your current needs. Whenever possible, we recommend that all new Nexus Repository Pro deployments use PostgreSQL or H2.
There are two important considerations to keep in mind before migrating to a new database:
- Unsupported formats will not be migrated; you will not be able to add new formats that your new database does not support. As mentioned above, review Feature Availability for PostgreSQL and H2 Databases and ensure that your new database supports all of your formats before migrating.
- Migration is a one-time process; attempts to migrate again will overwrite data.
The table below can help you choose the appropriate database mode for your deployment:
|Database Mode||Appropriate For|
|New: External PostgreSQL |
(Nexus Repository Pro only)
New: Embedded H2
Benefits of Database Externalization
There are a number of benefits to using an externalized database:
- Scalability improvements
- Ability to leverage the benefits of managed, fault-tolerant cloud databases like AWS Aurora, RDS, and Azure Database
- Improved compatibility with container orchestration such as Kubernetes and OpenShift
- Full availability for writes during backups
- Fault-tolerant cloud deployments with multi-AZ cloud deployment models
- Substantially simpler and easier disaster recovery procedures
Embedded Mode for Nexus Repository
Nexus Repository provides an embedded-database mode with improved speed using H2 instead of OrientDB. This mode is appropriate for the following scenarios:
- Teams and smaller organizations with non-mission-critical Nexus Repository needs
- Automatically provisioned, disposable Nexus Repository instances (e.g., pools of proxy-only instances used to shield a primary instance from a heavy read load)
Other Database Options Topics