Jan 08, 2025 |
Insight for DBAs, Monitoring, MySQL, Percona Software
This article will be helpful if you use the Percona Monitoring and Management (PMM) instance and alert notifications, as it is nice to capture the image of the graph when you receive the alert. We will see how to capture and attach the image of the graph when receiving the alert notification (email, telegram, Slack, […]
Mar 18, 2024 |
MySQL, Percona Software, Security
Percona XtraBackup (PXB) version 8.0.28 supports taking backups for the encrypted tables in your MySQL database using the AWS Key Management Service. For setting up data-at-rest encryption using AWS key management service, please see Configuring Keyring for Encryption Using AWS Key Management Service in Percona Server for MySQL. In this blog post, we will discuss […]
Jan 05, 2024 |
Cloud, MySQL, Security
The AWS KMS component is now available in Percona Server for MySQL starting from version 8.0.30. This addition enables data-at-rest encryption by utilizing the AWS KMS component, providing the functionality to create and manage cryptographic keys across AWS services. How do we set up encryption using AWS KMS? You should only load a keyring component […]
Jan 23, 2023 |
Insight for DBAs, MySQL, Percona Software
We had a couple of cases where clients reported that the MySQL error log was flooded with the below note:
|
2023-01-18T13:07:56.946323Z 2 [Note] InnoDB: Stopping purge 2023-01-18T13:07:56.948621Z 2 [Note] InnoDB: Resuming purge 2023-01-18T13:08:27.229703Z 2 [Note] InnoDB: Stopping purge 2023-01-18T13:08:27.231552Z 2 [Note] InnoDB: Resuming purge 2023-01-18T13:08:28.581674Z 2 [Note] InnoDB: Stopping purge |
One of my colleagues Sami Ahlroos found that whenever we trigger a truncate on any table, the function is stopping the purge and then resuming it once it has found it stopped. Below are […]
Dec 05, 2022 |
MySQL, ProxySQL
ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. It is a proven tool and is used largely in production. There can be an instance of ProxySQL using a lot of memory on the server. This post is related to one of […]