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 is...
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 was...
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 and...
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, we...
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 to easily...
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 have...
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, they...
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 Kamil...
by Marco Tusa | Jan 11, 2021 | Cloud, MySQL, Percona Software, ProxySQL
The aim of Percona Operator for MySQL based on Percona XtraDB Cluster is to be a special type of controller introduced to simplify complex deployments. The Operator extends the Kubernetes API with custom resources. The Operator solution is using Percona XtraDB Cluster...
by Marco Tusa | Jan 11, 2021 | Cloud, MySQL, Percona Software, ProxySQL
Percona Operator for MySQL based on Percona XtraDB Cluster comes with two different proxies, HAProxy and ProxySQL. While the initial version was based on ProxySQL, in time, Percona opted to set HAProxy as the default Proxy for the operator, without removing ProxySQL. ...
by Marco Tusa | Nov 30, 2020 | MySQL, Open Source, Percona Software, ProxySQL
How scheduler and script stand in supporting failover (Percona and Marco example) In part one of this series, I had illustrated how simple scenarios may fail or have problems when using Galera native support inside ProxySQL. In this post, I will repeat the same...
by Marco Tusa | Nov 30, 2020 | MySQL, Open Source, Percona Software, ProxySQL
How native ProxySQL stands in failover support (both v2.0.15 and v2.1.0) In recent times I have been designing several solutions focused on High Availability and Disaster Recovery. Some of them using Percona Server for MySQL with group replication, some using Percona...