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
Saat ini saya dan tim sedang mengelola beberapa project kuis (trivia) dan lead form di platform web, dan salah satu tantangan utamanya adalah bagaimana melindungi aplikasi dari serangan bot tanpa mengganggu pengalaman pengguna. Apapun, konversi yang tinggi dan data yang berkualitas menjadi tuntutan tim internal dan juga pastinya klien. Awalnya, seperti biasa, teman-teman developer mempertimbangkan… 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
Apakah kamu pernah merasa tiba-tiba disalahkan atas sesuatu yang bukan kesalahanmu? Atau pernah melihat seseorang yang mendadak dikorbankan demi menyelamatkan kepentingan orang lain? Jika iya, kamu mungkin telah menyaksikan atau bahkan mengalami fenomena throwing someone under the bus. Dalam dunia kerja, politik, dan kehidupan sosial, ungkapan ini sering digunakan untuk menggambarkan tindakan mengorbankan orang lain… 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