Tutorials Databases

Databases

MySQL, PostgreSQL, Redis, backups, replication

databases Advanced

Set up ClickHouse and Kafka real-time data pipeline with streaming analytics

Build a production-ready real-time data pipeline using ClickHouse for high-performance analytics and Apache Kafka for streaming data ingestion. Configure clustering, replication, and automated data processing workflows.

45 min 4 distros 303 views
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 427 views
databases Beginner

Install and configure DuckDB for analytical workloads with Python integration

Set up DuckDB, the high-performance analytical database, with CLI tools and Python integration for fast OLAP queries and data analytics workloads.

25 min 6 distros 459 views
databases Beginner

Install and configure MongoDB 8.0 with authentication and SSL encryption

Set up MongoDB 8.0 from official repositories with authentication enabled and SSL/TLS encryption. Configure admin users, implement security hardening, and establish monitoring for production deployments.

25 min 6 distros 455 views
databases Beginner

Install and configure MariaDB 11.6 with performance optimization and security hardening

Set up MariaDB 11.6 as a high-performance MySQL alternative with InnoDB optimization, SSL encryption, automated backups, and comprehensive security hardening for production environments.

45 min 6 distros 425 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 428 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 414 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 684 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 507 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 315 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 655 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 421 views