MariaDB Master-Slave HA with ProxySQL and Signal 18 Repman
Evaluation of MariaDB Master-Slave architecture with ProxySQL and Signal 18 Repman for high availability.
A production upgrade for a high-load application is being evaluated, focusing on MariaDB's Master-Slave architecture. Heavy write spikes are causing slave lag under current configurations. The proposed HA stack includes Keepalived, ProxySQL, and Signal 18 Replication Manager for automated failover. Questions arise regarding the architecture's viability for 1,500 writes/sec and the pros and cons of this setup.