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...
by Carlos Tutte | Jun 30, 2021 | MySQL, Percona Software
The Problem I recently worked on a customer engagement where the customer needed to archive a high amount of rows from different tables into another server (in this example for simplicity I am just archiving the results into a file). As explained in this other blog...
by Pep Pla | Jun 25, 2021 | Insight for DBAs, MySQL, Percona Software
Don’t Try This at Home! Disclaimer: The procedure described in this blog post is not officially supported by Percona XtraBackup. Use it under your responsibility. I tested and used it successfully, but your mileage may vary. Note from the author: Wikipedia...
by Oleksandr Miroshnychenko | Jun 24, 2021 | Cloud, MySQL, Percona Software
This quickstart shows you how to use the Azure portal to deploy a dedicated Percona Server for MySQL 8.0 drop-in replacement for MySQL that provides superior performance, scalability, and instrumentation. It also shows you how to connect to the server. Prerequisites...
by Marco Tusa | Jun 23, 2021 | Cloud, Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is well known for its offer of several outstanding fully open source, free-to-download software packages. And while Percona started as a MySQL-focused company, nowadays it covers different technologies such as MySQL, PostgreSQL, and MongoDB. In its constant...
by Dmitriy Kostiuk | Jun 23, 2021 | Cloud, MongoDB, MySQL, Percona Software, PostgreSQL
At some point, your needs for improving database performance may run into a threshold where optimization and tuning are no longer enough. If you cannot change the database engine and can no longer tune the parameters for your workload, you need to use scaling. As it...
by Sergey Pronin | Jun 23, 2021 | Cloud, MySQL, Open Source, Percona Software
GitOps workflow was introduced by WeaveWorks as a way to implement Continuous Deployment for cloud-native applications. This technique quickly found its way into devops and developer’s hearts as it greatly simplifies the application delivery pipeline: the change...
by Kenn Takara | Jun 18, 2021 | MySQL, ProxySQL, Security
Starting with the release of proxysql-admin 2.0.15, the proxysql-admin 2.x series can now encrypt the credentials needed to access proxysql and cluster nodes. This only applies to the proxysql-admin configuration, this does not change the ProxySQL config, so those...
by Vadim Tkachenko | Jun 17, 2021 | MySQL, Percona Software
In my talk at Percona Live 2021, “Creating Chaos in Databases”, I discussed how creating a controlled interruption in available resources (I used primary pod and network interruptions) allows us to test the stability of a database, and in our case, Percona XtraDB...
by Marco Tusa | Jun 15, 2021 | Insight for DBAs, MySQL, Security
When organizing things helps to simplify life. In the previous article, we start to explore dynamic privileges and the interaction with static ones. We also saw how to remove SUPER privilege from a DBA account. What we did was go by subtraction. But in real life, we...
by Marco Tusa | Jun 15, 2021 | Insight for DBAs, MySQL, Open Source
When trying to make things better, make it very complicated. I was working on a Security Threat Tool script when I had to learn more about the interaction between static and dynamic privileges in MySQL 8. Dynamic privileges is a “new” thing added in MySQL 8 to easily...
by Mike Benshoof | Jun 14, 2021 | MySQL, Percona Software
The practice of running databases in containers continues to grow in popularity. As a Technical Account Manager at Percona, I get asked regularly about our Percona Distribution for MySQL Operator. Additionally, I’m asked what I’m seeing in the industry in terms of...
