by Marcelo Altmann | Jan 20, 2022 | MySQL, Percona Software
Backups are a key part of a disaster recovery strategy, making sure you can continue or restore your business in case of an unwanted event with your data. We always work on trying to improve Percona XtraBackup reliability, always favoring consistency, attempting to...
by Carlos Tutte | Jan 18, 2022 | MySQL, Percona Software
The most common issue when using row-based replication (RBR) is replication lag due to the lack of Primary keys. The problem is that any replicated DML will do a full table scan for each modified row on the replica. This bug report explains it more in-depth:...
by Nik Krichko | Jan 17, 2022 | Benchmarks, Cloud, MySQL
Recently we published the first part (m5, m5a, m6g) and the second part (C5, C5a, C6g) of research regarding comparing Graviton ARM with AMD and Intel CPU on AWS. We selected general-purpose EC2 instances with the same configurations (amount of vCPU in the first...
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 Matt Yonkovit | Jan 5, 2022 | Database Trends, Insight for DBAs, Insight for Developers, MySQL
With modern application design, systems are becoming more diverse, varied and have more components than ever before. Developers are often forced to become master chefs adding the ingredients from dozens of different technologies and blending them together to create...
by Francisco Bordenave | Jan 5, 2022 | Insight for DBAs, MySQL
Recently we were asked to check the performance of the new family of AMD EPYC processors when using MySQL in Google Cloud Virtual Machines. This was motivated by a user running MySQL in the N1 machines family and willing to upgrade to N2D generation considering the...
by Mike Benshoof | Jan 4, 2022 | MySQL, Percona Software, Security
Security will always be a main focal point of a company’s data. A common question I get from clients is, “how do I enable encryption?” Like every good consulting answer, it depends on what you are trying to encrypt. This post is a high-level summary...
by Yves Trudeau | Jan 4, 2022 | Benchmarks, MySQL
Following my post MySQL/ZFS Performance Update, a few people have suggested I should take a look at BTRFS (“butter-FS”, “b-tree FS”) with MySQL. BTRFS is a filesystem with an architecture and a set of features that are similar to ZFS and with a...
by Sveta Smirnova | Dec 31, 2021 | MySQL, Percona Announcements
In Percona Support we spend a few hours per week doing Labs: short collective projects, not directly related to the tickets. One of our last labs was about to get ready for the winter holiday season which means preparing the tree and decorating it. To do it we used...
by Pep Pla | Dec 30, 2021 | MongoDB, Monitoring, MySQL, Percona Software
Percona Monitoring and Management 2 (PMM2) is the database monitoring suite assembled and developed by Percona. It is based on standard open source components and custom-made software integrations. PMM2 helps you reduce complexity, optimize performance, and improve...
by Sveta Smirnova | Dec 29, 2021 | Insight for Developers, MySQL, Webinars
First I want to thank everyone who attended my November 16, 2021 webinar “MySQL Performance for DevOps“. Recording and slides are available on the webinar page. Here are answers to the questions from participants which I was not able to provide during the webinar. Q:...
by Vinicius Grippa | Dec 27, 2021 | Insight for DBAs, MySQL, Percona Software
In this blog post, we will compare the performance of performing a backup from a MySQL database using mysqldump, MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. All these available options are open source and free to use for the...
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 Peter Boros | Dec 9, 2021 | Cloud, MySQL, Percona Software
We have a quickstart guide for how to install Percona Distribution for MySQL Operator on minikube. Installing the minimal version works well as it is described in the guide. After that, we will have one HAproxy and one Percona XtraDB Cluster (PXC) node to work with....
by David Ducos | Dec 3, 2021 | Insight for DBAs, MySQL
For a long time, MyDumper has been in Max Bubenick’s personal GitHub repository. Now, we decided to move to a new MyDumper’s Organization as requested earlier this year by a user from the community. There were also two other reasons why we decided to move it....
by Sveta Smirnova | Dec 2, 2021 | MySQL, Webinars
First, I want to thank everyone who attended my November 9, 2021 webinar “Introduction to MySQL Query Tuning for Dev[Op]s“. Recording and slides are available on our webinars page. Here are answers to the questions from participants which I was not able to provide...
by David Ducos | Dec 1, 2021 | Insight for DBAs, MySQL, Percona Software
Working on a real case scenario in a five node Percona XtraDB Cluster (PXC), we were forced to use wsrep_sync_wait = 1, because the app does reads-after-write and we send reads to all the nodes. We had the idea to leave some nodes in DESYNC mode to reduce the flow...
by David Ducos | Nov 29, 2021 | Insight for DBAs, MySQL
The new MyDumper 0.11.3 version, which includes many new features and bug fixes, is now available. You can download the code from here. We are very proud to announce that we were able to achieve the two main objectives for the milestone ZSTD and Stream support! We...
by Ivan Groenewold | Nov 24, 2021 | Cloud, Insight for DBAs, MySQL
A recommendation we often give to our customers is along the lines of “archive old data” to reduce your database size. There is a tradeoff between keeping all our data online and archiving part of it to cold storage. There could also be legal requirements...
by Przemysław Malkowski | Nov 22, 2021 | Insight for DBAs, MySQL, Storage Engine
If you ever had to deal with performance and/or disk space issues related to temporary tables, I bet you eventually found yourself puzzled. There are many possible scenarios depending on the type of temporary table, settings, and MySQL version used. We have observed a...
![Q&A on the Webinar “Introduction to MySQL Query Tuning for Dev[Op]s”](https://www.percona.com/blog/wp-content/uploads/2021/12/MySQL-Query-Tuning-for-DevOps-webinar.png)
