NavigationContentFooter
Jump toSuggest an edit

How to upgrade a Managed Database for PostgreSQL and MySQL

Reviewed on 04 July 2024Published on 11 May 2019

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

Important

If you have a Database Instance that uses a local volume, and you want to upgrade to a node type that uses Block volumes, you must change the volume type to Block storage first.

Similarly, if you have a new-generation Database Instance using a Low Latency Block volume node type and want to switch to a first-generation node type, you must first change the volume type to Basic Block Storage.

  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.

See also
How to renew a TLS certificateHow to upgrade Database Instance engine version
API DocsScaleway consoleDedibox consoleScaleway LearningScaleway.comPricingBlogCareers
© 2023-2024 – Scaleway