• HA Galera Cluster with HAProxy and Keepalived: Simplifying the Setup

    ·

    , , ,

    HA Galera Cluster with HAProxy and Keepalived: Simplifying the Setup

    When managing a database cluster in production, ensuring high availability and load balancing is critical. Initially, we used GLB (Global Load Balancer) on each webserver to balance connections to our four Galera MySQL servers. GLB worked fine, but maintaining it across multiple webservers quickly became cumbersome. So we decided to simplify and centralize our setup…

  • Effortless Backups for Galera Cluster with XtraBackup

    ·

    Effortless Backups for Galera Cluster with XtraBackup

    Maintaining high availability in a Galera Cluster environment requires a robust and reliable backup solution. XtraBackup is a popular choice, offering non-blocking backups that preserve data consistency across all nodes. Whether you need a full backup for disaster recovery or incremental backups for efficient storage use, XtraBackup integrates seamlessly with Galera. This guide walks you…

  • Evolving Our Database Class – Introducing Exponential Backoff and Enhanced Performance

    ·

    ,

    Evolving Our Database Class – Introducing Exponential Backoff and Enhanced Performance

    In a previous blog, we showcased a robust database class designed to streamline database interactions and handle common issues like deadlocks gracefully. While the original version was reliable, we’ve since implemented significant improvements to address real-world challenges, particularly in high-concurrency scenarios. Today, we’re excited to introduce exponential backoff in our retry mechanism, enhanced logging, and…

  • Efficient Database Operations in a Galera Cluster with PHP

    ·

    ,

    Efficient Database Operations in a Galera Cluster with PHP

    Working with distributed systems like a Galera cluster introduces unique challenges when managing database operations. Deadlocks, serialization issues, and transaction conflicts can easily disrupt your application’s performance if not handled properly. Recently, I implemented a robust PHP class to handle CRUD (Create, Read, Update, Delete) operations efficiently in such an environment. Here’s how it was…

  • Setting Up a Galera Cluster with GLB for Database Load Balancing

    Setting Up a Galera Cluster with GLB for Database Load Balancing

    In high-demand environments where uptime and responsiveness are critical, databases often become the backbone of any application’s infrastructure. A Galera cluster offers a powerful solution for creating a high-availability database system with synchronous replication. When paired with GLB (Galera Load Balancer), you get efficient load distribution across the cluster, ensuring that no single database node…