There are plenty of ways to run ProxySQL in Kubernetes (K8S). For example, we can deploy sidecar containers on the application pods, or run a dedicated ProxySQL service with its own pods.
We are going to discuss the latter approach, which is more likely to be used when dealing with a large number of application […]
Percona is well known for its offer of several outstanding fully open source, free-to-download software packages. And while Percona started as a MySQL-focused company, nowadays it covers different technologies such as MySQL, PostgreSQL, and MongoDB.
In its constant effort to make life easier for our users, Percona had moved from providing single software packages to […]
Starting with the release of proxysql-admin 2.0.15, the proxysql-admin 2.x series can now encrypt the credentials needed to access proxysql and cluster nodes. This only applies to the proxysql-admin configuration, this does not change the ProxySQL config, so those credentials are still unencrypted.
The credentials file is the unencrypted file containing the usernames, passwords, hostnames, […]
There are several ways to deploy ProxySQL between your applications and the database servers. A common approach is to have a floating virtual IP (VIP) managed by keepalived as the application endpoint. The proxies have to be strategically provisioned to improve the resiliency of the solution (different hardware, network segments, etc,).
When we consider cloud […]
The aim of Percona Kubernetes Operator for Percona XtraDB Cluster is to be a special type of controller introduced to simplify complex deployments. The Operator extends the Kubernetes API with custom resources. The Operator solution is using Percona XtraDB Cluster (PXC) behind the hood to provide a highly available, resilient, and scalable MySQL service […]
Read more