Databases tutorials

Installing, securing and optimizing MySQL, PostgreSQL, MongoDB and Redis databases, plus users, replication, migration and remote access.

How to connect an app to a remote database

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

Schedule daily MySQL or PostgreSQL backups with cron, with automatic retention, and send them to a Backup Box.

Move a MySQL or PostgreSQL database to a new server with minimal downtime, using dump and restore.

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.

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.

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

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

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