Infraista DocsDocs
Data & storageDatabases

Databases

Managed PostgreSQL, MySQL and MariaDB databases with secure access, daily backups, a browser Data Explorer and SQL console, and metrics.

Managed databases give you PostgreSQL, MySQL or MariaDB without running the server yourself. We apply updates, take backups and monitor it; you get a host name, users and a database to connect to.

Find them under Data & Storage › Databases.

  • Three engines: PostgreSQL, MySQL and MariaDB, in the versions we support and patch for you.
  • Secure access: public connections go through our gateway and can be limited to your trusted sources; your servers in the same region connect privately.
  • Daily backups, plus backups on demand, restores into a new or the same database, and downloads.
  • In the browser: browse and edit tables in the Data Explorer, run SQL in the SQL console, and run one script across many databases with Fleet query.
  • Billed by the hour while the database runs, from your credit first.

Each database has these tabs: Overview, Connection, Backups, Users & databases, Networking, Data Explorer, SQL console, Fleet query, Metrics, Performance Insights and Settings.

Move or delete a database

On Settings:

  • Move to project groups its cost on invoices.
  • The name is part of the host name, so it can't be changed. To use another name, create a new database.
  • Delete database deletes the database and all its data, which can't be recovered. Billing stops right away.

Create a database

Create a managed PostgreSQL, MySQL or MariaDB database in three steps. Pick the engine and version, a plan, the region and a name, and connect in minutes.

Connect to a database

Get a managed database's host, port, user and password, turn on public access through our gateway, allow trusted sources, and copy a ready-made connection string.

Users and databases

Add database users with admin, read-write or read-only access, reset their passwords, and create more logical databases on the same managed database server.

Backups and restore

Managed databases are backed up automatically. Set the schedule and retention, back up on demand, verify or download a backup, and restore it into a new or the same database.

Data Explorer and SQL console

Browse and edit tables in the browser, run SQL safely in read-only or write mode, import and export data, track schema changes and run one script on many databases.

Metrics and performance

Watch a managed database's CPU, memory, storage, connections and queries, see live sessions and the most expensive statements, and spot unused indexes.

Data & storage

Choose where your data lives on Infraista, from managed SQL databases and Redis caches to S3-compatible buckets and storage boxes for backups.

Create a database

Create a managed PostgreSQL, MySQL or MariaDB database in three steps. Pick the engine and version, a plan, the region and a name, and connect in minutes.

On this page

Move or delete a database