DocsCore Concepts
Reference
Troubleshooting
Feedback
Managing Databases
Aptible automatically handles configuring and managing of Databases - scaling, in-place upgrades, backups, database replication, network isolation, encryption, and more.
Scaling Databases
Databases RAM/CPU, Disk, IOPS, and throughput can be scaled on-demand with minimal downtime (typically less than 1 minute).
Refer to Database Scaling for more information.
Upgrading Databases
Aptible supports various methods for upgrading Databases - such as dump and restore, logical replication, and in-place upgrades.
Refer to Database Upgrades for more information.
Backing up Databases
Aptible provides Automatic Backups of your Databases every 24 hours and a range of other backup options. All Backups are compressed and encrypted for maximum security and efficiency.
Refer to Database Backups for more information.
Replicating Databases
Aptible simplifies Database replication (PostgreSQL, MySQL, Redis) and clustering (MongoDB) databases in high-availability setups by automatically deploying the Database Containers across different Availability Zones (AZ).
Refer to Database Replication and Clustering for more information.
Encrypting Databases
Aptible has built-in Database Encryption that applies to all Databases as well as the option to configure additional Custom Database Encryption. Application-Level Encryption may also be used.
Refer to Database Encryption for more information.
Restarting Databases
Databases can be restarted in the following ways:
- Using the
aptible db:restartcommand if you are also resizing the Database - Using the
aptible db:reloadcommand if you are not resizing the Database- Note: this command is faster to execute than aptible db:restart
- Within the Aptible Dashboard, by:
- Navigating to the database
- Selecting the Settings tab
- Selecting Restart
Renaming Databases
A Database can be renamed in the following ways:
- Using the
aptible db:renamecommand - Using the Aptible Terraform Provider
For the change to take effect, the Database must be restarted.
Deprovisioning Databases
A Database can be provisioned in the following ways:
- Using the
aptible db:deprovisioncommand - Using the Aptible Terraform Provider
When a Database is deprovisioned, its Database Backups are automatically purged per the Environment's Backup Retention Policy.
Restoring Databases
A deprovisioned Database can be restored from a Backup as a new Database. The resulting Database will have the same data, username, and password as the original when the Backup was taken. Any Database Endpoints or Replicas will have to be recreated.
Keep reading:
