by Marco Tusa | Apr 3, 2018 | Cloud, Insight for DBAs, MySQL
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?... by Marco Tusa | Jan 15, 2018 | Monitoring, MySQL, ProxySQL, Security
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... by Marco Tusa | Aug 1, 2017 | Insight for DBAs, MySQL, Percona Software
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... by Marco Tusa | May 25, 2017 | Insight for DBAs, MySQL, Percona Software, ProxySQL
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... by Marco Tusa | Apr 10, 2017 | Insight for DBAs, MySQL, Percona Software
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... 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 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,... 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... 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... by Marco Tusa | May 26, 2016 | MySQL
Some time ago, I published the article on AWS Aurora Benchmarking (AWS Aurora Benchmarking – Blast or Splash?), in which I analyzed the behavior of different solutions using synchronous replication in AWS environment. This blog follows up with some of the...
