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

Install and configure Deno for web development with systemd and reverse proxy

hosting
2,055

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

hosting
1,623

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

hosting
1,458

Install and configure Ollama for local AI models on Linux servers

devops
1,263

Configure Linux system time synchronization with chrony and NTP hardening

linux
1,170

Recently published

Configure Kubernetes network policies for enhanced cluster security

security
2 hours ago

Set up Kubernetes persistent volume snapshots and backup automation

devops
7 hours ago

Implement Kafka Streams exactly-once processing semantics with Java applications

devops
12 hours ago

Implement ClickHouse backup automation with compression and S3 integration

databases
21 hours ago

Install and configure Filebeat 8.15 for efficient log shipping to ELK stack

monitoring
1 day ago
"GTID" × Clear all
monitoring Intermediate

Configure Netdata MySQL monitoring and database performance alerts

Set up comprehensive MySQL monitoring with Netdata for real-time database performance metrics, query analysis, and automated alerts. Monitor connection pools, slow queries, and resource usage with production-grade alerting.

25 min 4 distros 92 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 178 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 219 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 134 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 75 views
databases Advanced

Setup MySQL replication with GTID and automatic failover

Configure MySQL 8.0 master-slave replication using GTID for reliable data synchronization, then implement MySQL High Availability (MHA) for automatic failover detection and promotion.

45 min 4 distros 94 views
databases Advanced

Configure MariaDB 11.6 master-slave replication with SSL encryption and automatic failover

Set up production-grade MariaDB master-slave replication with SSL/TLS encryption for secure data transmission and MaxScale for automatic failover and load balancing.

45 min 4 distros 476 views
databases Intermediate

Set up automated MySQL database backups with compression and rotation

Create production-grade MySQL backup automation with gzip compression, logrotate management, and systemd timer scheduling. Includes integrity checking and email notifications for reliable database protection.

25 min 4 distros 542 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 462 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