by Daniil Bazhenov | Oct 1, 2021 | MongoDB, MySQL, Percona Events, PostgreSQL
Percona serves several communities including MySQL, PostgreSQL, and MongoDB. The Percona Community Team is committed to promoting content and technical advice on open source database technologies and needs. Hence, we organize monthly MeetUps as a series of regular...
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
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...
