Author - Marco Tusa

MySQL 8 and The FRM Drop… How To Recover Table DDL

MySQL 8 frm drop recover ddl

… or what I should keep in mind in case of disaster

To retrieve and maintain in SQL format the definition of all tables in a database, is a best practice that we all should adopt. To have that under version control is also another best practice to keep in mind.
While doing that may seem […]

Read more

How Not to do MySQL High Availability: Geographic Node Distribution with Galera-Based Replication Misuse

MySQL High Availability 2

Let’s talk about MySQL high availability (HA) and synchronous replication once more.
It’s part of a longer series on some high availability reference architecture solutions over geographically distributed areas.
Part 1: Reference Architecture(s) for High Availability Solutions in Geographic Distributed Scenarios: Why Should I Care?
Part 2: MySQL High Availability On-Premises: A Geographically Distributed Scenario
The Problem
A question I often […]

Read more

MySQL High Availability On-Premises: A Geographically Distributed Scenario

On-Premises MySQL High Availability

MySQL High Availability. Shutterstock.com
In this article, we’ll look at an example of an on-premises, geographically distributed MySQL high availability solution. It’s part of a longer series on some high availability reference architecture solutions over geographically distributed areas.
Part 1: Reference Architecture(s) for High Availability Solutions in Geographic Distributed Scenarios: Why Should I Care?
Percona consulting’s main aim is […]

Read more

Reference Architecture(s) for High Availability Solutions in Geographic Distributed Scenarios: Why Should I Care?

High Availability Solutions

High Availability Solutions. Shutterstock.com
In this series of blog posts, I’m going to look at some high availability reference architecture solutions over geographically distributed areas.
The Problem
Nowadays, when businesses plan a new service or application, it is very common for them to worry about ensuring a very high level of availability. 
It doesn’t matter if we […]

Read more

PXC loves firewalls (and System Admins loves iptables)

PXC and setting firewalls using iptables

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 […]

Read more

Leveraging ProxySQL with AWS Aurora to Improve Performance, Or How ProxySQL Out-performs Native Aurora Cluster Endpoints

ProxySQL with AWS Aurora

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 […]

Read more

How to Implement ProxySQL with AWS Aurora

ProxySQL 1.4.12

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 […]

Read more

ProxySQL Firewalling

ProxySQL Firewalling

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 […]

Read more

Group Replication: The Sweet and the Sour

Group Replication

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 […]

Read more