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...
by Sergey Pronin | May 20, 2021 | Cloud, MySQL, Open Source, Percona Software
Quite a common request that we receive from the community and customers is to provide a way to manage database users with Operators – both MongoDB and MySQL. Even though we see it as an interesting task, our Operators are mainly a tool to simplify the deployment...
by George O. Lorch III | May 20, 2021 | MySQL, Percona Software
Percona Server for MySQL 8.0.23-14 was released last week and I wanted to take a minute to call out some of the interesting new features that we have introduced in this release. These are included in addition to the features and improvements in MySQL 8.0.23 that were...
by Vadim Tkachenko | May 19, 2021 | MongoDB, MySQL, Percona Software
Our recent releases of Percona Operator for MySQL based on Percona XtraDB Cluster 1.8 and Percona Operator for MongoDB 1.7 come with a new interesting feature: Support of custom sidecars. What is special about this? There is often a need to customize the default...
by David Ducos | May 7, 2021 | Insight for DBAs, MySQL
The new MyDumper 0.10.5 version, which includes many new features and bug fixes, is now available. You can download the code from here. For this release, we focused on fixing some old issues and testing old pull requests to get higher quality code. On releases...
