Tutorials Databases

Databases

MySQL, PostgreSQL, Redis, backups, replication

databases Intermediate

Configure Deno database connections to PostgreSQL and Redis with connection pooling

Set up production-ready database connections in Deno applications with PostgreSQL and Redis, including SSL configuration, connection pooling, authentication, and comprehensive error handling for high-performance TypeScript applications.

45 min 4 distros 332 views
databases Intermediate

Configure ScyllaDB backup and restore with automation

Set up automated daily backups for ScyllaDB with monitoring, restore procedures, and retention policies. Includes snapshot management, S3 storage integration, and comprehensive alerting for production NoSQL environments.

45 min 4 distros 368 views
databases Intermediate

Configure MinIO backup and disaster recovery with automated snapshots and replication

Configure comprehensive backup and disaster recovery for MinIO object storage with automated snapshots, cross-site replication, and encryption. Implement production-ready backup strategies to protect critical data and ensure business continuity.

45 min 4 distros 416 views
databases Intermediate

Implement Elasticsearch 8 index lifecycle management and retention policies

Configure automated index lifecycle management (ILM) policies in Elasticsearch 8 to optimize storage, performance, and data retention. Learn to set up hot-warm-cold architectures with automatic rollover and deletion based on age and size criteria.

25 min 4 distros 658 views
databases Intermediate

Set up MySQL backup encryption and remote storage with rsync

Create automated MySQL backups with GPG encryption and secure remote storage using rsync and SSH keys. This tutorial covers database dumping, compression, encryption, and automated synchronization to remote servers.

45 min 4 distros 498 views
databases Intermediate

Configure application connection pooling for CockroachDB with PgBouncer and HAProxy

Set up efficient connection pooling for CockroachDB applications using PgBouncer as a connection pool manager and HAProxy for load balancing across multiple database nodes. This configuration reduces database connection overhead and improves application performance.

45 min 4 distros 465 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 521 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 599 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 508 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 802 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 1,030 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 634 views