Thu, 11 Apr 2024 13:14:12 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/how-to-replicate-and-rename-a-database-in-mariadb/ https://www.percona.com/blog/how-to-replicate-and-rename-a-database-in-mariadb/#comments Thu, 11 Apr 2024 13:14:12 +0000 https://www.percona.com/blog/?p=95734 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 from […]]]> https://www.percona.com/blog/how-to-replicate-and-rename-a-database-in-mariadb/feed/ 1 95734 https://www.percona.com/blog/how-to-monitor-online-innodb-buffer-pool-resizing/ https://www.percona.com/blog/how-to-monitor-online-innodb-buffer-pool-resizing/#comments Wed, 20 Dec 2023 14:27:42 +0000 https://www.percona.com/blog/?p=92638 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 monitoring […]]]> https://www.percona.com/blog/how-to-monitor-online-innodb-buffer-pool-resizing/feed/ 1 92638 https://www.percona.com/blog/how-to-monitor-your-mysql-database-restore-progress/ https://www.percona.com/blog/how-to-monitor-your-mysql-database-restore-progress/#comments Wed, 02 Aug 2023 11:35:25 +0000 https://www.percona.com/blog/?p=89602 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 the […]]]> https://www.percona.com/blog/how-to-monitor-your-mysql-database-restore-progress/feed/ 3 89602 https://www.percona.com/blog/tale-of-a-mysql-8-upgrade-and-implications-on-backup/ https://www.percona.com/blog/tale-of-a-mysql-8-upgrade-and-implications-on-backup/#comments Thu, 05 Jan 2023 13:02:48 +0000 https://www.percona.com/blog/?p=84476 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 replication […]]]> https://www.percona.com/blog/tale-of-a-mysql-8-upgrade-and-implications-on-backup/feed/ 1 84476 https://www.percona.com/blog/impact-of-ddl-operations-on-aurora-mysql-readers/ https://www.percona.com/blog/impact-of-ddl-operations-on-aurora-mysql-readers/#comments Wed, 28 Dec 2022 13:18:34 +0000 https://www.percona.com/blog/?p=84234 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 […]]]> https://www.percona.com/blog/impact-of-ddl-operations-on-aurora-mysql-readers/feed/ 4 84234