by Vinicius Grippa | Dec 27, 2021 | Insight for DBAs, MySQL, Percona Software
In this blog post, we will compare the performance of performing a backup from a MySQL database using mysqldump, MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. All these available options are open source and free to use for the...
by Marco Tusa | Dec 9, 2021 | Insight for DBAs, MySQL, Percona Software
Percona XtraDB Cluster 8.0.25 (PXC) has introduced a new option to perform online schema modifications: NBO (Non-Blocking Operation). When using PXC, the cluster relies on the wsrep_OSU_method parameter to define the Online Schema Upgrade (OSU) method the node uses to...
by Peter Boros | Dec 9, 2021 | Cloud, MySQL, Percona Software
We have a quickstart guide for how to install Percona Distribution for MySQL Operator on minikube. Installing the minimal version works well as it is described in the guide. After that, we will have one HAproxy and one Percona XtraDB Cluster (PXC) node to work with....
by David Ducos | Dec 3, 2021 | Insight for DBAs, MySQL
For a long time, MyDumper has been in Max Bubenick’s personal GitHub repository. Now, we decided to move to a new MyDumper’s Organization as requested earlier this year by a user from the community. There were also two other reasons why we decided to move it....
by Sveta Smirnova | Dec 2, 2021 | MySQL, Webinars
First, I want to thank everyone who attended my November 9, 2021 webinar “Introduction to MySQL Query Tuning for Dev[Op]s“. Recording and slides are available on our webinars page. Here are answers to the questions from participants which I was not able to provide...
by David Ducos | Dec 1, 2021 | Insight for DBAs, MySQL, Percona Software
Working on a real case scenario in a five node Percona XtraDB Cluster (PXC), we were forced to use wsrep_sync_wait = 1, because the app does reads-after-write and we send reads to all the nodes. We had the idea to leave some nodes in DESYNC mode to reduce the flow...
by David Ducos | Nov 29, 2021 | Insight for DBAs, MySQL
The new MyDumper 0.11.3 version, which includes many new features and bug fixes, is now available. You can download the code from here. We are very proud to announce that we were able to achieve the two main objectives for the milestone ZSTD and Stream support! We...
by Ivan Groenewold | Nov 24, 2021 | Cloud, Insight for DBAs, MySQL
A recommendation we often give to our customers is along the lines of “archive old data” to reduce your database size. There is a tradeoff between keeping all our data online and archiving part of it to cold storage. There could also be legal requirements...
by Przemysław Malkowski | Nov 22, 2021 | Insight for DBAs, MySQL, Storage Engine
If you ever had to deal with performance and/or disk space issues related to temporary tables, I bet you eventually found yourself puzzled. There are many possible scenarios depending on the type of temporary table, settings, and MySQL version used. We have observed a...
by Marco Tusa | Nov 9, 2021 | Insight for DBAs, Insight for Developers, MySQL
Well, let me say if that happens it’s because there is a logic mistake in your application. But you need to know and understand what happens in MySQL to be able to avoid the problem. In short, the WHY of this article is to inform you about possible pitfalls and...
by Nik Krichko | Oct 25, 2021 | Benchmarks, Insight for DBAs, MySQL
Recently we published the first part of research comparing Graviton (ARM) with AMD and Intel CPU on AWS. In the first part, we selected general-purpose EC2 instances with the same configurations (amount of vCPU). The main goal was to see the trend and make a general...
by Nik Krichko | Oct 15, 2021 | Benchmarks, Cloud, Insight for DBAs, MySQL
Recently, AWS presented its own CPU on ARM architecture for server solutions. It was Graviton. As a result, they update some lines of their EC2 instances with new postfix “g” (e.g. m6g.small, r5g.nano, etc.). In their review and presentation, AWS showed impressive...
by Matt Yonkovit | Oct 14, 2021 | Monitoring, MySQL, Percona Software, PostgreSQL
A few weeks ago we did a live stream talking about Percona Monitoring and Management (PMM) and showcased some of the fun things we were doing at the OSS Summit. During the live stream, we tried to enable some custom queries to track the number of comments being added...
by Sri Sakthivel | Oct 12, 2021 | MySQL, ProxySQL
ProxySQL 2.3.0 was recently released and when I was reading the release notes, I was really impressed with the Group Replication enhancements and features. I thought of experimenting with those things and was interested to write a blog about them. Here, I have focused...
by Brian Sumpter | Oct 8, 2021 | Insight for DBAs, Insight for Developers, MySQL, Security
As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how using the new dual passwords feature can reduce the overall DBA workload and streamline the management process. I’ve also covered how the new password failure tracking features can...
by Ivan Groenewold | Oct 7, 2021 | Cloud, MySQL, Percona Software, ProxySQL
There are plenty of ways to run ProxySQL in Kubernetes (K8S). For example, we can deploy sidecar containers on the application pods, or run a dedicated ProxySQL service with its own pods. We are going to discuss the latter approach, which is more likely to be used...
by Agustín | Oct 6, 2021 | Monitoring, MySQL, Percona Software
In this short blog post, we are going to review how to avoid using credentials in the Percona Monitoring and Management (PMM) client command line when adding new exporters. We will use an example with the MySQL exporter, but it is extensible to others (PostgreSQL,...
by Lenz Grimmer | Oct 6, 2021 | MySQL, Percona Announcements, Percona Software, Storage Engine
As we’ve communicated in our blog post in May, the TokuDB Storage Engine has been marked as “deprecated” in Percona Server for MySQL 8.0. It will be removed in a future version (Percona Server for MySQL 8.0.28, expected to ship in Q1 2022). With the release of Percona...
by Brian Sumpter | Oct 5, 2021 | Insight for DBAs, MySQL, Security
As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how the new dual passwords feature can reduce the overall DBA workload and streamline the management process (see MySQL 8: Dual Passwords). This wasn’t the only change to user/password...
by Sveta Smirnova | Oct 4, 2021 | Insight for DBAs, MySQL, Percona Software
It is a common use case to synchronize data in two tables inside MySQL servers. This blog post describes one specific case: how to synchronize data between two different tables on the same MySQL server. This could be useful, for example, if you test DML query...
![Q&A on the Webinar “Introduction to MySQL Query Tuning for Dev[Op]s”](https://www.percona.com/blog/wp-content/uploads/2021/12/MySQL-Query-Tuning-for-DevOps-webinar.png)
