Tag: ProxySQL

Feed: Planet MySQL; Author: ProxySQL; Aurora cluster promises a high availability solution and seamless failover procedure. However, how much is actually the downtime when a failover happens? And how proxySQL can help in minimizing the downtime ? A little sneak peek on the results ProxySQL achieves up to 25x less downtime and the impressive up to ~9800x less errors during unplanned failovers. How proxySQL achieves this:  Less downtime “Queueing” feature when an instance in a hostgroup becomes unavailable. So what is ProxySQL? ProxySQL is a middle layer between the database and the application. ProxySQL protects databases from high traffic spikes, ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; ProxySQL 2.3.0 was recently released and when I was reading the release notes, I was really impressed with the Group Replication enhancements and features. I thought of experimenting with those things and was interested to write a blog about them. Here, I have focused on the following two topics: When the replication lag threshold is reached, ProxySQL will move the server to SHUNNED state, instead of moving them to OFFLINE hostgroup. When shunning a server, it will be performed gracefully and not immediately drop all backend connections. The servers can be taken to ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; 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 pods. Remember each ProxySQL instance runs a number of checks against the database backends. These checks monitor things like server-status and replication lag. Having too many proxies can cause significant overhead. Creating a Cluster For the purpose of ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; 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, and ports needed to connect to ProxySQL and PXC (Percona XtraDB Cluster). The proxysql-login-file tool is used to encrypt the credentials file. This encrypted file is known as a login-file. This login-file can then be used by the ... Read More

Feed: Planet MySQL; Author: ProxySQL; We are proud to announce the latest release of ProxySQL version 2.2.0ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL is freely usable and accessible according to the GNU GPL v3.0 license. Release Overview Highlights ProxySQL v2.2.0 is a minor release comprising of backward compatible changes, enhancements and bug fixes. Going forward ProxySQL will be using the common versioning standard “Major.Minor.Patch” and so this is ... Read More

Feed: Planet MySQL; Author: ProxySQL; We are proud to announce the latest release of ProxySQL version 2.1.1 on the 21st of April 2021ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL is freely usable and accessible according to the GNU GPL v3.0 license. Release Overview Highlights ProxySQL v2.1.1 is a patch release comprising of minor backward compatible changes and bug fixes. This release is the first patch release of the ... Read More

Feed: Planet MySQL; Author: ProxySQL; We are proud to announce the latest release of ProxySQL version 2.0.18 on the 8th of April 2021ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL is freely usable and accessible according to the GNU GPL v3.0 license. Release Overview Highlights ProxySQL v2.0.18 is a patch release comprising of minor backward compatible changes and bug fixes. Note: ProxySQL v2.1.0 remains the latest stable GA release ... Read More

Feed: Planet MySQL; Author: Severalnines; Hybrid environments, where a part of the database infrastructure is located on-prem and some of it is located in a public cloud are not uncommon. There may be different reasons to use such setup - scalability, flexibility, high availability, disaster recovery. How to implement this setup in a proper way? This might be challenging as you have to consider several pieces of a puzzle that have to fit together. This blog is intended to give you some insights into how such a setup may look like. Connectivity We are not going into details here because ... Read More

Feed: Planet MySQL; Author: ProxySQL; ProxySQL is proud to announce the latest release of ProxySQL version 2.0.17 on the 8th of February 2021ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here or alternatively from the ProxySQL Repository, or the Docker image available on our Official ProxySQL Docker Repository.  ProxySQL is freely usable and accessible according to the GNU GPL v3.0 license. Release Overview Highlights ProxySQL v2.0.17 is a patch release comprising of minor backward compatible changes and bug fixes. Be sure to try out the new ProxySQL 2.0.17 ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; 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 environments, spreading instances across many availability zones (AZ) is considered a best practice, but that presents a problem regarding VIP handling. Per definition, VPC subnets have to be created in a specific AZ, and subnet IP ranges can’t ... Read More