Database

Previous Next
1 Overview 2 Launch and backup a MySQL database instance 3 Managing a database instance 4 Manage Database Users 5 Manage Databases 6 Manage Database Logs 7 Using the command line 8 Accessing the Database 9 Next Steps

Find a mistake? Let us know the issue here.

Overview

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 infrastructure requirements of configuring and running them. The Nectar database service offers the benefit of API or web-based access for tasks like creating databases, creating and restoring backups, adding and removing database users, setting configuration parameters and more.

Available datastores and flavors

The datastores currently available are:

  • MySQL
  • PostgreSQL

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, you will need to dump and restore.

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 the allocation request form in the dashboard.

The allocation form allows you to request quota for database ram and database storage.

What you’ll learn

  • Launch a MySQL database instance
  • Create database backup
  • Create database user
  • Access MySQL database

What you’ll need

  • You need to apply for database quota from the Nectar Research Cloud Dashboard
  • If you want to take database backups, you will also need object storage quota to hold the backups.