Infrastructure tutorials

Production-grade guides for Linux, servers, security and performance. Copy-paste commands, multi-distro support, written by engineers who run this in production.

Browse by topic

Most viewed

Configure Linux system time synchronization with chrony and NTP hardening

linux
865

Set up Node.js application security with Helmet and rate limiting

security
744

Install and configure Caddy web server with automatic HTTPS and reverse proxy

hosting
724

Install and configure Uvicorn ASGI server with systemd and reverse proxy for FastAPI applications

hosting
718

Install and configure PostgreSQL 17 with performance tuning and security hardening

databases
713

Recently published

Configure logrotate with Elasticsearch and Kibana integration for automated log management

monitoring
4 hours ago

Setup log aggregation with rsyslog and logrotate for centralized system monitoring

linux
4 hours ago

Configure SSH key authentication and security hardening

security
4 hours ago

Configure PostgreSQL 17 SSL encryption and advanced security hardening

security
4 hours ago

Integrate ModSecurity 3 with SOAR platforms for automated incident response and threat detection

security
13 hours ago
"replication" × Clear all
security Intermediate

Configure PostgreSQL 17 SSL encryption and advanced security hardening

Set up SSL/TLS encryption, client certificate authentication, and comprehensive security policies for PostgreSQL 17. Includes audit logging, access controls, and firewall configuration for production environments.

45 min 4 distros 4 views
databases Advanced

Set up PostgreSQL 17 streaming replication with PgBouncer connection pooling and load balancing

Configure PostgreSQL 17 streaming replication with automatic failover, PgBouncer connection pooling for performance optimization, and HAProxy load balancing for high availability database architecture.

45 min 4 distros 40 views
devops Intermediate

Deploy FastAPI applications with Docker Compose and production optimization

Learn to containerize FastAPI applications with Docker Compose, integrate PostgreSQL and Redis services, configure Nginx reverse proxy with SSL, and implement production monitoring for scalable microservices deployment.

45 min 4 distros 10 views
databases Intermediate

Configure FastAPI database connection pooling with PostgreSQL 17 for high-performance applications

Set up optimized async database connection pooling in FastAPI using SQLAlchemy and asyncpg with PostgreSQL 17. Learn connection pool tuning, session management patterns, and performance optimization for production workloads.

25 min 4 distros 12 views
databases Advanced

Configure Redis 7 cluster sharding for horizontal scaling with automated failover and monitoring

Set up Redis 7 cluster with automatic sharding across multiple nodes for horizontal scaling. Configure hash slots, master-slave replication, and automated failover with comprehensive monitoring.

45 min 4 distros 5 views
linux Intermediate

Configure backup compression and deduplication with BorgBackup and rsync for optimal storage efficiency

Set up automated backup systems with BorgBackup's advanced compression and deduplication alongside rsync strategies for maximum storage efficiency and reliable data protection.

25 min 4 distros 7 views
databases Advanced

Set up PostgreSQL 17 streaming replication with PgBouncer connection pooling and load balancing

Configure PostgreSQL 17 with streaming replication for high availability, then add PgBouncer connection pooling with intelligent load balancing across primary and replica servers for production-grade database infrastructure.

45 min 4 distros 11 views
performance Intermediate

Configure Tomcat 11 database connection pooling with HikariCP and JNDI optimization for high-performance applications

Set up efficient database connection pooling in Apache Tomcat 11 using HikariCP through JNDI configuration. Optimize connection parameters, implement proper resource management, and configure monitoring for production database workloads.

25 min 4 distros 8 views
databases Intermediate

Configure MySQL connection pooling with ProxySQL 2.6 for high availability and performance optimization

Set up ProxySQL 2.6 to manage MySQL connection pooling, load balancing, and automatic failover. This tutorial covers backend server configuration, health checks, query routing rules, and monitoring for production MySQL environments.

45 min 4 distros 24 views
monitoring Intermediate

Monitor MySQL performance with Prometheus and Grafana dashboards

Set up comprehensive MySQL monitoring with Prometheus MySQL Exporter and Grafana dashboards. Track query performance, connections, replication lag, and resource usage with automated alerts for production database health.

45 min 4 distros 73 views
databases Intermediate

Implement MySQL backup automation with Percona XtraBackup and systemd timers

Set up automated MySQL hot backups with Percona XtraBackup, systemd timers, compression, and encryption. Configure backup verification, retention policies, and restoration procedures for production-ready database backup automation.

45 min 4 distros 16 views
performance Intermediate

Configure Linux filesystem tuning and optimization for database workloads

Optimize Linux filesystem performance for database workloads by configuring mount options, I/O schedulers, and kernel parameters to maximize database throughput and minimize latency.

45 min 4 distros 11 views

Need help?

Don't want to manage this yourself?

We handle infrastructure for businesses that depend on uptime. From initial setup to ongoing operations.

Talk to an engineer