by Yunus Shaikh | 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...
by Sergey Pronin | Mar 11, 2024 | Cloud, MySQL, Percona Software
Volume Expansion, a feature that became generally available since Kubernetes version 1.24, allows users to increase the capacity of their Persistent Volumes and underlying storage within Kubernetes. There is no need to use clouds’ UI or APIs to do that anymore. In...
by Bartek Gatz | Mar 5, 2024 | MySQL, Percona Software
What makes a great user experience? There are probably as many answers to this question as there are users because we are talking about very subjective and personal feelings and observations. While there are multiple experts at Percona, we also believe that one should...
by Edith Puclla | Feb 22, 2024 | Cloud, MySQL, Percona Software
In our last post, we looked into the lifecycle of applications in Kubernetes. We see that Kubernetes doesn’t handle database backups itself. This is where Kubernetes Operators come into action. They add additional functions to Kubernetes, enabling it to set up,...
by Edith Puclla | Feb 20, 2024 | Cloud, MySQL, Percona Software
This post was originally published on the Percona Community blog. If you are in the world of application development, you know that every application has a lifecycle. An application lifecycle refers to the stages that our application goes through, from initial...
by Przemysław Malkowski | Feb 9, 2024 | Insight for DBAs, MySQL
Historically, MySQL does not require explicit primary key defined on tables, and it’s like that by default till this day (MySQL version 8.3.0). Such a requirement is imposed through two replication methods, though: Group Replication and Percona XtraDB Cluster...
by Marco Tusa | Feb 6, 2024 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
To be honest, the comparison between the two MySQL distributions is not something that excited me a lot. Mainly because from my MySQL memories, I knew that there is not a real difference between the two distributions when talking about the code base. To my knowledge...
by David Stokes | Feb 6, 2024 | Insight for DBAs, MySQL, Security
Are your MySQL users using ‘password’, ‘s3cr3t’, or ‘thebossisajerk’ as their passwords? Easy-to-guess passwords can be disastrous to the security of your data, but there is a way to exclude inappropriate words or phrases from being used. The first step is to compile...
by Ninad Shah | Feb 2, 2024 | Insight for DBAs, MySQL, PostgreSQL
This blog was originally published in June of 2023 and was updated in February of 2024. On occasion, DBAs come across segmentation fault issues while executing some queries. However, this is one of the least-explored topics to date. I tried to search for details...
by Peter Zaitsev | Feb 1, 2024 | MySQL, Open Source
FOSDEM is for sure one of the most respected free and open source software-focused conferences in Europe, which is loved by many, myself included. It is from the point of love I am raising concerns about transparency, which seems to be lacking in regard to some...
by David Stokes | Feb 1, 2024 | Database Trends, Insight for DBAs, MySQL, PostgreSQL
This blog was originally published in June of 2023 and updated in February of 2024. For more than a quarter of a century, people have been discussing “Which is better, MySQL vs PostgreSQL?” — with no resolution. When people ask me which is better, I have to ask them...
by Michael Patrick | Feb 1, 2024 | Insight for DBAs
This blog was originally published in June 2016 but was updated in February 2024. In this blog post, we’ll look at various MySQL high availability (HA) solutions, detailing their advantages and disadvantages to equip you with the insight required for informed...
by Przemysław Malkowski | Jan 31, 2024 | Insight for DBAs, Insight for Developers, MySQL
It is a known good practice to keep only necessary indexes to reduce the write performance and disk space overhead. This simple rule is mentioned briefly in the official MySQL Documentation: https://dev.mysql.com/doc/refman/8.0/en/optimization-indexes.html However, in...
by Vinicius Grippa | Jan 18, 2024 | Insight for DBAs, MySQL
In this blog post, we will discuss how to validate at the operating system level the effects of changing the innodb_flush_method to variations other than the default (particularly for O_DIRECT which is most commonly used) and the use of innodb_use_fdatasync....
by David Stokes | Jan 17, 2024 | Insight for DBAs, MySQL
Oracle recently released MySQL 8.0.36 and MySQL 8.3, and this is a perusal of the release notes to determine what is new, what is in the seventy-three bugs fixed, and what has changed in the three months since the last releases. Comments in italics are my own and do...
by Edwin Wang | Jan 12, 2024 | Insight for DBAs, Insight for Developers, MySQL
by Marco Tusa | Jan 11, 2024 | Benchmarks, MySQL, Percona Software, ProxySQL
In my previous article, Comparisons of Proxies for MySQL, I showed how MySQL Router was the lesser performing Proxy in the comparison. From that time to now, we had several MySQL releases and, of course, also some new MySQL Router ones. Most importantly, we also had...
by Ivan Groenewold | Jan 9, 2024 | Insight for DBAs, MySQL, Open Source
When working with group replication, MySQL router would be the obvious choice for the connection layer. It is tightly coupled with the rest of the technologies since it is part of the InnoDB cluster stack. The problem is that except for simple workloads, MySQL...
by Eduardo Krieg | Jan 8, 2024 | Insight for DBAs, MySQL
One of the most underlooked parameters to configure MySQL is server_id, which is an integer number to identify a server inside a replication topology uniquely. Note that two servers within a replication set can’t have the same server_id value. It is generally set up...
by Yunus Shaikh | Jan 5, 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....
