by Yves Trudeau | Sep 13, 2021 | Cloud, Insight for DBAs, MySQL
Here’s a second post focusing on the performance of MySQL on ZFS in cloud environments. In the first post, MySQL/ZFS Performance Update, we compared the performances of ZFS and ext4. This time we’ll look at the benefits of using ephemeral storage devices. These...
by David Quilty | Sep 9, 2021 | Monitoring, MySQL, Percona Software, Webinars
Thanks to everyone who attended last week’s webinar on Using Open Source Software to Optimize and Troubleshoot Your MySQL Environment; hopefully you’ve found the time we spent in Percona Monitoring and Management (PMM) useful. We had a record-breaking number of...
by Marcelo Altmann | Sep 2, 2021 | Cloud, Insight for DBAs, MySQL, Percona Software
Storing your data locally can impose security and availability risks. Major cloud providers have object storage services available to allow you to upload and distribute data across different regions using various retention and restore policies. Percona XtraBackup...
by Lenz Grimmer | Sep 1, 2021 | MySQL, Percona Announcements, Percona Software
We’re excited to share that Marcelo Altmann from the Percona Server Engineering Team has just been promoted from Oracle ACE Associate to Oracle ACE. Congratulations! The Oracle ACE Program recognizes and rewards community members for their technical contributions to...
by David Ducos | Aug 23, 2021 | Insight for DBAs, MySQL, Open Source
During the development of the myloader –innodb-optimize-keys option, which was released in version 0.10.7, we found several issues and opportunities to improve the process. We had to change the approach, reimplement some of the core functionality and add a...
by Matt Yonkovit | Aug 20, 2021 | Insight for DBAs, MySQL
JSON Structure, The Next Generation (Performance, Scale, and Fun) Now you know the basic JSON functionality available to you, as covered in part one of this series. Let’s look deeper into performance, scale, and oddities that may occur. You can do almost anything you...
by Sergey Pronin | Aug 19, 2021 | Cloud, MySQL, Percona Software
You may have already seen this document which describes the integration between HashiCorp Vault and Percona Distribution for MySQL Operator to enable data-at-rest encryption for self-managed Vault deployments. In April 2021, HashiCorp announced a fully managed...
by Matt Yonkovit | Aug 19, 2021 | Insight for DBAs, MySQL
by Lenz Grimmer | Aug 17, 2021 | MongoDB, MySQL, Open Source, Percona Software
Over the weekend, the Debian project announced the availability of their newest major distribution release, Debian 11 (code name “bullseye”). We’d like to congratulate the Debian project and the open source community for achieving this major milestone! With over two...
by Aleksandra Abramova | Aug 13, 2021 | MySQL, Percona Software
Note: This promotion has ended. The next 10 user reviews for Percona Server for MySQL will receive a $10 Amazon gift card from Sourceforge. Add yours now! Why does Percona value honest user reviews? They provide valuable information for engineers to guide product...
by Przemysław Malkowski | Jul 12, 2021 | Insight for DBAs, MySQL, Percona Software
The Problem State Snapshot Transfer can be a very long and expensive process, depending on the size of your Percona XtraDB Cluster (PXC)/Galera cluster, as well as network and disk bandwidth. There are situations where it is needed though, like after long enough node...
by Peter Boros | Jul 9, 2021 | Cloud, Insight for DBAs, MySQL
Problem Statement Having backups of binary logs is fairly normal these days. The more recent binary logs are copied offsite, the better RPO (Recovery Point Objective) can be achieved. I was asked multiple times recently if something could be done to “stream” the...
by Yves Trudeau | Jul 9, 2021 | Benchmarks, Hardware and Storage, Insight for DBAs, MySQL
As some of you likely know, I have a favorable view of ZFS and especially of MySQL on ZFS. As I published a few years ago, the argument for ZFS was less about performance than its useful features like data compression and snapshots. At the time, ZFS was significantly...
by Sveta Smirnova | Jul 7, 2021 | Insight for DBAs, MySQL, Open Source
“It would be nice to have an option, that would allow to suppress the DEFINER statement in the CREATE VIEW statements generated by mysqldump. This would help when transferring data structures between databases with different security models.” TLDR; Use mysqlpump with...
by Fernando Laudares Camargos | Jul 7, 2021 | Monitoring, MySQL, Percona Software
In the previous posts of this series, I presented how the Percona Support team approaches the analysis and troubleshooting of a MySQL server using a tried-and-tested method supported by specific tools found in the Percona Toolkit: Inspecting MySQL Servers Part 1: The...
by David Ducos | Jul 6, 2021 | Insight for DBAs, MySQL
The new MyDumper 0.10.7 version, which includes many new features and bug fixes, is now available. You can download the code from here. For this release, we have added several features like WHERE support that is required for partial backups. We also added CHECKSUM...
by Brian Sumpter | Jul 5, 2021 | Insight for DBAs, MySQL
One of the new features introduced in MySQL 8.0.24 was the ability to log all SQL statements that are issued in the MySQL Shell to the system log. This is a useful feature that can greatly assist in tracking who did what on the system. Usage The simplest way to...
by Brian Sumpter | Jul 1, 2021 | Insight for DBAs, MySQL, Open Source
MySQL 8 brought many highly anticipated features, with support for user roles, a new shell, a more robust data dictionary, and better SQL support, just to name a few. There are lesser-known new features, however, that aim to reduce overall DBA workload and streamline...
by Hrvoje Matijakovic | Jul 1, 2021 | MySQL, Percona Software
With the CentOS project switching its focus to CentOS Stream, one of the alternatives that aim to function as a downstream build (building and releasing packages after they’re released by Red Hat) is Rocky Linux. This how-to shows how to install Percona Server...
by Michael Coburn | Jul 1, 2021 | Insight for DBAs, Monitoring, MySQL, Percona Software
Some of you may use MySQL’s asynchronous replication feature called Semisynchronous Replication (aka semi-sync), and now with the MySQL Semi-Sync Summary Dashboard + Percona Monitoring and Management (PMM), you can see the most important metrics! Refer to the...
