Tutorials Databases

Databases

MySQL, PostgreSQL, Redis, backups, replication

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
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
databases Intermediate

Configure Elasticsearch 8 snapshot and restore policies with automated backup strategies

Set up comprehensive Elasticsearch 8 backup strategies with snapshot lifecycle management (SLM), filesystem and S3 repository backends, automated scheduling, and recovery procedures for production environments.

45 min 4 distros 101 views
databases Advanced

Optimize MongoDB 8.0 performance with advanced indexing strategies and aggregation pipelines

Master MongoDB 8.0 performance optimization through strategic index design, aggregation pipeline efficiency, and production-ready monitoring. Covers compound indexes, query analysis, memory management, and security hardening for high-throughput database workloads.

45 min 4 distros 63 views
databases Advanced

Optimize Elasticsearch 8 search performance with custom analyzers and field mappings

Configure custom text analyzers, optimize field mappings, and implement index templates to dramatically improve Elasticsearch search performance and relevance for production workloads.

45 min 4 distros 81 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 96 views
databases Advanced

Configure MongoDB sharding with zone-based data distribution for geographic workloads

Set up MongoDB sharding with geographic zones to distribute data based on location, ensuring optimal performance for global applications and regulatory compliance.

45 min 4 distros 85 views
databases Advanced

Set up CockroachDB backup and disaster recovery automation with systemd timers and monitoring

Configure automated backup strategies for CockroachDB with systemd timers, implement comprehensive disaster recovery procedures, and set up monitoring with Prometheus and Grafana for production-grade database infrastructure.

90 min 4 distros 105 views
databases Advanced

Configure Elasticsearch cross-cluster replication for disaster recovery

Set up Elasticsearch cross-cluster replication (CCR) to replicate indices between clusters for disaster recovery. Configure remote clusters, create follower indices, and monitor replication status for high availability.

45 min 4 distros 92 views
databases Advanced

Configure InfluxDB 2.7 clustering for high availability with data replication and automated failover

Set up a production-ready InfluxDB Enterprise cluster with automatic data replication, failover mechanisms, and comprehensive monitoring using Grafana dashboards for time-series workloads.

45 min 4 distros 134 views
databases Intermediate

Configure Elasticsearch Index Lifecycle Management (ILM) for automated data retention

Set up Elasticsearch ILM policies to automatically manage index lifecycles through hot, warm, cold, and delete phases. Reduce storage costs and optimize performance by automating data retention and storage tiering.

25 min 4 distros 128 views
databases Advanced

Configure Redis 7 cluster sharding with SSL/TLS authentication and security hardening

Set up a production-ready Redis 7 cluster with automatic sharding, SSL/TLS encryption, authentication, and comprehensive security hardening for high availability and data protection.

45 min 4 distros 128 views