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.

performance Intermediate

Optimize Varnish 7 cache storage with memory tuning and persistence configuration

Configure Varnish 7 memory allocation and storage backends for optimal cache performance. Set up file-based persistence and tune memory parameters for high-traffic workloads with monitoring.

25 min 4 distros 166 views
hosting Intermediate

Configure PHP-FPM with NGINX reverse proxy and SSL certificates

Set up PHP-FPM with NGINX as a reverse proxy and secure it with Let's Encrypt SSL certificates. This configuration provides high performance for PHP applications with proper process isolation and automatic HTTPS.

25 min 4 distros 147 views
databases Advanced

Optimize ScyllaDB performance for time-series data workloads with advanced configuration tuning

Configure ScyllaDB with specialized optimizations for time-series workloads including partitioning strategies, compaction settings, and memory tuning. Set up monitoring with Prometheus and Grafana for production performance insights.

45 min 4 distros 199 views
databases Intermediate

Configure ClickHouse materialized views for real-time analytics with performance optimization

Set up ClickHouse materialized views to transform raw data into real-time aggregations. Configure performance optimization with memory tuning and monitoring for high-throughput analytics workloads.

45 min 4 distros 274 views
databases Advanced

Optimize ClickHouse performance for large datasets with advanced tuning and memory management

Optimize ClickHouse for high-performance analytics on multi-terabyte datasets with advanced memory tuning, storage engine configuration, query optimization strategies, and distributed clustering for production workloads.

45 min 4 distros 323 views
performance Advanced

Implement Nginx Redis cluster caching for high availability

Set up a Redis cluster with Nginx caching for high availability and improved performance. This configuration provides distributed caching with automatic failover and enhanced scalability for production web applications.

45 min 4 distros 831 views
performance Intermediate

Implement Varnish cache warming with automated content preloading for high-performance websites

Set up automated Varnish cache warming with priority URL preloading, systemd timers for scheduled content refreshing, and comprehensive monitoring to optimize cache hit rates and reduce backend server load for high-traffic websites.

35 min 4 distros 679 views
performance Beginner

Optimize PHP-FPM performance with memory tuning and connection pooling for high-traffic websites

Configure PHP-FPM with optimized memory pools, process management, and connection limits to handle high-traffic websites efficiently. Learn production-grade tuning strategies for maximum performance.

25 min 6 distros 794 views
databases Beginner

Install and configure DuckDB for analytical workloads with Python integration

Set up DuckDB, the high-performance analytical database, with CLI tools and Python integration for fast OLAP queries and data analytics workloads.

25 min 6 distros 871 views
performance Intermediate

Optimize Nginx caching performance with Redis backend and memory tuning for high-traffic websites

Supercharge your web application performance by integrating Redis as a caching backend for Nginx using lua-resty-redis. This tutorial covers Redis memory optimization, Nginx worker tuning, and comprehensive performance testing for production environments.

45 min 6 distros 654 views
performance Intermediate

Optimize MySQL query performance with indexes and query profiling for high-traffic applications

Learn how to dramatically improve MySQL query performance using proper indexing strategies, query profiling tools, and InnoDB optimization techniques. This tutorial covers slow query log analysis, EXPLAIN plan interpretation, and memory tuning for production databases.

45 min 6 distros 552 views
performance Intermediate

Configure Linux memory management and swap optimization for high-performance workloads

Optimize Linux memory subsystem performance through advanced swap configuration, virtual memory tuning, and memory compression techniques. Learn to configure transparent huge pages, zram, and application-specific memory settings for high-performance workloads.

25 min 6 distros 894 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