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.
You may need certain IAM permissions to carry out some actions described on this page. This means:
- you are the Owner of the Scaleway Organization in which the actions will be carried out, or
- you are an IAM user of the Organization, with a policy granting you the necessary permission sets
- You have an account and are logged into the Scaleway console
- You have a PostgreSQL or MySQL Database Instance
How to increase a Block Storage volume
- Scroll down to Volume settings in the overview page of your selected Database Instance.
- Click Increase volume size. A pop-up appears.
- 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.
- Click Increase volume size to confirm.
How to change the node type
If you have a Database Instance that uses a local volume, and you want to upgrade to an Instance that uses Block volumes, you must change the volume type to Block storage first.
- Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.
- Click the name of the Database Instance that you want to upgrade.
- Scroll down to the Node Settings section in the Database Information page. Then, click Change node type.
- Choose the specifications of the new Database Instance from the drop-down list.
- 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.