Databases

On this page, you can find how to create, edit, upgrade and delete Databases in the Cloud Console.

Table of contents

• Table of contents
  • Databases page
  • Create Database
  • High Availability
  • Database details page
  • Edit Database
  • Upgrade Database version
  • Reset Database Password
  • Start, Stop and Delete

Databases page

Select Databases in the VIRTUAL DATACENTER block of the side-bar menu. The page lists all Databases of the Project with a search bar, sorting and the CREATE DATABASE button. Click the name of a Database to open its details page.

The Actions menu of a row has Start (only for STOPPED Databases), Edit and Delete.

Create Database

Click CREATE DATABASE, fill in the form and click CREATE.

After you click CREATE the Database appears with the PROVISIONING status and a window shows its password once - save it. The Database is ready in a few minutes, when the status becomes ACTIVE.

High Availability

High Availability (HA) keeps the Database available when its server fails. The platform runs the Database as a primary with one standby copy that receives all changes. If the primary stops responding, the standby is promoted automatically and the connection address stays the same; clients only need to reconnect. MongoDB runs a replica set of three members that elects its primary by itself.

Switch HA on or off with Enable High Availability in the create or edit form. Switching it off removes the standby.

• For PostgreSQL, TimescaleDB, MySQL and MariaDB a change is confirmed by the standby before it is acknowledged. If the standby is unavailable, the Database keeps working with asynchronous replication instead of blocking writes.
• vCPUs, Memory and Disk are per member, and every member is charged: the Resources block shows Charged: x2 (HA) (x3 for MongoDB).
• HA protects against a server failure. It does not replace Backups and is not the same as Replicas, which are copies in other Projects.

The General block of the details page shows High availability: Yes/No and, when it is on:

Database details page

Notices. Problems and progress are shown in one box at the top. One notice shows its title and text, as in the picture below; several are merged into one box N notices, most severe first (errors, warnings, information). Notices: Upgrading X → Y (red if the upgrade failed or is blocked); Migration pending approval, in progress, failed or blocked (an older Database is being moved to the current platform image; when it is pending approval, contact customer support to approve or schedule the one restart); Restore failed and Restore failed and was rolled back; Last backup failed; Backup in progress; Load balancer not applied; Extensions not installed, Settings not applied, Charset and collation not applied (server default used), Permissions not applied and Extensions installing after the database restarts; and a notice that databases and users are read-only (see User Management). The reason is written in every notice.

Quick actions (icons next to the title): Start, Stop, Database management (opens the web-based management tool DbGate in a new tab), Reset password, Edit and Delete.

Details area:

The Usage chart shows CPU and memory load for the last hour.

Tabs. The selected tab is kept in the page address, so a link to it can be shared.

There is no separate scheduler tab: the backup schedule is on the BACKUPS TAB, and an old link with ?tab=scheduler opens it.

Edit Database

Open Edit from the Actions menu on the Databases page or with the Edit icon on the details page, change the fields and click SAVE. The Database is updated in a few minutes.

Upgrade Database version

Change the version with the Version field of the edit form.

• The list contains the version that is running (marked (current)), a pending version (marked (requested)) and the newer versions that are available. Moving to an older version is not possible.
• A major version is upgraded one major version at a time (for example 14 → 15 → 16). A step that skips a major version is refused.
• If an extension in use is not available on the selected version, the form warns you: the upgrade may be blocked or leave the extension uninstalled.
• During the upgrade the status is UPGRADING, the notice Upgrading X → Y shows the phase, and Version shows the requested version while Running shows the version that is running now.
• If the upgrade fails or is blocked, the notice turns red and gives the reason. To cancel an unfinished upgrade, edit the Database, select the (current) version and save.

Reset Database Password

Click the Reset password icon on the details page and confirm. The new password of the main Database user (the DB user from the create form) is shown once - save it. The icon is active for running Databases (ACTIVE or DEGRADED) in Standalone or Primary mode. It is not available for Replicas and for Databases whose users are managed inside the engine. Passwords of other users are reset on the USERS TAB.

Start, Stop and Delete

• Stop (details page) stops a running Database: it does not accept connections, its data is kept. Start (details page, or the row Actions menu) starts a STOPPED Database.
• Delete (the row Actions menu, or the Delete icon on the details page) asks you to type the name of the Database to confirm.