June 19, 2013

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

…, also XB 2.1 is required for most). Finally, the HAProxy. HAProxy is one of the loadbalancers recommended for use with PXC… XtraDB Cluster reference architecture with HaProxy“) for details. In their setup they have automated this with a HAProxy in each AZ (Availability….5.31), looking for optimizations with HAProxy to account for high connection rates, and using pacemaker with PXC. The goal is to…

Comment: Keep your MySQL backend online no matter what + TGIF Contest!

I use MySQL Galera with HAProxy setup with Pacemaker. I have scripts that HAProxy uses checks for up/down status. It’s been working pretty well.