Databases

MySQL, PostgreSQL, Redis, backups, replication

Databases tutorials

databases Intermediate

Set up automated MySQL database backups with compression and rotation

Create production-grade MySQL backup automation with gzip compression, logrotate management, and systemd timer scheduling. Includes integrity checking and email notifications for reliable database protection.

25 min 4 distros 1,086 views
databases Intermediate

Install and configure ScyllaDB cluster with replication and performance tuning

Set up a production-ready ScyllaDB cluster with multi-node configuration, automatic replication, and performance optimization. ScyllaDB provides 10x better performance than Cassandra with drop-in compatibility.

45 min 6 distros 1,293 views
databases Intermediate

Configure Apache Cassandra cluster with multi-node setup and performance optimization

Set up a production-ready Apache Cassandra cluster with multiple nodes, configure replication strategies, and optimize JVM settings and performance parameters for high-throughput distributed NoSQL workloads.

45 min 6 distros 1,043 views
databases Intermediate

Install and configure CockroachDB cluster with high availability and distributed SQL

Set up a production-ready CockroachDB cluster with SSL certificates, load balancing, and automated backups for distributed SQL workloads. This tutorial covers multi-node deployment, security hardening, and performance optimization for enterprise environments.

45 min 6 distros 1,431 views
databases Intermediate

Configure TimescaleDB continuous aggregates for real-time analytics with PostgreSQL optimization

Set up TimescaleDB continuous aggregates to automatically compute and maintain real-time materialized views for time-series data analytics. Configure refresh policies, optimize aggregate queries, and implement monitoring for production workloads.

45 min 4 distros 2,151 views
databases Intermediate

Configure Redis Sentinel for high availability and automatic failover

Set up Redis Sentinel to monitor Redis master-replica deployments and automatically handle failover scenarios. This tutorial covers configuring a 3-node Sentinel cluster with quorum-based decision making for production-grade high availability.

25 min 4 distros 1,970 views
databases Intermediate

Install and configure TimescaleDB with PostgreSQL for high-performance time-series data

Learn how to install TimescaleDB extension on PostgreSQL for handling time-series data at scale. This tutorial covers hypertables setup, compression policies, performance tuning, and security hardening with SSL.

45 min 6 distros 3,997 views
databases Intermediate

Install and configure ClickHouse for high-performance analytics with clustering

Set up ClickHouse OLAP database with clustering support for real-time analytics workloads. Configure distributed tables, security, SSL encryption, and monitoring for production environments.

45 min 6 distros 1,056 views
databases Intermediate

Install and configure MinIO object storage with SSL and clustering

Set up MinIO as a distributed S3-compatible object storage cluster with SSL/TLS encryption and production-grade security. This tutorial covers installation, clustering, access policies, and monitoring for high-availability storage infrastructure.

45 min 6 distros 2,069 views
databases Intermediate

Install and configure Elasticsearch 8 with security and performance optimization

Set up a production-ready Elasticsearch 8 cluster with SSL/TLS security, optimized JVM settings, and automated backups. Includes memory tuning, index mapping strategies, and common troubleshooting fixes.

45 min 6 distros 1,081 views
databases Intermediate

Install and configure Redis 7 with clustering and security hardening

Set up Redis 7 with master-replica clustering, SSL/TLS encryption, ACL authentication, and production-grade security hardening. Includes performance tuning, backup strategies, and monitoring configuration for high-availability deployments.

45 min 6 distros 1,217 views
databases Intermediate

Install and configure PostgreSQL 17 with performance tuning and security hardening

Learn to install PostgreSQL 17 from official repositories, optimize performance with proper memory settings, and implement security best practices including SSL encryption and authentication hardening.

45 min 6 distros 1,612 views