What is the Nectar database service?

The Nectar database service is a Database-as-a-Service (DBaaS) system powered by the Trove OpenStack project. It provides a simple interface to manage databases whilst hiding the underlying infrastructural requirements of configuring and running them. The Nectar database service offers the benefit of API or web based access for tasks like creating and restoring backups, adding and removing users and more.

The Nectar database service offers:

  • MySQL and PostgreSQL datastore support.
  • All user and database related operations: For instance, it allows you to add users and databases to your instance through the Trove API and dashboard.
  • Database backups, stored in Nectar object storage. Both incremental and non-incremental backups are supported.

Available datastores

The datastores currently available are:

  • MySQL, version 5.7 and 8.0
  • PostgreSQL, version 9.6 and 11

NOTE: MySQL can be automatically upgraded between major versions, but PostgreSQL cannot. If you wish to upgrade your PostgreSQL database to a newer major version (e.g. 9.6 to 11) you will need to dump and restore.

Available flavors

The flavors currently available are:

  • db.small (4GB RAM)
  • db.medium (8GB RAM)
  • db.large (16GB RAM)

Database service quota

Access to the Nectar database service is governed by its own type of quota, which you must apply for, through an allocation request form.

The allocation form allows you to request quota for:

  • Database RAM
  • Database storage

You can apply for specific quota for either RAM or storage, or both, depending on your requirements. If you don't specify storage, we'll allocate 20GB per 4GB of RAM you request. If you request database storage, but don't specifically request any RAM, we'll allocate you 8GB.

Database service tutorial

Once you have been assigned some Database service quota, we recommend you work through the Nectar Database service tutorial to familiarise yourself with the service and how it works.