by Brijesh Chauhan | 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... by Brijesh Chauhan | 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... by Brijesh Chauhan | Aug 2, 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... by Brijesh Chauhan | Jan 5, 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... by Brijesh Chauhan | 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...