Opening database access directly over the internet is not recommended for security reasons. Instead, we can use SSH tunneling to securely connect to various databases such as MySQL, MariaDB, PostgreSQL, MongoDB, and Redis. This guide will show you how to create a dedicated SSH user that authenticates only with an RSA key and use it… Continue reading
Introduction K6 is a powerful self-hosted load testing tool that can be run in Docker and configured to simulate API requests, including authentication, POST requests, and JSON payloads. This guide provides a step-by-step tutorial on setting up K6 using Docker Compose and gradually moving from a simple request to a more complex Postman-like simulation. Step… Continue reading
When setting up Debian 12 on Hyper-V, one common issue is that the static IP reverts to dynamic after a reboot. Despite configuring a static IP, the system continues to obtain a dynamic address via DHCP. After extensive troubleshooting, I found the solution to ensure Debian 12 retains its static IP permanently. Why Does the… Continue reading
MongoDB is a super flexible NoSQL database, and if you’re running it on Debian 12 (Bookworm), setting up Master-Slave (Primary-Secondary) replication can help with scaling and data redundancy. This guide will take you through installing, running, and configuring MongoDB 8 for a master-slave setup. Prerequisites Step 1: Install MongoDB 8 on Debian 12 1.1. Update… Continue reading
PostgreSQL replication is a robust solution for ensuring database availability, load balancing, and failover readiness. This guide provides a step-by-step approach to setting up Master-Slave replication on Debian 12, using PostgreSQL 15, along with hostname-based configurations. 1. System Prerequisites 1.1 Server Environment We will use four Debian 12 servers with PostgreSQL 15 installed: 1.2 Update… Continue reading
When setting up a PostgreSQL master-slave replication or general database storage management, you should consider mounting specific storage paths to optimize performance, ensure data integrity, and manage disk usage efficiently. Below is a list of important PostgreSQL storage paths and their purposes: 1. Data Directory (Main Database Storage) Path: /var/lib/postgresql/<version>/main/Purpose: Stores all PostgreSQL database files,… Continue reading
With the Windows Subsystem for Linux (WSL), you can enjoy the power of Linux on your Windows 11 system. This guide will walk you through setting up WSL, running Debian 12, exporting it from a desktop computer, and importing it to a laptop with a custom name as the second Debian 12 instance. 1. Setting… Continue reading
RabbitMQ is a robust message broker widely used in distributed systems. This guide provides a detailed, step-by-step tutorial on installing RabbitMQ 3.10.8 with Erlang 25.2.3 on Debian 12 and configuring a Master-Slave cluster. The setup will involve two servers: a Master at 10.11.33.83 and a Slave at 10.11.33.93. 1. Configure Hostname Resolution Ensure both servers… Continue reading
When working with Docker to build scalable applications, networking and service configuration are critical components. Over the course of our exploration, we’ve touched on a variety of topics, starting with creating a docker-compose.yaml template, understanding network modes like bridge and host, and configuring services like MySQL. This article captures the complete journey to demystify Docker’s… Continue reading
Mattermost is a powerful open-source collaboration tool that can be deployed in various ways, including using Docker for easy setup and management. This tutorial will guide you through setting up Mattermost on Debian 12 using Docker, with an external PostgreSQL database configured in host network mode and without setting up Nginx. Prerequisites Before proceeding, ensure… Continue reading