by Marco Tusa | Feb 6, 2024 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
To be honest, the comparison between the two MySQL distributions is not something that excited me a lot. Mainly because from my MySQL memories, I knew that there is not a real difference between the two distributions when talking about the code base.To my knowledge... by Marco Tusa | Jan 11, 2024 | Benchmarks, MySQL, Percona Software, ProxySQL
In my previous article, Comparisons of Proxies for MySQL, I showed how MySQL Router was the lesser performing Proxy in the comparison. From that time to now, we had several MySQL releases and, of course, also some new MySQL Router ones.Most importantly, we also had... by Marco Tusa | May 15, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
Historically MySQL is great in horizontal READ scale. The scaling, in that case, is offered by the different number of Replica nodes, no matter if using standard asynchronous replication or synchronous replication.However, those solutions do not offer the same level... by Marco Tusa | Mar 20, 2023 | Benchmarks, Cloud, MySQL, ProxySQL
With a special focus on Percona Operator for MySQL Overview HAProxy, ProxySQL, MySQL Router (AKA MySQL Proxy); in the last few years, I had to answer multiple times on what proxy to use and in what scenario. When designing an architecture, many components need to be... by Marco Tusa | Jan 20, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
How can we fix a nasty out-of-space issue leveraging the flexibility of Percona Operator for MySQL?When planning a database deployment, one of the most challenging factors to consider is the amount of space we need to dedicate to data on disk.This is even more... by Marco Tusa | Nov 23, 2022 | Insight for DBAs, MySQL, Security
What is dual password in MYSQL and how it works was already covered by my colleague Brian Sumpter in Using MySQL 8 Dual Passwords.However, let me do a brief recap here about it.Dual password is the MySQL mechanism that allows you to keep two passwords active at the... by Marco Tusa | Nov 10, 2022 | MySQL, Percona Software, ProxySQL, Security
Every day we use dozens if not hundreds of applications connecting to some kind of data repository. This simple step is normally executed over the network and, given so, it is subject to possible sniffing with all the possible related consequences.Given that, it... by Marco Tusa | Apr 22, 2022 | Cloud, Insight for DBAs, MySQL, Percona Software
In the last quarter of 2021, AWS released Aurora version 3. This new version aligns Aurora with the latest MySQL 8 version, porting many of the advantages MySQL 8 has over previous versions.While this brings a lot of new interesting features for Aurora, what we are... by Marco Tusa | Apr 12, 2022 | Cloud, MySQL, Percona Software
Last month I performed a review of the Percona Operator for MySQL Server which is still Alpha. That operator is based on Percona Server for MySQL and uses standard asynchronous replication, with the option to activate semi-synchronous replication to gain higher... by Marco Tusa | Jan 11, 2022 | MySQL, Percona Software
In April 2021, I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented. Anyhow, in that article I have shown how an online DDL... by Marco Tusa | Dec 9, 2021 | Insight for DBAs, MySQL, Percona Software
Percona XtraDB Cluster 8.0.25 (PXC) has introduced a new option to perform online schema modifications: NBO (Non-Blocking Operation).When using PXC, the cluster relies on the wsrep_OSU_method parameter to define the Online Schema Upgrade (OSU) method the node uses to... by Marco Tusa | Nov 9, 2021 | Insight for DBAs, Insight for Developers, MySQL
Well, let me say if that happens it’s because there is a logic mistake in your application. But you need to know and understand what happens in MySQL to be able to avoid the problem. In short, the WHY of this article is to inform you about possible pitfalls... by Marco Tusa | Jun 23, 2021 | Cloud, Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is well known for its offer of several outstanding fully open source, free-to-download software packages. And while Percona started as a MySQL-focused company, nowadays it covers different technologies such as MySQL, PostgreSQL, and MongoDB.In its constant... by Marco Tusa | Jun 15, 2021 | Insight for DBAs, MySQL, Security
When organizing things helps to simplify life.In the previous article, we start to explore dynamic privileges and the interaction with static ones. We also saw how to remove SUPER privilege from a DBA account. What we did was go by subtraction. But in real life,... by Marco Tusa | Jun 15, 2021 | Insight for DBAs, MySQL, Open Source
When trying to make things better, make it very complicated.I was working on a Security Threat Tool script when I had to learn more about the interaction between static and dynamic privileges in MySQL 8.Dynamic privileges is a “new” thing added in MySQL 8... by Marco Tusa | May 4, 2021 | Insight for DBAs, MySQL, Percona Software
AKA Cluster Error Voting… What is Cluster Error Voting (CEV)? “Cluster Error Voting is a new feature implemented by Alexey Yurchenko, and it is a protocol for nodes to decide how the cluster will react to problems in replication. When one or several nodes... by Marco Tusa | Apr 15, 2021 | Insight for DBAs, MySQL, Percona Software
While I was working on my grFailOver POC, I have also done some additional parallel testing. One of them was to see how online DDL is executed inside a Group Replication cluster.The online DDL feature provides support for instant and in-place table alterations and... by Marco Tusa | Apr 14, 2021 | Insight for DBAs, MySQL, Open Source, Percona Software
Where x is >= 22 😉 The Problem There are few things your data does not like. One is water and another is fire. Well, guess what:If you think that everything will be fine after all, take a look:Given my ISP had part of its management infrastructure on OVH,... by Marco Tusa | Apr 14, 2021 | Insight for DBAs, MySQL, Open Source, Percona Software
This blog provides high availability (HA) guidelines using group replication architecture and deployment recommendations in MySQL, based on our best practices.Every architecture and deployment depends on the customer requirements and application demands for high... by Marco Tusa | Jan 20, 2021 | Insight for DBAs, Insight for Developers, MySQL
As many of you have seen already, MySQL 8.0.23 is available for download (release notes).Today our dear LeFred thanked all the numerous contributors to bug fixes. About this: let me mention our two people involved in bug fixing, Venkatesh Prasad Venugopal and...