Tag - XtraDB Cluster

Different Types of MySQL Replication Solutions

MySQL Replication

In this blog post, I will review some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). I will also try to clarify some of the misconceptions people have about replication.
Since I’ve been working on the Solution Engineering team, I’ve noticed that – although information […]

Read more

Percona Software News and Roadmap Update with CEO Peter Zaitsev: Q1 2017

Percona Software News and Roadmap Update

This blog post is a summary of the webinar Percona Software News and Roadmap Update – Q1 2017 given by Peter Zaitsev on January 12, 2017.
Over the last few months, I’ve had the opportunity to meet and talk with many of Percona’s customers. I love these meetings, and I always get a bunch of questions […]

Read more

Percona XtraDB Cluster on Ceph

Ceph

This post discusses how XtraDB Cluster and Ceph are a good match, and how their combination allows for faster SST and a smaller disk footprint.
My last post was an introduction to Red Hat’s Ceph. As interesting and useful as it was, it wasn’t a practical example. Like most of the readers, I learn about […]

Read more

Galera warning “last inactive check”

Percona XtraDB Cluster Operator

In this post, we’ll discuss the Galera warning “last inactive check” and what it means.
Problem
I’ve been working with Percona XtraDB Cluster quite a bit recently, and have been investigating various warnings. I came across this one today:
[Warning] WSREP: last inactive check more than PT1.5S ago (PT1.51811S), skipping check
This warning is related to the evs.inactive_check_period […]

Read more

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

Percona XtraDB Cluster 5.6

The aim of this post is to enumerate real-world usage of Percona XtraDB Cluster (PXC), and also to solicit use cases from the readers. One of the prominent usages in the production environment that we have come across (and our Percona consultants have assisted) is that of HP Cloud. There is a post about […]

Read more

Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries

Accessing Percona XtraDB Cluster nodes in parallel with MySQL asynchronous calls
This post is followup to Peter’s recent post, “Investigating MySQL Replication Latency in Percona XtraDB Cluster,” in which a question was raised as to whether we can measure latency to all nodes at the same time. It is an interesting question: If we have N […]

Read more

Percona Toolkit version 2.1.6 released

The Percona Toolkit team is happy to announce the release of Percona Toolkit version 2.1.6. This is the sixth stable release in the 2.1 series, and primarily a bug-fix release; We suggest that users upgrade to the latest version of the tools.
The complete list of changes is on the Launchpad milestone for 2.1.6, but […]

Read more

Released: Percona Toolkit 2.1.5

Although Percona Toolkit 2.1.4 was recently released, we soon after found and fixed a couple of bugs concerning how pt-table-checksum works with Percona XtraDB Cluster:

pt-table-checksum 2.1.4 doesn’t detect diffs on Percona XtraDB Cluster nodes
pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes

There was also a bug affecting pt-table-sync –version-check, and the version check […]

Read more

Announcing Percona XtraBackup 2.0 Beta 1

Percona is glad to announce our first Beta release of what will become Percona XtraBackup 2.0. We’re releasing this beta to encourage testing of our upcoming 2.0 release of Percona XtraBackup.
Since this is a beta release, you should not rely on it for production workloads – use the stable 1.6 series of Percona XtraBackup […]

Read more