An application database is included with every Service Plan along with a Database Connection that connects the application to the database over a private internal network.
Supported Databases
There are 5 application databases to choose from:
- PostgreSQL
- Oracle XE
- Microsoft SQL Server Express
- MariaDB
- CouchDB
A Service Plan can include up to one of each of these databases at the same time. Note that adding additional databases may impact the cost of a Service Plan.
Database Administration
Each application database has a randomly generated strong password and sufficient user permissions to create schemas, tables, etc.
External access to Application Databases can be enabled and disabled in the Service Plan's details page of the Cloud Portal. Cloud Portal users must have an Owner or Admin role for the Service Plan to grant external access to the database. External connection information can also be found on details page.
Once external access has been enabled, database administration can be carried out using a compatible database client of your choosing.
Backups
Application databases are backed up daily as part of the Service Plan backup. SQL application database backups are taken online, so that the database remains available to your application while the backup is taken.
The Support Helpdesk and Production Critical Helpdesk can help restore your Service Plan application database from these scheduled backups. Note this is only supported for production Service Plans, rather than Service Plans used for test purposes.
Ad-hoc database backups can be taken by clicking the Backup Database link of an application database in the Service Plan's details page. The resulting backup is placed in the application filesystem's backups directory and can be downloaded using your choice of SFTP client.