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...
by Sveta Smirnova | Jun 18, 2024 | MySQL, Percona Software
Starting from Percona Toolkit 3.6.0, pt-online-schema-change supports the option –where, so you can not only alter your table definition live but copy only rows that satisfy certain criteria. It may happen that you may not need to copy all the data when changing...
by Peter Zaitsev | Jun 17, 2024 | Database Trends, MySQL, Open Source
I got quite a response to my article on whether Oracle is Killing MySQL, including a couple of great write-ups on The Register (1, 2) on the topic. There are a few questions in this discussion that I think are worth addressing. AWS and other cloud vendors compete,...
by Sveta Smirnova | Jun 14, 2024 | MySQL, Percona Software
Starting from Percona Toolkit 3.6.0, you can resume pt-online-schema-change if it was interrupted. This blog describes the prerequisites and usage of the new –resume option. To restart the job, you need to know where it failed. This is why the first option you...
by Marco Tusa | Jun 13, 2024 | Benchmarks, Database Trends, MySQL
At Percona, we monitor our users’ needs and try to accommodate them. One aspect we monitor is the MySQL version distribution/utilization. Observing that, we identified a very interesting trend: the lack of migration from 5.7 to 8.x, or better yet, the need of...
by Sveta Smirnova | Jun 12, 2024 | MongoDB, MySQL, Percona Software, PostgreSQL
Percona Toolkit 3.6.0 has been released on June 12, 2024. The most important updates in this version are: The possibility to resume pt-online-schema-change if it is interrupted. eu-stack support in pt-pmp that significantly improves this tool’s performance and...
by Kamil Holubicki | Jun 12, 2024 | Insight for DBAs, MySQL, Percona Software
Keeping Your Data Safe: An Introduction to Data-at-Rest Encryption in Percona XtraDB Cluster. In the first part of this blog post, we learned how to enable GCache and Record-Set cache encryption in Percona XtraDB Cluster. This part will explore the details of the...
by Peter Zaitsev | Jun 10, 2024 | Database Trends, MySQL, Open Source
Some 15 years ago, when Oracle acquired Sun, and hence MySQL, there was a lot of talk on the internet over when Oracle was going to “Kill MySQL”. Multiple theories were circled around, ranging from killing MySQL altogether, so there is less competition to proprietary...
by Kamil Holubicki | Jun 7, 2024 | Insight for DBAs, MySQL, Percona Software
Keeping Your Data Safe: An Introduction to Data-at-Rest Encryption in Percona XtraDB Cluster. Data breaches are a major concern today. Whether you’re a business owner or value your privacy, the thought of your sensitive information being exposed is unsettling....
by Smit Arora | Jun 1, 2024 | Insight for DBAs, MySQL, PostgreSQL
This blog was originally published in September 2023 and was updated in June 2024. In simple terms, a join in SQL combines columns from one or more tables to extract the required data. When used effectively, joins can simplify queries and save a lot of time. Some of...
