Tutorials

Step-by-step guides for your cloud servers: installs, configuration and best practices.

How to connect an app to a remote database

Allow access to a database from another server, securely: bind address, dedicated user and firewall.

By default, MongoDB runs without a password. Here is how to enable authentication and create an admin user.

Speed up your app with Redis: install, secure and use it as a cache or message broker.

Create roles, databases and grant privileges in PostgreSQL, step by step.

Create dedicated MySQL users per application and grant exactly the privileges needed, step by step.

Set up a standby (replica) that copies your PostgreSQL data in real time, for redundancy and distributed reads.

Install the most advanced open-source database and configure it safely: password, scram-sha-256 authentication and controlled access.

Install MySQL or MariaDB on your VPS and secure it properly: root password, removing test accounts and controlled access.

Basic settings for a fast MySQL: buffer pool, indexes, slow queries and how much RAM you need.

A complete MongoDB backup guide: mongodump, cron automation and how to send copies to a Backup Box mounted as an extra disk.

A complete MySQL backup guide: mysqldump, cron automation and how to send copies to a Backup Box mounted as an extra disk.

A complete Laravel backup: code, .env, storage and database, plus how to send it all to a Backup Box mounted as an extra disk.