MySQL Resource Groups, introduced in MySQL 8, provide the ability to manipulate the assignment of running threads to specific resources, thereby allowing the DBA to manage application priorities. Essentially, you can assign a thread to a specific virtual CPU. In this post, I’m going to take a look at how these might work in […]
Read more
Let them stay together.
In the last YEARS, I have seen quite often that users, when installing a product such as PXC, instead of spending five minutes to understand what to do just run
iptables -F and save.
In short, they remove any rules for their firewall.
With this post, I want to show you how easy […]
In this blog post, I’ll look at how you can use ProxySQL with AWS Aurora to further leverage database performance.
My previous article described how easy is to replace the native Aurora connector with ProxySQL. In this article, you will see WHY you should do that.
It is important to understand that aside from the basic […]
In this post, we’ll look at how to implement ProxySQL with AWS Aurora.
Recently, there have been a few discussions and customer requests that focused on AWS Aurora and how to make the various architectures and solutions more flexible.
Flexible how, you may ask? Well, there are the usual expectations:
How do you improve resource utilization?
How […]
In this blog post, we’ll look at ProxySQL firewalling (how to use ProxySQL as a firewall).
Not long ago we had an internal discussion about security, and how to enforce a stricter set of rules to prevent malicious acts and block other undesired queries. ProxySQL came up as a possible tool that could help us in […]
In this blog, we’ll look at group replication and how it deals with flow control (FC) and replication lag.
Overview
In the last few months, we had two main actors in the MySQL ecosystem: ProxySQL and Group-Replication (with the evolution to InnoDB Cluster).
While I have extensively covered the first, my last serious work on Group Replication […]
In this blog post, we’ll look at how ProxySQL and mirroring go together.
Overview
Let me be clear: I love ProxySQL, and I think it is a great component for expanding architecture flexibility and high availability. But not all that shines is gold! In this post, I want to correctly set some expectations, and avoid selling carbon […]
If you met one of the (few) MySQL consultants around the globe and asked him/her to review your queries and/or schemas, I am sure that he/she would tell you something regarding the importance of good primary key(s) design. Especially in the case of InnoDB, I’m sure they started to explain to you about index […]
Read more
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 MySQL: ProxySQL.
ProxySQL is becoming more flexible, solid, performant and used every […]
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 uses an event scheduler to extend functionalities and cover any special needs.
Given that specialized products like […]
