Tag - Percona XtraDB Cluster

ProxySQL 1.4.16 and Updated proxysql-admin Tool Now Available

ProxySQL 1.14.16

ProxySQL 1.4.16, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool.
ProxySQL is a high-performance proxy, currently for MySQL,  and database servers in the MySQL ecosystem (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the […]

Read more

ProxySQL 2.0.7 and proxysql-admin Tool Now Available

ProxySQL

ProxySQL 2.0.7, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues.
This release includesPSQLADM-204: Add support of MariaDB 10.4

Improvements

PSQLADM-157: In some cases, the proxysql-status script used the cat command to display a file without […]

Read more

Achieving Disaster Recovery with Percona XtraDB Cluster

Disaster Recovery with Percona XtraDB Cluster

One thing that comes up often from working with a variety of clients at Percona is “How can I achieve a Disaster Recovery (DR) solution with Percona XtraDB Cluster (PXC)?”  Unfortunately, decisions are sometimes made with far-reaching consequences by individuals who often do not well understand the architecture and its limitations.  As a Technical […]

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