by Yura Sorokin | Aug 10, 2022 | Insight for DBAs, MySQL, Percona Software, Storage Engine
In Percona Server for MySQL 8.0.29-21, we added one more patch that helps us to build server code on macOS. To be precise here, we still could do this even before this patch but only partially. Now it is possible to build RocksDB Storage Engine as well. A word of...
by Vinicius Grippa | Aug 10, 2022 | Insight for DBAs, MySQL
This blog post will discuss the newest feature available in MySQL 8.0.30: dynamic redo log sizing. After the InnoDB buffer pool size, we can say that having a proper size for the redo logs is crucial for MySQL performance. There are numerous blog posts about how to...
by Chetan Shivashankar | Aug 3, 2022 | Cloud, MySQL, Percona Software
In part one and part two of this series, we introduced the different ways to manage MySQL configurations and precedence when using the Percona XtraDB Cluster (PXC) object and ConfigMap. In this post, we will see the precedence when secrets are used for MySQL...
by Chetan Shivashankar | Aug 1, 2022 | Cloud, MySQL, Percona Software
In part one of this series, we introduced the different ways to manage MySQL configurations. In this post, we will walk through different possibilities and the changes happening while modifying MySQL configurations with the operator. Percona Distribution for MySQL...
by Sveta Smirnova | Jul 29, 2022 | Benchmarks, Insight for DBAs, MySQL, Percona Software
In this blog, I will cover important aspects which you need to test when benchmarking replication setup. MySQL has great tools that could be used to test its performance. They include: sysbench – https://github.com/akopytov/sysbench BMK-kit –...
by David Stokes | Jul 27, 2022 | Insight for DBAs, MySQL
MySQL 8.0 is now over four years old and Oracle released the latest quarterly offering today with MySQL 8.0.30, which comes with lots of bug fixes and some interesting additions. This is my take on the release notes for those who do not have the time to wade through...
by Chetan Shivashankar | Jul 25, 2022 | Cloud, MySQL, Percona Software
Introduction/FAQ Question: I need to run a production-grade open source MySQL DB. Answer: Percona to the rescue! Percona XtraDB Cluster (PXC) is an open source enterprise MySQL solution that helps you to ensure data availability for your applications while improving...
by Fernando Laudares Camargos | Jul 21, 2022 | Insight for DBAs, MySQL, Percona Software
When we run a SELECT in a replica server and it returns a different result to the one we would have obtained had we queried the source server instead, due to changes in the dataset that have not yet been replicated or synchronized to the replica, we get what is known...
by Sveta Smirnova | Jul 21, 2022 | Insight for DBAs, MySQL
In this blog, I explain how to recover from a replication failure caused by a corrupted relay log file. MySQL replica stores data received from its source binary log in the relay log file. This file could be corrupted due to various reasons, mostly hardware failures....
by Marcelo Altmann | Jul 19, 2022 | Insight for DBAs, MySQL, Percona Software
Oracle’s MySQL 8.0.29 release extended the support for ALTER TABLE … ALGORITHM=INSTANT to 1) allow users to instantly add columns in any position of the table, and 2) instantly drop columns. As part of this work, the InnoDB redo log format has changed for all DML...
by Peter Zaitsev | Jul 14, 2022 | Cloud, Insight for DBAs, MySQL, Percona Software
In this blog post, I will show how to install the MySQL-compatible Percona XtraDB Cluster (PXC) Operator on Minikube as well as perform some basic actions. I am by no means a Kubernetes expert and this blog post is the result of my explorations preparing for a local...
by Sveta Smirnova | Jul 13, 2022 | Monitoring, MySQL, Percona Software
In this blog, I will demonstrate how to use Percona Monitoring and Management (PMM) to find out the reason why the MySQL server is stalling. I will use only one typical situation for the MySQL server stall in this example, but the same dashboards, graphs, and...
by Yves Trudeau | Jul 13, 2022 | Insight for DBAs, MySQL
As a principal architect at Percona, one of my duties is to tune MySQL database servers for our customers. The tuning effort looks at every aspect of the database service like the operating system, the MySQL configuration, the schema, the queries, etc. We have...
by Sergey Pronin | Jul 11, 2022 | Cloud, MySQL, Open Source, Percona Software
There are two Operators at Percona to deploy MySQL on Kubernetes: one is based on Percona XtraDB Cluster (PXC), production-ready and widely adopted another is based on Percona Server for MySQL, now in tech preview and not recommended for production yet We wrote a blog...
by Fernando Mattera | Jul 8, 2022 | Insight for DBAs, MySQL, Percona Software
Hello folks, we all know the benefits of table compression in MySQL, with current technology, processing speed, and compression disks, and in most cases, it is a benefit. Now, what happens when that doesn’t happen? In this simple blog, I’m going to show...
by Zsolt Parragi | Jul 6, 2022 | Cloud, MySQL, Percona Software
Percona Server for MySQL 8.0.28-20 introduces a new keyring component, component_keyring_kms, which allows using the AWS Key Management Service as a keyring. The component is also included in Percona XtraBackup 8.0.28, allowing backing up databases encrypted with this...
by Zsolt Parragi | Jul 5, 2022 | Insight for DBAs, MySQL, Percona Software
The MySQL error log is usually used to store and later analyze error and warning messages, but in some cases, it is also used for high throughput debug messages for analyzing complex issues. These messages take up more space, slow down the server, and also make the...
by Yura Sorokin | Jun 30, 2022 | Insight for DBAs, MySQL, Percona Software, Security
Imagine you need to design an online system for storing documents on a per-user basis where nobody, including database administrators, would be able to change the content of those documents without being noticed by document owners. In Percona Server for MySQL...
by Aaditya Dubey | Jun 24, 2022 | Insight for DBAs, Insight for Developers, Percona Software
Here at Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open source...
by David Ducos | Jun 3, 2022 | Insight for DBAs, MySQL
As you might know, mysqldump is single-threaded and STDOUT is its default output. As MyDumper is multithreaded, it has to write on different files. Since version 0.11.3 was released in Nov 2021, we have the possibility to stream our backup in MyDumper. We thought for...
