by Alexey Zhebel | Apr 19, 2017 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.35-26.20-3 on April 13, 2017. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.35-26.20-3 is now the current release, based on the following: Percona...
by Alexey Zhebel | Apr 19, 2017 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.17-29.20 on April 19, 2017. Binaries are available from the downloads section or our software repositories. NOTE: You can also run Docker containers from the images in the Docker Hub repository. Percona...
by Tibor Korocz | Apr 12, 2017 | Insight for DBAs, MySQL
In this post, I am going to show you how you can minimize the performance impact of ProxySQL rules by using some finesse. Apply Test In my previous post, we could see the effect of the rules on ProxySQL performance. As we could also see, the “apply” option...
by Tibor Korocz | Apr 10, 2017 | Benchmarks, MySQL, ProxySQL
In this blog post we are going to take a closer look at ProxySQL rules. How do they work, and how big is the performance impact of having many rules? I would like to say thank you to Renè, who was willing to answer all my questions during my tests. Overview ProxySQL...
by Dave Avery | Feb 3, 2017 | MySQL
Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your...
by Ramesh Sivaraman | Jan 25, 2017 | Percona Software, ProxySQL
ProxySQL Admin (proxysql-admin) is a powerful tool for configuring Percona XtraDB Cluster nodes into ProxySQL. The proxysql-admin tool comes with the ProxySQL package from Percona apt/yum repositories. ProxySQL 1.3.2-1 is now available from the Percona repositories....
by Marco Tusa | Jan 19, 2017 | Insight for DBAs, MySQL, ProxySQL
In this blog post, we’ll look at how to set up ProxySQL for high availability. During the last few months, we’ve had a lot of opportunities to present and discuss a very powerful tool that will become more and more used in the architectures supporting...
by Alexey Zhebel | Dec 15, 2016 | MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.16-27.19 on December 15, 2016. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.7.16-27.19 is now the current release, based on the following: Percona...
by Tibor Korocz | Nov 9, 2016 | Insight for DBAs, MySQL, ProxySQL
In this blog post, I am going to show you how can you use Orchestrator and ProxySQL together. In my previous blog post, I showed how to use bash scripts and move virtual IPs with Orchestrator. As in that post, I assume you already have Orchestrator working. If not,...
by Federico Razzoli | Oct 10, 2016 | MySQL, Percona Software
In this blog post, I’ll provide my thoughts about Consul for ProxySQL service discovery and automation. I approached Consul recently while looking for a service discovery and configuration automation solution for ProxySQL. My colleague Nik Vyzas wrote a...
by Nik Vyzas | Sep 16, 2016 | MySQL
When it comes to “decision time” about which type of MySQL HA (high-availability) solution to implement, and how to architect the solution, many questions come to mind. The most important questions are: “What are the best tools to provide HA and Load...
by Marco Tusa | Sep 15, 2016 | Insight for DBAs, MySQL, Percona Software, ProxySQL
In this post, we’ll discuss how an integrated ProxySQL and Percona XtraDB Cluster (Galera) helps manage node states and failovers. ProxySQL is designed to not perform any specialized operation in relation to the servers with which it communicates. Instead, it...
by Marco Tusa | Sep 13, 2016 | Insight for DBAs, MySQL, ProxySQL
This blog post discusses ProxySQL and MHA integration, and how they work together. MHA (Master High Availability Manager and tools for MySQL) is almost fully integrated with the ProxySQL process. This means you can count on the MHA standard feature to manage failover,...
by Marco Tusa | Aug 30, 2016 | MySQL
This article demonstrates how MySQL sharding with ProxySQL works. Recently a colleague of mine asked me to provide a simple example on how ProxySQL performs sharding. In response, I’m writing this short tutorial in the hope it will illustrate ProxySQL’s...
by Marco Tusa | Aug 23, 2016 | MySQL, ProxySQL
This blog discusses how to find and address badly written queries using ProxySQL. All of us are very good in writing good queries. We know this to always be true! 😉 But sometimes a bad query escapes our control and hits our database. There is the new guy, the probie,...
by Vadim Tkachenko | Jun 16, 2016 | MySQL
How do you scale Percona XtraDB Cluster with ProxySQL in Kubernetes? In my previous post I looked how to run Percona XtraDB Cluster in a Docker Swarm orchestration system, and today I want to review how can we do it in the more advanced Kubernetes environment. There...
by Vadim Tkachenko | May 12, 2016 | MySQL
In this blog post, we’ll discuss ProxySQL versus MaxScale for OLTP RO workloads. Continuing my series of READ-ONLY benchmarks (you can find the other posts here and here), in this post I want to see how much overhead a proxy adds. At this In my opinion, there...
