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.

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 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 99 views
performance Intermediate

Configure Tomcat 11 database connection pooling with HikariCP and JNDI optimization for high-performance applications

Set up efficient database connection pooling in Apache Tomcat 11 using HikariCP through JNDI configuration. Optimize connection parameters, implement proper resource management, and configure monitoring for production database workloads.

25 min 4 distros 102 views
hosting Intermediate

Install and configure OpenLiteSpeed with WordPress and LSCache optimization

Set up OpenLiteSpeed web server with PHP 8.4, deploy WordPress with database integration, and enable LSCache plugin for maximum performance optimization.

35 min 4 distros 115 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 168 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 92 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 195 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 191 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 227 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 288 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 624 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 514 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