PostgreSQL / MySQL

Relational databases with durable storage.

Insert screenshot of Marketplace → Databases here

Prereqs

• Premium/Pro volumes; open ports only to trusted sources

PostgreSQL ▶️

sudo apt -y install postgresql
sudo -u postgres psql -c "CREATE USER app WITH PASSWORD 'StrongPass!';"
sudo -u postgres createdb -O app appdb

Tune shared_buffers, work_mem, and enable regular backups.

MySQL ▶️

sudo apt -y install mysql-server
sudo mysql_secure_installation
sudo mysql -e "CREATE DATABASE appdb; CREATE USER 'app'@'%' IDENTIFIED BY 'StrongPass!'; GRANT ALL ON appdb.* TO 'app'@'%'; FLUSH PRIVILEGES;"