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.

databases Advanced

Benchmark database performance with sysbench and fio integration

Learn to benchmark MySQL and PostgreSQL database performance using sysbench 1.0.20 combined with fio 3.37 disk I/O testing. This comprehensive guide covers installation, configuration, execution of performance tests, and analysis of results for database optimization in production environments.

45 min 4 distros 32 views
databases Intermediate

Set up MySQL backup monitoring with Prometheus alerts and Grafana dashboards

Monitor MySQL backup health with automated mysqldump, Prometheus metrics collection, and Grafana dashboards. Get instant alerts when backups fail or take too long.

45 min 4 distros 23 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 177 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 86 views
databases Intermediate

Configure TimescaleDB automated data retention policies for efficient storage management

Set up automated data retention and compression policies in TimescaleDB to optimize storage usage and maintain database performance. Learn to configure drop_chunks and compression policies with monitoring.

25 min 4 distros 122 views
databases Intermediate

Set up MySQL backup encryption and remote storage with rsync

Create automated MySQL backups with GPG encryption and secure remote storage using rsync and SSH keys. This tutorial covers database dumping, compression, encryption, and automated synchronization to remote servers.

45 min 4 distros 507 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 528 views
databases Intermediate

Configure TimescaleDB continuous aggregates for real-time analytics with PostgreSQL optimization

Set up TimescaleDB continuous aggregates to automatically compute and maintain real-time materialized views for time-series data analytics. Configure refresh policies, optimize aggregate queries, and implement monitoring for production workloads.

45 min 4 distros 1,048 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