High-availability

Updating Percona XtraDB Cluster from 5.6.24-72.2 to 5.6.32-25.17

wsrep-stages

This blog describes how to upgrade Percona XtraDB Cluster in place from 5.6.24-72.2 to 5.6.32-25.17.
This very hands-on blog is the result of some questions such as “can I perform an in-place upgrade for Percona XtraDB Cluster” coming in. We have done these minor upgrades for Percona Managed Services customers running Percona XtraDB Cluster with lots […]

Read more

Orchestrator: Moving VIPs During Failover

autotokubackup

In this post, I’ll discuss how to moving VIPs during a failover using Orchestrator.
In our previous post, we showed you how Orchestrator works. In this post, I am going to give you a proof-of-concept on how Orchestrator can move VIPs in case of failover. For this post, I’m assuming the Orchestrator is already installed and […]

Read more

Take Percona’s One-Click 2017 Top Database Concerns Poll

2017 top database concerns

Take Percona’s One-Click 2017 Top Database Concerns Poll.
With 2017 coming quick around the corner, it’s time to start thinking about what next year is going to bring to the open source database community. We just finished Percona Live Europe 2017, and at the conference we looked at new technologies, new techniques, and new ideas. […]

Read more

High Availability at Percona Live Europe 2016

This blog will review some of the high availability topics featured at this year’s Percona Live Europe, Amsterdam conference.
The topic of high availability MySQL is always hot, because beyond just being available, you also want efficient database manageability. I’m sure you’ve all seen the video by Frederic Descamps talking about the launch of […]

Read more

ProxySQL and Percona XtraDB Cluster (Galera) Integration

In this post, we’ll discuss how an integrated ProxySQL and Percona XtraDB Cluster (Galera) helps manage node states and failovers.
ProxySQL is designed to not perform any specialized operation in relation to the servers with which it communicates. Instead, it uses an event scheduler to extend functionalities and cover any special needs.
Given that specialized products like […]

Read more

ProxySQL and MHA Integration

MHA

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 is […]

Read more

MHA Quick Start Guide

MHA

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 […]

Read more

High Availability Poll Results

high availability poll

This blog reports the results of Percona’s high availability poll.
High availability (HA) is always a hot topic. The reality is that if your data is not available, your customers cannot do business with you. In fact, estimates show the average cost of downtime is about $5K per minute. With an average outage taking 40 […]

Read more

Using Ceph with MySQL

Ceph

Over the last year, the Ceph world drew me in. Partly because of my taste for distributed systems, but also because I think Ceph represents a great opportunity for MySQL specifically and databases in general. The shift from local storage to distributed storage is similar to the shift from bare disks host configuration to […]

Read more

Webinar Thursday June 23: Choosing a MySQL High Availability Solution Today

GTID Replication

Please join Percona, Technical Account Manager, Michael Patrick on Thursday, June 23, 2016 at 10 AM PDT (UTC-7) as he presents “Choosing a MySQL High Availability Solution Today.”
High availability (HA) is one of the solutions to improve performance, avoid data outages, and recover quickly from disasters. An HA environment helps guarantee that your database doesn’t […]

Read more