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...
by Vadim Tkachenko | Jun 10, 2021 | Insight for DBAs, MySQL, Percona Software
In the previous release of our Percona Distribution for MySQL Operator, we implemented one interesting feature, which can be seen as “self-healing”: https://jira.percona.com/browse/K8SPXC-564. I do not think it got enough attention, so I want to write more about this....
by David Ducos | Jun 8, 2021 | Insight for DBAs, MySQL
In my previous post Back From a Long Sleep, MyDumper Lives!, I told you that Fast Index Creation was in the queue and (after fixing several bugs) it will package in release 0.10.7 next month. But why am I so excited about it? Well, this feature opens new...
by Fernando Laudares Camargos | Jun 4, 2021 | Insight for DBAs, MySQL
The combination of the information obtained from the “pt-summaries” discussed in the previous posts of this series (Part 1: The Percona Support Way, Part 2: Knowing the Server, Part 3: What MySQL?) helps us come up with the first impression of a MySQL server. However,...
by Fernando Laudares Camargos | Jun 3, 2021 | Insight for DBAs, MySQL, Percona Software
In the previous post of this series, we looked at the hardware specifications and operating system settings of the host server through the lenses of a pt-summary report. Now that we know the foundation on which the database is running, we can turn our focus to MySQL...
by Fernando Laudares Camargos | Jun 2, 2021 | Insight for DBAs, Insight for Developers, MySQL
In part 1 of this series, we introduced you to the approach used by the Percona Support team to inspect MySQL servers, which is based on a triad of tools from the Percona Toolkit used to gather diagnostic information. In this article, we will be focusing on the first...
by Lenz Grimmer | Jun 1, 2021 | MySQL, Open Source, Percona Software
After Oracle released MySQL version 8.0.24 on April 20, 2021, our engineering team got started right away with merging our enhancements to prepare the corresponding 8.0.24 version of Percona Server for MySQL. However, Oracle released MySQL version 8.0.25 shortly...
by Fernando Laudares Camargos | Jun 1, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Services
When I joined the Percona Support team in early 2013, MySQL 5.6 was being launched. I remember all the buzz and euphoria surrounding its release: it was a big step from the 5.5 series, carrying important changes in the MySQL architecture and internals that brought...
by Yves Trudeau | May 27, 2021 | Insight for DBAs, MySQL, Storage Engine
Recently we had a debate in the consulting team about how InnoDB handles TEXT/BLOB columns. More specifically, the argument was around the Barracuda file format with dynamic rows. In the InnoDB official documentation, you can find this extract: When a table is created...
by Lenz Grimmer | May 21, 2021 | MySQL, Open Source, Percona Software, Storage Engine
Back in December 2018, when we announced the general availability of Percona Server for MySQL 8.0, we also announced that the TokuDB Storage Engine has been marked as “deprecated” in this release, recommending to use the MyRocks Storage Engine as an alternative. We...
