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...
by Bartek Gatz | Jul 16, 2024 | MySQL, Percona Software
On July 1st, 2024, Oracle launched MySQL 9.0.0, the first release in the 9.x series. This release and the following six versions (9.1.0 to 9.6.0) are designated as “Innovation Releases.” These releases are characterized by their short support lifecycles,...
by marcos.albe | Jul 15, 2024 | Insight for DBAs, MySQL, Percona Software
You probably missed the news, but… PT-1751: Adds –where param to pt-online-schema-change This brings the possibility to perform what I would call an “inverted purge” because you are not actually purging rows from your multi-terabyte table, but...
by Alina Derkach | Jul 15, 2024 | Insight for DBAs, MySQL, Percona Software
We’re excited to announce that both Percona Server for MySQL and Percona XtraBackup now support the ARM64 architecture on Red Hat Enterprise Linux (RHEL) 8/9 and Oracle Linux (OL) 8/9. The packages with the aarch64.rpm extension can be found on Percona Software...
by Larry Xia | Jul 12, 2024 | Insight for DBAs, MySQL, Percona Software
At Percona Managed Services, we manage Percona MySQL, Community MySQL, and MariaDB. Sometimes, we might need to enable audit logging and share the logs for client MySQL Community 8.0.x servers. There are several ways to enable audit logs. One is to use the MySQL...
by Marco Tusa | Jul 11, 2024 | Insight for DBAs, MySQL
Warning! Recently, Jean-François Gagné opened a bug on bug.mysql.com #115517; unfortunately, the bug is now private. However, the bug looks quite serious. We at Percona have performed several tests and opened the issue PS-9306 to investigate the problem. In short,...
by David Ducos | Jul 9, 2024 | Insight for DBAs, MySQL
For a long time, I’ve been thinking about the possibility of importing a single file with multiple connections. Why? Simply because we have scenarios where we end up importing a big file with a single loader thread. Well, I have good news: since the release of...
by David Stokes | Jul 2, 2024 | Insight for DBAs, MySQL
MySQL 9.0 was released on July 1, 2024. This is an ‘Innovation’ release, which means it provides access to the latest features and improvements in MySQL technologies. Innovation releases are the opposite of the Long Term Support (LTS) releases, where...
by Przemysław Malkowski | Jun 28, 2024 | Insight for DBAs, MySQL
Some of our Percona Support customers report performance degradation after a major MySQL upgrade, and there can be many different reasons for this. These days, the most common major upgrade is from MySQL 5.7 (which recently reached EOL) to 8.0, and I am going to...
by David Quilty | Jun 26, 2024 | Insight for DBAs, Monitoring, MySQL
Is your MySQL database running at its best? While MySQL is known for its reliability and ease of use, ensuring top-notch performance is crucial. One way to do that is through performance monitoring, an essential practice for identifying bottlenecks, maintaining...
by Przemysław Malkowski | Jun 25, 2024 | Insight for DBAs, MySQL
Replication has been the core functionality, allowing high availability in MySQL for decades already. However, you may still encounter replication errors that keep you awake at night. One of the most common and challenging to deal with starts with: “Got fatal...
by Anil Joshi | Jun 24, 2024 | Insight for DBAs, Insight for Developers, Monitoring, MySQL
Flow control is not a new term, and we have already heard it a lot of times in Percona XtraDB Cluster/Galera-based environments. In very simple terms, it means the cluster node can’t keep up with the cluster write pace. The write rate is too high, or the nodes...