ProxySQL

How to Use ProxySQL 2 on Percona XtraDB Cluster for Failover

xtradbcluster

If you are thinking of using ProxySQL in our Percona XtraDB Cluster environment, I’ll explain how to use ProxySQL 2 for failover tasks.
How to Test
ProxySQL uses the “weight” column to define who is the WRITER node. For this example, I’ll use the following list of hostnames and IPs for references:

Shell

+———–+—————-+
| node_name | ip […]

Read more

Using pt-heartbeat with ProxySQL

Using pt-heartbeat with ProxySQL

ProxySQL and Orchestrator are usually installed to achieve high availability when using MySQL replication. On a failover (or graceful takeover) scenario, Orchestrator will promote a slave, and ProxySQL will redirect the traffic. Depending on how your environment is configured, and how long the promotion takes, you could end up in a scenario where you […]

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

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

Experimental Binary of Percona XtraDB Cluster 8.0

Experimental Binary XtraDB 8.0

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

Read more