12 tutorials · 26 guides
Install PostgreSQL 18 on a Raff Ubuntu 24.04 VM. Add PGDG, create a database role, verify SCRAM, secure port 5432, and test backup and restore safely.
Install MongoDB 8.3 on Ubuntu 24.04 from the official repository. Enable authentication, secure port 27017, and verify backup and restore safely.
Install MySQL 8.0 on a Raff Ubuntu 24.04 VM. Secure root access and port 3306, create an app user, verify CRUD, and test backup and restore safely.
Self-host Supabase on Ubuntu 24.04 with the versioned Docker Compose stack, Caddy HTTPS, secure keys, Postgres and Storage backups, restores, and safe updates.
Self-host Invoice Ninja 5.13.37 on Ubuntu 24.04 with Docker Compose, MySQL, Redis, Caddy HTTPS, built-in queues/scheduler, backups, restores, and safe updates.
Deploy Odoo 19 on Ubuntu 24.04 with Docker Compose, PostgreSQL 15, Caddy HTTPS, workers, database lockdown, matched backups, restores, and safe updates.
Install Ghost CMS on Ubuntu 24.04 with Nginx, Node.js 22, MySQL 8, Ghost-CLI, HTTPS, backups, rollback, and current Ghost 6 deployment guidance.
Back up PostgreSQL to S3-compatible Raff Object Storage with Restic on Ubuntu 24.04. Automate encrypted dumps, retention, checks, and restore tests.
Self-host Plausible Analytics CE on Ubuntu 24.04 with Docker Compose, automatic HTTPS, protected secrets, health checks, backups, and safe upgrades.
Deploy a multi-container Docker Compose app on Ubuntu 24.04 with Node.js, PostgreSQL, Redis, secrets, health checks, private networking, backups, and persistence.
Deploy Gitea on Ubuntu 24.04 with Docker Compose, PostgreSQL, Nginx, HTTPS, SSH clone access, backups, upgrades, and verification steps.
Self-host n8n on Ubuntu 24.04 with Docker Compose, PostgreSQL, Nginx, HTTPS, safe firewall setup, backups, restore verification, and updates.
Design MySQL backups and point-in-time recovery with full backups, binary logs, retention, restore testing, and safe replay after accidental changes.
Diagnose MySQL performance bottlenecks across slow queries, indexes, connections, locks, memory, and storage before scaling production database capacity.
Compare managed database vs self-hosted across total cost, control, backups, HA, recovery, security, scaling, and operational ownership for production workloads.
Compare PostgreSQL replication, backups, point-in-time recovery, and snapshots by the failure modes each protects and the recovery gaps each leaves.
Plan database storage on block volumes for PostgreSQL and MySQL, including layout, capacity headroom, I/O monitoring, backups, and recovery.
Compare database migration services by scope, cost, downtime, provider responsibilities, validation, and rollback before choosing a migration provider or consultant.
Compare VPS database hosting with managed databases, including control, cost, backups, recovery, networking, and operational ownership for small teams.
Compare MySQL, PostgreSQL, and MongoDB by data model, ecosystem, performance, scaling, and operations to narrow a three-engine database decision.
Use this database migration checklist to assess compatibility, prepare the target, prove recovery, synchronize data, control cutover, validate production, and plan rollback.
Compare database hosting services for production apps by engine support, backups, PITR, HA, private networking, connections, pricing, migration, and support.
Learn K3s default datastore behavior and compare SQLite, embedded etcd, and external PostgreSQL/MySQL/etcd for HA, quorum, backups, and recovery.
Understand PostgreSQL connection pooling, PgBouncer modes, pool sizing, max_connections, and how SaaS teams prevent connection storms in production.
Understand PostgreSQL for SaaS apps across sizing, connections, pooling, backups, high availability, and managed vs self-hosted production ownership.
PostgreSQL performance tuning for SaaS teams: query plans, indexes, vacuum, statistics, locks, connection pressure, and capacity decisions.
PostgreSQL high availability explained: architecture, synchronous vs asynchronous replication, failover, fencing, read replicas, application reconnects, and managed vs self-hosted HA.
Plan a zero-downtime database migration with expand-contract, staged backfills, replication cutovers, rollback, and PostgreSQL or MySQL safety checks.
Compare MongoDB vs PostgreSQL across data modeling, JSON, transactions, performance, scaling, and operations to choose the database that fits your application.
Compare MongoDB hosting and MongoDB database hosting options across managed vs self-hosted deployment, providers, production architecture, backups, security, scaling, and total operating cost.
Compare MySQL hosting across managed MySQL and self-hosted MySQL, including cost, connections, backups, PITR, HA, recovery, and operational ownership.
Compare Postgres hosting for SaaS across managed PostgreSQL and self-hosted PostgreSQL, including cost, connections, backups, HA, recovery, and operational ownership.
Compare PostgreSQL vs MySQL across performance, JSON, transactions, extensions, replication, use cases, migration, and managed hosting to choose the right database.
Compare MongoDB vs MySQL across data model, performance, transactions, JSON, scaling, use cases, migration, and operations to choose the right database.
Compare MySQL vs MariaDB for production apps across compatibility, performance, migration risk, backups, and managed or self-hosted operations.
Compare SQL vs NoSQL across relational, document, and key-value models, including data modeling, performance, scaling, SaaS use cases, and operations.
Learn how Windows Server licensing affects hosted VMs, including SPLA, BYOL, RDS CALs, SQL Server, Standard vs Datacenter, and provider selection.
Compare Windows VPS hosting for RDP, Windows business software, IIS and SQL Server. Learn provider criteria, sizing, licensing, security, backups, and total cost.
The tutorials, guides, and comparisons we publish, rounded up in one weekly email. Unsubscribe anytime.
Spin up a Linux or Windows server and follow any tutorial here on real infrastructure. RDP and SSH ready, 14-day money-back guarantee.
Deploy a server