Databases

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 743 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 1,069 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 896 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 1,077 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 889 views

databases Intermediate

Implement ClickHouse backup automation with compression and S3 integration

Set up automated ClickHouse backups with compression, S3 storage, and systemd timers. Includes monitoring, encryption, and recovery procedures for production environments.

45 min 4 distros 847 views

databases Advanced

Benchmark database performance with sysbench and fio integration

Learn to benchmark MySQL and PostgreSQL database performance using sysbench 1.0.20 combined with fio 3.37 disk I/O testing. This comprehensive guide covers installation, configuration, execution of performance tests, and analysis of results for database optimization in production environments.

45 min 4 distros 1,002 views

databases Advanced

Configure MySQL binary log backup and point-in-time recovery

Set up automated MySQL binary log backup with rotation and implement point-in-time recovery procedures for complete database disaster recovery and operational continuity.

45 min 4 distros 1,732 views

databases Intermediate

Set up MySQL backup monitoring with Prometheus alerts and Grafana dashboards

Monitor MySQL backup health with automated mysqldump, Prometheus metrics collection, and Grafana dashboards. Get instant alerts when backups fail or take too long.

45 min 4 distros 1,794 views

databases Advanced

Optimize DuckDB performance for large datasets with partitioning

Configure DuckDB with advanced partitioning strategies and memory optimization for processing multi-gigabyte datasets efficiently. Includes Python integration, query optimization techniques, and comprehensive monitoring setup.

45 min 4 distros 1,184 views

databases Intermediate

Configure DuckDB cluster setup for distributed analytics and high performance workloads

Set up a DuckDB cluster with distributed query processing, network security, and performance optimization for high-throughput analytical workloads across multiple nodes.

45 min 4 distros 847 views

databases Intermediate

Setup DuckDB with Apache Airflow for automated data pipelines

Configure DuckDB as a high-performance analytical database backend for Apache Airflow workflows. Build automated data pipelines that process files, APIs, and databases using DuckDB's columnar engine.

45 min 4 distros 924 views