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 Rachel Pescador | Oct 4, 2021 | Database Trends, Open Source
Complete the 2021 Open Source Data Management Software Survey to share your knowledge and experience, and help inform the open source database community. In 2020 we ran our second Open Source Data Management Software Survey. This resulted in some interesting data on...
by Lalit Choudhary | Sep 29, 2021 | Insight for DBAs, Insight for Developers, Percona Software
Here at Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open source...
by Mike Benshoof | Sep 28, 2021 | Insight for DBAs, Insight for Developers, MySQL
In a previous post, A Horizontal Scalability Mindset for MySQL, I discussed the concerns around growing individual MySQL instances too large and some basic strategies: Optimizing/minimizing size with proper data types Removing unused/duplicate indexes Keeping your...
by Aleksandra Abramova | Sep 28, 2021 | MongoDB, Monitoring, MySQL, Percona Software
It’s been a while since Percona started to develop its own software products, but collecting reviews is a new experience for us. We started this activity about a year ago, and the results we got are stunning. Your reviews said more about us than we ever could imagine....
by Mike Benshoof | Sep 27, 2021 | Insight for DBAs, MySQL, Percona Services, Percona Software
As a Technical Account Manager at Percona, I get to work with many of our largest clients. While the industry verticals vary, one main core challenge generally remains the same – what do I do with all this data? Dealing with massive data sets in MySQL isn’t a...
by Sri Sakthivel | Sep 22, 2021 | Insight for DBAs, MySQL
MySQL 8 comes with a lot of good features, and recently I explored its password management systems. I wanted to put together a series of blogs about it, and this is the first part. In this post, I am going to explain the following topics in detail. Password Reuse...
by Francisco Bordenave | Sep 21, 2021 | Benchmarks, Cloud, Insight for DBAs, MySQL
Primary Key design is an important thing for InnoDB performance, and choosing a poor PK definition will have an impact on performance and also write propagation in databases. When this comes to Aurora, this impact is even worse than you may notice. In short, we...
by David Ducos | Sep 21, 2021 | Insight for DBAs, MySQL
The new MyDumper 0.11.1 version, which includes many new features and bug fixes, is now available. You can download the code from here. For this release, there are three main changes: 1) we added config file functionality which allows users to set session-level...
by Slava Sarzhan | Sep 17, 2021 | Cloud, MySQL, Percona Software
Nowadays, more and more companies are thinking about the migration of their infrastructure to Kubernetes. Databases are no exception. There were a lot of k8s operators that were created to simplify the different types of deployments and also perform routine day-to-day...
by Carlos Tutte | Sep 16, 2021 | Insight for DBAs, MySQL, Percona Software
When doing migrations or failovers in MySQL, there is usually a need to do a topology change and repoint replica servers to obtain replication data from a different server. For example, given servers {A, B, and C} and the following topology: If you need to repoint C...
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
