Database scaling is performed manually with minimal downtime (typically less than 1 minute). A Database can be scaled/resized in three ways on Aptible:
- Within the Aptible Dashboard by:
- Navigating to the Environment in which your Database lives in
- Selecting the Databases tab
- Selecting the respective Database
- Selecting Scale
- Using the
- Using the Aptible Terraform Provider
Scale Databases vertically by changing the size of Containers, i.e., changing the Memory Limits and CPU Limits. The available sizes are determined by the Container Profile.
While Databases cannot be scaled horizontally by adding more Containers, horizontal scaling can be achieved by setting up database replication and clustering. Refer to Database Replication and Clustering for more information.
Database Disks can be scaled up to 16384GB. Database Disks can be resized at most once a day and can only be resized up (i.e., you cannot shrink your Database Disk).
If you do need to scale Database Disk down, you can either dump and restore to a smaller Database or create a replica and failover. Refer to our Supported Databases documentation to see if replication and failover is supported for your Database type.
Database IOPS can be scaled with no downtime. Database IOPS can only be scaled using the
aptible db:modify command. Refer to Database Performance Tuning for more information.
All new Databases are provisioned with GP3 volume, with a default throughput performance of 125MiB/s. This can be scaled up to 1,000MiB/s by contacting Aptible Support. Refer to Database Performance Tuning for more information.