by Fernando Laudares Camargos | Nov 14, 2024 | Cloud, Insight for DBAs, MySQL, Percona Software
Even though I used a dedicated Kubernetes cluster to host my test database, I had this belief that by not explicitly allocating (or requesting, in Kubernetes vocabulary) CPU resources to my Percona XtraDB Cluster (PXC) pods or yet making just a small request,...
by Peter Zaitsev | Nov 1, 2024 | MySQL, Open Source, PostgreSQL
When I talk to old-timers in the MySQL community, I often hear this question: “How come MySQL is so awesome and still more popular than PostgreSQL (according to DB-Engines methodology at least), but it is losing ground while PostgreSQL’s growth in...
by Yunus Uyanik | Oct 31, 2024 | Insight for DBAs, MySQL
by Przemysław Malkowski | Oct 5, 2024 | Insight for DBAs, MySQL
This post was originally published in July 2023 and was updated in October 2024. Upgrading to MySQL version 8.0 is a hot topic since version 5.7 reached EOL. MySQL 5.7 EOL was at the end of October 2023. If you feel unprepared for the upgrade, consider post-EOL...
by Anil Joshi | Sep 25, 2024 | Benchmarks, Insight for DBAs, MySQL
In this blog post, we will explore how network partitions impact group replication and the way it detects and responds to failures. In case you haven’t checked out my previous blog post about group replication recovery strategies, please have a look at them for...
by David Quilty | Sep 23, 2024 | Insight for DBAs, MySQL
When it comes to MySQL databases, performance is everything. As more activities move online and data volumes grow exponentially, ensuring efficient data retrieval and query execution becomes crucial. Database indexing plays a significant role in this by providing...
by Vinicius Grippa | Sep 17, 2024 | Database Trends, Insight for DBAs, MySQL
There has been much discussion recently about the stability and performance of the latest MySQL releases. Many database professionals are voicing concerns, especially after encountering several issues in the newer versions. Issues with MySQL 8.0.38 Let’s start with...
by Valeria Bogatyreva | Sep 16, 2024 | MySQL, Percona Software
Historically, Percona has been providing our customers with enterprise-grade solutions for MySQL that meet the highest standards of compatibility and compliance. To follow this commitment, Percona now offers RHEL9-certified builds for the users of Percona software for...
by Oleksiy Lukin | Sep 13, 2024 | Insight for DBAs, MySQL, Percona Software
The release of Percona Server for MySQL 8.4.0 includes the new UUID_VX component, which implements UUID versions 1, 3, 4, 5, 6, and 7 according to recently published RFC 9562. UUIDs (Universally Unique Identifiers) are unique identifiers that can be generated...
by Przemysław Malkowski | Aug 30, 2024 | Insight for DBAs, MySQL
Mysterious warning Recently, I was involved in an investigation whose goal was to find out the reason for a warning message like this: [Warning] [MY-011825] [InnoDB] Cannot add field `c11` in table `db1`.`test` because after adding it, the row size is 8484 which is...
by Julia Vural | Aug 26, 2024 | Benchmarks, MySQL, Percona Software
At Percona, we have always prioritized database performance as a critical factor in selecting database technologies. Recently, we have observed a concerning trend in the community edition of MySQL, where performance appears to be declining across major releases,...
by Jaime Sicam | Aug 20, 2024 | Cloud, MySQL, Percona Software
Percona Operator for MySQL, based on Percona XtraDB Cluster (PXC), provides configuration to expose the ProxySQL, HAProxy, and the PXC instances themselves so that you can use Percona Toolkit to connect to MySQL from these endpoints externally. However, you can also...
by Kedar Vaijanapurkar | Aug 19, 2024 | Cloud, Insight for DBAs, MySQL
In current times, there is a high degree of focus on ensuring the availability and recovery of your production data. This can be challenging at times when using DBaaS solutions in the public cloud space, for example, when using AWS Aurora. Relying solely on a single...
by Anil Joshi | Aug 14, 2024 | Insight for DBAs, MySQL, Percona Software, Storage Engine
Group replication is a fault-tolerant/highly available replication topology that ensures if the primary node goes down, one of the other candidates or secondary members takes over so write and read operations can continue without any interruptions. However, there are...
by Roberto De Bem | Aug 8, 2024 | Insight for DBAs, Insight for Developers, Monitoring, MySQL
The usage of MySQL Router as a Middleware/Proxy/Router has increased along with the rise in MySQL InnoDB Cluster usage. While it is still relatively easy to use in production, monitoring it to stay informed about its current status is essential. This blog post will...
by Bartek Gatz | Jul 25, 2024 | Insight for DBAs, MySQL, Percona Software
A couple of weeks ago, my colleague Marco Tusa published an important announcement titled “Do Not Upgrade to Any Version of MySQL After 8.0.37.” The announcement highlighted a critical issue in MySQL 8.0.38, MySQL 8.4.1, and MySQL 9.0.0 that caused database server...
by Kedar Vaijanapurkar | Jul 22, 2024 | Insight for DBAs, MySQL
pt-online-schema-change is an amazing tool for assisting in table modifications in cases where ONLINE ALTER is not an option. But if you have foreign keys, this could be an interesting and important read for you. Tables with foreign keys are always complicated, and...
by David Stokes | Jul 19, 2024 | Insight for DBAs, MySQL
by Totel | Jul 18, 2024 | Insight for DBAs, MySQL
In this article, we will demonstrate how to have a single MySQL database user account that can connect from specific hosts. We would usually implement it by creating separate user accounts with the same username but different hosts/IPs like <USER>@<HOST1>,...
by David Quilty | Jul 17, 2024 | Insight for DBAs, MySQL
Have you ever waited far too long for a MySQL query to finish and wondered if there’s a better way? If you manage a MySQL database or build apps that depend on one, you know how slow queries can grind everything to a halt. Users get frustrated, response times creep...
