EmergencyEMERGENCY? Get 24/7 Help Now!

Consul, ProxySQL and MySQL HA

 | September 16, 2016 |  Posted In: MySQL


When it comes to “decision time” about which type of MySQL HA (high-availability) solution to implement, and how to architect the solution, many questions come to mind. The most important questions are: “What are the best tools to provide HA and Load Balancing?” “Should I be deploying this proxy tool on my application servers or on a […]

Read More

ProxySQL and MHA Integration

 | September 13, 2016 |  Posted In: High-availability, MySQL, ProxySQL


This blog post discusses ProxySQL and MHA integration, and how they work together. MHA (Master High Availability Manager and tools for MySQL) is almost fully integrated with the ProxySQL process. This means you can count on the MHA standard feature to manage failover, and ProxySQL to manage the traffic and shift from one server to another. This […]

Read More

MHA Quick Start Guide

 | September 2, 2016 |  Posted In: High-availability, MySQL


MHA (Master High Availability Manager and tools for MySQL) is one of the most important pieces of our managed services. When properly set up, it can check replication health, move writer and reader virtual IPs, perform failovers, and have its output constantly monitored by Nagios. Is it easy to deploy and follows the KISS (Keep It […]

Read More

Measuring failover time for ScaleArc load balancer

 | August 19, 2014 |  Posted In: Benchmarks, Insight for DBAs, MySQL, Percona MySQL Consulting, Percona Software, Percona XtraDB Cluster

ScaleArc hired Percona to benchmark failover times for the ScaleArc database traffic management software in different scenarios. We tested failover times for various clustered setups, where ScaleArc itself was the load balancer for the cluster. These tests complement other performance tests on the ScaleArc software – sysbench testing for latency and testing for WordPress acceleration. […]

Read More

High-availability options for MySQL, October 2013 update

 | October 23, 2013 |  Posted In: High-availability, MySQL, Percona Server, Percona XtraDB Cluster

The technologies allowing to build highly-available (HA) MySQL solutions are in constant evolution and they cover very different needs and use cases. In order to help people choose the best HA solution for their needs, we decided, Jay Janssen and I, to publish, on a regular basis (hopefully, this is the first), an update on […]

Read More

Choosing a MySQL HA Solution – MySQL Webinar: June 5

 | May 28, 2013 |  Posted In: Events and Announcements, Insight for DBAs, MySQL, Technical Webinars

Selecting the most appropriate solution for a MySQL HA infrastructure is as much a business and philosophical decision as it is a technical one, but often the choice is made without adequately considering all three perspectives.  When too much attention is paid to one of these aspects at the cost of the others, the resulting […]

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.