Backups and Restores for a Relational DB Instance

Updated by Brian Waganer on Oct 22, 2017
Article Code: d148

Audience

This article is to support customers of Relational DB Service, CenturyLink's database-as-a-service product. These instructions are specific to performing backups and restores through the Control Portal.

Overview

CenturyLink's Relational DB Service is a database-as-a-service product that provides instant access to a database instance with SSL support, daily backups, restore functionality, basic monitoring and a replication option with auto-failover. Users can configure the amount of CPU, Memory, and Storage based on their database needs. They can choose to replicate their instance for a more highly available solution. As the customer's capacity needs grow, they can easily scale their CPU, RAM, and/or Storage with the click of a button.

Prerequisites

Access to the CenturyLink Cloud Platform as an authorized user

Relational DB Backups

The Relational DB service includes daily, automated Hot Backups as well as the ability to take a backup on demand. We also backup all database transaction logs allowing you to recover to a point-in-time. Users have the ability to define the time of day backups are run as well as a data retention policy.

We make every effort to store backups off-site at least 350 miles from the datacenter housing the Relational DB instance it was backed up from. Please reference the table below under the Data Sovereignty section.

When a database is deleted, we automatically take one last backup for you.

The last valid backup will be kept for 3 months. This is to help safeguard people from themselves. And allows you a very easy way to recover if you choose to. If you know for sure you won't use it you can manually delete that backup.

Data Sovereignty

The below details where backups are held in relation to the datacenter location of the primary instance. Please note that for CA3 instances, our current backup strategy does not provide us an off-site location in Canada, so backups are being held in North America.

Primary Instance Datacenter Location Backup Location
UC1, VA1, IL1, NY1 Oregon
GB1 London
GB3 Ireland
CA3 Oregon
AU1, SG1 Singapore

Defining your Backup Policy

  1. Upon provisioning of a Relational DB instance, the user is asked to define their Backup Schedule and their Backup Retention. The Backup Schedule governs the time of day all automated daily backups are taken. Backup retention can be set to any value between 1 and 35 days. Please note that increasing your backup retention period may increase the backup storage consumed by your instance.

Your Relational DB subscription includes additional backup storage, up to 100% of your allocated storage amount. Backup storage that exceeds the size of your allocated storage is billed at the Additional Backup Storage rate defined in the pricing catalogue.
DefineBackupPolicy

  1. Users may also change the backup policy of an existing Relational DB instance from the subscription details page. The details page includes a "Backup Policy" section with an "Edit" option.
    BackupPolicy

  2. When a user clicks the 'edit' button, a new section appears that allows the user to make changes to the backup policy. Simply change the backup time and/or backup retention to the new desired settings and click 'save'. The request results in the Relational DB instance status being changed to "Configuring" for a few minutes, at which point no additional policy changes, backups, or restores can occur. But this will have no affect to the availability of the database, unless it states a restart is required.
    EditBackupPolicy

Taking a Manual Backup

Users may choose to take a backup at any time. Manual backups are retained in accordance with the defined backup policy for that instance, but can also be deleted at any time by the user.

  1. Identify the Relational DB instance for back up and click on the instance to navigate to the details page.

  2. Click the 'backup' button on the action bar.

  3. The action bar then indicates that there is a "backup in process" and the status of the instance is changed to "Backing Up".

  4. Upon successful completion, the backup is listed and marked as "Manual".

    ManualBackup

Restoring from Backup

A Relational DB instance can be restored from any available backup within the same account of equal or smaller storage size.

The benefits of this are:

  • Restore a desired time back to the existing DB
  • Easily moving Development DBs to Production when you're ready to GoLive
  • If you have a production issue you can spin up a HotFix DB to test your code changes
  • To enable Replication just create an new replicated DB and Restore to it
  • To refresh your Dev and QA databases is now a simple task

This functionality allows a user to seamlessly transition data loads between environments with different levels of availability and performance.

A user can define a specific point in time within the last week as the restore point. You can also restore back further if you have the backups, but it's will be consistent at the time the backup finished.

  1. A list of available backups for a given instance are displayed on the Subscription Details page. In order to restore from an available backup, navigate to the database instance to be restored and click the 'restore' button on the action bar.
    BackupRestore

  2. When the 'restore' button is clicked, a new window is displayed.

    • The "Restore From" drop-down displays a list of all instances of equal or smaller storage size. Select the instance you would like to restore from.
    • Once the user has selected the Relational DB instance they would like to restore from, they should select either "Full Restore" to select a previous full backup or "Point in Time Restore" to select a point in time within the last week as the restore point.
    • When "Full Restore" is selected, a drop-down menu appears showing all available backups of qualifying size.
    • When "Point in Time Restore" is selected, the user is able to select a particular date and time as the restore point.
    • Select which restore point should be used and click "restore". During the restore process, the status of the instance will be set to "Restoring", at which point no other actions can be performed against the instance.

    Restore

  3. If you have questions or feedback, please submit them to our team by emailing rdbs-help@ctl.io.