Migrating your DB-Beta instance to a Generally Available Database Instance

Database Instance - Overview

The Scaleway Elements Database Instances provide a managed environment for PostgreSQL databases. In comparison to traditional database management, which requires users to provision their infrastructure and resources to manage their databases, Scaleway Elements Database offers the user access to a database instance without the need for setting up the hardware or configuring the software. Scaleway handles the provisioning, manages the configuration, and provides useful features as high availability, Automated Backup, User management, and more.

If you have tested the service during the beta-phase and you have used a DB-BETA instance you can now migrate your workload to the Generally Available Database instances with a few easy steps from your Scaleway Console.

Requirements

Automatic Upgrade Using the Scale up Feature

In case you want to use the same topology of your instance (for example: From High-Availability to High-Availability) you can upgrade it seamlessly by using the Scale Up feature.

1 . Connect to your Scaleway Console and click on Database in the storage-section of the side-menu. The list of your Database instances displays. Click on the name of your DB-BETA instance that you want to upgrade:

2 . On the Database Information page, scroll down to the Scale up section. Then click on Scale up:

3 . Choose the specifications of the new Database Instance from the drop down list and click on Scale up:

Important: Make sure that the Database Instance you choose provides sufficient disk space for your database. Otherwise an error message will be displayed and the database will not be upgraded.

4 . Your database is being upgraded. The Scale Up process will perform a rolling upgrade of your database instance. It will be done without downtime.

Manual Upgrade

In case you want to change the topology of your Database Instance (for example: From Single Instance to High-Availability or vice versa), you need to upgrade it manually using the following steps:

Creating a Database Backup

1 . Connect to your Scaleway Console and click on Database in the storage-section of the side-menu. The list of your Database instances displays. Click on the name of your DB-BETA instance that you want to backup:

2 . On the Database Information page, click on the Databases tab to view the list of databases in your instance.

3 . Click on next to the database you want to backup and click on Backup.

4 . The backup pop-up displays. Enter a name for the backup and the expiry date on which it will be removed from your account automatically. Click on Create backup to launch the backup process.

Deploying a New Database Instance

1 . Click on Database in the side menu to go back to the list of your Database Instances. Then click on + Create an Instance to create a new Generally Available Database Instance.

2 . Choose the PostgreSQL version you want to on the Database Instance.

3 . Choose the Database Instance type. Several instance types are available to match your requirements.

Important: Make sure that the Database Instance you choose provides sufficient disk space to restore your database backup on it.

By default the Backup option is enabled. This option allows you to make automatic backups of your database. Also the High Availability option is activated by default. This option creates a secondary server which will act as a hot standby database node. If the primary server fails for any reason, the secondary can take over requests, reducing downtime.

Important: Disabling the Backup and High Availability feature may have an impact on the availability of your databases. It is not recommended to deactivate these options.

4 . Create a first user for your database by entering the username and password for it. Then enter a name and optionally tags for the new instance. Once done, click on Create Instance to deploy the new instance.

Recreating Users

1 . The new Database Instance appears in the instances list once it is deployed. Click on it, to view the Database Information page.

2 . Click on the Users tab, then on + Add user to add your database users to the new instance:

3 . Fill-in the user information and credentials, then click on Create a user

Once you have recreated all required users, proceed to the next step.

Restoring a Backup

1 . Click on Back to Database Instances on the top of the page, or on Database in the side-menu to go back to the Database Instances overview page.

2 . Click on Backups to view the list of your database backups.

3 . Click on then Restore to open the restore pop-up:

4 . Choose the new Database Instance from the drop-down list and select Restore to the original database. Click on Restore this backup to restore your backup on the new Database Instance.

5 . Your backup has been restored and is available within the new Database Instance now.

6 . Just update the connection information in your applications to communicate with the new database instance.

Discover a New Cloud Experience

Deploy SSD Cloud Servers in seconds.