EmergencyEMERGENCY? Get 24/7 Help Now!

Proxy Protocol and Percona XtraDB Cluster: A Quick Guide

 | October 15, 2015 |  Posted In: haproxy, MySQL, Percona XtraDB Cluster

cluster3

On September 21st, we released Percona XtraDB Cluster 5.6.25. This is the first PXC release supporting proxy-protocol that has been included in Percona Server since 5.6.25-73.0. With this blog post, I want to promote a new feature that you may have ignored. Let’s start with a description of the use case: Architecture Overview: HAProxy is configured like […]

Read More

Q&A: High availability when using MySQL in the cloud

 | June 19, 2015 |  Posted In: Cloud and MySQL, MySQL, MySQL Webinars, Percona XtraDB Cluster

Last week I hosted a webinar on using MySQL in the cloud for High Availability (HA) alongside 451 Research analyst Jason Stamper. You can watch the recording and also download the slides (free) here. Just click the “Register” button at the end of that page. We had several excellent questions and we didn’t have time […]

Read More

Making HAProxy 1.5 replication lag aware in MySQL

 | December 18, 2014 |  Posted In: haproxy, Insight for DBAs, MySQL, Percona Toolkit, Percona XtraDB Cluster

HAProxy is frequently used as a software load balancer in the MySQL world. Peter Boros, in a past post, explained how to set it up with Percona XtraDB Cluster (PXC) so that it only sends queries to available nodes. The same approach can be used in a regular master-slaves setup to spread the read load across […]

Read More

HAProxy: Give me some logs on CentOS 6.5!

 | October 3, 2014 |  Posted In: Insight for DBAs, MySQL

HAProxy is frequently used as a load-balancer in front of a Galera cluster. While diagnosing an issue with HAProxy configuration, I realized that logging doesn’t work out of the box on CentOS 6.5. Here is a simple recipe to fix the issue. If you look at the top of /etc/haproxy/haproxy.cfg, you will see something like: […]

Read More

Using keepalived for HA on top of Percona XtraDB Cluster

 | October 15, 2013 |  Posted In: MySQL, Percona XtraDB Cluster

Percona XtraDB Cluster (PXC) itself manages quorum and node failure.  Minorities of nodes in a network partition situation will move themselves into a Non-primary state and not allow any DB activity.  Nodes in such a state will be easily detectable via SHOW GLOBAL STATUS variables. It’s common to use HAproxy with PXC for load balancing purposes, but […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.