ProxySQL

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

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

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