by Mike Benshoof | Jun 14, 2021 | MySQL, Percona Software
The practice of running databases in containers continues to grow in popularity. As a Technical Account Manager at Percona, I get asked regularly about our Percona Distribution for MySQL Operator. Additionally, I’m asked what I’m seeing in the industry in terms of...
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 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 Denys Kondratenko | May 19, 2021 | MongoDB, Monitoring, MySQL, Percona Software
Database-as-a-Service (DBaaS) is a managed database that doesn’t need to be installed and maintained but is instead provided as a service to the user. The Percona Monitoring and Management (PMM) DBaaS component allows users to CRUD (Create, Read, Update, Delete)...
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 David Quilty | May 7, 2021 | Cloud, Insight for DBAs, Webinars
Considering a move to the cloud, but unsure which provider is right for you? According to the results of our 2020 Open Source Data Management Software Survey, AWS continues to dominate the public cloud provider market, with 50% of respondents using its cloud platform...
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 Rachel Pescador | Apr 29, 2021 | Percona Events, Percona Live
The latest schedule for Percona Live ONLINE 2021, taking place on May 12-13, allows you to filter by track to identify the sessions that interest you most! The conference takes place May 12-13 and features more than 150 expert speakers and over 160 hours of content...
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,...
