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 Intermediate

Set up automated MariaDB Galera cluster backups with compression

Learn how to build a cluster-safe backup strategy for MariaDB Galera using Mariabackup, compression, systemd timers and remote storage offloading, with verification and node restore procedures.

40 min 4 distros 97 views
databases Intermediate

Set up MySQL point-in-time recovery with binary logs for database backup and restore

Configure MySQL binary logging and implement automated point-in-time recovery procedures for comprehensive database backup and restore operations with monitoring.

45 min 4 distros 1,537 views
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 1,026 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 987 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 2,356 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 2,013 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 1,695 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 1,604 views

Don't want to manage this yourself?

We handle infrastructure for businesses that depend on uptime. Fully managed, with one fixed contact who knows your setup.

You get one fixed contact who knows your setup

Rotterdam 03:39 · reachable in a message, no ticket form