# Installing Database Role
TIP
If you are using an external firewall, you should allow ports 3306 (MySQL/MariaDB) and 5432 (PostgreSQL) between the servers in your cluster.
If you would like to allow customers to connect remotely, from their own device or a 3rd party server, you will need to open those ports to the wider internet.
TIP
We recommend installing the Database role on each of your Application servers. If the Database role exists on the same server as the Application role, Enhance will place the Database role there by default. This removes reliance on the network and generally gives better performance.
If you need to run an external database server, for compliance reasons or to host very large databases, you can choose not to install the Database role on your Application servers or to override Database role placement during website creation.
To add a Database role to a server:
- Click Servers in the left side bar
- Choose the server that you want to add the backup role to
- Click Add role and select the Database check box
- Select your preferred database kind and version. You can choose between MySQL (8.0/8.4) or MariaDB 11 (LTS or rolling) and/or PostgreSQL 16.
TIP
PostgreSQL can be installed alongside MySQL/MariaDB. It is not possible to run both MySQL and MariaDB on the same server. You can mix MySQL and MariaDB within your cluster.
WARNING
It is not possible to switch between MySQL and MariaDB once websites have been added.
- Click Add role to finish
TIP
You can navigate away from the server page when a service is being installed and you will be notified when the installation is completed.