How to manage Database Instance nodes
You can change your Database Instance node type and enable High Availability after the nodes have been created.
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 change the node type
- Click PostgreSQL and MySQL under Databases on the side menu. A list of your Database Instances displays.
- Select the geographical region of the Instance you want to manage from the drop-down.
- Click the name of the Database Instance you want to configure. Your database's Overview page displays.
- Scroll down to the Node settings section. 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.
How to enable High Availability
You define your Database Instance's node configuration upon its creation. Two node configuration modes are available with PostgreSQL or MySQL Database Instances.
- High Availability: creates a secondary Instance with an up-to-date replica of the database. If the primary Instance fails, the secondary takes over requests.
- Standalone: a standalone database provisioned on a single node.
If you are in standalone mode, you can change the node configuration to High Availability in the console at any time.
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 in standalone mode.
-
Click PostgreSQL and MySQL under Databases on the side menu. A list of your Database Instances displays.
-
Select the geographical region of the Instance you want to manage from the drop-down.
-
Click the name of the Database Instance you want to configure. Your database's Overview page displays.
-
Scroll down to the Node settings section. Then, click Activate High Availability.
-
Review the new estimated cost.
-
Click Activate.