What is a database?
A database can be configured on your servers. Databases hold structured data for your websites and apps and can either be installed on the same server as your website / app or on its own dedicated server.
What types of databases can I add?
The following types of databases can be added to your provisioned servers.
One of the best known relational databases, MySQL is an open-source product by Oracle. You can choose between MySQL 5.7 and MySQL 8.0.
An open-source object-relational databases, PostgreSQL is built for speed and for data analytics.
A fork of MySQL, MariaDB is another popular relational database.
Install a database
During the steps to provision a new server, you have the option to install one of the database types. This will install the database system onto your server and you can then add databases after provisioning is complete.
You can also provision a server that is meant solely to be a databases server by selecting the Database Server server type when adding a new server.
Add a new database
In Servers > your selected server > Database,
Manage databases and users
To add a new database user, select Add New Database User. Once you add the new user, you can edit the user to manage which databases the user has privileges to.
Select the ellipsis icon for databases and database users to remove the selected resource.
Postgres Plugins and Admin Role
Click on the elipsis icon for a postgres database to add a PostgreSQL extension. For example, you can add the popular
In some cases, you may need to make a postgres databases user a superuser. To do so, click on the elipsis for the postgres user and then select the Make Superuser option.
It's not recommended that you keep a user as a superuser. When you are done with the task where a superuser is required, we recommend that you then demote the user.
Open database hosts to outside servers
When creating a new PostgreSQL database, enter the IP for the outside server that will access the database.
If you have server monitoring enabled for your server, then you can also select the option to enable database monitoring from the database section. This will show database monitoring reports in this section.
Clone Database Server
You can select Clone Database Server to clone the database server and related databases and database users on a server and then clone them to another server.
Note, the target server must not be running a conflicting database server type. Such as, if the current server is running MySQL 5.7 and the target server is running MySQL 8.0, then the cloning process will not work.
What database should I use for WordPress?
MySQL 5.7, MySQL 8.0, and MariaDB 10.4 will work with your WordPress site.