by Vadim Tkachenko | Jun 10, 2021 | Insight for DBAs, MySQL, Percona Software
In the previous release of our Percona Distribution for MySQL Operator, we implemented one interesting feature, which can be seen as “self-healing”: https://jira.percona.com/browse/K8SPXC-564. I do not think it got enough attention, so I want to write more about this....
by David Ducos | Jun 8, 2021 | Insight for DBAs, MySQL
In my previous post Back From a Long Sleep, MyDumper Lives!, I told you that Fast Index Creation was in the queue and (after fixing several bugs) it will package in release 0.10.7 next month. But why am I so excited about it? Well, this feature opens new...
by Fernando Laudares Camargos | Jun 4, 2021 | Insight for DBAs, MySQL
The combination of the information obtained from the “pt-summaries” discussed in the previous posts of this series (Part 1: The Percona Support Way, Part 2: Knowing the Server, Part 3: What MySQL?) helps us come up with the first impression of a MySQL server. However,...
by Fernando Laudares Camargos | Jun 3, 2021 | Insight for DBAs, MySQL, Percona Software
In the previous post of this series, we looked at the hardware specifications and operating system settings of the host server through the lenses of a pt-summary report. Now that we know the foundation on which the database is running, we can turn our focus to MySQL...
by Fernando Laudares Camargos | Jun 2, 2021 | Insight for DBAs, Insight for Developers, MySQL
In part 1 of this series, we introduced you to the approach used by the Percona Support team to inspect MySQL servers, which is based on a triad of tools from the Percona Toolkit used to gather diagnostic information. In this article, we will be focusing on the first...
by Lenz Grimmer | Jun 1, 2021 | MySQL, Open Source, Percona Software
After Oracle released MySQL version 8.0.24 on April 20, 2021, our engineering team got started right away with merging our enhancements to prepare the corresponding 8.0.24 version of Percona Server for MySQL. However, Oracle released MySQL version 8.0.25 shortly...
by Fernando Laudares Camargos | Jun 1, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Services
When I joined the Percona Support team in early 2013, MySQL 5.6 was being launched. I remember all the buzz and euphoria surrounding its release: it was a big step from the 5.5 series, carrying important changes in the MySQL architecture and internals that brought...
by Yves Trudeau | May 27, 2021 | Insight for DBAs, MySQL, Storage Engine
Recently we had a debate in the consulting team about how InnoDB handles TEXT/BLOB columns. More specifically, the argument was around the Barracuda file format with dynamic rows. In the InnoDB official documentation, you can find this extract: When a table is created...
by Lenz Grimmer | May 21, 2021 | MySQL, Open Source, Percona Software, Storage Engine
Back in December 2018, when we announced the general availability of Percona Server for MySQL 8.0, we also announced that the TokuDB Storage Engine has been marked as “deprecated” in this release, recommending to use the MyRocks Storage Engine as an alternative. We...
by Sergey Pronin | May 20, 2021 | Cloud, MySQL, Open Source, Percona Software
Quite a common request that we receive from the community and customers is to provide a way to manage database users with Operators – both MongoDB and MySQL. Even though we see it as an interesting task, our Operators are mainly a tool to simplify the deployment...
by George O. Lorch III | May 20, 2021 | MySQL, Percona Software
Percona Server for MySQL 8.0.23-14 was released last week and I wanted to take a minute to call out some of the interesting new features that we have introduced in this release. These are included in addition to the features and improvements in MySQL 8.0.23 that were...
by Vadim Tkachenko | May 19, 2021 | MongoDB, MySQL, Percona Software
Our recent releases of Percona Operator for MySQL based on Percona XtraDB Cluster 1.8 and Percona Operator for MongoDB 1.7 come with a new interesting feature: Support of custom sidecars. What is special about this? There is often a need to customize the default...
by David Ducos | May 7, 2021 | Insight for DBAs, MySQL
The new MyDumper 0.10.5 version, which includes many new features and bug fixes, is now available. You can download the code from here. For this release, we focused on fixing some old issues and testing old pull requests to get higher quality code. On releases...
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 Yves Trudeau | May 4, 2021 | Insight for DBAs, MySQL, Storage Engine
There is a common pattern in life, you often discover or understand things by accident. Many scientific discoveries fit such a description. In our database world, I was looking to see how BLOB/TEXT columns are allocated using overlay pages and I stumbled upon...
by Vinicius Grippa | Apr 28, 2021 | Insight for DBAs, MySQL, Percona Software
This blog post will show how to compile the Percona XtraBackup (PXB) tool for ARM. For this, we are going to use an AWS EC2 ARM instance with Ubuntu 20.04(Focal Fossa). The motivation for this was born in my interest in the new generation of ARM processors and if this...
by Przemysław Malkowski | Apr 28, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Multi-writer replication has been a challenge in the MySQL ecosystem for years before truly dedicated solutions were introduced – first Galera (and so Percona XtradDB Cluster (PXC)) replication (around 2011), and then Group Replication (first GA in 2016). Now,...
by Francisco Bordenave | Apr 27, 2021 | Insight for DBAs, MySQL
DBAs are important cogs in the availability, performance, and security of your data. Getting a great DBA is one of the most important things any company can do to ensure their database operations continue working without a problem. So how do you find great DBAs? In...
by Fernando Laudares Camargos | Apr 23, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Apologies for the silly title, but the issue is a real one, even though it is not a new thing. Schema upgrades are not an ordinary operation in Galera. For the subject at hand, the bottom line is: under the default Total Order Isolation (TOI) method, “the cluster...
by David Ducos | Apr 21, 2021 | Insight for DBAs, MySQL, Open Source
MySQL databases keep getting larger and larger. And the larger the databases get, the harder it is to backup and restore them. MyDumper has changed the way that we perform logical backups to enable you to restore tables or objects from large databases. Over the years...
