Tag - 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

Multiplexing (Mux) in ProxySQL: Use Case

Multiplexing (Mux) in ProxySQL

Multiplexing Background
Historically it’s a technique used in networking to integrate multiple analog and digital signals via a shared medium. The goal of multiplexing over the network was to enable signals to be transmitted more efficiently for a given communication channel, thus achieving cost efficiency. 
Since the term Multiplexing comes from telecommunications, the industry has heavily […]

Read more

ProxySQL 2.0.6 and proxysql-admin tool Now Available

ProxySQL

ProxySQL 2.0.6, 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 includesDocker images for release 2.0.6 are available as well. You can in the wiki format.
ProxySQL is available under Open Source license GPLv3.

Read more