How to upgrade a Managed Database for PostgreSQL and MySQL

You can upgrade your Database Instances in two ways: by increasing its Block Storage volume or by changing the node type.

Before you start

To complete the actions presented below, you must have:

• A Scaleway account logged into the console
• Owner status or IAM permissions allowing you to perform actions in the intended Organization
• A PostgreSQL or MySQL Database Instance

How to increase a Block Storage volume

1. Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.
2. Click the name of the Database Instance you want to configure. The Database Instance overview page displays.
3. Scroll down to Volume settings.
4. Specify your volume capacity (in GB). The amount you define will be your new volume capacity.
   Important

   • You can increase your Block Storage volume to up to 10 TB.
   • Block volume sizes cannot be decreased.
5. Click Increase volume size to confirm.

How to change the node type

1. Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.
2. Click the name of the Database Instance you want to configure. Your database’s Overview page displays.
3. Scroll down to the Node settings section. Then, click Change node type.
4. Choose the specifications of the new Database Instance from the drop-down list.
5. Click Update node type to confirm your choices.
   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.

The action of changing the node type will perform a rolling upgrade of your Database Instance. During this process, the Database Instance will be unavailable for several tens of seconds.