Tag - pxc

MySQL Group Replication – Partial Network Failure Performance Impact

mysql group replication

In this two-part blog series, I wanted to cover some failover scenarios with Group Replication. In part one, I will discuss an interesting behavior and performance degradation I discovered while writing these posts. In part two, I will show several failover scenarios and demonstrate how Group Replication handles each situation.
The test environment is very […]

Read more

Help Drive the Future of Percona XtraDB Cluster

Percona XtraDB Cluster

Percona is happy to announce the experimental release of Percona XtraDB Cluster 8.0. This is a major step for tuning Percona XtraDB Cluster to be more cloud- and user-friendly. This is the second experimental release that combines the updated and feature-rich Galera 4, with substantial improvements made by our development team.
Improvements and New Features […]

Read more

Deploying the Percona Kubernetes Operator for XtraDB Cluster in Amazon (AWS)

Percona Kubernetes Operator for Percona XtraDB Cluster in AWS

Being that Amazon is one of the most-used cloud vendors, it is only natural that one may ask “How can Kubernetes be used in AWS?“. And the answer is – not that different than with other cloud vendors. What one needs is two things (and this applies universally): a Kubernetes cluster + the Percona […]

Read more

Percona XtraDB Cluster 8.0 (experimental release) : SST Improvements

xtradb sst improvements

Starting with the experimental release of Percona XtraDB Cluster 8.0, we have made changes to the SST process to make the process more robust and easier to use.

mysqldump and rsync are no longer supported SST methods.
Support for mysqldump was deprecated starting with PXC 5.7 and has now been completely removed.
MySQL 8.0 introduced a new […]

Read more

Percona XtraDB Cluster 8.0 New Feature: wsrep_sst_auth Removal

Experimental Binary XtraDB 8.0

The problem
In PXC 5.6 and 5.7, when using xtrabackup-v2 as the SST method, the DBA must create a user with the appropriate privileges for use by Percona XtraBackup (PXB). The username and password of this backup user are specified in the wsrep_sst_auth variable.
This is a problem because this username and password was being stored […]

Read more