Setting Up MySQL Master-Master Replication for High Availability
Network Connectivity Requirements
Ensure bidirectional network commuincation between cluster nodes using ping utility.
C:\Users\administrator>ping 192.168.100.91
Pinging 192.168.100.91 with 32 bytes of data:
Reply from 192.168.100.91: bytes=32 time=2ms TTL=64
Reply from 192.168.100.91: bytes=32 time=1ms TTL=64
Reply from 192.168.100.91: byt ...
Posted on Fri, 18 Sep 2026 16:42:44 +0000 by kaumilpatel
Implementing High Availability with MariaDB Galera Multi-Master Cluster
Infrastructure Overview
In this deployement, we utilize three Linux instances to form a resilient multi-master MariaDB cluster. This setup ensures data consistency and high availability across all nodes.
Node Hostname
IP Address
Role
galera-01
10.32.161.131
Cluster Node
galera-02
10.32.161.132
Cluster Node
galeera-03
10.32.161.133
Cl ...
Posted on Sun, 19 Jul 2026 17:06:36 +0000 by skyer2000
Understanding and Configuring MySQL Server Logging
Introduction to Database Logging Mechanisms
MySQL employs a modular logging architecture to capture operational events, diagnose runtime failures, monitor query efficiency, and support disaster recovery. Each log subsystem serves a distinct purpose within the server lifecycle, and cnofiguring them correctly is fundamental to maintaining a stabl ...
Posted on Sat, 18 Jul 2026 17:17:20 +0000 by phpfre@k*