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 88 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 103 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 119 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 221 views
databases Beginner

Set up development database environments with environment variables

Learn to configure PostgreSQL, MySQL, and MariaDB development databases using environment variables for secure connection management and simplified configuration across different environments.

25 min 4 distros 143 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 198 views
hosting Intermediate

Configure Tomcat 11 database connection pooling with JNDI and HikariCP for high availability

Set up production-grade database connection pooling in Tomcat 11 using JNDI resources and HikariCP for optimal performance and high availability. Learn to configure server.xml, context.xml, and monitor connection pools effectively.

25 min 4 distros 297 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 Advanced

Optimize CockroachDB 24.3 performance with advanced tuning and configuration

Master advanced CockroachDB 24.3 performance optimization through memory, CPU, storage, and query tuning. Configure cluster parameters, connection pooling, and indexing strategies for production-grade distributed SQL workloads.

45 min 4 distros 368 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 426 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

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