Apr 11, 2024 |
Insight for DBAs, MariaDB, MySQL
MySQL/MariaDB replication filter is an important feature when we need to replicate only certain databases or tables. Having this configuration option change dynamically is really convenient, but in this article, we’ll note that some replication filters are not dynamic, and you should be aware of that. The use case here is to replicate one database […]
Dec 20, 2023 |
Insight for DBAs, MySQL
The InnoDB buffer pool acts as a powerhouse for MySQL, caching frequently accessed data and index pages in memory to accelerate query performance. In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to monitor its progress and how to monitor it. Importance of […]
Aug 02, 2023 |
Insight for DBAs, Monitoring, MySQL
Restoring a MySQL database backup is a crucial task that can sometimes be time-consuming, especially for large databases. Monitoring the progress of the restore process is essential to estimate completion time and ensure everything is proceeding smoothly. In this blog post, we will explore two distinct and effective methods to calculate the percentage progress of […]
Jan 05, 2023 |
Insight for DBAs, MySQL, Percona Software
Recently, we performed a database engine major version upgrade in one of our customers’ environments from MySQL 5.7.26 to 8.0.27. After this version upgrade, we experienced issues with backups and replication for one of the nodes. In this article, I will explain these issues in detail and recommend a way to take backups from a […]
Dec 28, 2022 |
Cloud, Insight for DBAs, MySQL
Recently I came across an interesting investigation about long-running transactions getting killed on an Aurora Reader instance. In this article, I will explain why it is advisable to avoid long-running transactions on Aurora readers when executing frequent DDL operations on the Writer, or at least be aware of how a DDL can impact your Aurora […]