Databases

MySQL, PostgreSQL, Redis, backups, replication

Databases tutorials

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 Advanced

Configure Elasticsearch 8 cluster with multiple nodes for high availability and scalability

Set up a production-ready Elasticsearch 8 cluster with dedicated master, data, and coordinating nodes for high availability, fault tolerance, and horizontal scalability across multiple servers.

45 min 4 distros 1,319 views
databases Advanced

Set up TimescaleDB clustering for high availability with automatic failover

Configure a production-ready TimescaleDB cluster with streaming replication, automatic failover using Patroni, and etcd for distributed consensus to ensure zero-downtime operation of your time-series database.

45 min 4 distros 1,993 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 Advanced

Configure ZooKeeper for ClickHouse replication with multi-node cluster setup

Set up a production-ready ZooKeeper ensemble to enable ClickHouse replication across multiple nodes. This tutorial covers ZooKeeper cluster configuration, ClickHouse integration, security hardening, and failover testing.

45 min 4 distros 1,127 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,996 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,058 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,071 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,207 views