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

Implement MariaDB backup encryption with Mariabackup and automated restoration

Set up encrypted MariaDB backups using Mariabackup with AES encryption, automated scheduling, and verified restoration procedures for secure database protection.

45 min 4 distros 78 views
monitoring Intermediate

Configure MariaDB 11.6 performance monitoring with Prometheus and Grafana dashboards

Set up comprehensive MariaDB monitoring with mysqld_exporter, Prometheus metrics collection, and custom Grafana dashboards for database performance insights and alerting.

35 min 4 distros 90 views
databases Advanced

Configure MariaDB Galera cluster for multi-master replication with automatic failover

Set up a highly available MariaDB Galera cluster with multi-master replication and automatic failover for production database workloads. This tutorial covers cluster initialization, node configuration, and monitoring setup across multiple servers.

45 min 4 distros 109 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 86 views
monitoring Intermediate

Configure MariaDB 11.6 monitoring with Prometheus and Grafana dashboards

Set up comprehensive MariaDB monitoring with Prometheus mysqld_exporter metrics collection and Grafana visualization. Configure database performance alerts, query monitoring, and custom dashboards for production MariaDB instances.

25 min 4 distros 194 views
databases Advanced

Configure MariaDB Galera cluster 10.11 for multi-master replication with automatic failover

Set up a highly available MariaDB Galera cluster with multi-master replication, automatic failover, and synchronous data replication across multiple database nodes for enterprise applications.

45 min 4 distros 197 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 342 views
monitoring Advanced

Monitor MariaDB Galera cluster with Prometheus and Grafana for high availability insights

Configure comprehensive monitoring for MariaDB Galera clusters using Prometheus exporters and Grafana dashboards to track cluster health, replication status, and performance metrics with automated alerting for production environments.

45 min 4 distros 307 views
databases Intermediate

Implement MariaDB connection pooling with ProxySQL for high availability

Set up ProxySQL as a connection pooling proxy for MariaDB to improve performance and provide high availability. Configure backend server management, connection pooling rules, and monitoring for production workloads.

45 min 4 distros 425 views
databases Advanced

Set up MariaDB Galera Cluster 11.6 for multi-master replication with automatic failover

Configure a production-ready MariaDB Galera cluster with three nodes for multi-master replication, automatic failover, and SSL encryption. Includes HAProxy load balancing and comprehensive monitoring for high availability database operations.

45 min 4 distros 777 views
databases Advanced

Optimize MariaDB 11.6 performance with query analysis and indexing for high-traffic applications

Learn advanced MariaDB performance optimization techniques including query profiling, slow query analysis, and strategic indexing for high-traffic applications. This tutorial covers query execution plan analysis, covering indexes, and automated monitoring setup.

45 min 4 distros 631 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 897 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